/// <summary>
/// init repeater
/// </summary>
void InitRpt()
{
string s = Utils.GetQueryStringValue("orderid");
string[] s1 = s.Split(',');
var items = new EyouSoft.BLL.FinStructure.BFinance().GetBatchTourOrderSalesCheck(s1);
if (items != null && items.Count > 0)
{
rpt.DataSource = items;
rpt.DataBind();
decimal heJiJinE = 0;
foreach (var item in items)
{
heJiJinE += item.CollectionRefundAmount;
}
ltrHeJiJinE.Text = UtilsCommons.GetMoneyString(heJiJinE, ProviderToMoney);
phEmpty.Visible = false;
phHeJiJinE.Visible = true;
}
else
{
phHeJiJinE.Visible = false;
phEmpty.Visible = true;
}
}
/// <summary>
/// 初始化
/// </summary>
void DataInit()
{
//获取分页参数并强转
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"));
EyouSoft.Model.FinStructure.MPayableApproveBase queryModel = new EyouSoft.Model.FinStructure.MPayableApproveBase();
#region 查询参数
//公司id
queryModel.CompanyId = CurrentUserCompanyID;
queryModel.Status = EyouSoft.Model.EnumType.FinStructure.FinStatus.销售待确认;
queryModel.IsPrepaidConfirm = true;
#endregion
decimal sum = 0;
IList <EyouSoft.Model.FinStructure.MPayableApprove> ls = new EyouSoft.BLL.FinStructure.BFinance().GetMPayableApproveLst(
pageSize,
pageIndex,
ref recordCount,
ref sum,
queryModel);
if (ls != null && ls.Count > 0)
{
rpt.DataSource = ls;
rpt.DataBind();
}
BindPage();
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit(string sId)
{
decimal payableSum = 0;
decimal paidSum = 0;
decimal returnedSum = 0;
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
IList <EyouSoft.Model.FinStructure.MSalesmanWarning> list = new EyouSoft.BLL.FinStructure.BFinance().GetSalesmanConfirmLstBySellerId(pageSize, pageIndex, ref recordCount, ref payableSum, ref paidSum, ref returnedSum, sId);
if (list != null && list.Count > 0)
{
repList.DataSource = list;
repList.DataBind();
this.labSumMoney.Text = UtilsCommons.GetMoneyString((payableSum - paidSum + returnedSum), ProviderToMoney);
BindPage(pageSize, pageIndex, recordCount);
}
else
{
this.repList.Controls.Add(new Label()
{
Text = "<tr><td colspan='8' align='center'>对不起，没有相关数据！</td></tr>"
});
ExporPageInfoSelect1.Visible = false;
}
}
/// <summary>
/// 绑定导游借款列表
/// </summary>
/// <param name="tourID">团号</param>
protected void GetDebitListByTourId(string tourID)
{
if (!string.IsNullOrEmpty(tourID))
{
IList <EyouSoft.Model.FinStructure.MDebit> detitlist = new EyouSoft.BLL.FinStructure.BFinance().GetDebitLstByTourId(tourID, false);
if (detitlist != null && detitlist.Count > 0)
{
this.repGuidPayList.DataSource = detitlist;
this.repGuidPayList.DataBind();
}
}
}
/// <summary>
/// 初始化
/// </summary>
void DataInit()
{
pageIndex = UtilsCommons.GetPadingIndex();
decimal xmlSum = 0;
var searchInfo = GetSearchInfo();
var items = new EyouSoft.BLL.FinStructure.BFinance().GetDayReceivablesChkLst(pageSize, pageIndex, ref recordCount, ref xmlSum, null, false, this.SiteUserInfo.CompanyId, searchInfo);
if (items != null && items.Count > 0)
{
rpt.DataSource = items;
rpt.DataBind();
}
BindPage();
}
/// <summary>
/// 初始化团队信息
/// </summary>
/// <param name="tourID">团号</param>
/// <param name="souceName">供应商名称</param>
protected void DateInit()
{
string tourID = Utils.GetQueryStringValue("tourId");
string planID = Utils.GetQueryStringValue("PlanId");
string souceName = Utils.GetQueryStringValue("souceName");
this.txtPayDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
if (!string.IsNullOrEmpty(tourID))
{
EyouSoft.Model.TourStructure.MTourBaseInfo tourInfo = new EyouSoft.BLL.TourStructure.BTour().GetTourInfo(tourID);
if (tourInfo != null)
{
_isPlaner = tourInfo.TourPlaner.Where(m => m.PlanerId == this.SiteUserInfo.UserId).Count() > 0;
this.panView.Visible = !UtilsCommons.GetTourStatusByTourID(tourInfo.TourStatus) && _isPlaner;
this.litTourCode.Text = tourInfo.TourCode;
if (tourInfo.SaleInfo != null)
{
this.litSellers.Text = tourInfo.SaleInfo.Name;
}
}
else
{
this.panView.Visible = false;
}
}
else
{
this.panView.Visible = false;
}
if (planID != "")
{
EyouSoft.BLL.FinStructure.BFinance bll = new EyouSoft.BLL.FinStructure.BFinance();
//支出项目基本信息
EyouSoft.Model.FinStructure.MPayRegister model = bll.GetPayRegisterBaseByPlanId(planID);
if (model != null)
{
if (model.PaymentType == EyouSoft.Model.EnumType.PlanStructure.Payment.导游现付)
{
this.panView.Visible = false;
}
}
}
if (!string.IsNullOrEmpty(souceName))
{
this.litPrepaidCompany.Text = souceName;
}
}
/// <summary>
/// 根据计调项目获取某一个支出项目出账等级列表
/// </summary>
/// <param name="planID">计调项id</param>
protected void DataInitPayList()
{
string planID = Utils.GetQueryStringValue("PlanId");
if (!string.IsNullOrEmpty(planID))
{
IList <EyouSoft.Model.FinStructure.MRegister> paylist = new EyouSoft.BLL.FinStructure.BFinance().GetPayRegisterLstByPlanId(planID);
if (paylist != null && paylist.Count > 0)
{
this.repPrepaidList.DataSource = paylist;
this.repPrepaidList.DataBind();
}
}
}
/// <summary>
/// 初始化
/// </summary>
void DataInit()
{
#region 获取查询条件
//获取分页参数并强转
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
//合同号状态
int dep = Utils.GetInt(Utils.GetQueryStringValue("sltDept"), 0);
//销售员
string sellerId = Utils.GetQueryStringValue(this.txtXiaoShouYuan.SellsIDClient);
string sellerName = Utils.GetQueryStringValue(this.txtXiaoShouYuan.SellsNameClient);
this.txtXiaoShouYuan.SellsID = sellerId;
this.txtXiaoShouYuan.SellsName = sellerName;
//查询实体
EyouSoft.Model.FinStructure.MWarningBase searchModel = new EyouSoft.Model.FinStructure.MWarningBase();
if (dep > 0)
{
searchModel.DeptId = dep;
}
searchModel.SellerId = sellerId;
searchModel.SellerName = sellerName;
searchModel.SignArrear = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperator));
searchModel.Arrear = Utils.GetDecimalNull(Utils.GetQueryStringValue(CaiWuShaiXuan1.ClientUniqueIDOperatorNumber));
searchModel.SignTransfinite = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(CaiWuShaiXuan2.ClientUniqueIDOperator));
searchModel.Transfinite = Utils.GetDecimalNull(Utils.GetQueryStringValue(CaiWuShaiXuan2.ClientUniqueIDOperatorNumber));
#endregion
EyouSoft.BLL.FinStructure.BFinance bll = new EyouSoft.BLL.FinStructure.BFinance();
IList <EyouSoft.Model.FinStructure.MSalesmanWarning> list = bll.GetSalesmanWarningLst(this.pageSize, this.pageIndex, ref this.recordCount, SiteUserInfo.CompanyId, searchModel);
if (list != null && list.Count > 0)
{
rptList.DataSource = list;
rptList.DataBind();
}
else
{
this.rptList.Controls.Add(new Label()
{
Text = "<tr><td colspan='8' align='center'>对不起，没有相关数据！</td></tr>"
});
}
//绑定分页
BindPage();
//释放
searchModel = null;
bll = null;
}
/// <summary>
/// 获取计调项出账等级实体
/// </summary>
/// <param name="registerID">出账等级id</param>
protected void GetPayResgin()
{
string ID = Utils.GetQueryStringValue("ID");
if (!string.IsNullOrEmpty(ID))
{
EyouSoft.Model.FinStructure.MRegister registerM = new EyouSoft.BLL.FinStructure.BFinance().GetRegisterById(this.SiteUserInfo.CompanyId, Utils.GetInt(ID));
if (registerM != null)
{
this.txtPrepaidPrices.Text = Utils.FilterEndOfTheZeroDecimal(registerM.PaymentAmount);
this.txtPayDate.Text = UtilsCommons.GetDateString(registerM.Deadline, ProviderToDate);
this.txtUseInterpret.Text = registerM.Remark;
if (registerM.Status == EyouSoft.Model.EnumType.FinStructure.FinStatus.账务待支付 || registerM.Status == EyouSoft.Model.EnumType.FinStructure.FinStatus.账务已支付)
{
this.panView.Visible = false;
}
}
}
}
/// <summary>
/// 导出
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
decimal xmlSum = 0;
StringBuilder s = new StringBuilder();
var searchInfo = GetSearchInfo();
var items = new EyouSoft.BLL.FinStructure.BFinance().GetDayReceivablesChkLst(toXlsRecordCount, 1, ref _recordCount, ref xmlSum, null, false, this.SiteUserInfo.CompanyId, searchInfo);
if (items != null && items.Count > 0)
{
s.Append("<table border=1>");
s.Append("<tr><th align='center'>团号</th>");
s.Append("<th align='center'>线路名称</th>");
s.Append("<th align='center'>订单号</th>");
s.Append("<th align='center'>客户单位/游客姓名</th>");
s.Append("<th align='center'>人数</th>");
s.Append("<th align='center'>销售员</th>");
s.Append("<th align='center'>收款金额</th>");
s.Append("<th align='center'>状态</th></tr>");
foreach (var item in items)
{
s.AppendFormat("<tr><td align='center'>{0}</td>", item.TourCode);
s.AppendFormat("<td align='center'>{0}</td>", item.RouteName);
s.AppendFormat("<td align='center'>{0}</td>", item.OrderCode);
s.AppendFormat("<td align='center'>{0}</td>", item.Customer);
s.AppendFormat("<td align='center'><b>{0}</b><sup>+{1}</sup></td>", item.Adults, item.Childs);
s.AppendFormat("<td align='center'>{0}</td>", item.Salesman);
s.AppendFormat("<td align='right'>{0}</td>", UtilsCommons.GetMoneyString(item.ReceivableAmount, ProviderToMoney));
s.AppendFormat("<td align='center'>{0}</td>", item.Status);
s.Append("</tr>");
}
}
ResponseToXls(s.ToString());
}
/// <summary>
/// 绑定控件
/// </summary>
private void PageInit()
{
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
EyouSoft.Model.FinStructure.MReceivableBase search = new EyouSoft.Model.FinStructure.MReceivableBase();
search.CompanyId = SiteUserInfo.CompanyId;
search.CustomerId = SiteUserInfo.TourCompanyInfo.CompanyId;
search.Customer = SiteUserInfo.TourCompanyInfo.CompanyName;
//search.SalesmanId = SiteUserInfo.UserId;
search.IsShowDistribution = true;
search.OrderCode = Utils.GetQueryStringValue("txtOrderCode");
search.RouteName = Utils.GetQueryStringValue("txtRouteName");
string jieQingStatus = Utils.GetQueryStringValue("ddlIsClean");
if (jieQingStatus == "1")
{
search.IsClean = true;
}
else if (jieQingStatus == "0")
{
search.IsClean = false;
}
//统计实体
EyouSoft.Model.FinStructure.MReceivableSum mSum = new EyouSoft.Model.FinStructure.MReceivableSum();
EyouSoft.BLL.FinStructure.BFinance bFinance = new EyouSoft.BLL.FinStructure.BFinance();
IList <EyouSoft.Model.FinStructure.MReceivableInfo> list = bFinance.GetReceivableInfoLst(pageSize, pageIndex, ref recordCount, ref mSum, search);
this.RpFinancial.DataSource = list;
this.RpFinancial.DataBind();
//合计
this.LtTotalReceived.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(mSum.TotalReceived, this.ProviderToMoney);
this.LtTotalSumPrice.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(mSum.TotalSumPrice, this.ProviderToMoney);
this.LtTotalUnReceived.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(mSum.TotalUnReceived, this.ProviderToMoney);
BindPage();
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
string s = Utils.GetQueryStringValue("orderid");
string[] s1 = s.Split(',');
string[] s2 = Utils.GetFormValues("chk");
if (s2 == null || s2.Length == 0)
{
ResponseToXls(string.Empty);
}
var items = new EyouSoft.BLL.FinStructure.BFinance().GetBatchTourOrderSalesCheck(s1);
if (items == null || items.Count == 0)
{
ResponseToXls(string.Empty);
}
System.Text.StringBuilder s3 = new System.Text.StringBuilder();
s3.Append("订单号\t收款日期\t收款人\t收款金额\t收款方式\t备注\n");
foreach (var item in items)
{
if (s2.Contains(item.Id))
{
s3.Append(item.OrderCode + "\t");
s3.Append(item.CollectionRefundDate.Value.ToString("yyyy-MM-dd") + "\t");
s3.Append(item.CollectionRefundOperator + "\t");
s3.Append(item.CollectionRefundAmount.ToString("F2") + "\t");
s3.Append(item.CollectionRefundModeName + "\t");
s3.Append(item.Memo.Replace("\t", " ").Replace("\r\n", " ") + "\n");
}
}
ResponseToXls(s3.ToString());
}
/// <summary>
/// 绑定数据源、分页控件
/// </summary>
private void BindSource()
{
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
//应付
EyouSoft.Model.FinStructure.MPayableBase search = new EyouSoft.Model.FinStructure.MPayableBase();
search.CompanyId = SiteUserInfo.CompanyId;
search.SupplierId = SiteUserInfo.SourceCompanyInfo.CompanyId;
search.Supplier = SiteUserInfo.SourceCompanyInfo.CompanyName;
search.IsDj = true;
search.TourCode = Utils.GetQueryStringValue("txtTourCode");
search.AreaId = Utils.GetInt(Utils.GetQueryStringValue("ddlArea"), 0);
search.Planer = Utils.GetQueryStringValue("txtPlaner");
search.LDateStart = Utils.GetQueryStringValue("txtBeginLDate");
search.LDateEnd = Utils.GetQueryStringValue("txtEndLDate");
search.SignUnpaid = (EyouSoft.Model.EnumType.FinStructure.EqualSign?)Utils.GetEnumValueNull(typeof(EyouSoft.Model.EnumType.FinStructure.EqualSign), Utils.GetQueryStringValue(this.CaiWuShaiXuan1.ClientUniqueIDOperator));
search.Unpaid = Utils.GetDecimalNull(Utils.GetQueryStringValue(this.CaiWuShaiXuan1.ClientUniqueIDOperatorNumber));
//统计实体
EyouSoft.Model.FinStructure.MPayableSum mSum = new EyouSoft.Model.FinStructure.MPayableSum();
EyouSoft.BLL.FinStructure.BFinance bFinance = new EyouSoft.BLL.FinStructure.BFinance();
IList <EyouSoft.Model.FinStructure.MPayable> list = bFinance.GetPayableLst(pageSize, pageIndex, ref recordCount, ref mSum, search);
this.RpFinance.DataSource = list;
this.RpFinance.DataBind();
//统计
this.LtTotalPaid.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(mSum.TotalPaid, this.ProviderToMoney);
this.LtTotalPayable.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(mSum.TotalPayable, this.ProviderToMoney);
this.LtTotalUnpaid.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(System.Math.Abs(mSum.TotalPaid - mSum.TotalPayable), this.ProviderToMoney);
BindPage();
}
/// <summary>
/// 保存
/// </summary>
protected void PageShenHe()
{
int[] registerIds = Utils.ConvertToIntArray(Utils.GetQueryStringValue("RegisterId").Split(','));
string msg = string.Empty;
bool result = false;
if (registerIds.Length <= 0)
{
msg = "审批失败!";
}
if (msg.Length <= 0)
{
int i = new EyouSoft.BLL.FinStructure.BFinance().SetRegisterApprove(
SiteUserInfo.UserId, //审核人ID
SiteUserInfo.Name, //审核人
DateTime.Now, //审核时间(当前时间)
"审核意见", //审核意见
EyouSoft.Model.EnumType.FinStructure.FinStatus.财务待审批, //审核状态
CurrentUserCompanyID, //公司ID
registerIds //登记编号集合
);
if (i > 0)
{
result = true;
msg = "审核成功！";
}
else
{
result = false;
msg = "审批失败！";
}
}
Response.Clear();
Response.Write("{\"result\":\"" + result + "\",\"msg\":\"" + msg + "\"}");
Response.End();
}
/// <summary>
/// 预付申请 销售确认 计调确认
/// </summary>
/// <param name="RegisterId">登记id</param>
/// <param name="tourID">团号</param>
/// <param name="planID">计调id</param>
/// <returns></returns>
protected string PageSaveSellConfirm(EyouSoft.Model.EnumType.FinStructure.FinStatus status)
{
string setErorMsg = string.Empty;
string msg = string.Empty;
string tourID = Utils.GetQueryStringValue("tourId");
string planID = Utils.GetQueryStringValue("PlanId");
decimal prepaidPrices = Utils.GetDecimal(Utils.GetFormValue(this.txtPrepaidPrices.UniqueID));
DateTime?dtPayDate = Utils.GetDateTimeNullable(Utils.GetFormValue(this.txtPayDate.UniqueID));
if (prepaidPrices <= 0)
{
msg += "请输入预付金额！<br/>";
}
if (dtPayDate == null)
{
msg += "请选择最晚付款日期！<br/>";
}
if (!string.IsNullOrEmpty(msg))
{
setErorMsg = "{\"result\":\"0\",\"msg\":\"" + msg + "\"}";
return(setErorMsg);
}
EyouSoft.Model.FinStructure.MRegister registerM = new EyouSoft.Model.FinStructure.MRegister();
registerM.CompanyId = this.SiteUserInfo.CompanyId;
registerM.Deadline = Utils.GetDateTimeNullable(Utils.GetFormValue(this.txtPayDate.UniqueID));
//付款人
if (!string.IsNullOrEmpty(tourID))
{
EyouSoft.Model.TourStructure.MTourBaseInfo tourInfo = new EyouSoft.BLL.TourStructure.BTour().GetTourInfo(tourID);
if (tourInfo != null)
{
this.litTourCode.Text = tourInfo.TourCode;
if (tourInfo.SaleInfo != null)
{
this.litSellers.Text = tourInfo.SaleInfo.Name;
registerM.Dealer = tourInfo.SaleInfo.Name;
registerM.DealerDeptId = tourInfo.SaleInfo.DeptId;
registerM.DealerId = tourInfo.SaleInfo.SellerId;
}
}
}
registerM.IsPrepaid = true;
registerM.IssueTime = System.DateTime.Now;
registerM.PaymentAmount = Utils.GetDecimal(Utils.GetFormValue(this.txtPrepaidPrices.UniqueID));
registerM.PlanId = planID;
registerM.Remark = Utils.GetFormValue(this.txtUseInterpret.UniqueID);
registerM.TourId = tourID;
registerM.OperatorId = this.SiteUserInfo.UserId;
registerM.Operator = this.SiteUserInfo.Name;
registerM.DeptId = this.SiteUserInfo.DeptId;
registerM.Status = status;
if (string.IsNullOrEmpty(Utils.GetQueryStringValue("ID")))
{
var intRtn = new EyouSoft.BLL.FinStructure.BFinance().AddRegister(registerM);
switch (intRtn)
{
case 0:
AjaxResponse(UtilsCommons.AjaxReturnJson("0", "确认失败!"));
break;
case -1:
AjaxResponse(UtilsCommons.AjaxReturnJson("-1", "超额付款!"));
break;
default:
AjaxResponse(UtilsCommons.AjaxReturnJson("1", "确认成功"));
break;
}
}
else
{
registerM.RegisterId = Utils.GetInt(Utils.GetQueryStringValue("ID"));
var intRtn = new EyouSoft.BLL.FinStructure.BFinance().UpdRegister(registerM);
switch (intRtn)
{
case 0:
AjaxResponse(UtilsCommons.AjaxReturnJson("0", "确认失败!"));
break;
case -1:
AjaxResponse(UtilsCommons.AjaxReturnJson("-1", "超额付款!"));
break;
default:
AjaxResponse(UtilsCommons.AjaxReturnJson("1", "确认成功"));
break;
}
}
return(setErorMsg);
}
/// <summary>
/// 初始化数据
/// </summary>
private void DataInit()
{
string b = Utils.GetQueryStringValue("mark");
switch (b)
{
case "1":
this.lblMsg.Text = "提交成功！";
break;
case "2":
this.lblMsg.Text = "提交失败！";
break;
case "3":
this.lblMsg.Text = "保存成功！";
break;
}
string tourId = Utils.GetQueryStringValue("tourId");
BPlan bll = new BPlan();
//团队支出
IList <MPlanBaseInfo> list = bll.GetList(tourId);
if (list != null && list.Count > 0)
{
rptList.DataSource = list;
rptList.DataBind();
this.litFrist.Text = " <span>类型</span> - <span>名称</span> - <span>结算费用</span>";
}
else
{
this.litFrist.Text = "暂无支出!";
}
//导游收入
EyouSoft.Model.TourStructure.MOrderSum sum = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> orders = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(ref sum, tourId);
if (orders != null && orders.Count > 0)
{
repGuidInMoney.DataSource = orders;
repGuidInMoney.DataBind();
this.litSecond.Text = " <span>客源单位</span> - <span>团款现收</span>";
}
else
{
this.litSecond.Text = "暂无收入!";
}
//导游借款
IList <MDebit> ls = new EyouSoft.BLL.FinStructure.BFinance().GetDebitLstByTourId(tourId, true);
if (ls != null && ls.Count > 0)
{
this.rptDebit.DataSource = ls;
this.rptDebit.DataBind();
this.litThird.Text = " <span>姓名</span> - <span>日期</span> - <span>金额</span>";
}
else
{
this.litThird.Text = "暂无借款!";
}
//报账汇总
MBZHZ model = bll.GetBZHZ(tourId);
if (model != null)
{
lbl_guidesIncome.Text = UtilsCommons.GetMoneyString(model.GuideIncome, ProviderToMoney);
lbl_guidesBorrower.Text = UtilsCommons.GetMoneyString(model.GuideBorrow, ProviderToMoney);
lbl_guidesSpending.Text = UtilsCommons.GetMoneyString(model.GuideOutlay, ProviderToMoney);
lbl_replacementOrReturn.Text = UtilsCommons.GetMoneyString(model.GuideMoneyRtn, ProviderToMoney);
}
}
