/// <summary> /// 重置查询条件 protected void ibtnjobreset_Click(object sender, ImageClickEventArgs e) { pages.Visible = true; this.tbxnumber.Text = ""; this.ddlauditstatus.SelectedIndex = 0; this.ddlsavestatus.SelectedIndex = 0; this.iptenddate.Value = ""; this.iptstartdate.Value = ""; DataTable tbl = Exists(); int id = int.Parse(tbl.Rows[0]["id"].ToString()); PJOAModels.SearchPageSet upmodel = PJOABLL.SearchPageSetManager.GetModel(id); if (upmodel != null) { upmodel.searchsift = " AND auditstatus in ('01','02')"; PJOABLL.SearchPageSetManager.Update(upmodel); } LoadSealFormData(); }
/// <summary> /// 检验页面设置记录是否存在,如不存在新建一条记录 /// </summary> private DataTable Exists() { string strsql = " ownersid = " + ((PJOAModels.LoginInfo)Session["login"]).Id; strsql += " AND pagenum='012'"; DataTable tbl = PJOABLL.SearchPageSetManager.GetList(strsql); if (tbl.Rows.Count < 1) { PJOAModels.SearchPageSet pageset = new PJOAModels.SearchPageSet(); pageset.ownersid = ((PJOAModels.LoginInfo)Session["login"]).Id; pageset.pagenum = "012"; pageset.pagecount = 2; pageset.pageitem = 2; pageset.searchsift = " AND auditstatus in ('01','02')"; pageset.siftfence = 0; PJOABLL.SearchPageSetManager.Add(pageset); return(Exists()); } else { return(tbl); } }
/// <summary> /// 查询显示请假单的数据 /// </summary> private void LoadSealFormData() { DataTable tbl = Exists(); string str = " AND founderid=" + ((PJOAModels.LoginInfo)Session["login"]).Id + " "; string strSql = ""; if (this.tbxnumber.Text.Trim() != "") { strSql += " AND jobflowcname like '%" + this.tbxnumber.Text + "%' "; } if (this.ddlauditstatus.SelectedIndex != 0) { if (this.ddlauditstatus.SelectedIndex != 1) { strSql += " AND auditstatus='" + this.ddlauditstatus.SelectedValue + "' "; } else { strSql += " AND auditstatus in('01','02','03','04') "; } } if (this.ddlsavestatus.SelectedIndex != 0) { strSql += " AND savestatus='" + this.ddlsavestatus.SelectedValue + "' "; } if (this.iptstartdate.Value.Trim() != "" && this.iptenddate.Value.Trim() != "") { strSql += " AND (applydate >= '" + this.iptstartdate.Value + "' AND applydate <= '" + this.iptenddate.Value + "') "; } else if (this.iptstartdate.Value.Trim() != "" && this.iptenddate.Value.Trim() == "") { strSql += " AND applydate >= '" + this.iptstartdate.Value + "' "; } else if (this.iptstartdate.Value.Trim() == "" && this.iptenddate.Value.Trim() != "") { strSql += " AND applydate <= '" + this.iptenddate.Value + "' "; } else { } if (strSql == "") { strSql = tbl.Rows[0]["searchsift"].ToString(); } else { int id = int.Parse(tbl.Rows[0]["id"].ToString()); PJOAModels.SearchPageSet upmodel = PJOABLL.SearchPageSetManager.GetModel(id); if (upmodel != null) { upmodel.searchsift = strSql; PJOABLL.SearchPageSetManager.Update(upmodel); } } int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString()); int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString()); PJOABLL.DataPage.Data data = new PJOABLL.DataPage.Data(); DataSet set = data.DataPage("ViewApplySeal", "id", "*", str + strSql, "id", true, pitem, pcount, pages); this.rptsealform.DataSource = set; this.rptsealform.DataBind(); }