Exemplo n.º 1
0
        /// <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();
        }
Exemplo n.º 2
0
        /// <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();
        }
Exemplo n.º 3
0
        /// <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());
        }
Exemplo n.º 4
0
        /// <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());
        }
Exemplo n.º 5
0
        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());
        }
Exemplo n.º 6
0
        /// <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();
        }
Exemplo n.º 7
0
        /// <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());
        }
Exemplo n.º 8
0
        /// <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();
        }
Exemplo n.º 9
0
        /// <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();
        }
Exemplo n.º 10
0
        /// <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());
        }
Exemplo n.º 11
0
        /// <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();
        }
Exemplo n.º 12
0
        /// <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);
        }
Exemplo n.º 13
0
        /// <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());
        }
Exemplo n.º 14
0
        /// <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());
        }
Exemplo n.º 15
0
        /// <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();
        }
Exemplo n.º 16
0
        /// <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());
        }