Пример #1
0
 IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticAirLine> list = null;//未收集合
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (!CheckGrant(TravelPermission.机票管理_机票管理_出票统计))
         {
             Utils.ResponseNoPermit(TravelPermission.机票管理_机票管理_出票统计, false);
         }
         Bind();
         #region 导出报表请求
         if (Utils.GetInt(Request.QueryString["isExport"], 0) == 1)
         {
             var bll   = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(SiteUserInfo);
             var model = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
             model.OfficeName = Utils.GetQueryStringValue("OfficeName");
             model.CompanyId  = SiteUserInfo.CompanyID;
             model.DepartName = Utils.GetQueryStringValue("DepartMents");
             string strDepIds = Utils.GetQueryStringValue("DepartIds");
             model.DepartIds          = JiPiao_TuiList.GetIntArrByStr(strDepIds);
             model.StartTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("DateTime"));
             model.EndTicketOutTime   = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("endtime"));
             model.LeaveDateStart     = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
             model.LeaveDateEnd       = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
             list = bll.GetTicketOutStatisticAirLine(model);
             if (list != null && list.Count != 0)
             {
                 ToExcel(this.rpt_list, list);
             }
         }
         #endregion
     }
 }
Пример #2
0
        void Bind()
        {
            pageIndex = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1);

            EyouSoft.BLL.StatisticStructure.TicketOutStatistic       bll   = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(SiteUserInfo);
            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti model = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            model.OfficeName = Utils.GetQueryStringValue("OfficeName");
            model.CompanyId  = SiteUserInfo.CompanyID;
            model.DepartName = Utils.GetQueryStringValue("DepartMents");
            string strDepIds = Utils.GetQueryStringValue("DepartIds");

            model.DepartIds          = JiPiao_TuiList.GetIntArrByStr(strDepIds);
            model.StartTicketOutTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("DateTime"));
            model.EndTicketOutTime   = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("endtime"));
            model.LeaveDateStart     = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
            model.LeaveDateEnd       = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
            list = bll.GetTicketOutStatisticAirLine(model);
            if (list != null && list.Count > 0)
            {
                recordCount         = list.Count;
                rpt_list.DataSource = list.Skip((pageIndex - 1) * pageSize).Take(pageSize);
                rpt_list.DataBind();

                #region 设置总计
                //总票数
                this.lblAllTickets = list.Sum(p => p.TicketOutNum).ToString();
                //应付机票款
                this.lblNeedMoney = list.Sum(p => p.TotalAmount).ToString("¥#,###0.00");
                //已付机票款
                this.lblOverMoney = list.Sum(p => p.PayAmount).ToString("¥#,###0.00");
                //未付机票款
                this.lblNoMoney = list.Sum(p => p.UnPaidAmount).ToString("¥#,###0.00");
                #endregion


                #region 设置分页
                ExportPageInfo1.intPageSize    = pageSize;
                ExportPageInfo1.intRecordCount = recordCount;
                ExportPageInfo1.PageLinkURL    = Request.Path + "?";
                ExportPageInfo1.UrlParams      = Request.QueryString;
                ExportPageInfo1.CurrencyPage   = pageIndex;
                #endregion
            }
            else
            {
                //没有数据隐藏控件
                ExportPageInfo1.Visible = false;
            }

            UCselectDepart.GetDepartmentName = model.DepartName;
            UCselectDepart.GetDepartId       = strDepIds;
            txt_date.Value         = model.StartTicketOutTime.HasValue ? model.StartTicketOutTime.Value.ToString("yyyy-MM-dd") : "";
            txt_endDate.Value      = model.EndTicketOutTime.HasValue ? model.EndTicketOutTime.Value.ToString("yyyy-MM-dd") : "";
            txt_spq.Value          = model.OfficeName;
            txtLeaveDateStart.Text = model.LeaveDateStart.HasValue ? model.LeaveDateStart.Value.ToString("yyyy-MM-dd") : string.Empty;
            txtLeaveDateEnd.Text   = model.LeaveDateEnd.HasValue ? model.LeaveDateEnd.Value.ToString("yyyy-MM-dd") : string.Empty;
        }
