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