Example #1
0
        /// <summary>
        /// 初始化页面
        /// </summary>
        private void InitPage()
        {
            //分页参数
            int intRecordCount            = 0,                                                  //记录条数
                CurrencyPage              = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1), //页码
                intPageSize               = 15;                                                 //每页条数
            MOrderStaticSearch queryModel = new MOrderStaticSearch();

            #region 查询参数
            //专线Id
            queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"));
            isDetail          = queryModel.AreaId > 0;
            //是否详细列表
            queryModel.IsDetail = isDetail;
            if (isDetail)
            {
                lbl_title.Text = Utils.GetQueryStringValue("title");
            }
            //出团时间开始
            queryModel.LeaveDateS = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeS"));
            txt_goTimeS.Value     = Utils.GetQueryStringValue("goTimeS");
            //出团时间结束
            queryModel.LeaveDateE = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeE"));
            txt_goTimeE.Value     = Utils.GetQueryStringValue("goTimeE");
            //公司编号
            queryModel.CompanyId = SiteUserInfo.CompanyID;
            //公司类型
            queryModel.CompanyTyp = CompanyType.组团;
            #endregion
            IList <MOrderStatic> list = EyouSoft.BLL.NewTourStructure.BTourOrder.CreateInstance().GetOrderStaticLst(
                intPageSize,
                CurrencyPage,
                ref intRecordCount,
                queryModel);

            if (list != null && list.Count > 0)
            {
                rpt_parentList.DataSource = list;
                rpt_parentList.DataBind();
                ExportPageInfo1.Visible             = true;
                this.ExportPageInfo1.intPageSize    = intPageSize;
                this.ExportPageInfo1.intRecordCount = intRecordCount;
                this.ExportPageInfo1.CurrencyPage   = CurrencyPage;
                this.ExportPageInfo1.PageLinkURL    = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";

                this.ExportPageInfo1.UrlParams.Add("title", Utils.GetQueryStringValue("title"));
                this.ExportPageInfo1.UrlParams.Add("lineId", queryModel.AreaId.ToString());
                this.ExportPageInfo1.UrlParams.Add("goTimeS", queryModel.LeaveDateS.ToString());
                this.ExportPageInfo1.UrlParams.Add("goTimeE", queryModel.LeaveDateE.ToString());
                //this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.OrderKey);
            }
            else
            {
                //不存在列表数据
                pnlNodata.Visible = true;
            }
        }
Example #2
0
        /// <summary>
        /// 绑定线路列表
        /// </summary>
        protected void BindLineList()
        {
            int                recordCount = 0;
            string             IsOrNoDetal = Utils.GetQueryStringValue("IsDetail");
            string             Lineid      = Utils.GetQueryStringValue("LineId");
            MOrderStaticSearch SearchModel = new MOrderStaticSearch();

            SearchModel.AreaId   = Utils.GetInt(Lineid);
            SearchModel.IsDetail = bool.Parse(IsOrNoDetal);
            IList <MOrderStatic> listScenicArea = EyouSoft.BLL.NewTourStructure.BTourOrder.CreateInstance().GetOrderStaticLst(PageSize, PageIndex, ref recordCount, SearchModel);


            #region  递数据
            //StringBuilder strb = new StringBuilder("{tolist:[");
            //foreach (MOrderStatic item in listScenicArea)
            //{
            //    strb.Append("{\"RouteName\":\"" + item.RouteName + "\",\"TotalOrder\":\"" + item.TotalOrder + "\""
            //              + ",\"TotalPeople\":\"" + item.TotalPeople + "\",,\"TotalAdult\":\"" + item.TotalAdult + "\""
            //              + ",\"TotalChild\":\"" + item.TotalChild + "\",,\"TotalSale\":\"" + item.TotalSale + "\""
            //              + ",\"TotalSettle\":\"" + item.TotalSettle + "\"},");
            //}
            //Response.Clear();
            //Response.Write(strb.ToString().TrimEnd(',') + "]}");
            //Response.End();

            #endregion

            if (listScenicArea.Count > 0)
            {
                //this.ExporPageInfoSelect1.intPageSize = PageSize;
                //this.ExporPageInfoSelect1.intRecordCount = recordCount;
                //this.ExporPageInfoSelect1.CurrencyPage = PageIndex;
                //this.ExporPageInfoSelect1.HrefType = Adpost.Common.ExporPage.HrefTypeEnum.JsHref;
                //this.ExporPageInfoSelect1.AttributesEventAdd("onclick", "LineDetailmanage.LoadData(this);", 1);
                //this.ExporPageInfoSelect1.AttributesEventAdd("onchange", "LineDetailmanage.LoadData(this);", 0);
                this.repList.DataSource = listScenicArea;
                this.repList.DataBind();
            }
            else
            {
                StringBuilder strEmptyText = new StringBuilder();
                strEmptyText.Append("<table width=\"98%\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#C7DEEB\" class=\"table_basic\">");
                strEmptyText.Append("<tr>");
                strEmptyText.Append("<th>时间</th>");
                strEmptyText.Append("<th>专线</th>");
                strEmptyText.Append("<th>订单量</th><th>总人数</th>");
                strEmptyText.Append("<th>成人</th><th>儿童</th>");
                strEmptyText.Append("<th>销售总额</th><th>订单总额</th>");
                strEmptyText.Append("<th>功能</th>");
                strEmptyText.Append("<tr align='center'><td  align='center' colspan='20' height='100px'>暂无订单信息</td></tr>");
                strEmptyText.Append("</tr>");
                strEmptyText.Append("</table>");
                this.repList.EmptyText = strEmptyText.ToString();
            }
            SearchModel    = null;
            listScenicArea = null;
        }
