/// <summary>
/// 初使化数据
/// </summary>
private void DataInit()
{
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
var searchInfo = new EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun();
searchInfo.ShouKuanDanWei = Utils.GetQueryStringValue("scname");
searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate"));
searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchInfo.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchInfo.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
IList <EyouSoft.Model.PersonalCenterStructure.PayRemind> list = null;
list = trBll.GetPayRemind(pageSize, pageIndex, ref recordCount, CurrentUserCompanyID, searchInfo);
len = list == null?0:list.Count;
this.rptlist.DataSource = list;
this.rptlist.DataBind();
BindPage();
if (len > 0)
{
phWeiShouHeJi.Visible = true;
decimal weiShouHeJi;
trBll.GetPayRemind(CurrentUserCompanyID, searchInfo, out weiShouHeJi);
ltrWeiShouHeJi.Text = weiShouHeJi.ToString("C2");
}
RegisterScript(string.Format("var recordCount={0};", recordCount));
}
/// <summary>
/// to xls
/// </summary>
private void ToXls()
{
int _pageSize = Utils.GetInt(Utils.GetQueryStringValue("recordcount"));
int _recordCount = 0;
var searchInfo = new EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun();
searchInfo.ShouKuanDanWei = Utils.GetQueryStringValue("scname");
searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate"));
searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchInfo.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchInfo.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
var items = new EyouSoft.BLL.PersonalCenterStructure.TranRemind(SiteUserInfo).GetPayRemind(_pageSize, 1, ref _recordCount, CurrentUserCompanyID, searchInfo);
StringBuilder s = new StringBuilder();
s.Append("收款单位\t联系人\t电话\t欠款金额\t责任计调\n");
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
s.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", item.SupplierName, item.ContactName, item.ContactTel, item.PayCash, item.JobName);
}
}
Response.Clear();
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
Response.ContentType = "application/ms-excel";
Response.Write(s.ToString());
Response.End();
}
/// <summary>
/// 获取付款提醒查看明细信息汇总
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="supplierId">供应商编号</param>
/// <param name="searchInfo">查询信息</param>
/// <param name="weiFuHeJi">未付金额合计</param>
/// <returns></returns>
public void GetFuKuanTiXingMingXi(int companyId, int supplierId, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo, out decimal weiFuHeJi)
{
weiFuHeJi = 0;
#region SQL
StringBuilder cmdText = new StringBuilder();
cmdText.Append("SELECT SUM(Arrear) AS WeiFuHeJi FROM View_TravelAndTicketArrear WHERE ");
cmdText.AppendFormat(" arrear <>0 and companyid={0} and serverid={1}", companyId, supplierId);
if (searchInfo != null)
{
if (searchInfo.LEDate.HasValue ||
searchInfo.LSDate.HasValue ||
(searchInfo.OperatorDepartIds != null && searchInfo.OperatorDepartIds.Length > 0) ||
(searchInfo.OperatorIds != null && searchInfo.OperatorIds.Length > 0))
{
if (searchInfo.LSDate.HasValue)
{
cmdText.AppendFormat(" AND LeaveDate>='{0}' ", searchInfo.LSDate.Value);
}
if (searchInfo.LEDate.HasValue)
{
cmdText.AppendFormat(" AND LeaveDate<='{0}' ", searchInfo.LEDate.Value.AddDays(1).AddMilliseconds(-1));
}
if (searchInfo.OperatorIds != null && searchInfo.OperatorIds.Length > 0)
{
cmdText.AppendFormat(" AND TourOperatorId IN({0}) ", Utils.GetSqlIdStrByArray(searchInfo.OperatorIds));
}
if (searchInfo.OperatorDepartIds != null && searchInfo.OperatorDepartIds.Length > 0)
{
cmdText.AppendFormat(" AND TourOperatorId IN(SELECT Id FROM tbl_CompanyUser WHERE DepartId IN({0})) ", Utils.GetSqlIdStrByArray(searchInfo.OperatorDepartIds));
}
}
}
#endregion
DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
if (!rdr.IsDBNull(0))
{
weiFuHeJi = rdr.GetDecimal(0);
}
}
}
}
/// <summary>
/// 付款初使数据绑定
/// </summary>
/// <param name="tid"></param>
private void BindPay()
{
//初使化条件
string[] tid_type = (Utils.GetQueryStringValue("tid")).Split('_'); //供应商ID和类型
int tid = 0; //供应商ID
int suptype = 0; //供应商类型
if (tid_type.Length == 2)
{
tid = Utils.GetInt(tid_type[0]);
suptype = Utils.GetInt(tid_type[1]);
}
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
//BLL实例化
taBll = new EyouSoft.BLL.PlanStruture.TravelAgency();
IList <EyouSoft.Model.PlanStructure.ArrearInfo> list = null;
//EyouSoft.Model.PlanStructure.ArrearSearchInfo asiModel = new EyouSoft.Model.PlanStructure.ArrearSearchInfo();
//asiModel.CompanyId = CurrentUserCompanyID;
var searchInfo = new EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun();
searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate"));
searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchInfo.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchInfo.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
list = taBll.GetFuKuanTiXingMingXi(CurrentUserCompanyID, tid, suptype, pageSize, pageIndex, ref recordCount, searchInfo);
len = list == null ? 0 : list.Count;
this.repList.DataSource = list;
this.repList.DataBind();
BindPage();
if (len > 0)
{
phDaiShouKuanHeJi.Visible = true;
decimal weiFuHeJi = 0;
taBll.GetFuKuanTiXingMingXi(CurrentUserCompanyID, tid, searchInfo, out weiFuHeJi);
ltrDaiShouKuanHeJi.Text = weiFuHeJi.ToString("C2");
}
RegisterScript(string.Format("var recordCount={0};", recordCount));
}
/// <summary>
/// 获取付款提醒查看明细信息汇总
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="supplierId">供应商编号</param>
/// <param name="searchInfo">查询信息</param>
/// <param name="weiFuHeJi">未付金额合计</param>
/// <returns></returns>
public void GetFuKuanTiXingMingXi(int companyId, int supplierId, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo, out decimal weiFuHeJi)
{
dal.GetFuKuanTiXingMingXi(companyId, supplierId, searchInfo, out weiFuHeJi);
}
/*
* /// <summary>
* /// 添加日志
* /// </summary>
* /// <param name="?"></param>
* /// <returns></returns>
* private bool AddSysLog(string type)
* {
* EyouSoft.BLL.CompanyStructure.SysHandleLogs sysLong = new EyouSoft.BLL.CompanyStructure.SysHandleLogs();
* EyouSoft.Model.CompanyStructure.SysHandleLogs sysModel = new EyouSoft.Model.CompanyStructure.SysHandleLogs();
* sysModel.EventMessage = System.DateTime.Now.ToString() + "{0}在安排地接" + type + "了数据";
* sysModel.EventTitle = type + " 安排地接 数据";
* sysModel.ID = Guid.NewGuid().ToString();
* sysModel.EventCode = Model.CompanyStructure.SysHandleLogsNO.EventCode;
* sysModel.ModuleId = Model.EnumType.CompanyStructure.SysPermissionClass.机票管理_机票管理;
*
* return sysLong.Add(sysModel);
* } */
/// <summary>
/// 获取付款提醒查看明细信息集合
/// </summary>
/// <param name="CompanyId"></param>
/// <param name="ServerId"></param>
/// <param name="Type">1代表地接，2代表票务</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <ArrearInfo> GetFuKuanTiXingMingXi(int CompanyId, int ServerId, int ServerType, int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo)
{
return(dal.GetFuKuanTiXingMingXi(CompanyId, ServerId, ServerType, PageSize, PageIndex, ref RecordCount, searchInfo));
}
/// <summary>
/// 获取付款提醒未付款合计
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="searchInfo">查询实体</param>
/// <param name="weiFuHeJi">未付款合计</param>
/// <returns></returns>
public void GetPayRemind(int companyId, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo, out decimal weiFuHeJi)
{
idalSupplier.GetPayRemind(companyId, searchInfo, out weiFuHeJi);
}
/*/// <summary>
* /// 获取收款提醒数量
* /// </summary>
* /// <param name="CompanyId">公司编号</param>
* /// <returns></returns>
* public int GetReceiptRemind(int CompanyId)
* {
* if (CompanyId <= 0)
* return 0;
*
* return idalCustomer.GetReceiptRemind(CompanyId);
* }*/
/// <summary>
/// 分页获取付款提醒
/// </summary>
/// <param name="pageSize">每页显示数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="CompanyId">公司编号</param>
/// <param name="searchInfo">查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.PersonalCenterStructure.PayRemind> GetPayRemind(int pageSize, int pageIndex, ref int recordCount, int CompanyId, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo)
{
if (CompanyId <= 0)
{
return(null);
}
return(idalSupplier.GetPayRemind(pageSize, pageIndex, ref recordCount, CompanyId, searchInfo));
}
/// <summary>
/// to xls
/// </summary>
private void ToXls()
{
string requestType = Utils.GetQueryStringValue("type");
if (requestType == "Appect" && !CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_收款提醒栏目))
{
ResponseToXls(string.Empty);
}
if (requestType == "Pay" && !CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_付款提醒栏目))
{
ResponseToXls(string.Empty);
}
StringBuilder s = new StringBuilder();
if (requestType == "Appect")
{
int keHuDanWeiId = Utils.GetInt(Utils.GetQueryStringValue("tid"));
int _pageSize = Utils.GetInt(Utils.GetQueryStringValue("recordcount"));
if (_pageSize < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
int sellerId = Utils.GetInt(Utils.GetQueryStringValue("sellerid"));
var searchInfo = new EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo();
searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate"));
searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchInfo.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchInfo.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
var items = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo).GetOrderListByBuyCompanyId(_pageSize, 1, ref _recordCount, CurrentUserCompanyID, keHuDanWeiId, sellerId, searchInfo);
s.Append("团号\t线路名称\t出团日期\t总金额\t待收金额\n");
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
s.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", item.TourNo, item.RouteName, item.LeaveDate.ToString("yyyy-MM-dd"), item.FinanceSum.ToString("C2"), item.NotReceived.ToString("C2"));
}
}
}
if (requestType == "Pay")
{
string[] tid_type = (Utils.GetQueryStringValue("tid")).Split('_'); //供应商ID和类型
int tid = 0; //供应商ID
int suptype = 0; //供应商类型
if (tid_type.Length == 2)
{
tid = Utils.GetInt(tid_type[0]);
suptype = Utils.GetInt(tid_type[1]);
}
var searchInfo = new EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun();
searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate"));
searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate"));
searchInfo.OperatorDepartIds = Utils.GetIntArray(Utils.GetQueryStringValue("departids"), ",");
searchInfo.OperatorIds = Utils.GetIntArray(Utils.GetQueryStringValue("operatorids"), ",");
var items = new EyouSoft.BLL.PlanStruture.TravelAgency().GetFuKuanTiXingMingXi(CurrentUserCompanyID, tid, suptype, pageSize, pageIndex, ref recordCount, searchInfo);
if (items != null && items.Count > 0)
{
s.Append("团号\t线路名称\t出团日期\t总金额\t未付金额\n");
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
s.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", item.TourCode, item.RouteName, item.LeaveDate.ToString("yyyy-MM-dd"), item.TotalAmount.ToString("C2"), item.Arrear.ToString("C2"));
}
}
}
}
ResponseToXls(s.ToString());
}
/// <summary>
/// 获取付款提醒查看明细信息集合
/// </summary>
/// <param name="CompanyId"></param>
/// <param name="ServerId"></param>
/// <param name="Type">1代表地接，2代表票务</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <ArrearInfo> GetFuKuanTiXingMingXi(int CompanyId, int ServerId, int ServerType, int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.PersonalCenterStructure.FuKuanTiXingChaXun searchInfo)
{
string tableName = "View_TravelAndTicketArrear";
string field = " * ";
string orderBy = " leaveDate ";
//string sqlWhere = string.Format(" arrear <>0 and companyid={0} and serverid={1} and ServerType={2}", CompanyId, ServerId, ServerType);
StringBuilder sqlWhere = new StringBuilder();
sqlWhere.AppendFormat(" arrear <>0 and companyid={0} and serverid={1}", CompanyId, ServerId);
if (searchInfo != null)
{
if (searchInfo.LEDate.HasValue ||
searchInfo.LSDate.HasValue ||
(searchInfo.OperatorDepartIds != null && searchInfo.OperatorDepartIds.Length > 0) ||
(searchInfo.OperatorIds != null && searchInfo.OperatorIds.Length > 0))
{
if (searchInfo.LSDate.HasValue)
{
sqlWhere.AppendFormat(" AND LeaveDate>='{0}' ", searchInfo.LSDate.Value);
}
if (searchInfo.LEDate.HasValue)
{
sqlWhere.AppendFormat(" AND LeaveDate<='{0}' ", searchInfo.LEDate.Value.AddDays(1).AddMilliseconds(-1));
}
if (searchInfo.OperatorIds != null && searchInfo.OperatorIds.Length > 0)
{
sqlWhere.AppendFormat(" AND TourOperatorId IN({0}) ", Utils.GetSqlIdStrByArray(searchInfo.OperatorIds));
}
if (searchInfo.OperatorDepartIds != null && searchInfo.OperatorDepartIds.Length > 0)
{
sqlWhere.AppendFormat(" AND TourOperatorId IN(SELECT Id FROM tbl_CompanyUser WHERE DepartId IN({0})) ", Utils.GetSqlIdStrByArray(searchInfo.OperatorDepartIds));
}
}
}
IList <ArrearInfo> ArrearList = new List <ArrearInfo>();
ArrearInfo model = null;
using (IDataReader rd = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, " tourid ", field, sqlWhere.ToString(), orderBy))
{
while (rd.Read())
{
model = new ArrearInfo();
model.Arrear = rd.GetDecimal(rd.GetOrdinal("Arrear"));
model.LeaveDate = rd.IsDBNull(rd.GetOrdinal("LeaveDate")) ? DateTime.Parse("2000-1-1") : rd.GetDateTime(rd.GetOrdinal("LeaveDate"));
model.RouteName = rd.IsDBNull(rd.GetOrdinal("RouteName")) ? "" : rd.GetString(rd.GetOrdinal("RouteName"));
model.TotalAmount = rd.GetDecimal(rd.GetOrdinal("TotalAmount"));;
model.TourCode = rd.IsDBNull(rd.GetOrdinal("TourCode")) ? "" : rd.GetString(rd.GetOrdinal("TourCode"));
model.TourId = rd.IsDBNull(rd.GetOrdinal("TourId")) ? "" : rd.GetString(rd.GetOrdinal("TourId"));
ArrearList.Add(model);
}
}
return(ArrearList);
}
