/// <summary>
/// 修改数据列表的显示
/// </summary>
/// <param name="sift">是否打筛选栏</param>
/// <param name="count">导航页数</param>
/// <param name="item">数据条数</param>
private void ModifyDataList(int founderid, int sift, int count, int item)
{
string strsql = " ownersid=" + founderid;
DataTable tbl = EtNet_BLL.SearchPageSetManager.GetList(strsql);
EtNet_Models.SearchPageSet pageset = null;
int id = 0;
for (int i = 0; i < tbl.Rows.Count; i++)
{
id = int.Parse(tbl.Rows[i]["id"].ToString());
pageset = EtNet_BLL.SearchPageSetManager.GetModel(id);
pageset.Pagecount = count;
pageset.Pageitem = item;
EtNet_BLL.SearchPageSetManager.updateSearchPageSet(pageset);
}
}
//重置
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
this.tbxnumber.Text = "";
this.ddlauditstatus.SelectedIndex = 0;
this.ddlsavestatus.SelectedIndex = 0;
this.iptstartdate.Value = "";
this.iptenddate.Value = "";
DataTable tbl = Exists();
int id = int.Parse(tbl.Rows[0]["id"].ToString());
EtNet_Models.SearchPageSet upmodel = EtNet_BLL.SearchPageSetManager.GetModel(id);
if (upmodel != null)
{
upmodel.searchsift = " AND auditstatus in('01','02') ";
EtNet_BLL.SearchPageSetManager.Update(upmodel);
}
LoadSupplyFormData();
}
/// <summary>
/// 检验页面设置记录是否存在,如不存在新建一条记录
/// </summary>
private DataTable Exists()
{
string strsql = " Ownersid = " + ((EtNet_Models.LoginInfo)Session["login"]).Id;
strsql += " AND Pagenum='028'";
DataTable tbl = EtNet_BLL.SearchPageSetManager.GetList(strsql);
if (tbl.Rows.Count < 1)
{
EtNet_Models.SearchPageSet pageset = new EtNet_Models.SearchPageSet();
pageset.Ownersid = ((EtNet_Models.LoginInfo)Session["login"]).Id;
pageset.Pagenum = "028";
pageset.Pagecount = 10;
pageset.Pageitem = 10;
EtNet_BLL.SearchPageSetManager.addSearchPageSet(pageset);
return(Exists());
}
else
{
return(tbl);
}
}
/// <summary>
/// 创建用户的初始化参数
/// </summary>
/// <param name="ownersid">用户的id值</param>
private void CreateInitializeData(int ownersid)
{
DataTable tbl = EtNet_BLL.InitializeSetManager.GetList(1, "", "id");
if (tbl.Rows.Count == 1)
{
string strpagenum = "001,002,003,004,008,011,013,014,019,020,021,022,024,025,030,";
strpagenum += "100,101,102,105,111,140,201";
string[] list = strpagenum.Split(',');
EtNet_Models.SearchPageSet model = null;
for (int i = 0; i < list.Length; i++)
{
model = new EtNet_Models.SearchPageSet();
model.Ownersid = ownersid;
model.Pagenum = list[i];
model.Pagecount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
model.Pageitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
EtNet_BLL.SearchPageSetManager.addSearchPageSet(model);
}
EtNet_Models.InitializeUserSet usermodel = new EtNet_Models.InitializeUserSet();
usermodel.cname = tbl.Rows[0]["cname"].ToString();
usermodel.createtime = DateTime.Now;
usermodel.infocycle = int.Parse(tbl.Rows[0]["infocycle"].ToString());
usermodel.inforemind = int.Parse(tbl.Rows[0]["inforemind"].ToString());
usermodel.newinforemind = int.Parse(tbl.Rows[0]["newinforemind"].ToString());
usermodel.pagecount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
usermodel.pageitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
usermodel.panelcols = int.Parse(tbl.Rows[0]["panelcols"].ToString());
usermodel.panelcount = tbl.Rows[0]["panelcount"].ToString();
usermodel.panellist = tbl.Rows[0]["panellist"].ToString();
usermodel.panellistall = tbl.Rows[0]["panellistall"].ToString();
usermodel.createrid = ownersid;
EtNet_BLL.InitializeUserSetManager.Add(usermodel);
PanelMenuRecord(ownersid, usermodel.panelcols);
FirstPanelItem(ownersid, usermodel.panellist);
}
}
/// <summary>
/// 检验页面设置记录是否存在,如不存在新建一条记录
/// </summary>
private DataTable Exists()
{
string strsql = " ownersid = " + ((EtNet_Models.LoginInfo)Session["login"]).Id;
strsql += " AND pagenum='009'";
DataTable tbl = EtNet_BLL.SearchPageSetManager.GetList(strsql);
if (tbl.Rows.Count < 1)
{
EtNet_Models.SearchPageSet pageset = new EtNet_Models.SearchPageSet();
pageset.ownersid = ((EtNet_Models.LoginInfo)Session["login"]).Id;
pageset.pagenum = "009";
pageset.pagecount = 2;
pageset.pageitem = 2;
pageset.searchsift = " AND auditstatus in ('01','02')";
pageset.siftfence = 0;
EtNet_BLL.SearchPageSetManager.Add(pageset);
return(Exists());
}
else
{
return(tbl);
}
}
/// <summary>
/// 查询显示请假单的数据
/// </summary>
private void LoadLeaveFormData()
{
DataTable tbl = Exists();
string str = " AND founderid=" + ((EtNet_Models.LoginInfo)Session["login"]).Id + " ";
string strSql = "";
if (this.tbxnumber.Text != "")
{
strSql += " AND cname like '%" + this.tbxnumber.Text + "%' ";
}
if (this.ddlauditstatus.SelectedIndex != 0)
{
if (this.ddlauditstatus.SelectedIndex == 1)
{
strSql += " AND auditstatus in('01','02','03','04') ";
}
else
{
strSql += " AND auditstatus='" + this.ddlauditstatus.SelectedValue + "'";
}
}
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());
EtNet_Models.SearchPageSet upmodel = EtNet_BLL.SearchPageSetManager.GetModel(id);
if (upmodel != null)
{
upmodel.searchsift = strSql;
EtNet_BLL.SearchPageSetManager.Update(upmodel);
}
}
int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet set = data.DataPage("ViewApplyLeaveList", "id", "*", str + strSql, "id", true, pitem, pcount, pages);
this.rptapplyleaveform.DataSource = set;
this.rptapplyleaveform.DataBind();
}
