/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); SumMoney = new Model.StatStructure.MReconciliationTongJi(); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompanyId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_收入对账单_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetReconciliationRestAmountLst( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); rptRestAmount.DataSource = list; rptRestAmount.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); SumMoney = new Model.StatStructure.MPersonalOrderListTongJi(); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("DepartId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_个人业绩统计_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetPersonalOrderListBySellerId( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); rptOrder.DataSource = list; rptOrder.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); SumMoney = new Model.StatStructure.MDepartmentPeopleListTongJi(); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompanyId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_部门业绩统计_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } s.Append("序号\t姓名\t订单人数\t订单数量\t收入\t支出\t毛利\t毛利率\n"); var list = new BLL.StatStructure.BStatistics().GetDepartmentPeopleListByDeptId( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); if (list != null && list.Any()) { int index = 1; foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n", index, t.SellerName, t.PeopleNum, t.OrderNum, UtilsCommons.GetMoneyString(t.TotalIncome, ProviderToMoney), UtilsCommons.GetMoneyString(t.TotalOutlay, ProviderToMoney), UtilsCommons.GetMoneyString(t.GrossProfit, ProviderToMoney), GetBfbString(t.GrossProfitRate, 0)); index++; } s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n", " ", "合计:", SumMoney.PeopleNum, SumMoney.OrderNum, UtilsCommons.GetMoneyString(SumMoney.InCome, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.Pay, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.GrossProfit, ProviderToMoney), ""); } ResponseToXls(s.ToString()); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); SumMoney = new Model.StatStructure.MReconciliationTongJi(); s.Append("部门\t销售员\t应收款\t已收款\t未收\n"); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompan")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_收入对账单_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetReconciliationLst( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); if (list != null && list.Any()) { foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\n", t.DeptName, t.SellerName, UtilsCommons.GetMoneyString(t.TotalAmount, ProviderToMoney), UtilsCommons.GetMoneyString(t.InAmount, ProviderToMoney), UtilsCommons.GetMoneyString(t.RestAmount, ProviderToMoney)); } s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\n", " ", "合计:", UtilsCommons.GetMoneyString(SumMoney.TotalAmount, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.InAmount, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.RestAmount, ProviderToMoney)); } ResponseToXls(s.ToString()); }
void ToXls() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var tongJiInfo = new Model.StatStructure.MPersonalOrderListTongJi(); int deptId = Utils.GetInt(Utils.GetQueryStringValue("DepartId")); if (deptId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_个人业绩统计_查看全部)) { deptId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var items = new BLL.StatStructure.BStatistics().GetPersonalOrderListBySellerId(SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, deptId, this.GetSearchModel(), ref tongJiInfo); if (items == null || items.Count == 0) { ResponseToXls(string.Empty); } StringBuilder s = new StringBuilder(); s.Append("序号\t团号\t订单号\t线路名称\t客户单位\t出团时间\t人数\t收入\t支出\t毛利\t毛利率\t下单人\n"); int i = 1; foreach (var item in items) { s.Append(i + "\t"); s.Append(item.TourCode + "\t"); s.Append(item.OrderCode + "\t"); s.Append(item.RouteName + "\t"); s.Append(item.BuyCompanyName + "\t"); s.Append(item.LDate.ToString("yyyy-MM-dd") + "\t"); s.Append(item.PeopleNum + "\t"); s.Append(item.TotalIncome.ToString("F2") + "\t"); s.Append(item.TotalOutlay.ToString("F2") + "\t"); s.Append(item.GrossProfit.ToString("F2") + "\t"); s.Append(GetBfbString(item.GrossProfitRate, 2) + "\t"); s.Append(item.Operator + "\n"); i++; } ResponseToXls(s.ToString()); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); var list = new BLL.StatStructure.BStatistics().GetPersonalLst( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, FenGongSiId, this.GetSearchModel()); rptPersonal.DataSource = list; rptPersonal.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); s.Append("线路区域\t收客数\t团队数量\t总收入\t总支出\t毛利\t毛利率\t人均毛利\n"); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("DepartId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_线路流量统计_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetRouteFlowLst( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, sunCompanyId, this.GetSearchModel()); if (list != null && list.Any()) { foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\n", t.AreaName, t.Adults + "+" + t.Childs, t.TourCount, UtilsCommons.GetMoneyString(t.TotalIncome, ProviderToMoney), UtilsCommons.GetMoneyString(t.TotalOutlay, ProviderToMoney), UtilsCommons.GetMoneyString(t.GrossProfit, ProviderToMoney), GetBfbString(t.GrossProfitRate, 0), GetBfbString(t.PerGrossProfitRate, 0)); } } ResponseToXls(s.ToString()); }
/// <summary> /// 初始化列表数据 /// </summary> /// <param name="ttp">游客类型编号</param> private void InitData(int ttp) { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); var list = new BLL.StatStructure.BStatistics().GetTravellerFlowLst( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref RecordCount, FenGongSiId, this.GetSearchModel(), GetTravellerType(ttp)); rptTraveller.DataSource = list; rptTraveller.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("DepartId")); if (sunCompanyId <= 0 || (!CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_线路流量统计_查看全部))) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetRouteFlowTourListByAreaId( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, sunCompanyId, GetSearchModel()); rptTourList.DataSource = list; rptTourList.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); s.Append("销售员\t人数\t订单数\t总收入\t总支出\t毛利\t毛利率\n"); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("DepartId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_个人业绩统计_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetPersonalLst( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, sunCompanyId, this.GetSearchModel()); if (list != null && list.Any()) { foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\n", t.SellerName, t.PeopleNum, t.OrderNum, t.TotalIncome.ToString("F2"), t.TotalOutlay.ToString("F2"), t.GrossProfit.ToString("F2"), GetBfbString(t.GrossProfitRate, 0)); } } ResponseToXls(s.ToString()); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); SumMoney = new Model.StatStructure.MReconciliationTongJi(); var list = new BLL.StatStructure.BStatistics().GetReconciliationLst( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, FenGongSiId, this.GetSearchModel(), ref SumMoney); rptIncome.DataSource = list; rptIncome.DataBind(); //绑定分页 BindPage(); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompanyId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_部门业绩统计_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } SumMoney = new Model.StatStructure.MDepartmentTongJi(); var list = new BLL.StatStructure.BStatistics().GetDepartmentLst( SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); InitFlashData(list); }
/// <summary> /// 导出Excel /// </summary> /// <param name="ttp">游客类型编号</param> private void ListToExcel(int ttp) { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); s.Append("序号\t人数(订单人数合计)\t人天数(订单人数*计划天数合计)\t客源地\n"); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompan")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_游客统计表_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } var list = new BLL.StatStructure.BStatistics().GetTravellerFlowLst( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref RecordCount, sunCompanyId, this.GetSearchModel(), this.GetTravellerType(ttp)); if (list != null && list.Any()) { int index = 1; foreach (var t in list) { s.AppendFormat("{0}\t{1}\t{2}\t{3}\n", index, t.PeopleNum, t.PeopleDayNum, t.Place); index++; } } ResponseToXls(s.ToString()); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); s.Append("团号\t线路名称\t出团时间\t回团时间\t人数\t销售员\t计调员\t导游\t状态\n"); object[] heJi; IList <Model.StatStructure.MTourStatus> list; list = new BLL.StatStructure.BStatistics().GetTourStatusLst(SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, this.GetSearchModel(), out heJi); if (list != null && list.Any()) { foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\n", t.TourCode, t.RouteName, UtilsCommons.GetDateString(t.LDate, ProviderToDate), UtilsCommons.GetDateString(t.RDate, ProviderToDate), t.PersonNum, t.SellerName, GetPlanerName(t.Planer), GetGuiderName(t.Guide), t.TourStatus); } } ResponseToXls(s.ToString()); }
/// <summary> /// 初始化列表数据 /// </summary> private void InitData() { _pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); object[] heJI; IList <Model.StatStructure.MTourStatus> list; list = new BLL.StatStructure.BStatistics().GetTourStatusLst(SiteUserInfo.CompanyId, _pageSize, _pageIndex, ref _recordCount, this.GetSearchModel(), out heJI); if (list != null && list.Count > 0) { rptTourList.DataSource = list; rptTourList.DataBind(); ltrRenShuHeJi.Text = heJI[0].ToString(); } else { phHeJi.Visible = false; } //绑定分页 BindPage(); }
/// <summary> /// 导出Excel /// </summary> private void ListToExcel() { int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount(); if (toXlsRecordCount < 1) { ResponseToXls(string.Empty); } var s = new StringBuilder(); SumMoney = new Model.StatStructure.MReconciliationTongJi(); int sunCompanyId = Utils.GetInt(Utils.GetQueryStringValue("SunCompanyId")); if (sunCompanyId <= 0 || !CheckGrant(Model.EnumType.PrivsStructure.Privs.统计分析_收入对账单_查看全部)) { sunCompanyId = UtilsCommons.GetFirstDepartId(SiteUserInfo.CompanyId, SiteUserInfo.DeptId); } s.Append("序号\t订单号\t线路名称\t出团时间\t客户单位\t人数\t应收款\t已收款\t未收款\n"); var list = new BLL.StatStructure.BStatistics().GetReconciliationRestAmountLst( SiteUserInfo.CompanyId, toXlsRecordCount, 1, ref _recordCount, sunCompanyId, this.GetSearchModel(), ref SumMoney); if (list != null && list.Any()) { int index = 1; foreach (var t in list) { s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\n", index, t.OrderCode, t.RouteName, UtilsCommons.GetDateString(t.LDate, ProviderToDate), t.BuyCompanyName, t.PeopleNum, UtilsCommons.GetMoneyString(t.TotalAmount, ProviderToMoney), UtilsCommons.GetMoneyString(t.InAmount, ProviderToMoney), UtilsCommons.GetMoneyString(t.RestAmount, ProviderToMoney)); index++; } s.AppendFormat( "{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\n", " ", " ", " ", " ", " ", "合计:", UtilsCommons.GetMoneyString(SumMoney.TotalAmount, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.InAmount, ProviderToMoney), UtilsCommons.GetMoneyString(SumMoney.RestAmount, ProviderToMoney)); } ResponseToXls(s.ToString()); }