/// <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; } }
/// <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; }
/// <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; } }
/// <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); } }
/// <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)); }
/// <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; }