//初始化 public void InitData() { try { ViewState["page"] = 0; List <Common.Entities.AchievementCA> list = ca.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchievementCA.RecordCount = list.Count(); if (list != null) { Grid_AchievementCA.DataSource = list.Skip(Grid_AchievementCA.PageIndex * Grid_AchievementCA.PageSize).Take(Grid_AchievementCA.PageSize); Grid_AchievementCA.DataBind(); } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按名称搜索 public void FindByName() { try { ViewState["page"] = 1; List <int> achieve = ach.FindByAchievementNamelist(tCondition.Text.Trim()); List <Common.Entities.AchievementCA> list = ca.FindByAchievementName(achieve, Convert.ToInt32(Session["SecrecyLevel"])); Convert.ToInt32(Session["SecrecyLevel"]); Grid_AchievementCA.RecordCount = list.Count(); if (list != null) { Grid_AchievementCA.DataSource = list.Skip(Grid_AchievementCA.PageIndex * Grid_AchievementCA.PageSize).Take(Grid_AchievementCA.PageSize); Grid_AchievementCA.DataBind(); } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按完成人搜索 public void FindByPeople() { try { ViewState["page"] = 4; 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.AchievementCA> list = ca.FindByAchievementName(AchieveID, Convert.ToInt32(Session["SecrecyLevel"])); Grid_AchievementCA.RecordCount = list.Count(); if (list != null) { Grid_AchievementCA.DataSource = list.Skip(Grid_AchievementCA.PageIndex * Grid_AchievementCA.PageSize).Take(Grid_AchievementCA.PageSize); Grid_AchievementCA.DataBind(); } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按验收评语级别 public void FindByCACommnetLevel() { try { //保存当前的搜索状态 ViewState["page"] = 5; //获取到查询结果 List <Common.Entities.AchievementCA> list = ca.FindByCACommnetLevel(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); //结果数量传给前台 Grid_AchievementCA.RecordCount = list.Count(); if (list != null) { Grid_AchievementCA.DataSource = list.Skip(Grid_AchievementCA.PageIndex * Grid_AchievementCA.PageSize).Take(Grid_AchievementCA.PageSize); Grid_AchievementCA.DataBind(); } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//导出 protected void btn_Get_Click(object sender, EventArgs e) { try { if (page == 0) { List <Common.Entities.AchievementCA> list = ca.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 1) { List <int> achieve = ach.FindByAchievementNamelist(tCondition.Text.Trim()); List <Common.Entities.AchievementCA> list = ca.FindByAchievementName(achieve, Convert.ToInt32(Session["SecrecyLevel"])); Convert.ToInt32(Session["SecrecyLevel"]); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 2) { List <Common.Entities.AchievementCA> list = ca.FindByCATime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 3) { List <Common.Entities.AchievementCA> list = ca.FindByCAUnit(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 4) { 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.AchievementCA> list = ca.FindByAchievementName(AchieveID, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 5) { List <Common.Entities.AchievementCA> list = ca.FindByCACommnetLevel(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 6) { List <Common.Entities.AchievementCA> list = ca.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } if (page == 7) { List <Common.Entities.AchievementCA> list = ca.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_AchievementCA.DataSource = list; Grid_AchievementCA.DataBind(); } } pm.ExportExcel(3, Grid_AchievementCA, 1); } catch (Exception ex) { pm.SaveError(ex, this.Request); } }