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