Пример #3
0
        /// <summary>
        /// 导出Excel
        /// </summary>
        public void toExcel(string FileName)
        {
            EyouSoft.SSOComponent.Entity.UserInfo UserModel = new EyouSoft.SSOComponent.Entity.UserInfo();
            UserModel.CompanyID = SiteUserInfo.CompanyID;
            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti ssModel = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            //查询条件
            ssModel.CompanyId = SiteUserInfo.CompanyID;
            string departId   = Utils.GetQueryStringValue("DepartIds");
            string OfficeName = Utils.GetQueryStringValue("OfficeName");//获取航空公司查询条件

            int[] AirLineIds = new int[1];
            AirLineIds[0] = Utils.GetInt(Utils.GetQueryStringValue("areaId"));//获取售票处查询条件
            if (AirLineIds[0] > 0)
            {
                ssModel.AirLineIds = AirLineIds;
            }
            ssModel.DepartIds      = JiPiao_TuiList.GetIntArrByStr(departId);
            ssModel.OfficeName     = OfficeName;
            ssModel.LeaveDateStart = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
            ssModel.LeaveDateEnd   = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
            EyouSoft.BLL.StatisticStructure.TicketOutStatistic ssBLL = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(UserModel);
            IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticTime> ssList = null;

            ssList = ssBLL.GetTicketOutStatisticTime(ssModel);

            Response.Clear();
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls");
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.ContentType     = "application/ms-excel";

            //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符
            StringBuilder sb = new StringBuilder();

            sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", "月份", "出票量", "应付机票款", "已付机票款", "未付机票款");
            foreach (EyouSoft.Model.StatisticStructure.TicketOutStatisticTime cs in ssList)
            {
                sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n",
                                cs.CurrYear + "年" + cs.CurrMonth + "月",
                                cs.TicketOutNum + "(张)",
                                cs.TotalAmount.ToString("¥#,##0.00 "),
                                cs.PayAmount.ToString("¥#,##0.00 "),
                                cs.UnPaidAmount.ToString("¥#,##0.00 "));
            }
            sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", "总计", lblAllTickets.Text + "(张)", lblNeedMoney.Text, lblOverMoney.Text, lblNoMoney.Text);
            Response.Write(sb.ToString());
            Response.End();
        }
Пример #4
0
        /// <summary>
        /// 导出Excel
        /// </summary>
        public void CreateExcel(string FileName)
        {
            AirlinesValue = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("AirlinesValue"));
            string DepartId = EyouSoft.Common.Utils.GetQueryStringValue("DepartIds");

            Datetime      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("DateTime"));
            ticketendtime = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("endtime"));
            LeaDateS      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("leaDateS"));
            LeaDateE      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("leaDateE"));

            //列表数据绑定
            Response.Clear();
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls");
            Response.ContentEncoding = System.Text.Encoding.Default;
            Response.ContentType     = "application/ms-excel";

            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti QueryTicket = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            QueryTicket.CompanyId = SiteUserInfo.CompanyID;
            if (AirlinesValue > 0)
            {
                QueryTicket.AirLineIds = new int[1] {
                    AirlinesValue
                }
            }
            ;
            QueryTicket.DepartIds          = JiPiao_TuiList.GetIntArrByStr(DepartId);
            QueryTicket.EndTicketOutTime   = ticketendtime;
            QueryTicket.StartTicketOutTime = Datetime;
            QueryTicket.LeaveDateStart     = LeaDateS;
            QueryTicket.LeaveDateEnd       = LeaDateE;
            IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticOffice> ticketlist = ticketlist = TicketBll.GetTicketOutStatisticOffice(QueryTicket);

            if (ticketlist != null && ticketlist.Count > 0)
            {
                //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符
                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", "售票处", "出票量", "应付机票款", "已付机票款", "未付机票款");
                foreach (EyouSoft.Model.StatisticStructure.TicketOutStatisticOffice sh in ticketlist)
                {
                    sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", sh.OfficeName, sh.TicketOutNum, "¥" + sh.TotalAmount, "¥" + sh.PayAmount, "¥" + sh.UnPaidAmount);
                }
                sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\n", "总计", ticketlist.Sum(p => p.TicketOutNum).ToString(), "¥" + ticketlist.Sum(p => p.TotalAmount).ToString(), "¥" + ticketlist.Sum(p => p.PayAmount).ToString(), "¥" + ticketlist.Sum(p => p.UnPaidAmount).ToString());
                Response.Write(sb.ToString());
                Response.End();
            }
        }
