/// <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> /// 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()); }
protected void Page_Load(object sender, EventArgs e) { if (Utils.GetQueryStringValue("istoxls") == "1") { ToXls(); } trBll = new EyouSoft.BLL.PersonalCenterStructure.TranRemind(SiteUserInfo); if (!IsPostBack) { DataInit(); } }
protected void Page_Load(object sender, EventArgs e) { setday = CheckGrant(global::Common.Enum.TravelPermission.系统设置_系统配置_系统设置栏目); trBll = new EyouSoft.BLL.PersonalCenterStructure.TranRemind(SiteUserInfo); csBll = new EyouSoft.BLL.CompanyStructure.CompanySetting(); if (!IsPostBack) { string type = Utils.GetQueryStringValue("type"); switch (type) { case "duedayset": SetDay(); break; default: DataInit(); break; } } }
protected void InitBindOrderlist() { EyouSoft.BLL.PersonalCenterStructure.TranRemind trBll = new EyouSoft.BLL.PersonalCenterStructure.TranRemind(SiteUserInfo); remindnum = trBll.GetTotalOrderCountByBuyCompanyId(CurrentUserCompanyID); }
private void GetAjaxHtml() { Response.Clear(); EyouSoft.BLL.PersonalCenterStructure.TranRemind trBll = new EyouSoft.BLL.PersonalCenterStructure.TranRemind(SiteUserInfo); EyouSoft.BLL.CompanyStructure.CompanySetting csBll = new EyouSoft.BLL.CompanyStructure.CompanySetting(); StringBuilder sb = new StringBuilder(); if (SiteUserInfo != null) { if (CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_收款提醒栏目)) { EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType rrt = csBll.GetReceiptRemindType(CurrentUserCompanyID); int?sellerId = null; if (rrt == EyouSoft.Model.EnumType.CompanyStructure.ReceiptRemindType.OnlySeller) { sellerId = SiteUserInfo.ID; } int awakenum = 0; trBll.GetReceiptRemind(1, 0, ref awakenum, CurrentUserCompanyID, rrt, sellerId, null); if (awakenum > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/AppectAwake.aspx';window.opener.focus();\"; >您有{0}条收款未处理!</a></p>", awakenum); } } if (CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_付款提醒栏目)) { int awakenum = trBll.GetPayRemind(this.CurrentUserCompanyID); if (awakenum > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/PayAwake.aspx';window.opener.focus();\"; >您有{0}条付款未处理!</a></p>", awakenum); } } if (CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_出团提醒栏目)) { int day = csBll.GetLeaveTourReminderDays(CurrentUserCompanyID); int awakenum = trBll.GetLeaveTourRemind(this.CurrentUserCompanyID, day); if (awakenum > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/OutAwake.aspx';window.opener.focus();\"; >{0}天内有{1}个团出团!</a></p>", day, awakenum); } } if (CheckGrant(global::Common.Enum.TravelPermission.个人中心_事务提醒_回团提醒栏目)) { int day = csBll.GetBackTourReminderDays(this.CurrentUserCompanyID); int awakenum = trBll.GetBackTourRemind(this.CurrentUserCompanyID, day); if (awakenum > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/BackAwake.aspx';window.opener.focus();\"; >{0}天内有{1}个团回团!</a></p>", day, awakenum); } } if (SiteUserInfo.PermissionList.Contains(5)) { int day = csBll.GetContractReminderDays(this.CurrentUserCompanyID); int awakenum = trBll.GetTotalContractRemind(day, CurrentUserCompanyID); if (awakenum > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/DueAwake.aspx';window.opener.focus();\"; >{0}天内有{1}个员工劳动合同到期!</a></p>", day, awakenum); } } if (SiteUserInfo.PermissionList.Contains((int)global::Common.Enum.TravelPermission.个人中心_事务提醒_订单提醒栏目)) { var searchInfo = new EyouSoft.Model.TourStructure.MDingDanTiXingInfo(); int recordCount = 0; var items = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo).GetDingDanTiXing(CurrentUserCompanyID, 1, 1, ref recordCount, searchInfo); if (recordCount > 0) { sb.AppendFormat("<p><a href=\"javascript:window.opener.location.href='http/UserCenter/WorkAwake/DingDanTiXing.aspx';window.opener.focus();\"; >您有<b>{0}</b>个未处理订单!</a></p>", recordCount); } } } Utils.SetCookie(CookieKeyManage.LAST_LOGIN_TIME_COOKIE_KEY, DateTime.Now.ToString("yyyy-M-d-H-m-s")); Response.Write(sb.ToString()); Response.End(); }