//按发明人查询 public void FindByPeople() { try { ViewState["page"] = 5; List <Patent> list = patent.FindByPatentPeople(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); Grid_Patent.RecordCount = list.Count(); if (list != null) { Grid_Patent.DataSource = list.Skip(Grid_Patent.PageIndex * Grid_Patent.PageSize).Take(Grid_Patent.PageSize); Grid_Patent.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按保密级别查询 private void FindBySecrecyLevel() { try { ViewState["page"] = 7; List <Patent> list = patent.FindBySecrecyLevel(secrecyLevel.SelectedIndex + 1, Convert.ToInt32(Session["SecrecyLevel"])); Grid_Patent.RecordCount = list.Count(); if (list != null) { Grid_Patent.DataSource = list.Skip(Grid_Patent.PageIndex * Grid_Patent.PageSize).Take(Grid_Patent.PageSize); Grid_Patent.DataBind(); } else { return; } } catch (Exception ex) { pm.SaveError(ex, this.Request); } }
//按授权时间查询 public void FindByAccreditTime() { try { ViewState["page"] = 4; List <Common.Entities.Patent> list = patent.FindByAccreditTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); Grid_Patent.RecordCount = list.Count(); if (list != null) { Grid_Patent.DataSource = list.Skip(Grid_Patent.PageIndex * Grid_Patent.PageSize).Take(Grid_Patent.PageSize); Grid_Patent.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.Patent> list = patent.FindPaged(Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 1) { List <Common.Entities.Patent> list = patent.FindByPatentDepartment(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 3) { List <Common.Entities.Patent> list = patent.FindByApplicationTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 4) { List <Common.Entities.Patent> list = patent.FindByAccreditTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 5) { List <Patent> list = patent.FindByPatentPeople(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 6) { List <Patent> list = patent.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else if (page == 7) { List <Patent> list = patent.FindBySecrecyLevel(secrecyLevel.SelectedIndex + 1, Convert.ToInt32(Session["SecrecyLevel"])); if (list != null) { Grid_Patent.DataSource = list; Grid_Patent.DataBind(); } } else { return; } pm.ExportExcel(3, Grid_Patent, 4); } catch (Exception ex) { pm.SaveError(ex, this.Request); } }