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 Subaltern_TaskFP : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); DataBindToGridview(""); //设定按钮权限 ImageButton2.Visible = ZWL.Common.PublicMethod.StrIFIn("|132E|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); } } #region 分页方法 protected void ButtonGo_Click(object sender, ImageClickEventArgs e) { try { if (GoPage.Text.Trim().ToString() == "") { Response.Write(""); } else if (GoPage.Text.Trim().ToString() == "0" || Convert.ToInt32(GoPage.Text.Trim().ToString()) > GVData.PageCount) { Response.Write(""); } 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(""); } else if (TxtPageSize.Text.Trim().ToString() == "0") { Response.Write(""); } else if (TxtPageSize.Text.Trim() != "") { try { int MyPageSize = int.Parse(TxtPageSize.Text.ToString().Trim()); this.GVData.PageSize = MyPageSize; } catch { Response.Write(""); } } DataBindToGridview(""); } catch { DataBindToGridview(""); Response.Write(""); } } protected void PagerButtonClick(object sender, ImageClickEventArgs e) { //获得Button的参数值 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: //本页值 GVData.PageIndex = 0; break; } DataBindToGridview(""); } #endregion protected void GVData_RowDataBound(object sender, GridViewRowEventArgs e) { ZWL.Common.PublicMethod.GridViewRowDataBound(e); //判定是否有权限 if (e.Row.RowType == DataControlRowType.DataRow) { HyperLink MyHyp1 = (HyperLink)e.Row.FindControl("HyperLink3"); MyHyp1.Visible = ZWL.Common.PublicMethod.StrIFIn("|132N|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); } } protected void ImageButton6_Click(object sender, ImageClickEventArgs e) { //保存上一次查询结果 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.ERPTaskFP MyModel = new ZWL.BLL.ERPTaskFP(); if (IDList.Trim().Length > 0) { GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and ID in(" + IDList + ") and ','+ToUserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' order by ID desc"); } else { GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and ','+ToUserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' 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 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("TaskTitle", "任务标题"); MyTable.Add("TaskContent", "任务内容"); MyTable.Add("FromUser", "分配人"); MyTable.Add("ToUserList", "执行人"); MyTable.Add("XinXiGouTong", "汇报与批示"); MyTable.Add("JinDu", "任务进度"); MyTable.Add("WanCheng", "完成情况"); MyTable.Add("NowState", "当前状态"); ZWL.Common.DataToExcel.GridViewToExcel(ZWL.DBUtility.DbHelperSQL.GetDataSet("select TaskTitle,TaskContent,FromUser,ToUserList,XinXiGouTong,JinDu,WanCheng,NowState from ERPTaskFP where ID in (" + IDList + ") order by ID desc"), MyTable, "Excel报表"); } }