Пример #5
0
        /// <summary>
        /// 初始化方法
        /// </summary>
        /// <param name="id"></param>
        /// <param name="departIds"></param>
        /// <param name="areaIds"></param>
        /// <param name="beginDate"></param>
        /// <param name="endDate"></param>
        /// <param name="leaDateStart"></param>
        /// <param name="leaDateEnd"></param>
        /// <param name="officeName"></param>
        protected void DataInit(int id, string departIds, string areaIds, DateTime?beginDate, DateTime?endDate, DateTime?leaDateStart
                                , DateTime?leaDateEnd, string officeName)
        {
            //部门ID 的集合
            int[] departIdList = JiPiao_TuiList.GetIntArrByStr(departIds);
            //航空公司 ID 集合
            int[] areaIdList = JiPiao_TuiList.GetIntArrByStr(areaIds);

            //声明查询Model
            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti searchModel = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            //查询Model 赋值
            searchModel.CompanyId          = SiteUserInfo.CompanyID;
            searchModel.DepartIds          = departIdList;
            searchModel.AirLineIds         = areaIdList;
            searchModel.StartTicketOutTime = beginDate;
            searchModel.EndTicketOutTime   = endDate;
            searchModel.OfficeId           = id;
            searchModel.LeaveDateStart     = leaDateStart;
            searchModel.LeaveDateEnd       = leaDateEnd;
            searchModel.OfficeName         = officeName;

            //声明机票 bll 操作对象
            EyouSoft.BLL.PlanStruture.PlaneTicket bll = new EyouSoft.BLL.PlanStruture.PlaneTicket(SiteUserInfo);
            //声明出票量集合对象

            IList <EyouSoft.Model.PlanStructure.TicketOutStatisticInfo> list = bll.GetTicketOutStatisticList(pageSize, pageIndex, ref recordCount, searchModel);

            //判断list内数据条数大于0
            if (list != null && list.Count > 0)
            {
                //绑定控件
                this.rptList.DataSource = list;
                this.rptList.DataBind();
                //设置分页
                BindPage();
                //隐藏提示
                this.lblMsg.Visible = false;
            }
            else
            {
                //隐藏分页
                this.ExportPageInfo1.Visible = false;
                //显示提示
                this.lblMsg.Visible = true;
            }
        }
Пример #6
0
        /// <summary>
        /// 绑定列表
        /// </summary>
        private void DataBindLs()
        {
            //获取显示页数
            pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
            //用户信息实体
            EyouSoft.SSOComponent.Entity.UserInfo UserModel = new EyouSoft.SSOComponent.Entity.UserInfo();
            //公司编号
            UserModel.CompanyID = SiteUserInfo.CompanyID;
            //出票统计查询实体
            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti ssModel = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            //查询条件
            ssModel.CompanyId = SiteUserInfo.CompanyID;
            string DepartName = Utils.GetQueryStringValue("DepartMents"); //获取部门查询条件
            string departId   = Utils.GetQueryStringValue("DepartIds");
            string OfficeName = Utils.GetQueryStringValue("OfficeName");  //获取航空公司查询条件

            int[] AirLineIds = new int[1];
            AirLineIds[0] = Utils.GetInt(Utils.GetQueryStringValue("areaId"));//获取售票处查询条件
            if (AirLineIds[0] > 0)
            {
                ssModel.AirLineIds = AirLineIds;
            }
            ssModel.DepartIds      = JiPiao_TuiList.GetIntArrByStr(departId);
            ssModel.OfficeName     = OfficeName;
            ssModel.LeaveDateStart = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateS"));
            ssModel.LeaveDateEnd   = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("leaDateE"));
            //出票统计BLL
            EyouSoft.BLL.StatisticStructure.TicketOutStatistic ssBLL = new EyouSoft.BLL.StatisticStructure.TicketOutStatistic(UserModel);
            //按日期获取出票统计
            IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticTime> ssList = ssBLL.GetTicketOutStatisticTime(ssModel);

            if (ssList != null && ssList.Count > 0)
            {
                retList.DataSource = ssList.Skip((pageIndex - 1) * pageSize).Take(pageSize);;
                retList.DataBind();
                recordCount = ssList.Count;
                BindPage();

                #region 设置总计
                //总票数
                this.lblAllTickets.Text = ssList.Sum(p => p.TicketOutNum).ToString();
                //应付机票款
                this.lblNeedMoney.Text = ssList.Sum(p => p.TotalAmount).ToString("¥#,##0.00");
                //已付机票款
                this.lblOverMoney.Text = ssList.Sum(p => p.PayAmount).ToString("¥#,##0.00");
                //未付机票款
                this.lblNoMoney.Text = ssList.Sum(p => p.UnPaidAmount).ToString("¥#,##0.00");
                #endregion

                this.lblMsg.Visible = false;
            }
            else
            {
                this.ExportPageInfo1.Visible = false;
            }

            ssList = null;
            Bindddl(AirLineIds);
            txt_spq.Value = ssModel.OfficeName;
            if (ssModel.LeaveDateStart.HasValue)
            {
                txtLeaveDateStart.Text = ssModel.LeaveDateStart.Value.ToShortDateString();
            }
            if (ssModel.LeaveDateEnd.HasValue)
            {
                txtLeaveDateEnd.Text = ssModel.LeaveDateEnd.Value.ToShortDateString();
            }
            UCselectDepart.GetDepartmentName = DepartName;
            UCselectDepart.GetDepartId       = departId;
        }