Example #3
0
        /// <summary>
        /// 初始化页面
        /// </summary>
        private void InitPage()
        {
            //分页参数
            int intRecordCount            = 0,                                                  //记录条数
                CurrencyPage              = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1), //页码
                intPageSize               = 15;                                                 //每页条数
            MOrderStaticSearch queryModel = new MOrderStaticSearch();

            #region 查询参数
            //专线Id
            queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"));

            //是否详细列表
            queryModel.IsDetail = false;
            //出团时间开始
            queryModel.LeaveDateS = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeS"));

            //出团时间结束
            queryModel.LeaveDateE = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeE"));

            //公司编号
            queryModel.CompanyId = Utils.GetQueryStringValue("companyId");
            //公司类型
            queryModel.CompanyTyp = CompanyType.专线;
            #endregion
            IList <MOrderStatic> list = EyouSoft.BLL.NewTourStructure.BTourOrder.CreateInstance().GetOrderStaticLst(
                intPageSize,
                CurrencyPage,
                ref intRecordCount,
                queryModel);

            if (list != null && list.Count > 0)
            {
                rpt_parentList.DataSource = list;
                rpt_parentList.DataBind();
                ExportPageInfo1.Visible             = true;
                this.ExportPageInfo1.intPageSize    = intPageSize;
                this.ExportPageInfo1.intRecordCount = intRecordCount;
                this.ExportPageInfo1.CurrencyPage   = CurrencyPage;
                this.ExportPageInfo1.PageLinkURL    = "/RouteAgency/OrderStatistics.aspx?";

                this.ExportPageInfo1.UrlParams.Add("area", queryModel.AreaId.ToString());
                this.ExportPageInfo1.UrlParams.Add("status", Utils.GetQueryStringValue("status"));
                this.ExportPageInfo1.UrlParams.Add("goTimeS", queryModel.LeaveDateS.ToString());
                this.ExportPageInfo1.UrlParams.Add("goTimeE", queryModel.LeaveDateE.ToString());
                //this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.OrderKey);
            }
            else
            {
                //不存在列表数据
                pnlNodata.Visible = true;
            }
        }
Example #4
0
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <returns></returns>
        protected string GetList(int lineId)
        {
            //分页参数
            int intRecordCount            = 0,                                                  //记录条数
                CurrencyPage              = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1), //页码
                intPageSize               = 15;                                                 //每页条数
            MOrderStaticSearch queryModel = new MOrderStaticSearch();

            #region 查询参数
            //专线Id
            queryModel.AreaId = lineId;

            //是否详细列表
            queryModel.IsDetail = true;
            //出团时间开始
            queryModel.LeaveDateS = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeS"));

            //出团时间结束
            queryModel.LeaveDateE = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeE"));

            //公司编号
            queryModel.CompanyId = Utils.GetQueryStringValue("companyId");
            //公司类型
            queryModel.CompanyTyp = CompanyType.专线;
            #endregion
            IList <MOrderStatic> list = EyouSoft.BLL.NewTourStructure.BTourOrder.CreateInstance().GetOrderStaticLst(
                intPageSize,
                CurrencyPage,
                ref intRecordCount,
                queryModel);

            if (list != null && list.Count > 0)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("<tr id=\"div_Detailed_" + lineId + "\" style=\"display: none\" bgcolor=\"#FFFFFF\">");
                sb.Append("<td colspan=\"9\" align=\"left\">");
                sb.Append("<table width=\"96%\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#cccccc\"style=\"margin-top: 5px; margin-bottom: 5px;\">");
                sb.Append("<tr bgcolor=\"#f1f1f1\"><th>线路名</th><th>订单量</th><th>总人数</th><th>成人</th><th>儿童</th><th>销售总额</th><th>结算总额</th></tr>");
                foreach (var item in list)
                {
                    sb.Append("<tr>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + item.RouteName + "</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + item.TotalOrder + "</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + item.TotalPeople + "</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + item.TotalAdult + "</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + item.TotalChild + "</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + Utils.FilterEndOfTheZeroDecimal(item.TotalSale) + "元</td>");
                    sb.Append("<td bgcolor=\"#FFFFFF\">" + Utils.FilterEndOfTheZeroDecimal(item.TotalSettle) + "元</td>");
                    sb.Append("</tr>");
                }
                sb.Append("</table></div></td></tr></div></td></tr>");
                return(sb.ToString());
            }
            else
            {
                string str = "<tr bgcolor=\"#FFFFFF\"><td colspan=\"9\" align=\"left\"><div id=\"div_Detailed_1\" style=\"display: none\">";
                str += "暂无数据!";
                str += "</div></td></tr>";
                return(str);
            }
        }
