/// <summary>
/// 导出
/// </summary>
private void ToXls()
{
int recordCount = 0;
//金额汇总信息
decimal sum = 0;
MAuditBase queryModel = new MAuditBase();
queryModel.TourCode = Utils.GetQueryStringValue("tourID");
queryModel.IssueTimeS = Utils.GetQueryStringValue("SDate");
queryModel.IssueTimeE = Utils.GetQueryStringValue("EDate");
queryModel.SellerId = txt_Seller.SellsID = Utils.GetQueryStringValue(txt_Seller.SellsIDClient);
queryModel.SellerName = txt_Seller.SellsName = Utils.GetQueryStringValue(txt_Seller.SellsNameClient);
queryModel.Crm = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHMC);
queryModel.CrmId = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHBH);
IList <MReconciliation> ls = new BFinance().GetReconciliationLst(
UtilsCommons.GetToXlsRecordCount(),
1,
ref recordCount,
ref sum,
ReconciliationType.今日应收,
CurrentUserCompanyID,
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}\n",
"订单号",
"线路名称",
"客户单位",
"销售员",
"应收金额",
"核算日期",
"财务人");
foreach (MReconciliation item in ls)
{
sb.Append(item.OrderCode + "\t");
sb.Append(item.RouteName + "\t");
sb.Append(item.Crm + "\t");
sb.Append(item.SellerName + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.Amount, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetDateString(item.IssueTime, ProviderToDate) + "\t");
sb.Append(item.Operator + "\n");
}
ResponseToXls(sb.ToString());
}
ResponseToXls(string.Empty);
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
CustomerUnitSelect1.DefaultTab = PlanProject.酒店;
#region 分页参数
int pageSize = 20;
int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
int recordCount = 0;
#endregion
MAuditBase queryModel = new MAuditBase();
queryModel.TourCode = Utils.GetQueryStringValue("tourID");
queryModel.IssueTimeS = Utils.GetQueryStringValue("SDate");
queryModel.IssueTimeE = Utils.GetQueryStringValue("EDate");
queryModel.SellerId = txt_Seller.SellsID = Utils.GetQueryStringValue(txt_Seller.SellsIDClient);
queryModel.SellerName = txt_Seller.SellsName = Utils.GetQueryStringValue(txt_Seller.SellsNameClient);
queryModel.Crm = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHMC);
queryModel.CrmId = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHBH);
queryModel.SignAmount = (EqualSign?)Utils.GetEnumValueNull(typeof(EqualSign), Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperator));
queryModel.Amount = Utils.GetDecimalNull(Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperatorNumber));
queryModel.PlanItem = (PlanProject?)Utils.GetEnumValueNull(typeof(PlanProject), Utils.GetQueryStringValue("item"));
decimal sum = 0;
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
IList <MReconciliation> ls = new BFinance().GetReconciliationLst(
pageSize,
pageIndex,
ref recordCount,
ref sum,
ReconciliationType.今日应付,
CurrentUserCompanyID,
queryModel
);
lbl_sum.Text = UtilsCommons.GetMoneyString(sum, ProviderToMoney);
if (ls != null && ls.Count > 0)
{
pan_sum.Visible = !(pan_Msg.Visible = false);
rpt_list.DataSource = ls;
rpt_list.DataBind();
//绑定分页
BindPage(pageSize, pageIndex, recordCount);
}
ExporPageInfoSelect1.Visible = ls != null && ls.Count > 0 && recordCount > pageSize;
}