//导出 protected void btn_Get_Click(object sender, EventArgs e) { try { if (page == 0) { List <Monograph> list = mo.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Monograph.DataSource = list; Grid_Monograph.DataBind(); } } if (page == 1) { List <Monograph> list = mo.FindByPublicTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Monograph.DataSource = list; Grid_Monograph.DataBind(); } } if (page == 2) { List <Monograph> list = mo.FindByMonographPeople(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Monograph.DataSource = list; Grid_Monograph.DataBind(); } } if (page == 3) { List <Monograph> list = mo.FindBySort(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Monograph.DataSource = list; Grid_Monograph.DataBind(); } } pm.ExportExcel(3, Grid_Monograph, 4); } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//全选按钮 protected void btnSelect_All_Click(object sender, EventArgs e) { Grid_Monograph.SelectAllRows(); int[] select = Grid_Monograph.SelectedRowIndexArray; int m; //取整数(不是四舍五入,全舍) int Pages = (int)Math.Floor(Convert.ToDouble(Grid_Monograph.RecordCount / this.Grid_Monograph.PageSize)); if (Grid_Monograph.PageIndex == Pages) { m = (Grid_Monograph.RecordCount - this.Grid_Monograph.PageSize * Grid_Monograph.PageIndex); } else { m = this.Grid_Monograph.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); } Delete.Enabled = true; btnSelect_All.Text = "取消全选"; } else { foreach (int item in select) { CBoxSelect.SetCheckedState(item, false); } Delete.Enabled = false; btnSelect_All.Text = "全选"; } }
//按部门查询 private void FindByAgency() { try { ViewState["page"] = 7; List <Monograph> list = mo.FindByAgency(dCondition.SelectedText.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); //dCondition.SelectedText.Trim() Grid_Monograph.RecordCount = list.Count(); if (list != null) { Grid_Monograph.DataSource = list.Skip(Grid_Monograph.PageIndex * Grid_Monograph.PageSize).Take(Grid_Monograph.PageSize); Grid_Monograph.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按作者查询 public void FindByWriter() { try { ViewState["page"] = 2; List <Monograph> list = mo.FindByMonographPeople(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); Grid_Monograph.RecordCount = list.Count(); if (list != null) { Grid_Monograph.DataSource = list.Skip(Grid_Monograph.PageIndex * Grid_Monograph.PageSize).Take(Grid_Monograph.PageSize); Grid_Monograph.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }