/// <summary>
/// 获取查询信息
/// </summary>
/// <returns></returns>
MReceivableBase GetChaXunInfo()
{
MReceivableBase info = new MReceivableBase();
info.CompanyId = CurrentUserCompanyID;
info.SLDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("SDate"));
info.LLDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EDate"));
info.OrderCode = Utils.GetQueryStringValue("orderId"); //订单号
info.Customer = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHMC); //客户单位
info.CustomerId = Utils.GetQueryStringValue(CustomerUnitSelect1.ClientNameKHBH);
info.IsClean = Utils.GetQueryStringValue("isReceived") == "1"; //是否已结清
info.Salesman = txt_Seller.SellsName = Utils.GetQueryStringValue(txt_Seller.SellsNameClient); //销售员
info.SalesmanId = txt_Seller.SellsID = Utils.GetQueryStringValue(txt_Seller.SellsIDClient); //销售员
//已收待审金额
info.SignUnChecked = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(CaiWuShaiXuan2.ClientUniqueIDOperator));
info.UnChecked = Utils.GetDecimalNull(Utils.GetQueryStringValue(CaiWuShaiXuan2.ClientUniqueIDOperatorNumber));
//未收金额
info.SignUnReceived = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperator));
info.UnReceived = Utils.GetDecimalNull(Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperatorNumber));
info.OperatorId = txtXiaDanRen.SellsID = Utils.GetQueryStringValue(txtXiaDanRen.SellsIDClient);
info.OperatorName = txtXiaDanRen.SellsName = Utils.GetQueryStringValue(txtXiaDanRen.SellsNameClient);
if (Utils.GetQueryStringValue("txtHeTongJinEQueRenStatus") == "1")
{
info.HeTongJinEQueRenStatus = true;
}
if (Utils.GetQueryStringValue("txtHeTongJinEQueRenStatus") == "0")
{
info.HeTongJinEQueRenStatus = false;
}
info.ShouKuanRenId = Utils.GetQueryStringValue(txtShouKuanRen.SellsIDClient);
info.ShluKuanRenName = Utils.GetQueryStringValue(txtShouKuanRen.SellsNameClient);
info.ShouKuanSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtShouKuanSTime"));
info.ShouKuanETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtShouKuanETime"));
info.RouteName = Utils.GetQueryStringValue("txtRouteName");
info.JiDiaoYuanId = txtJiDiaoYuan.SellsID = Utils.GetQueryStringValue(txtJiDiaoYuan.SellsIDClient);
info.JiDiaoYuanName = txtJiDiaoYuan.SellsName = Utils.GetQueryStringValue(txtJiDiaoYuan.SellsNameClient);
return(info);
}
/// <summary>
/// 导出
/// </summary>
private void ToXls()
{
int recordCount = 0;
//金额汇总信息
MReceivableSum sum = new MReceivableSum();
MReceivableBase queryModel = GetChaXunInfo();
IList <MReceivableInfo> ls = new BFinance().GetReceivableInfoLst(
UtilsCommons.GetToXlsRecordCount(),
1,
ref recordCount,
ref sum,
queryModel);
if (ls != null && ls.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("订单号\t线路名称\t客源单位\t客源单位部门\t客源单位联系人\t");
sb.Append("销售员\t下单人\t金额\t状态\t已收金额\t");
sb.Append("已收待审\t欠款金额\t已退金额\t已退待审金额\t开票金额\n");
foreach (MReceivableInfo item in ls)
{
sb.Append(item.OrderCode + "\t");
sb.Append(item.RouteName + "\t");
sb.Append(item.Customer + "\t");
sb.Append(item.KeHuDeptName + "\t");
sb.Append(item.Contact + "\t");
sb.Append(item.Salesman + "\t");
sb.Append(item.OperatorName + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.Receivable, ProviderToMoney) + "\t");
sb.Append((item.IsConfirmed ? "已确认" : "未确认") + item.TourType + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.Received, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.UnChecked, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.UnReceived, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.Returned, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.UnChkRtn, ProviderToMoney) + "\t");
sb.Append(UtilsCommons.GetMoneyString(item.Bill, ProviderToMoney) + "\n");
}
ResponseToXls(sb.ToString());
}
ResponseToXls(string.Empty);
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
//获取分页参数并强转
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
#region 查询实体
MReceivableBase queryModel = new MReceivableBase();
queryModel.CompanyId = CurrentUserCompanyID;
queryModel.Customer = Utils.GetQueryStringValue("txt_customerUnitName");
queryModel.IsClean = false;
queryModel.OrderCode = Utils.GetQueryStringValue("");
queryModel.Salesman = Utils.GetQueryStringValue(this.SellsSelect1.UniqueID.Replace('$', '_') + "_txtSellName");
queryModel.TourCode = Utils.GetQueryStringValue("");
#endregion
IList <MReceivableInfo> ls = new BFinance().GetReceivableInfoLst(
pageSize,
pageIndex,
ref recordCount,
CheckGrant(TravelPermission.账务管理_应收管理_查看全部),
false,
queryModel);
if (ls != null && ls.Count > 0)
{
rpt_list.DataSource = ls;
rpt_list.DataBind();
BindPage();
}
else
{
lbl_msg.Text = "没有相关数据！";
ExporPageInfoSelect1.Visible = false;
ExporPageInfoSelect2.Visible = false;
}
CustomerUnitSelect1.ThisTitle = "客户单位";
CustomerUnitSelect1.CustomerUnitName = Utils.GetQueryStringValue("txt_customerUnitName");
SellsSelect1.SetTitle = "销售员";
SellsSelect1.SellsName = Utils.GetQueryStringValue(this.SellsSelect1.UniqueID.Replace('$', '_') + "_txtSellName");
//绑定分页
BindPage();
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
#region 分页参数
int pageSize = 20;
int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
int recordCount = 0;
#endregion
#region 查询实体
MReceivableBase queryModel = GetChaXunInfo();
#endregion
//金额汇总信息
MReceivableSum sum = new MReceivableSum();
IList <MReceivableInfo> ls = new BFinance().GetReceivableInfoLst(
pageSize,
pageIndex,
ref recordCount,
ref sum,
queryModel);
lbl_totalBill.Text = UtilsCommons.GetMoneyString(sum.TotalBill, ProviderToMoney);
lbl_totalReceived.Text = UtilsCommons.GetMoneyString(sum.TotalReceived, ProviderToMoney);
lbl_totalReturned.Text = UtilsCommons.GetMoneyString(sum.TotalReturned, ProviderToMoney);
lbl_totalSumPrice.Text = UtilsCommons.GetMoneyString(sum.TotalSumPrice, ProviderToMoney);
lbl_totalUnchecked.Text = UtilsCommons.GetMoneyString(sum.TotalUnchecked, ProviderToMoney);
lbl_totalUnChkReturn.Text = UtilsCommons.GetMoneyString(sum.TotalUnChkReturn, ProviderToMoney);
lbl_totalUnReceived.Text = UtilsCommons.GetMoneyString(sum.TotalUnReceived, ProviderToMoney);
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;
}
