xinyilu/tijian_tieying
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
tijian_tieying/web/Web/DocFile/TiKuShiJuan.aspx.cs

226 lines
9.1 KiB
C#
Raw Permalink Normal View History

v1
2025-02-20 12:14:39 +08:00
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class DocFile_TiKuShiJuan : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataBindToGridview("");
//<2F>趨<EFBFBD><E8B6A8>ťȨ<C5A5><C8A8>
ImageButton1.Visible = ZWL.Common.PublicMethod.StrIFIn("|045A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
ImageButton5.Visible = ZWL.Common.PublicMethod.StrIFIn("|045M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
ImageButton3.Visible = ZWL.Common.PublicMethod.StrIFIn("|045D|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
ImageButton2.Visible = ZWL.Common.PublicMethod.StrIFIn("|045E|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
}
}
#region <EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
protected void ButtonGo_Click(object sender, ImageClickEventArgs e)
{
try
{
if (GoPage.Text.Trim().ToString() == "")
{
Response.Write("<script language='javascript'>alert('ҳ<>벻<EFBFBD><EBB2BB><EFBFBD><EFBFBD>Ϊ<EFBFBD><CEAA>!');</script>");
}
else if (GoPage.Text.Trim().ToString() == "0" || Convert.ToInt32(GoPage.Text.Trim().ToString()) > GVData.PageCount)
{
Response.Write("<script language='javascript'>alert('ҳ<>벻<EFBFBD><EBB2BB>һ<EFBFBD><D2BB><EFBFBD><EFBFBD>Чֵ!');</script>");
}
else if (GoPage.Text.Trim() != "")
{
int PageI = Int32.Parse(GoPage.Text.Trim()) - 1;
if (PageI >= 0 && PageI < (GVData.PageCount))
{
GVData.PageIndex = PageI;
}
}
if (TxtPageSize.Text.Trim().ToString() == "")
{
Response.Write("<script language='javascript'>alert('ÿҳ<C3BF><D2B3>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϊ<EFBFBD><CEAA>!');</script>");
}
else if (TxtPageSize.Text.Trim().ToString() == "0")
{
Response.Write("<script language='javascript'>alert('ÿҳ<C3BF><D2B3>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><D2BB><EFBFBD><EFBFBD>Чֵ!');</script>");
}
else if (TxtPageSize.Text.Trim() != "")
{
try
{
int MyPageSize = int.Parse(TxtPageSize.Text.ToString().Trim());
this.GVData.PageSize = MyPageSize;
}
catch
{
Response.Write("<script language='javascript'>alert('ÿҳ<C3BF><D2B3>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><D2BB><EFBFBD><EFBFBD>Чֵ!');</script>");
}
}
DataBindToGridview("");
}
catch
{
DataBindToGridview("");
Response.Write("<script language='javascript'>alert('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ч<EFBFBD><D0A7><EFBFBD>֣<EFBFBD>');</script>");
}
}
protected void PagerButtonClick(object sender, ImageClickEventArgs e)
{
//<2F><><EFBFBD><EFBFBD>Button<6F>IJ<EFBFBD><C4B2><EFBFBD>ֵ
string arg = ((ImageButton)sender).CommandName.ToString();
switch (arg)
{
case ("Next"):
if (this.GVData.PageIndex < (GVData.PageCount - 1))
GVData.PageIndex++;
break;
case ("Pre"):
if (GVData.PageIndex > 0)
GVData.PageIndex--;
break;
case ("Last"):
try
{
GVData.PageIndex = (GVData.PageCount - 1);
}
catch
{
GVData.PageIndex = 0;
}
break;
default:
//<2F><>ҳֵ
GVData.PageIndex = 0;
break;
}
DataBindToGridview("");
}
#endregion
protected void GVData_RowDataBound(object sender, GridViewRowEventArgs e)
{
ZWL.Common.PublicMethod.GridViewRowDataBound(e);
//<2F>ж<EFBFBD><D0B6>Ƿ<EFBFBD><C7B7><EFBFBD>Ȩ<EFBFBD><C8A8>
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label MyLab = (Label)e.Row.FindControl("Label100");
MyLab.Visible = ZWL.Common.PublicMethod.StrIFIn("|045N|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
Label LabV = (Label)e.Row.FindControl("LabVisible");
if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 IFSuiJiChuTi from ERPTiKuShiJuan where ID=" + LabV.Text) == "<22><>")
{
MyLab.Text = "[<a class=\"BlueCss\" href=\"TiKuShiJuanSet.aspx?ID=" + LabV.Text + "&FenLeiStr=<3D><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>\"><3E><>ѡ<EFBFBD><D1A1></a>]";
MyLab.Text = MyLab.Text + "[<a class=\"BlueCss\" href=\"TiKuShiJuanSet.aspx?ID=" + LabV.Text + "&FenLeiStr=<3D><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>\"><3E><>ѡ<EFBFBD><D1A1></a>]";
MyLab.Text = MyLab.Text + "[<a class=\"BlueCss\" href=\"TiKuShiJuanSet.aspx?ID=" + LabV.Text + "&FenLeiStr=<3D>ж<EFBFBD><D0B6><EFBFBD>\"><3E>ж<EFBFBD><D0B6><EFBFBD></a>]";
MyLab.Text = MyLab.Text + "[<a class=\"BlueCss\" href=\"TiKuShiJuanSet.aspx?ID=" + LabV.Text + "&FenLeiStr=<3D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>\"><3E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD></a>]";
MyLab.Text = MyLab.Text + "[<a class=\"BlueCss\" href=\"TiKuShiJuanSet.aspx?ID=" + LabV.Text + "&FenLeiStr=<3D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>\"><3E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD></a>]";
}
else
{
MyLab.Text = "[<a class=\"BlueCss\" href=\"TiKuShiJuanSetDongTai.aspx?ID=" + LabV.Text + "\"><3E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ</a>]";
}
}
}
protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
{
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD>β<EFBFBD>ѯ<EFBFBD><D1AF><EFBFBD><EFBFBD>
string JJ = "0";
for (int i = 0; i < this.GVData.Rows.Count; i++)
{
Label LabV = (Label)GVData.Rows[i].FindControl("LabVisible");
JJ = JJ + "," + LabV.Text.Trim();
}
DataBindToGridview(JJ);
}
protected void ImageButton4_Click(object sender, ImageClickEventArgs e)
{
DataBindToGridview("");
}
public void DataBindToGridview(string IDList)
{
ZWL.BLL.ERPTiKuShiJuan MyModel = new ZWL.BLL.ERPTiKuShiJuan();
if (IDList.Trim().Length > 0)
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and ID in(" + IDList + ") order by ID desc");
}
else
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' order by ID desc");
}
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("TiKuShiJuanAdd.aspx");
}
protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
string IDlist = ZWL.Common.PublicMethod.CheckCbx(this.GVData, "CheckSelect", "LabVisible");
if (ZWL.DBUtility.DbHelperSQL.ExecuteSQL("delete from ERPTiKuShiJuan where ID in (" + IDlist + ")") == -1)
{
Response.Write("<script>alert('ɾ<><C9BE>ѡ<EFBFBD>м<EFBFBD>¼ʱ<C2BC><CAB1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>µ<EFBFBD>½<EFBFBD><C2BD><EFBFBD><EFBFBD><EFBFBD>ԣ<EFBFBD>');</script>");
}
else
{
DataBindToGridview("");
//дϵͳ<CFB5><CDB3>־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "<22>û<EFBFBD>ɾ<EFBFBD><C9BE><EFBFBD>Ծ<EFBFBD><D4BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
string IDList = "0";
for (int i = 0; i < GVData.Rows.Count; i++)
{
Label LabVis = (Label)GVData.Rows[i].FindControl("LabVisible");
IDList = IDList + "," + LabVis.Text.ToString();
}
Hashtable MyTable = new Hashtable();
MyTable.Add("ShiJuanTitle", "<22>Ծ<EFBFBD><D4BE><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("IFSuiJiChuTi", "<22>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("FenLeiShunXu", "<22><>Ŀ<EFBFBD><C4BF>ʾ˳<CABE><CBB3>");
MyTable.Add("KaoShiXianShi", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1><EFBFBD>֣<EFBFBD>");
MyTable.Add("PanDuanTiList", "<22>ж<EFBFBD><D0B6><EFBFBD>");
MyTable.Add("DanXuanTiList", "<22><>ѡ<EFBFBD><D1A1>");
MyTable.Add("DuoXuanTiList", "<22><>ѡ<EFBFBD><D1A1>");
MyTable.Add("TianKongTiList", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("JianDaTiList", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("PanDuanFenShu", "<22>ж<EFBFBD><D0B6><EFBFBD>ÿ<EFBFBD><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("DanXuanFenShu", "<22><>ѡ<EFBFBD><D1A1>ÿ<EFBFBD><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("DuoXuanFenShu", "<22><>ѡ<EFBFBD><D1A1>ÿ<EFBFBD><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("TianKongFenShu", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ÿ<EFBFBD><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("JianDaFenShu", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ÿ<EFBFBD><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
MyTable.Add("BackInfo", "<22><>ע˵<D7A2><CBB5>");
MyTable.Add("UserName", "¼<><C2BC><EFBFBD><EFBFBD>");
MyTable.Add("TimeStr", "¼<><C2BC>ʱ<EFBFBD><CAB1>");
ZWL.Common.DataToExcel.GridViewToExcel(ZWL.DBUtility.DbHelperSQL.GetDataSet("select ShiJuanTitle,IFSuiJiChuTi,FenLeiShunXu,KaoShiXianShi,PanDuanTiList,DanXuanTiList,DuoXuanTiList,TianKongTiList,JianDaTiList,PanDuanFenShu,DanXuanFenShu,DuoXuanFenShu,TianKongFenShu,JianDaFenShu,BackInfo,UserName,TimeStr from ERPTiKuShiJuan where ID in (" + IDList + ") order by ID desc"), MyTable, "Excel<65><6C><EFBFBD><EFBFBD>");
}
protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
{
string CheckStr = ZWL.Common.PublicMethod.CheckCbx(this.GVData, "CheckSelect", "LabVisible");
string[] CheckStrArray = CheckStr.Split(',');
Response.Redirect("TiKuShiJuanModify.aspx?ID=" + CheckStrArray[0].ToString());
}
}
Reference in New Issue Copy Permalink