Example #5
0
 /// <summary>
 /// 根据搜索实体获取订单统计列表
 /// </summary>
 /// <param name="pageSize">每页显示记录数</param>
 /// <param name="pageCurrent">当前页</param>
 /// <param name="recordCount">总记录数</param>
 /// <param name="search">搜索实体</param>
 /// <returns>订单统计实体列表</returns>
 public IList <MOrderStatic> GetOrderStaticLst(int pageSize, int pageCurrent, ref int recordCount, MOrderStaticSearch search)
 {
     return(search == null ? null : this._dal.GetOrderStaticLst(pageSize, pageCurrent, ref recordCount, search));
 }
Example #6
0
        /// <summary>
        /// 绑定散客订单列表
        /// </summary>
        protected void BindCompanyList()
        {
            int                recordCount  = 0;
            int                Line1        = EyouSoft.Common.Function.StringValidate.GetIntValue(Request.QueryString["Line1"]); //专线国内国外周边
            int                Line2        = EyouSoft.Common.Function.StringValidate.GetIntValue(Request.QueryString["Line2"]); //专线区域
            string             BusinessLine = Utils.GetQueryStringValue("BusinessLine");                                         //专线商
            string             StartDate    = Utils.InputText(Request.QueryString["StartDate"]);                                 //出发时间
            string             EndDate      = Utils.InputText(Request.QueryString["EndDate"]);                                   //返回时间
            MOrderStaticSearch SearchModel  = new MOrderStaticSearch();

            if (Line1 > -1)
            {
                SearchModel.AreaType = (AreaType)Line1;
            }
            if (Line2 > 0)
            {
                SearchModel.AreaId = Line2;
            }
            if (BusinessLine != "0")
            {
                SearchModel.CompanyId = BusinessLine;
            }
            if (StartDate != "")
            {
                SearchModel.LeaveDateS = Convert.ToDateTime(StartDate);
            }
            if (EndDate != "")
            {
                SearchModel.LeaveDateE = Convert.ToDateTime(EndDate);
            }
            IList <MOrderStatic> listScenicArea = EyouSoft.BLL.NewTourStructure.BTourOrder.CreateInstance().GetOrderStaticLst(PageSize, PageIndex, ref recordCount, SearchModel);


            if (listScenicArea.Count > 0)
            {
                this.ExporPageInfoSelect1.intPageSize    = PageSize;
                this.ExporPageInfoSelect1.intRecordCount = recordCount;
                this.ExporPageInfoSelect1.CurrencyPage   = PageIndex;
                this.ExporPageInfoSelect1.HrefType       = Adpost.Common.ExporPage.HrefTypeEnum.JsHref;
                this.ExporPageInfoSelect1.AttributesEventAdd("onclick", "FitStatistics.LoadData(this);", 1);
                this.ExporPageInfoSelect1.AttributesEventAdd("onchange", "FitStatistics.LoadData(this);", 0);
                this.ExporPageInfoSelect1.UrlParams = Request.Params;
                this.repList.DataSource             = listScenicArea;
                this.repList.DataBind();
            }
            else
            {
                StringBuilder strEmptyText = new StringBuilder();
                strEmptyText.Append("<table width=\"98%\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#C7DEEB\" class=\"table_basic\">");
                strEmptyText.Append("<tr>");
                strEmptyText.Append("<th>时间</th>");
                strEmptyText.Append("<th>专线</th>");
                strEmptyText.Append("<th>订单量</th><th>总人数</th>");
                strEmptyText.Append("<th>成人</th><th>儿童</th>");
                strEmptyText.Append("<th>销售总额</th><th>订单总额</th>");
                strEmptyText.Append("<th>功能</th>");
                strEmptyText.Append("<tr align='center'><td  align='center' colspan='20' height='100px'>暂无订单信息</td></tr>");
                strEmptyText.Append("</tr>");
                strEmptyText.Append("</table>");
                this.repList.EmptyText = strEmptyText.ToString();
            }
            SearchModel    = null;
            listScenicArea = null;
        }