/// <summary> /// 绑定统计分析账龄分析按客户单位 /// </summary> private void BindZhangLingAnKeHuDanWei() { int pageSize = 20; int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1); int recordCount = 0; var searchInfo = new EyouSoft.Model.StatisticStructure.ZhangLingAnKeHuDanWeiChaXun(); searchInfo.KeHuName = Utils.GetQueryStringValue("kehumingcheng"); searchInfo.SortType = Utils.GetInt(Utils.GetQueryStringValue("sorttype")); searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate")); searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate")); EyouSoft.BLL.StatisticStructure.AccountAgeStatistic bll = new EyouSoft.BLL.StatisticStructure.AccountAgeStatistic(SiteUserInfo); var items = bll.GetZhangLingAnKeHuDanWei(pageSize, pageIndex, ref recordCount, CurrentUserCompanyID, searchInfo); if (items != null && items.Count > 0) { ph.Visible = true; phEmpty.Visible = false; rpt.DataSource = items; rpt.DataBind(); decimal weiShouKuanHeJi; bll.GetZhangLingAnKeHuDanWei(CurrentUserCompanyID, searchInfo, out weiShouKuanHeJi); ltrWeiShouHeJi.Text = weiShouKuanHeJi.ToString("C2"); this.ExportPageInfo1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExportPageInfo1.UrlParams = Request.QueryString; this.ExportPageInfo1.intPageSize = pageSize; this.ExportPageInfo1.CurrencyPage = pageIndex; this.ExportPageInfo1.intRecordCount = recordCount; } else { ph.Visible = false; phEmpty.Visible = true; } RegisterScript(string.Format("var recordCount={0};", recordCount)); }
/// <summary> /// to xls /// </summary> private void ToXls() { if (!CheckGrant(TravelPermission.统计分析_帐龄分析_帐龄分析栏目)) { ResponseToXls(string.Empty); } int pageSize = Utils.GetInt(Utils.GetQueryStringValue("recordcount")); if (pageSize < 1) { ResponseToXls(string.Empty); } int recordCount = 0; var searchInfo = new EyouSoft.Model.StatisticStructure.ZhangLingAnKeHuDanWeiChaXun(); searchInfo.KeHuName = Utils.GetQueryStringValue("kehumingcheng"); searchInfo.SortType = Utils.GetInt(Utils.GetQueryStringValue("sorttype")); searchInfo.LSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("lsdate")); searchInfo.LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("ledate")); EyouSoft.BLL.StatisticStructure.AccountAgeStatistic bll = new EyouSoft.BLL.StatisticStructure.AccountAgeStatistic(SiteUserInfo); var items = bll.GetZhangLingAnKeHuDanWei(pageSize, 1, ref recordCount, CurrentUserCompanyID, searchInfo); System.Text.StringBuilder s = new System.Text.StringBuilder(); if (items != null && items.Count > 0) { s.Append("客户单位\t拖欠款总额\t最长拖欠时间\n"); foreach (var item in items) { s.AppendFormat("{0}\t{1}\t{2}\n", item.KeHuName, item.WeiShouKuan.ToString("C2"), item.EarlyTime.ToString("yyyy-MM-dd")); } } ResponseToXls(s.ToString()); }