/// <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); }