/// <summary>
/// 绑定统计数据
/// </summary>
/// <param name="xmlSum">xml类型的字符串</param>
private void BindSum(MBatchWriteOffOrder sumModel)
{
if (sumModel != null)
{
//应付
lbl_receivable.Text = UtilsCommons.GetMoneyString(sumModel.Receivable, ProviderToMoney);
//已付
lbl_received.Text = UtilsCommons.GetMoneyString(sumModel.Received, ProviderToMoney);
//未付
lbl_unreceivable.Text = UtilsCommons.GetMoneyString(sumModel.Unreceivable, ProviderToMoney);
}
}
/// <summary>
/// 导出
/// </summary>
private void ToXls()
{
int recordCount = 0;
MBatchWriteOffOrder sumModel = new MBatchWriteOffOrder();
IList <MBatchWriteOffOrder> ls = new BFinance().GetArrearOrderLstByCrmId(
UtilsCommons.GetToXlsRecordCount(),
1,
ref recordCount,
ref sumModel,
Utils.GetQueryStringValue("crmId"));
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 (MBatchWriteOffOrder item in ls)
{
sb.Append(item.TourCode + "\t");
sb.Append(item.RouteName + "\t");
sb.Append(item.AdultNum + "+" + item.ChildNum + "\t");
sb.Append(EyouSoft.Common.UtilsCommons.GetDateString(item.LDate, ProviderToDate) + "\t");
sb.Append(EyouSoft.Common.UtilsCommons.GetDateString(item.OrderTime, ProviderToDate) + "\t");
sb.Append(EyouSoft.Common.UtilsCommons.GetMoneyString(item.Receivable, ProviderToMoney) + "\t");
sb.Append(EyouSoft.Common.UtilsCommons.GetMoneyString(item.Received, ProviderToMoney) + "\t");
sb.Append(EyouSoft.Common.UtilsCommons.GetMoneyString(item.Unreceivable, ProviderToMoney) + "\n");
}
sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n",
"",
"",
"",
"",
"合计",
UtilsCommons.GetMoneyString(sumModel.Receivable, ProviderToMoney),
UtilsCommons.GetMoneyString(sumModel.Received, ProviderToMoney),
UtilsCommons.GetMoneyString(sumModel.Unreceivable, ProviderToMoney));
ResponseToXls(sb.ToString());
}
ResponseToXls(string.Empty);
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
lbl_Title.Text = SiteUserInfo.CompanyName + "【与 <b class=fontred>" + Utils.GetQueryStringValue("crmName") + "</b> 的核算单】";
string crmId = Utils.GetQueryStringValue("crmId");
#region 分页参数
int pageSize = 10;
int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);;
int recordCount = 0;
#endregion
MBatchWriteOffOrder sumModel = new MBatchWriteOffOrder();
IList <MBatchWriteOffOrder> ls = new BFinance().GetArrearOrderLstByCrmId(pageSize, pageIndex, ref recordCount, ref sumModel, crmId);
if (ls != null && ls.Count > 0)
{
rpt_list.DataSource = ls;
rpt_list.DataBind();
BindPage(pageSize, pageIndex, recordCount);
}
//绑定统计数据
BindSum(sumModel);
ExporPageInfoSelect1.Visible = ls != null && ls.Count > 0 && recordCount > pageSize;
}
