/// <summary>
/// 团队订单-运营后台
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, MTourListSearch search)
{
IList <MTourList> list = new List <MTourList>();
string tableName = "tbl_NewTourList";
string fields = "*,(select StartCityName,DayNum,LateNum from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId for xml raw,root) as RouteInfo,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Business) as BusinessName,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as TravelName";
string primaryKey = "TourId";
string orderByString = "IssueTime DESC ";
StringBuilder strWhere = new StringBuilder("1=1");
if (search != null)
{
if (search.SLeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)>=0", search.SLeaveDate);
}
if (search.ELeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)<=0", search.ELeaveDate);
}
if (search.TourOrderStatus != null)
{
strWhere.AppendFormat(" and OrderStatus={0}", (int)search.TourOrderStatus);
}
if (!string.IsNullOrEmpty(search.TourKey))
{
strWhere.AppendFormat(" and (isnull(RouteName,'') + (select isnull(CompanyName,'') from tbl_CompanyInfo where Id=tbl_NewTourList.Business) + (select isnull(CompanyName,'') from tbl_CompanyInfo where Id=tbl_NewTourList.Travel)) like '%{0}%'", search.TourKey.Trim());
}
if (search.AreaType != null)
{
strWhere.AppendFormat(" and exists(select 1 from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId and RouteType={0})", (int)search.AreaType);
}
}
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageCurrent, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (rdr.Read())
{
MTourList model = new MTourList();
model.TourId = rdr.IsDBNull(rdr.GetOrdinal("TourId")) ? "" : rdr.GetString(rdr.GetOrdinal("TourId"));
model.OrderNo = rdr.IsDBNull(rdr.GetOrdinal("OrderNo")) ? "" : rdr.GetString(rdr.GetOrdinal("OrderNo"));
model.TourNo = rdr.IsDBNull(rdr.GetOrdinal("TourNo")) ? "" : rdr.GetString(rdr.GetOrdinal("TourNo"));
model.RouteId = rdr.IsDBNull(rdr.GetOrdinal("RouteId")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteId"));
model.RouteName = rdr.IsDBNull(rdr.GetOrdinal("RouteName")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteName"));
model.StartDate = rdr.IsDBNull(rdr.GetOrdinal("StartDate")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("StartDate"));
model.Business = rdr.IsDBNull(rdr.GetOrdinal("Business")) ? "" : rdr.GetString(rdr.GetOrdinal("Business"));
model.SLeaveDate = rdr.IsDBNull(rdr.GetOrdinal("LeaveDate")) ? "" : rdr.GetString(rdr.GetOrdinal("LeaveDate"));
model.ComeBackDate = rdr.IsDBNull(rdr.GetOrdinal("ComeBackDate")) ? "" : rdr.GetString(rdr.GetOrdinal("ComeBackDate"));
model.TravelContact = rdr.IsDBNull(rdr.GetOrdinal("TravelContact")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelContact"));
model.TravelTel = rdr.IsDBNull(rdr.GetOrdinal("TravelTel")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelTel"));
model.VisitorContact = rdr.IsDBNull(rdr.GetOrdinal("VisitorContact")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorContact"));
model.VisitorTel = rdr.IsDBNull(rdr.GetOrdinal("VisitorTel")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorTel"));
model.ScheduleNum = rdr.IsDBNull(rdr.GetOrdinal("ScheduleNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ScheduleNum"));
model.AdultNum = rdr.IsDBNull(rdr.GetOrdinal("AdultNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("AdultNum"));
model.ChildrenNum = rdr.IsDBNull(rdr.GetOrdinal("ChildrenNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ChildrenNum"));
model.SingleRoomNum = rdr.IsDBNull(rdr.GetOrdinal("SingleRoomNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SingleRoomNum"));
model.VisitorNotes = rdr.IsDBNull(rdr.GetOrdinal("VisitorNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorNotes"));
model.TravelNotes = rdr.IsDBNull(rdr.GetOrdinal("TravelNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelNotes"));
model.BusinessNotes = rdr.IsDBNull(rdr.GetOrdinal("BusinessNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessNotes"));
model.IssueTime = rdr.IsDBNull(rdr.GetOrdinal("IssueTime")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
model.OrderStatus = (TourOrderStatus)rdr.GetByte(rdr.GetOrdinal("OrderStatus"));
model.TourStatus = (TourStatus)rdr.GetByte(rdr.GetOrdinal("TourStatus"));
model.OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? "" : rdr.GetString(rdr.GetOrdinal("OperatorId"));
model.TourPrice = rdr.IsDBNull(rdr.GetOrdinal("TourPrice")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("TourPrice"));
model.Travel = rdr.IsDBNull(rdr.GetOrdinal("Travel")) ? "" : rdr.GetString(rdr.GetOrdinal("Travel"));
model.DayNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "DayNum"));
model.LateNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "LateNum"));
model.StartCityName = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "StartCityName");
model.BusinessName = rdr.IsDBNull(rdr.GetOrdinal("BusinessName")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessName"));
model.TravelName = rdr.IsDBNull(rdr.GetOrdinal("TravelName")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelName"));
list.Add(model);
}
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
//分页参数
int pageSize = 15,
pageCurrent = Utils.GetInt(Utils.GetQueryStringValue("page"), 1),
recordCount = 0;
MTourListSearch queryModel = new MTourListSearch();
#region 查询实体
//关键字
queryModel.TourKey = Utils.GetQueryStringValue("keyWord"); //status
//订单状态
queryModel.TourOrderStatus = null;
if (Utils.GetQueryStringValue("status").Length > 0)
{
queryModel.TourOrderStatus = (TourOrderStatus)Utils.GetInt(Utils.GetQueryStringValue("status"));
}
//出团时间
queryModel.SLeaveDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeS"));
//出团时间
queryModel.ELeaveDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeE"));
#endregion
IList <MTourList> list = new List <MTourList>();
if (Utils.GetQueryStringValue("routeSource").Length > 0)
{
routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1);
}
switch (routeSource)
{
case RouteSource.地接社添加:
list = BTourList.CreateInstance().GetDJList(pageSize, pageCurrent, ref recordCount, Utils.GetQueryStringValue("companyID"), queryModel);
break;
case RouteSource.专线商添加:
list = BTourList.CreateInstance().GetZXList(pageSize, pageCurrent, ref recordCount, Utils.GetQueryStringValue("companyID"), queryModel);
break;
default:
list = BTourList.CreateInstance().GetZTList(pageSize, pageCurrent, ref recordCount, Utils.GetQueryStringValue("companyID"), queryModel);
break;
}
if (list != null && list.Count > 0)
{
rpt_list.DataSource = list;
rpt_list.DataBind();
ExportPageInfo1.Visible = true;
this.ExportPageInfo1.intPageSize = pageSize;
this.ExportPageInfo1.intRecordCount = recordCount;
this.ExportPageInfo1.CurrencyPage = pageCurrent;
this.ExportPageInfo1.PageLinkURL = "/TeamService/TeamOrders.aspx?";
//this.ExportPageInfo1.UrlParams = Request.QueryString;
this.ExportPageInfo1.UrlParams.Add("status", Utils.GetQueryStringValue("status"));
this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType"));
this.ExportPageInfo1.UrlParams.Add("goTimeS", queryModel.SLeaveDate.ToString());
this.ExportPageInfo1.UrlParams.Add("goTimeE", queryModel.ELeaveDate.ToString());
this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.TourKey);
this.ExportPageInfo1.UrlParams.Add("routeSource", Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1).ToString());
}
else
{
//不存在列表数据
pnlNodata.Visible = true;
}
}
/// <summary>
/// 绑定团队订单列表
/// </summary>
protected void BindLineList()
{
int recordCount = 0;
string SearchKeyword = Utils.InputText(Request.QueryString["SearchKeyword"]); //关键字
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"]); //出发地
int OrderStatus = EyouSoft.Common.Function.StringValidate.GetIntValue(Request.QueryString["OrderStatus"]); //订单状态
MTourListSearch SearchModel = new MTourListSearch();
#region 订单状态
switch (OrderStatus)
{
case 0:
SearchModel.TourOrderStatus = TourOrderStatus.未确认;
break;
case 1:
SearchModel.TourOrderStatus = TourOrderStatus.已确认;
break;
case 2:
SearchModel.TourOrderStatus = TourOrderStatus.结单;
break;
case 3:
SearchModel.TourOrderStatus = TourOrderStatus.取消;
break;
}
#endregion
if (SearchKeyword != "")
{
SearchModel.TourKey = SearchKeyword;
}
if (Line1 > -1)
{
SearchModel.AreaType = (AreaType)Line1;
}
//if (Line2 > 0)
// SearchModel.TourOrderStatus = Line2;
//if (StartDate != "")
SearchModel.SLeaveDate = Utils.GetDateTimeNullable(StartDate);
//if (EndDate != "")
SearchModel.ELeaveDate = Utils.GetDateTimeNullable(EndDate);
IList <MTourList> listScenicArea = EyouSoft.BLL.NewTourStructure.BTourList.CreateInstance().GetList(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", "TeamorderManage.LoadData(this);", 1);
this.ExporPageInfoSelect1.AttributesEventAdd("onchange", "TeamorderManage.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 class=\"list_basicbg\">");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">出发城市</th>");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">线路名称</th>");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">出发时间</th><th align=\"middle\" nowrap=\"nowrap\">专线商</th>");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">预订单位</th><th align=\"middle\" nowrap=\"nowrap\">预定时间</th>");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">人数</th><th align=\"middle\" nowrap=\"nowrap\">状态</th>");
strEmptyText.Append("<th align=\"middle\" nowrap=\"nowrap\">操作</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()
{
BindPowderOrderStatus();
//分页参数
int pageSize = 15,
pageCurrent = Utils.GetInt(Utils.GetQueryStringValue("page"), 1),
recordCount = 0;
bool isSelected = false;
MTourListSearch queryModel = new MTourListSearch();
#region 查询实体
//关键字
queryModel.TourKey = Utils.GetQueryStringValue("keyWord"); //status
//订单状态
queryModel.TourOrderStatus = null;
//订单状态
if (Utils.GetQueryStringValue("status").Length > 0 && Utils.GetQueryStringValue("status") != "-1")
{
string[] status = Utils.GetQueryStringValue("status").Split(',');
var tourOrderStatus = new TourOrderStatus?[status.Length];
for (int i = 0; i < status.Length; i++)
{
if (Utils.GetInt(status[i]) > 0)
{
tourOrderStatus[i] = (TourOrderStatus)Utils.GetInt(status[i]);
}
if (!isSelected && sel_status.Items.FindByValue(status[i]) != null)
{
sel_status.Items.FindByValue(status[i]).Selected = true;
isSelected = true;
}
}
queryModel.OrderStatus = tourOrderStatus;
}
//出团时间
queryModel.SLeaveDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeS"));
//出团时间
queryModel.ELeaveDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("goTimeE"));
txt_keyWord.Value = queryModel.TourKey;
txt_goTimeS.Value = queryModel.SLeaveDate.HasValue ? queryModel.SLeaveDate.Value.ToShortDateString() : string.Empty;
txt_goTimeE.Value = queryModel.ELeaveDate.HasValue ? queryModel.ELeaveDate.Value.ToShortDateString() : string.Empty;
#endregion
IList <MTourList> list = new List <MTourList>();
switch (routeSource)
{
case RouteSource.地接社添加:
list = BTourList.CreateInstance().GetDJList(pageSize, pageCurrent, ref recordCount, SiteUserInfo.CompanyID, queryModel);
break;
case RouteSource.专线商添加:
list = BTourList.CreateInstance().GetZXList(pageSize, pageCurrent, ref recordCount, SiteUserInfo.CompanyID, queryModel);
break;
default:
list = BTourList.CreateInstance().GetZTList(pageSize, pageCurrent, ref recordCount, SiteUserInfo.CompanyID, queryModel);
break;
}
if (list != null && list.Count > 0)
{
rpt_list.DataSource = list;
rpt_list.DataBind();
ExportPageInfo1.Visible = true;
this.ExportPageInfo1.intPageSize = pageSize;
this.ExportPageInfo1.intRecordCount = recordCount;
this.ExportPageInfo1.CurrencyPage = pageCurrent;
this.ExportPageInfo1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
//this.ExportPageInfo1.UrlParams = Request.QueryString;
this.ExportPageInfo1.UrlParams.Add("status", Utils.GetQueryStringValue("status"));
this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType"));
this.ExportPageInfo1.UrlParams.Add("goTimeS", queryModel.SLeaveDate.ToString());
this.ExportPageInfo1.UrlParams.Add("goTimeE", queryModel.ELeaveDate.ToString());
this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.TourKey);
this.ExportPageInfo1.UrlParams.Add("routeSource", routeSource.ToString());
}
else
{
//不存在列表数据
pnlNodata.Visible = true;
}
}
