200 lines
7.3 KiB
C#
200 lines
7.3 KiB
C#
|
|
|
|||
|
|
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_MianShi : 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("|057A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
|
|||
|
|
ImageButton5.Visible = ZWL.Common.PublicMethod.StrIFIn("|057M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
|
|||
|
|
ImageButton3.Visible = ZWL.Common.PublicMethod.StrIFIn("|057D|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
|
|||
|
|
ImageButton2.Visible = ZWL.Common.PublicMethod.StrIFIn("|057E|", 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);
|
|||
|
|
}
|
|||
|
|
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.ERPMianShi MyModel = new ZWL.BLL.ERPMianShi();
|
|||
|
|
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("MianShiAdd.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 ERPMianShi 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><EFBFBD><EFBFBD><EFBFBD><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("MSName", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
MyTable.Add("MSDate", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
MyTable.Add("MSSex", "<22>Ա<EFBFBD>");
|
|||
|
|
MyTable.Add("MSAge", "<22><><EFBFBD><EFBFBD>");
|
|||
|
|
MyTable.Add("XueLi", "ѧ<><D1A7>");
|
|||
|
|
MyTable.Add("ZhuanYe", "רҵ");
|
|||
|
|
MyTable.Add("MSZhiWei", "<22><><EFBFBD><EFBFBD>ְλ");
|
|||
|
|
MyTable.Add("MSJieGuo", "<22><><EFBFBD>Խ<EFBFBD><D4BD><EFBFBD>");
|
|||
|
|
MyTable.Add("BackInfo", "<22><>ע˵<D7A2><CBB5>");
|
|||
|
|
MyTable.Add("FuJianStr", "<22><><EFBFBD><EFBFBD><EFBFBD>ļ<EFBFBD>");
|
|||
|
|
MyTable.Add("UserName", "¼<><C2BC><EFBFBD><EFBFBD>");
|
|||
|
|
MyTable.Add("TimeStr", "¼<><C2BC>ʱ<EFBFBD><CAB1>");
|
|||
|
|
ZWL.Common.DataToExcel.GridViewToExcel(ZWL.DBUtility.DbHelperSQL.GetDataSet("select MSName,MSDate,MSSex,MSAge,XueLi,ZhuanYe,MSZhiWei,MSJieGuo,BackInfo,FuJianStr,UserName,TimeStr from ERPMianShi 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("MianShiModify.aspx?ID=" + CheckStrArray[0].ToString());
|
|||
|
|
}
|
|||
|
|
}
|