Пример #7
0
        protected void BindList()
        {
            //分页
            PageIndex     = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("Page"), 1);
            AirlinesValue = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("AirlinesValue"));
            string DepartMent = EyouSoft.Common.Utils.GetQueryStringValue("DepartMents");
            string DepartId   = EyouSoft.Common.Utils.GetQueryStringValue("DepartIds");

            Datetime      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("DateTime"));
            ticketendtime = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("endtime"));
            LeaDateS      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("leaDateS"));
            LeaDateE      = EyouSoft.Common.Utils.GetDateTimeNullable(EyouSoft.Common.Utils.GetQueryStringValue("leaDateE"));
            EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti QueryTicket = new EyouSoft.Model.StatisticStructure.QueryTicketOutStatisti();
            QueryTicket.CompanyId = SiteUserInfo.CompanyID;
            if (AirlinesValue > 0)
            {
                QueryTicket.AirLineIds = new int[1] {
                    AirlinesValue
                };
                if (this.Airlineslist.Items.FindByValue(AirlinesValue.ToString()) != null)
                {
                    this.Airlineslist.Items.FindByValue(AirlinesValue.ToString()).Selected = true;
                }
            }
            QueryTicket.DepartIds          = JiPiao_TuiList.GetIntArrByStr(DepartId);
            QueryTicket.EndTicketOutTime   = ticketendtime;
            QueryTicket.StartTicketOutTime = Datetime;
            QueryTicket.LeaveDateStart     = LeaDateS;
            QueryTicket.LeaveDateEnd       = LeaDateE;
            IList <EyouSoft.Model.StatisticStructure.TicketOutStatisticOffice> ticketlist = TicketBll.GetTicketOutStatisticOffice(QueryTicket);

            if (ticketlist != null && ticketlist.Count > 0)
            {
                this.prtticketlist.DataSource = EyouSoft.Common.Function.SelfExportPage.GetList <EyouSoft.Model.StatisticStructure.TicketOutStatisticOffice>(PageIndex, PageSize, out RecordCount, ticketlist);
                this.prtticketlist.DataBind();
                BindPage();
                lenght = ticketlist.Count;

                #region 设置总计
                //总票数
                this.lblAllTickets.Text = ticketlist.Sum(p => p.TicketOutNum).ToString();
                //应付机票款
                this.lblNeedMoney.Text = ticketlist.Sum(p => p.TotalAmount).ToString("c2");
                //已付机票款
                this.lblOverMoney.Text = ticketlist.Sum(p => p.PayAmount).ToString("c2");
                //未付机票款
                this.lblNoMoney.Text = ticketlist.Sum(p => p.UnPaidAmount).ToString("c2");
                #endregion

                this.lblMsg.Visible = false;
            }
            else
            {
                this.lblMsg.Visible          = true;
                this.ExportPageInfo1.Visible = false;
            }

            #region 设置查询值

            UCselectDepart.GetDepartmentName = DepartMent;
            UCselectDepart.GetDepartId       = DepartId;
            if (QueryTicket.LeaveDateStart.HasValue)
            {
                txtLeaveDateStart.Text = QueryTicket.LeaveDateStart.Value.ToShortDateString();
            }
            if (QueryTicket.LeaveDateEnd.HasValue)
            {
                txtLeaveDateEnd.Text = QueryTicket.LeaveDateEnd.Value.ToShortDateString();
            }

            #endregion
        }