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