/// <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();
        }