/// <summary>
/// 导出
/// </summary>
private void ToXls()
{
int recordCount = 0;
//金额汇总信息
decimal sum = 0;
MPayableApproveBase queryModel = new MPayableApproveBase {
CompanyId = CurrentUserCompanyID
};
IList <MPayableApprove> ls = new BFinance().GetMPayableApproveLst(
UtilsCommons.GetToXlsRecordCount(),
1,
ref recordCount,
ref sum,
queryModel);
if (ls != null && ls.Count > 0)
{
StringBuilder sb = new StringBuilder();
//应付账款
sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n",
"计调项",
"团号",
"出团时间",
"供应商单位",
"请款人",
"付款金额",
"最晚付款时间",
"备注");
foreach (MPayableApprove item in ls)
{
sb.Append(item.PlanTyp + "\t");
sb.Append(item.TourCode + "\t");
sb.Append(UtilsCommons.GetDateString(item.LDate, ProviderToDate) + "\t");
sb.Append(item.Supplier + "\t");
sb.Append(item.Dealer + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.PayAmount, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetDateString(item.PayExpire, ProviderToDate) + "\t");
sb.Append(item.Remark + "\n");
}
ResponseToXls(sb.ToString());
}
ResponseToXls(string.Empty);
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
//系统配置实体
MComSetting comModel = new BComSetting().GetModel(CurrentUserCompanyID) ?? new MComSetting();
IsEnableKis = comModel.IsEnableKis;
//获取分页参数并强转
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
MPayableApproveBase queryModel = new MPayableApproveBase();
#region 查询参数
//公司id
queryModel.CompanyId = CurrentUserCompanyID;
//
int status = Utils.GetIntSign(Utils.GetQueryStringValue("Status"), -1);
if (status >= 0)
{
queryModel.Status = (FinStatus)status;
}
queryModel.PlanTyp = (PlanProject?)Utils.GetIntNull(Utils.GetQueryStringValue("sustainType"));
//团号
queryModel.TourCode = Utils.GetQueryStringValue("txt_teamNumber");
//供应商
queryModel.Supplier = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHMC);
//供应商Id
queryModel.SupplierId = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHBH);
//请款人
queryModel.Dealer = SellsSelect1.SellsName = Utils.GetQueryStringValue(SellsSelect1.SellsNameClient);
//请款人Id
queryModel.DealerId = SellsSelect1.SellsID = Utils.GetQueryStringValue(SellsSelect1.SellsIDClient);
//付款时间 始
queryModel.PaymentDateS = Utils.GetQueryStringValue("txt_paymentDateS");
//付款时间 终
queryModel.PaymentDateE = Utils.GetQueryStringValue("txt_paymentDateE");
//最晚付款日期 始
queryModel.DeadlineS = Utils.GetQueryStringValue("txt_DeadlineS");
//最晚付款日期 终
queryModel.DeadlineE = Utils.GetQueryStringValue("txt_DeadlineE");
#endregion
decimal sum = 0;
IList <MPayableApprove> ls = new BFinance().GetMPayableApproveLst(
pageSize,
pageIndex,
ref recordCount,
ref sum,
queryModel);
lbl_sum.Text = UtilsCommons.GetMoneyString(sum, ProviderToMoney);
if (ls != null && ls.Count > 0)
{
pan_sum.Visible = true;
pan_Msg.Visible = false;
rpt_list.DataSource = ls;
rpt_list.DataBind();
//绑定分页
BindPage();
}
ExporPageInfoSelect1.Visible = ls != null && ls.Count > 0 && recordCount > pageSize;
}
