//全选按钮 protected void btnSelect_All_Click(object sender, EventArgs e) { Grid_Achievementt.SelectAllRows(); int[] select = Grid_Achievementt.SelectedRowIndexArray; int m; //取整数(不是四舍五入,全舍) int Pages = (int)Math.Floor(Convert.ToDouble(Grid_Achievementt.RecordCount / this.Grid_Achievementt.PageSize)); if (Grid_Achievementt.PageIndex == Pages) { m = (Grid_Achievementt.RecordCount - this.Grid_Achievementt.PageSize * Grid_Achievementt.PageIndex); } else { m = this.Grid_Achievementt.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 FindByLevel() { try { ViewState["page"] = 6; List <Common.Entities.Achievement> list = achieve.FindByLevel(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); Grid_Achievementt.RecordCount = list.Count(); if (list != null) { Grid_Achievementt.DataSource = list.Skip(Grid_Achievementt.PageIndex * Grid_Achievementt.PageSize).Take(Grid_Achievementt.PageSize); Grid_Achievementt.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 <Common.Entities.Achievement> list = achieve.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 1) { // List<int> ProjectID = project.FindProjectList(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); List <Common.Entities.Achievement> list = achieve.FindByProject(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.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.Achievement> list = achieve.SelectAll(AchieveID, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 3) { List <Common.Entities.Achievement> list = achieve.FindByName(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 4) { List <Common.Entities.Achievement> list = achieve.FindByTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 5) { List <Common.Entities.Achievement> list = achieve.FindByUnit(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 6) { List <Common.Entities.Achievement> list = achieve.FindByLevel(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 9) { int selevel = LevelChange(dCondition.SelectedText.Trim()); List <Common.Entities.Achievement> list = achieve.FindBySecrecyLevel(selevel, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } if (page == 10) { List <Common.Entities.Achievement> list = achieve.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Achievementt.DataSource = list; Grid_Achievementt.DataBind(); } } pm.ExportExcel(3, Grid_Achievementt, 2); } catch (Exception ex) { pm.SaveError(ex, this.Request); } }