//全选按钮 protected void btnSelect_All_Click(object sender, EventArgs e) { Grid_AchieveApply.SelectAllRows(); int[] select = Grid_AchieveApply.SelectedRowIndexArray; int m; //取整数(不是四舍五入,全舍) int Pages = (int)Math.Floor(Convert.ToDouble(Grid_AchieveApply.RecordCount / this.Grid_AchieveApply.PageSize)); if (Grid_AchieveApply.PageIndex == Pages) { m = (Grid_AchieveApply.RecordCount - this.Grid_AchieveApply.PageSize * Grid_AchieveApply.PageIndex); } else { m = this.Grid_AchieveApply.PageSize; } bool isCheck = false; for (int i = 0; i < m; i++) { if (CBoxSelect.GetCheckedState(i) == false) { isCheck = true; } } if (isCheck) { foreach (int item in select) { CBoxSelect.SetCheckedState(item, true); } btnDelete.Enabled = true; btnSelect_All.Text = "取消全选"; } else { foreach (int item in select) { CBoxSelect.SetCheckedState(item, false); } btnDelete.Enabled = false; btnSelect_All.Text = "全选"; } }
//界面初始化 public void InitData() { try { ViewState["page"] = 0; List <AchivementApply> list = applys.FindPage(Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchieveApply.RecordCount = list.Count(); if (list != null) { Grid_AchieveApply.DataSource = list.Skip(Grid_AchieveApply.PageIndex * Grid_AchieveApply.PageSize).Take(Grid_AchieveApply.PageSize); Grid_AchieveApply.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按成果名称搜索 public void FindByAchievementNmae() { try { ViewState["page"] = 1; List <int> achieve = ach.FindByAchievementNamelist(tCondition.Text.Trim()); List <AchivementApply> list = applys.FindByAchievementName(achieve, Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchieveApply.RecordCount = list.Count(); if (list != null) { Grid_AchieveApply.DataSource = list.Skip(Grid_AchieveApply.PageIndex * Grid_AchieveApply.PageSize).Take(Grid_AchieveApply.PageSize); Grid_AchieveApply.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按完成人查询 public void FindByPeople() { try { ViewState["page"] = 2; List <int> UserInfoID = user.FindList(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); List <int> AchieveID = blst.SelectIDlist(UserInfoID, Convert.ToInt32(Session["SecrecyLevel"])); List <Common.Entities.AchivementApply> list = applys.FindByAchievementName(AchieveID, Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchieveApply.RecordCount = list.Count(); if (list != null) { Grid_AchieveApply.DataSource = list.Skip(Grid_AchieveApply.PageIndex * Grid_AchieveApply.PageSize).Take(Grid_AchieveApply.PageSize); Grid_AchieveApply.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//导出 protected void btn_Get_Click(object sender, EventArgs e) { try { if (page == 0) { List <AchivementApply> list = applys.FindPage(Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchieveApply.RecordCount = list.Count(); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 1) { List <int> AchievementID = ach.FindByAchievementNamelist(tCondition.Text); List <AchivementApply> list = applys.FindByAchievementName(AchievementID, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 2) { List <int> UserInfoID = user.FindList(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); List <int> AchieveID = blst.SelectIDlist(UserInfoID, Convert.ToInt32(Session["SecrecyLevel"])); List <Common.Entities.AchivementApply> list = applys.FindByAchievementName(AchieveID, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 3) { List <AchivementApply> list = applys.FindByTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 4) { List <AchivementApply> list = applys.FindByUnit(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 5) { List <AchivementApply> list = applys.FindBySecrecyLevel(exchangesecrecylevel(dCondition.SelectedValue), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } if (page == 6) { List <AchivementApply> list = applys.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchieveApply.DataSource = list; Grid_AchieveApply.DataBind(); } } pm.ExportExcel(3, Grid_AchieveApply, 1); } catch (Exception ex) { pm.SaveError(ex, this.Request); } }