/// <summary>
/// 获取财务管理-团款收入-批量收款审核列表合计
/// </summary>
/// <param name="companyId"></param>
/// <param name="searchInfo"></param>
/// <param name="skJinEHeJi">收款金额合计</param>
public void GetShouKuanShenHeLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchInfo, out decimal skJinEHeJi)
{
skJinEHeJi = 0;
if (companyId < 1)
{
return;
}
dal.GetShouKuanShenHeLBHeJi(companyId, searchInfo, out skJinEHeJi);
}
/// <summary>
/// 获取财务管理-团款收入-批量收款审核列表查询条件SQL
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
string SQLWhere_GetShouKuanShenHeLB(EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchInfo)
{
StringBuilder cmdText = new StringBuilder();
if (searchInfo != null)
{
if (searchInfo.CTETime.HasValue)
{
cmdText.AppendFormat(" AND LeaveDate<'{0}' ", searchInfo.CTETime.Value.AddDays(1));
}
if (searchInfo.CTSTime.HasValue)
{
cmdText.AppendFormat(" AND LeaveDate>'{0}' ", searchInfo.CTSTime.Value.AddDays(-1));
}
if (!string.IsNullOrEmpty(searchInfo.KeHuMingCheng))
{
cmdText.AppendFormat(" AND BuyCompanyName LIKE '%{0}%' ", searchInfo.KeHuMingCheng);
}
if (!string.IsNullOrEmpty(searchInfo.OrderCode))
{
cmdText.AppendFormat(" AND OrderNo LIKE '%{0}%' ", searchInfo.OrderCode);
}
if (searchInfo.SKETime.HasValue)
{
cmdText.AppendFormat(" AND RefundDate<'{0}' ", searchInfo.SKETime.Value.AddDays(1));
}
if (searchInfo.SKStatus.HasValue)
{
cmdText.AppendFormat(" AND IsCheck={0} ", searchInfo.SKStatus.Value ? "1" : "0");
}
if (searchInfo.SKSTime.HasValue)
{
cmdText.AppendFormat(" AND RefundDate>'{0}' ", searchInfo.SKSTime.Value.AddDays(-1));
}
if (!string.IsNullOrEmpty(searchInfo.TourCode))
{
cmdText.AppendFormat(" AND TourCode LIKE '%{0}%' ", searchInfo.TourCode);
}
if (searchInfo.TongJiDingDanFangShi == EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType.统计有效订单)
{
cmdText.AppendFormat(" AND OrderState IN({0},{1},{2}) ", (int)Model.EnumType.TourStructure.OrderState.未处理, (int)Model.EnumType.TourStructure.OrderState.已成交, (int)Model.EnumType.TourStructure.OrderState.已留位);
}
else
{
cmdText.AppendFormat(" AND OrderState = {0} ", (int)Model.EnumType.TourStructure.OrderState.已成交);
}
}
return(cmdText.ToString());
}
/// <summary>
/// 获取财务管理-团款收入-批量收款审核列表合计
/// </summary>
/// <param name="companyId"></param>
/// <param name="searchInfo"></param>
/// <param name="skJinEHeJi">收款金额合计</param>
public void GetShouKuanShenHeLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchInfo, out decimal skJinEHeJi)
{
skJinEHeJi = 0;
StringBuilder cmdText = new StringBuilder();
cmdText.AppendFormat(" SELECT SUM([RefundMoney]) AS SKJinEHeJi FROM view_FinShouKuanDengJi WHERE CompanyId={0} ", companyId);
cmdText.Append(SQLWhere_GetShouKuanShenHeLB(searchInfo));
DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
if (!rdr.IsDBNull(0))
{
skJinEHeJi = rdr.GetDecimal(0);
}
}
}
}
/// <summary>
/// 绑定审核列表数据
/// </summary>
private void BindList()
{
string tourcode = Utils.GetQueryStringValue("tourcode");
string ordercode = Utils.GetQueryStringValue("ordercode");
string companyname = Utils.GetQueryStringValue("companyname");
string leaveStime = Utils.GetQueryStringValue("leaveSTime").Trim();
string leaveEtime = Utils.GetQueryStringValue("leaveETime").Trim();
string skStime = Utils.GetQueryStringValue("skStime").Trim();
string skEtime = Utils.GetQueryStringValue("skEtime").Trim();
string sltstatus = Utils.GetQueryStringValue("sltstatus");
EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchmodel = new EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo();
searchmodel.CTETime = Utils.GetDateTimeNullable(leaveEtime);
searchmodel.CTSTime = Utils.GetDateTimeNullable(leaveStime);
searchmodel.KeHuMingCheng = companyname;
searchmodel.OrderCode = ordercode;
searchmodel.SKETime = Utils.GetDateTimeNullable(skEtime);
searchmodel.SKSTime = Utils.GetDateTimeNullable(skStime);
bool?status = false;
if (sltstatus == "0")
{
status = null;
}
else if (sltstatus == "2")
{
status = true;
}
searchmodel.SKStatus = status;
searchmodel.TourCode = tourcode;
EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType?tongJiDingDanFangShi = new EyouSoft.BLL.CompanyStructure.CompanySetting().GetComputeOrderType(SiteUserInfo.CompanyID);
if (tongJiDingDanFangShi.HasValue)
{
searchmodel.TongJiDingDanFangShi = tongJiDingDanFangShi.Value;
}
pageIndex = Utils.GetQueryStringValue("page") != "" ? Utils.GetInt(Utils.GetQueryStringValue("page")) : 1;
EyouSoft.BLL.FinanceStructure.BShouRu bll = new EyouSoft.BLL.FinanceStructure.BShouRu();
IList <EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo> list = bll.GetShouKuanShenHeLB(this.SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchmodel);
if (list != null && list.Count > 0)
{
decimal TotalMoney = 0;
rptList.DataSource = list;
rptList.DataBind();
bll.GetShouKuanShenHeLBHeJi(this.SiteUserInfo.CompanyID, searchmodel, out TotalMoney);
this.lbTotleMoney.Text = "￥" + TotalMoney.ToString("F2");
}
else
{
lbemptydata.Text = "<tr><td style='text-align:center' colspan='8'>暂无数据!</td></tr>";
}
#region 分页
ExportPageInfo1.intPageSize = pageSize;
ExportPageInfo1.intRecordCount = recordCount;
ExportPageInfo1.PageLinkURL = Request.Path + "?";
ExportPageInfo1.UrlParams = Request.QueryString;
ExportPageInfo1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1);
#endregion
}
/// <summary>
/// 获取财务管理-团款收入-批量收款审核列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页面索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo> GetShouKuanShenHeLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchInfo)
{
if (companyId < 1)
{
return(null);
}
return(dal.GetShouKuanShenHeLB(companyId, pageSize, pageIndex, ref recordCount, searchInfo));
}
/// <summary>
/// 获取财务管理-团款收入-批量收款审核列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页面索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo> GetShouKuanShenHeLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeSearchInfo searchInfo)
{
IList <EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo> items = new List <EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "view_FinShouKuanDengJi";
string primaryKey = "Id";
string orderByString = "RefundDate DESC";
string fields = "*";
#region SQL
cmdQuery.AppendFormat(" CompanyId={0} ", companyId);
cmdQuery.Append(SQLWhere_GetShouKuanShenHeLB(searchInfo));
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
var item = new EyouSoft.Model.FinanceStructure.MLBShouKuanShenHeInfo();
item.KeHuMingCheng = rdr["BuyCompanyName"].ToString();
item.OrderCode = rdr["OrderNo"].ToString();
item.OrderId = rdr["OrderId"].ToString();
item.SKDengJiId = rdr["Id"].ToString();
item.SKFangShi = (EyouSoft.Model.EnumType.TourStructure.RefundType)rdr.GetByte(rdr.GetOrdinal("RefundType"));
item.SKJinE = rdr.GetDecimal(rdr.GetOrdinal("RefundMoney"));
if (!rdr.IsDBNull(rdr.GetOrdinal("RefundDate")))
{
item.SKRiQi = rdr.GetDateTime(rdr.GetOrdinal("RefundDate"));
}
item.SKStatus = rdr.GetByte(rdr.GetOrdinal("IsCheck")) == 1;
item.TourCode = rdr["TourCode"].ToString();
item.SKBeiZhu = rdr["Remark"].ToString();
item.SKRenName = rdr["StaffName"].ToString();
items.Add(item);
}
}
return(items);
}
