/// <summary> /// 获取查询实体 /// </summary> /// <returns></returns> MPayableBase GetChaXunInfo() { MPayableBase info = new MPayableBase(); //系统公司Id info.CompanyId = CurrentUserCompanyID; //是否结清(未结清无参数,已结清有参数) info.IsClean = Utils.GetQueryStringValue("IsClean") == "1"; switch (Utils.GetQueryStringValue("tourType")) { case "1": info.IsConfirmed = true; break; case "2": info.IsConfirmed = false; break; default: break; } //出团时间开始 info.LDateStart = Utils.GetQueryStringValue("SDate"); //出团时间结束 info.LDateEnd = Utils.GetQueryStringValue("EDate"); //付款时间开始 info.PaymentDateS = Utils.GetQueryStringValue("payDateS"); //付款时间结束 info.PaymentDateE = Utils.GetQueryStringValue("payDateE"); //计调类别 info.PlanItem = (PlanProject?)Utils.GetEnumValueNull(typeof(PlanProject), Utils.GetQueryStringValue("sustainType")); //客户单位 info.Supplier = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHMC); info.SupplierId = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHBH); //销售员 info.SalesmanId = txt_Seller.SellsID = Utils.GetQueryStringValue(txt_Seller.SellsIDClient); info.Salesman = txt_Seller.SellsName = Utils.GetQueryStringValue(txt_Seller.SellsNameClient); //计调员 info.Planer = txt_Plan.SellsName = Utils.GetQueryStringValue(txt_Plan.SellsNameClient); info.PlanerId = txt_Plan.SellsID = Utils.GetQueryStringValue(txt_Plan.SellsIDClient); //已付金额 info.SignPaid = (EqualSign?)Utils.GetEnumValueNull(typeof(EqualSign), Utils.GetQueryStringValue(Paid.ClientUniqueIDOperator)); info.Paid = Utils.GetDecimalNull(Utils.GetQueryStringValue(Paid.ClientUniqueIDOperatorNumber)); //未付金额 info.SignUnpaid = (EqualSign?)Utils.GetEnumValueNull(typeof(EqualSign), Utils.GetQueryStringValue(Unpaid.ClientUniqueIDOperator)); info.Unpaid = Utils.GetDecimalNull(Utils.GetQueryStringValue(Unpaid.ClientUniqueIDOperatorNumber)); //团号 info.TourCode = Utils.GetQueryStringValue("TourCode"); return(info); }
/// <summary> /// 初始化 /// </summary> void DataInit() { CustomerUnitSelect1.DefaultTab = PlanProject.酒店; #region 分页参数 int pageSize = 20; int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); int recordCount = 0; #endregion MPayableBase queryModel = GetChaXunInfo(); MPayableSum sum = new MPayableSum(); IList <MPayable> ls = new BFinance().GetPayableLst( pageSize, pageIndex, ref recordCount, ref sum, queryModel); if (ls != null && ls.Count > 0) { pan_sum.Visible = true; pan_Msg.Visible = false; rpt_list.DataSource = ls; rpt_list.DataBind(); //绑定分页 BindPage(pageSize, pageIndex, recordCount); } ExporPageInfoSelect1.Visible = ls != null && ls.Count > 0 && recordCount > pageSize; lbl_TotalPaid.Text = UtilsCommons.GetMoneyString(sum.TotalPaid, ProviderToMoney); lbl_TotalPayable.Text = UtilsCommons.GetMoneyString(sum.TotalPayable, ProviderToMoney); lbl_TotalUnchecked.Text = UtilsCommons.GetMoneyString(sum.TotalUnchecked, ProviderToMoney); lbl_TotalUnpaid.Text = UtilsCommons.GetMoneyString(sum.TotalUnpaid, ProviderToMoney); }
/// <summary> /// 导出 /// </summary> void ToXls() { int recordCount = 0; //金额汇总信息 MPayableSum sum = new MPayableSum(); MPayableBase queryModel = GetChaXunInfo(); IList <MPayable> ls = new BFinance().GetPayableLst(UtilsCommons.GetToXlsRecordCount(), 1, ref recordCount, ref sum, queryModel); if (ls == null || ls.Count == 0) { ResponseToXls(string.Empty); } StringBuilder sb = new StringBuilder(); if (!queryModel.IsClean) { //应付账款 sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\t{9}\t{10}\t{11}\n", "计调项", "团号", "单位名称", "数量", "出团时间", "销售员", "计调员", "状态", "应付金额", "已付金额", "已登待付", "未付金额"); } else { //已结清账款 sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\t{9}\t{10}\n", "计调项", "团号", "单位名称", "数量", "出团时间", "销售员", "计调员", "状态", "应付金额", "已付金额", "未付金额"); } foreach (MPayable item in ls) { sb.Append(item.PlanItem + "\t"); sb.Append(item.TourCode + "\t"); sb.Append(item.Supplier + "\t"); sb.Append(item.Num + "\t"); sb.Append(UtilsCommons.GetDateString(item.LDate, ProviderToDate) + "\t"); sb.Append(item.Salesman + "\t"); sb.Append(item.Planer + "\t"); sb.Append((item.IsConfirmed == true ? "已确认" : "未确认") + "\t"); sb.Append(item.Payable.ToString("F2") + "\t"); if (!item.Paid.HasValue) { item.Paid = 0; } sb.Append(item.Paid.Value.ToString("F2") + "\t"); if (!queryModel.IsClean) { sb.Append(item.UnChecked.ToString("F2") + "\t"); } if (!item.Unpaid.HasValue) { item.Unpaid = 0; } sb.Append(item.Unpaid.Value.ToString("F2") + "\n"); } ResponseToXls(sb.ToString()); }