/// <summary> /// 获取收款提醒合计 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="receiptRemindType">收款提醒配置</param> /// <param name="sellerId">销售员编号 收款提醒配置成EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller时不可为空</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public void GetReceiptRemind(int companyId, EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType receiptRemindType, int?sellerId , EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo searchInfo, out decimal daiShouKuanHeJi) { daiShouKuanHeJi = 0; if (CompanyId <= 0) { return; } if (receiptRemindType == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller && !sellerId.HasValue) { return; } //结算日之前不提醒 DateTime today = DateTime.Today; int accountDay = today.Day; if (DateTime.DaysInMonth(today.Year, today.Month) == today.Day) { accountDay = 31; } //结算星期几开始往后提醒4天 int[] accountDayWeek = null; DayOfWeek dayOfWeek = today.DayOfWeek; switch (dayOfWeek) { case DayOfWeek.Monday: accountDayWeek = new int[] { 0, 5, 6, 7, 1 }; break; case DayOfWeek.Tuesday: accountDayWeek = new int[] { 0, 6, 7, 1, 2 }; break; case DayOfWeek.Wednesday: accountDayWeek = new int[] { 0, 7, 1, 2, 3 }; break; case DayOfWeek.Thursday: accountDayWeek = new int[] { 0, 1, 2, 3, 4 }; break; case DayOfWeek.Friday: accountDayWeek = new int[] { 0, 2, 3, 4, 5 }; break; case DayOfWeek.Saturday: accountDayWeek = new int[] { 0, 3, 4, 5, 6 }; break; case DayOfWeek.Sunday: accountDayWeek = new int[] { 0, 4, 5, 6, 7 }; break; } string sellers = string.Empty; if (receiptRemindType == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller && sellerId.HasValue) { sellers = sellerId.ToString(); } if (!string.IsNullOrEmpty(sellers)) { idalCustomer.GetReceiptRemindByOrderSeller(CompanyId, accountDay, accountDayWeek, sellers, searchInfo, out daiShouKuanHeJi); return; } idalCustomer.GetReceiptRemind(CompanyId, accountDay, accountDayWeek, searchInfo, out daiShouKuanHeJi); }
/// <summary> /// to xls /// </summary> private void ToXls() { if (!CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_收款提醒栏目)) { ResponseToXls(string.Empty); } EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo searchInfo = new EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo(); searchInfo.QianKuanDanWei = Utils.GetQueryStringValue("sn"); 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"), ","); EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType rrt = new EyouSoft.BLL.CompanyStructure.CompanySetting().GetReceiptRemindType(CurrentUserCompanyID); int?sellerId = null; if (rrt == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller) { sellerId = SiteUserInfo.ID; } int _pageSize = Utils.GetInt(Utils.GetQueryStringValue("recordcount")); int _recordCount = 0; if (_pageSize < 1) { ResponseToXls(string.Empty); } var items = new EyouSoft.BLL.PersonalCenterStructure.TranRemind().GetReceiptRemind(_pageSize, 1, ref _recordCount, CurrentUserCompanyID, rrt, sellerId, 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", item.CustomerName); s.AppendFormat("{0}\t", item.ContactName); s.AppendFormat("{0}\t", item.ContactTel); s.AppendFormat("{0}\t", item.ArrearCash.ToString("C2")); s.AppendFormat("{0}\n", item.SalerName); } } ResponseToXls(s.ToString()); }
/// <summary> /// 初使化 /// </summary> private void DataInit() { if (!CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_收款提醒栏目)) { tbShow.Visible = false; tbinfo.InnerHtml = "欢迎 " + SiteUserInfo.UserName + " 登录系统!"; } else { EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo searchInfo = new EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo(); searchInfo.QianKuanDanWei = S_QianKuanDanWei = Utils.GetQueryStringValue("sn"); 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"), ","); pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); EyouSoft.BLL.CompanyStructure.CompanySetting csBll = new EyouSoft.BLL.CompanyStructure.CompanySetting(); EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType rrt = csBll.GetReceiptRemindType(CurrentUserCompanyID); int?sellerId = null; if (rrt == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller) { sellerId = SiteUserInfo.ID; } IList <EyouSoft.Model.PersonalCenterStructure.ReceiptRemind> list = null; list = trBll.GetReceiptRemind(pageSize, pageIndex, ref recordCount, CurrentUserCompanyID, rrt, sellerId, searchInfo); len = list == null ? 0 : list.Count; this.rptlist.DataSource = list; this.rptlist.DataBind(); if (list != null && list.Count > 0) { phDaiShouKuanHeJi.Visible = true; decimal daiShouKuanHeJi = 0; trBll.GetReceiptRemind(CurrentUserCompanyID, rrt, sellerId, searchInfo, out daiShouKuanHeJi); ltrDaiShouKuanHeJi.Text = daiShouKuanHeJi.ToString("C2"); } BindPage(); RegisterScript(string.Format("var recordCount={0};", recordCount)); } }
/// <summary> /// 收款初使数据绑定 /// </summary> /// <param name="type"></param> /// <param name="tid"></param> private void BindAppect() { //初使化条件 int tid = Utils.GetInt(Utils.GetQueryStringValue("tid")); pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); 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"), ","); //BLL实例化 toBll = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo); IList <EyouSoft.Model.TourStructure.TourOrder> list = null; list = toBll.GetOrderListByBuyCompanyId(pageSize, pageIndex, ref recordCount, CurrentUserCompanyID, tid, sellerId, searchInfo); len = list == null ? 0 : list.Count; this.repList.DataSource = list; this.repList.DataBind(); //设置分页 BindPage(); if (len > 0) { phDaiShouKuanHeJi.Visible = true; decimal daiShouKuanHeJi = 0; toBll.GetOrderListByBuyCompanyId(CurrentUserCompanyID, tid, sellerId, searchInfo, out daiShouKuanHeJi); ltrDaiShouKuanHeJi.Text = daiShouKuanHeJi.ToString("C2"); } RegisterScript(string.Format("var recordCount={0};", recordCount)); }
/// <summary> /// 分页获取收款提醒 /// </summary> /// <param name="pageSize">每页显示数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="CompanyId">公司编号</param> /// <param name="receiptRemindType">收款提醒配置</param> /// <param name="sellerId">销售员编号 收款提醒配置成EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller时不可为空</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.ReceiptRemind> GetReceiptRemind(int pageSize, int pageIndex, ref int recordCount, int CompanyId , EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType receiptRemindType, int?sellerId , EyouSoft.Model.PersonalCenterStructure.ReceiptRemindSearchInfo searchInfo) { if (CompanyId <= 0) { return(null); } if (receiptRemindType == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller && !sellerId.HasValue) { return(null); } //结算日之前不提醒 DateTime today = DateTime.Today; int accountDay = today.Day; if (DateTime.DaysInMonth(today.Year, today.Month) == today.Day) { accountDay = 31; } //结算星期几开始往后提醒4天 int[] accountDayWeek = null; DayOfWeek dayOfWeek = today.DayOfWeek; switch (dayOfWeek) { case DayOfWeek.Monday: accountDayWeek = new int[] { 0, 5, 6, 7, 1 }; break; case DayOfWeek.Tuesday: accountDayWeek = new int[] { 0, 6, 7, 1, 2 }; break; case DayOfWeek.Wednesday: accountDayWeek = new int[] { 0, 7, 1, 2, 3 }; break; case DayOfWeek.Thursday: accountDayWeek = new int[] { 0, 1, 2, 3, 4 }; break; case DayOfWeek.Friday: accountDayWeek = new int[] { 0, 2, 3, 4, 5 }; break; case DayOfWeek.Saturday: accountDayWeek = new int[] { 0, 3, 4, 5, 6 }; break; case DayOfWeek.Sunday: accountDayWeek = new int[] { 0, 4, 5, 6, 7 }; break; } string sellers = string.Empty; if (receiptRemindType == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller && sellerId.HasValue) { sellers = sellerId.ToString(); } if (!string.IsNullOrEmpty(sellers)) { return(idalCustomer.GetReceiptRemindByOrderSeller(pageSize, pageIndex, ref recordCount, CompanyId, accountDay, accountDayWeek, sellers, searchInfo)); } return(idalCustomer.GetReceiptRemind(pageSize, pageIndex, ref recordCount, CompanyId, accountDay, accountDayWeek, 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()); }