/// <summary>
/// 加载图片数据
/// </summary>
private void LoadPictureData()
{
this.picturedata.Visible = true;
this.pages.Visible = true;
DataTable strtbl = Exists();
string login = ((EtNet_Models.LoginInfo)Session["login"]).Id.ToString();
string strfixed = " AND creatercode not in(" + login + ") AND sharecode = 1 AND ',' + viewidlist + ',' like '%," + login + ",%'";
string strsql = Session["query"].ToString();
int pitem = int.Parse(strtbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(strtbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataTable tbl = data.DataPage("ViewPictureInfo", "id", "*", strfixed + strsql, "id", true, pitem, pcount, pages).Tables[0];
string str = "";
for (int i = 0; i < tbl.Rows.Count; i++)
{
str += "<div class='pictotal'>";
str += "<div class='pictop' title='" + tbl.Rows[i]["sharestxt"] + "'>";
str += "<img src='" + tbl.Rows[i]["imgpath"] + "' /></div>";
str += "<div class='piccenter'>" + tbl.Rows[i]["cname"] + "</div></div>";
}
if (str == "")
{
this.picturedata.Visible = false;
}
else
{
this.picturedata.InnerHtml = str;
}
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderList()
{
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = Session["login"] as LoginInfo;
if (Session["cutPay"].ToString() != "")
{
string sql = " collectStatus='完成收款' ";
sql += Session["cutPay"].ToString();
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 033);
if (sps != null)
{
this.j_pagesize.Value = sps.Pageitem.ToString();
this.j_pagecount.Value = sps.Pagecount.ToString();
}
this.payRepeater.DataSource = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
this.payRepeater.DataBind();
}
}
}
///// <summary>
///// 加载收款单位
///// </summary>
//private void LoadColUnit()
//{
// this.collectUnit.Items.Clear();
// this.collectUnit.Items.Add(new ListItem("——请选择——", "0"));
// IList<Customer> customers = CustomerManager.getCustomerAll();
// foreach (Customer customer in customers)
// {
// ListItem adItem = new ListItem();
// adItem.Value = customer.Id.ToString();
// adItem.Text = customer.CusshortName;
// this.collectUnit.Items.Add(adItem);
// }
//}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadInvoiceRecordList()
{
LoginInfo login = Session["login"] as LoginInfo;
string sql = " ";
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("InvoiceRecord", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 032);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("InvoiceRecord", "makeDate", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
/// <summary>
/// 加载明细数据
/// </summary>
private void LoadReimbursementDetial()
{
pagesql = "";
pagesql = Session["sort"].ToString();
this.pages.Visible = true;
double zje = 0;
DataTable tbl = Exists();
pagesql += Session["query"];
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("View_AusDetialInfo", "id", "*", pagesql, "happendate", true, pitem, pcount, pages);
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
zje += set.Tables[0].Rows[i]["ausmoney"].ToString() == "" ? 0.00 : Convert.ToDouble(set.Tables[0].Rows[i]["ausmoney"]);
}
this.rptdata.DataSource = set;
this.rptdata.DataBind();
Session["MyData"] = set.Tables[0];
this.zje.Text = zje.ToString("0.00");
}
/// <summary>
/// 查询显示报销单的数据
/// </summary>
private void LoadReimbursementFormData()
{
this.pages.Visible = true;
DataTable tbl = Exists();
string str = "";
int login = ((EtNet_Models.LoginInfo)Session["login"]).Id;
string strlist = EtNet_BLL.LoginDataLimitManager.GetLimit(login);
if (strlist == null || strlist.Trim() == "")
{
str = " AND founderid in(" + login + ")";
}
else
{
str = " AND founderid in(" + login + "," + strlist + ")";
}
str += Session["query"].ToString();
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("ViewAusRottenInfo", "id", "*", str, "id", true, pitem, pcount, pages);
this.rptdata.DataSource = set;
this.rptdata.DataBind();
}
/// <summary>
/// 加载金额预算信息
/// </summary>
private void LoadMoney()
{
decimal zje = 0; //总金额
decimal zyzf = 0; //总已支付金额
decimal zkzf = 0; //总可支付金额
this.pages.Visible = true;
DataTable tbl = Exists();
sqlstr += Session["query"].ToString();
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("DepartMoney", "ID", "*", sqlstr, "ID", true, pitem, pcount, pages);
this.moneylist.DataSource = set;
this.moneylist.DataBind();
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
zje += set.Tables[0].Rows[i]["amount"].ToString() == "" ? 0 : Convert.ToDecimal(set.Tables[0].Rows[i]["amount"]); //累加总金额
zyzf += set.Tables[0].Rows[i]["haspay"].ToString() == "" ? 0 : Convert.ToDecimal(set.Tables[0].Rows[i]["haspay"]); //累加总可支付金额
}
zkzf = zje - zyzf;
this.zzje.Text = zje.ToString("0.00");
this.zyzf.Text = zyzf.ToString("0.00");
this.zkzf.Text = zkzf.ToString("0.00");
}
/// <summary>
/// 数据绑定
/// </summary>
public void dataBind()
{
int count = Convert.ToInt32(ConfigurationManager.AppSettings["CMSCount"]);
int page = Convert.ToInt32(ConfigurationManager.AppSettings["CMSPage"]);
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("Customer", "Id", "*", "", "Id", true, count, page, pages);
rpCustomer.DataSource = ds;
rpCustomer.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
private void BindData()
{
int count = Convert.ToInt32(ConfigurationManager.AppSettings["CMSCount"]);
int page = Convert.ToInt32(ConfigurationManager.AppSettings["CMSPage"]);
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("ViewAusRottenInfo", "id", "*", "", "id", true, count, page, pages);
rpPoliy.DataSource = ds;
rpPoliy.DataBind();
}
//加载文档列表
private void LoadAnnouncementList()
{
if (Request.Params["id"] != null && Request.Params["id"] != "")
{
string strsql = " AND announcementcode=" + Request.Params["id"];
int pitem = 5;
int pcount = 10;
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet set = data.DataPage("ViewAnnouncementLog", "id", "*", strsql, "id", true, pitem, pcount, pages);
this.rptrecord.DataSource = set;
this.rptrecord.DataBind();
}
}
/// <summary>
/// 加载订单信息
/// </summary>
private void LoadOrderInfo()
{
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sql = " and orderid in " + id;
sql += Session["invoiceQuery"]; //收款单位
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("View_OrderAndClollect", "orderid", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
}
/// <summary>
/// 加载综合比率信息
/// </summary>
public void LoadRate()
{
this.pages.Visible = true;
DataTable tbl = Exists(); //页面设置信息
string sql = "";
sql += Session["query"].ToString();
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 ds = data.DataPage("LoginProdRate", "id", "*", sql, "id", false, pitem, pcount, pages);
this.ratelist.DataSource = ds;
this.ratelist.DataBind();
}
/// <summary>
/// 加载审核的工作流的数据
/// </summary>
private void LoadRptjobflowData()
{
pages.Visible = true;
DataTable tbl = Exists();
string str = " AND auditoperat = '未操作' AND reviewerid =" + ((EtNet_Models.LoginInfo)Session["login"]).Id + " AND (nowreviewer ='T' OR nowreviewer='p') ";
str += Session["query"].ToString();
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("ViewAuditJobFlow", "id", "*", str, "id", true, pitem, pcount, pages);
this.rptauditjobflow.DataSource = set;
this.rptauditjobflow.DataBind();
}
//加载公司数据
private void LoadFirmData()
{
DataTable strtbl = Exists();
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
//SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 201);
int pitem = int.Parse(strtbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(strtbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet tbl = data.DataPage("FirmInfo", "id", "*", sqlstr, "id", true, pitem, pcount, pages);
this.rptfirm.DataSource = tbl;
this.rptfirm.DataBind();
}
/// <summary>
/// 查询审核规则的数据
/// </summary>
private void LoadAuditRoleData()
{
DataTable tbl = Exists();
string str = Session["query"].ToString();
if (str == "")
{
str += " and hide =1";
}
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("ViewApprovalRule", "id", "*", str, "id", true, pitem, pcount, pages);
this.rptauditrole.DataSource = set;
this.rptauditrole.DataBind();
}
/// <summary>
/// 加载公告数据
/// </summary>
private void LoadAnnouncementList()
{
this.pages.Visible = true;
DataTable strtbl = Exists();
EtNet_Models.LoginInfo model = (EtNet_Models.LoginInfo)Session["login"];
string strsql = "AND visiblecode=1 AND statuscode=2 ";
strsql += "AND (sortcode=1 OR (sortcode=2 AND ',' + departlist +',' like '%," + model.Departid + ",%' ))";
strsql += Session["query"].ToString();
int pitem = int.Parse(strtbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(strtbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet tbl = data.DataPage("ViewAnnouncementInfo", "id", "*", strsql, "createtime", true, pitem, pcount, pages);
this.rptdata.DataSource = tbl;
this.rptdata.DataBind();
}
/// <summary>
/// 加载订单收款信息
/// </summary>
private void LoadOrderInfo()
{
//CutPayList cList = (CutPayList)Context.Handler;
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sort = Request.QueryString["sort"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
switch (sort)
{
case "0":
this.czy.Visible = false;
string sql = " and collectId in " + id;
DataSet ds = data.DataPage("View_OrderAndClollect", "collectId", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
sql = " 1=1 " + sql;
DataTable dt0 = To_OrderInfoManager.GetViewOrderAndCollect("sum(adultNum)+sum(childNum) as num,sum(lirun) as lirun", sql);
if (dt0.Rows.Count > 0)
{
this.sumNum.InnerText = dt0.Rows[0]["num"].ToString();
this.sumlirun.InnerText = dt0.Rows[0]["lirun"].ToString();
}
break;
case "1":
this.ywy.Visible = false;
string str = " and id in " + id;
DataSet dt = data.DataPage("To_orderInfo", "id", "*", str, "orderNum", false, 5, 5, pages);
czyRepeater.DataSource = dt;
czyRepeater.DataBind();
str = " 1=1 " + str;
DataTable dt1 = To_OrderInfoManager.getList("sum(inputerTc) as inputerTc", str);
if (dt1.Rows.Count > 0)
{
this.suminputerTc.InnerText = dt1.Rows[0]["inputerTc"].ToString();
}
break;
}
}
/// <summary>
/// 加载付款申请数据
/// </summary>
private void LoadPayList()
{
LoginInfo login = Session["login"] as LoginInfo;
if (!string.IsNullOrEmpty(Session["payQuery"].ToString()) || !string.IsNullOrEmpty(Session["query"].ToString()))//--0429 更改
{
//}
//if (Session["payQuery"].ToString() != "" || Session["query"].ToString() != "")//原方法报错
//{
string sql = " and auditstatus = '04' ";
sql += Session["payQuery"];
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("View_PaymentList", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 040);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
//0429 修改 为了排序顺序
// DataTable dt = new EtNet_BLL.RegReimbursementManager().GetListpage(" auditstatus = '04'" + Session["payQuery"] + Session["query"], "regType asc,confirmDate DESC", AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
DataTable dt = data.GetpageList("View_PaymentList", " regType asc,confirmDate DESC ", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
// DataTable dt = data.GetList("View_PaymentList", "isConfirm", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);//原方法
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
else
{
this.payRepeater.DataSource = null;
this.payRepeater.DataBind();
}
}
/// <summary>
/// 查询显示所有报销明细数据
/// </summary>
private void LoadAllAusDetial()
{
this.pages.Visible = true;
double zje = 0;
DataTable tbl = Exists();
string str = "";
int login = ((LoginInfo)Session["login"]).Id;
string strlist = LoginDataLimitManager.GetLimit(login);
if (strlist == null || strlist.Trim() == "")
{
str = " AND founderid in (" + login + ")";
}
else
{
str = " AND founderid in (" + login + "," + strlist + ")";
}
str += Session["query"];
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("View_AllAusDetial", "bxdh", "*", str, "applydate", true, pitem, pcount, pages);
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
zje += set.Tables[0].Rows[i]["ausmoney"].ToString() == "" ? 0.00 : Convert.ToDouble(set.Tables[0].Rows[i]["ausmoney"]);
}
this.rptdata.DataSource = set;
this.rptdata.DataBind();
this.zje.Text = zje.ToString("0.00");
}
/// <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();
}
