void Bind() { EyouSoft.BLL.RouteStructure.Route bll = new EyouSoft.BLL.RouteStructure.Route(SiteUserInfo); int count = 0; EyouSoft.Model.RouteStructure.RouteSearchInfo search = new EyouSoft.Model.RouteStructure.RouteSearchInfo(); if (Utils.GetQueryStringValue("xlid") != "") { search.AreaId = Utils.GetInt(Utils.GetQueryStringValue("xlid")); } search.RSDate = Utils.GetDateTimeNullable(Utils.GetFormValue(txt_date.UniqueID)); string xlname = Utils.GetFormValue(txt_xianluName.UniqueID); if (xlname != "") { search.RouteName = xlname; } IList <EyouSoft.Model.RouteStructure.RouteBaseInfo> list = new List <EyouSoft.Model.RouteStructure.RouteBaseInfo>(); if (Utils.GetQueryStringValue("publishtype") != "") { ///快速 if (Utils.GetInt(Utils.GetQueryStringValue("publishtype")) == 1) { list = bll.GetQuickRoutes(CurrentUserCompanyID, 20, EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1), ref count, search); } if (Utils.GetInt(Utils.GetQueryStringValue("publishtype")) == 2) { list = bll.GetNormalRoutes(CurrentUserCompanyID, 20, EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1), ref count, search); } if (Utils.GetInt(Utils.GetQueryStringValue("publishtype")) == 3) { list = bll.GetRoutes(CurrentUserCompanyID, 20, EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1), ref count, search); } if (Utils.GetInt(Utils.GetQueryStringValue("publishtype")) == 4) { list = bll.GetRoutes(SiteUserInfo.CompanyID, 20, EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1), ref count, search); } } rptList.DataSource = list; rptList.DataBind(); ExporPageInfoSelect1.intPageSize = 20; ExporPageInfoSelect1.intRecordCount = count; ExporPageInfoSelect1.PageLinkURL = Request.Path + "?"; ExporPageInfoSelect1.UrlParams = Request.QueryString; ExporPageInfoSelect1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1); }
/// <summary> /// 绑定线路列表 /// </summary> protected void BindInitLineProducts(int?AreaID, string LineName, DateTime?StartTime, DateTime?EndTime, int?DateNumber, string Author) { EyouSoft.Model.RouteStructure.RouteSearchInfo ModelRouteSearch = new EyouSoft.Model.RouteStructure.RouteSearchInfo(); //线路区域编号 ModelRouteSearch.AreaId = AreaID; //线路名称 ModelRouteSearch.RouteName = LineName; //发布截止时间 ModelRouteSearch.REDate = EndTime; //线路天数 ModelRouteSearch.RouteDays = DateNumber; //发布起始时间 ModelRouteSearch.RSDate = StartTime; //发布人姓名 ModelRouteSearch.OperatorName = Author; //线路筛选 if (Request.QueryString["xlid"] != "" && Request.QueryString["xlid"] != null) { ModelRouteSearch.AreaId = Utils.GetInt(Utils.GetQueryStringValue("xlid")); } //线路库业务逻辑类 EyouSoft.BLL.RouteStructure.Route RouteList = new EyouSoft.BLL.RouteStructure.Route(SiteUserInfo); IList <EyouSoft.Model.RouteStructure.RouteBaseInfo> RouteLists = RouteList.GetRoutes(SiteUserInfo.CompanyID, PageSize, PageIndex, ref RecordCount, ModelRouteSearch); if (RouteLists != null && RouteLists.Count > 0) { this.LineProductList.DataSource = RouteLists; this.LineProductList.DataBind(); BinPage(); } else { this.LinePro_ExportPageInfo1.Visible = false; } RouteList = null; RouteLists = null; ModelRouteSearch = null; }
/// <summary> /// 获取线路信息集合 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="info">查询信息</param> /// <param name="us">用户信息集合</param> /// <param name="ReleaseType">线路发布类型</param> /// <returns></returns> public IList <EyouSoft.Model.RouteStructure.RouteBaseInfo> GetRoutes(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.RouteStructure.RouteSearchInfo info, string us, EyouSoft.Model.EnumType.TourStructure.ReleaseType?ReleaseType) { IList <EyouSoft.Model.RouteStructure.RouteBaseInfo> list = new List <EyouSoft.Model.RouteStructure.RouteBaseInfo>(); #region 分页存储过程参数设置 string tableName = "tbl_Route"; string fields = "Id,AreaId,RouteName,OperatorId,OperatorName,RouteDays,IssueTime,TourCount,VisitorCount,RouteIssueTypeId,(select AreaName from tbl_Area where id=tbl_Route.AreaId and IsDelete='0') as AreaName"; string primaryKey = "Id"; string orderStrBy = "IssueTime desc"; StringBuilder strWhere = new StringBuilder(""); strWhere.AppendFormat(" IsDelete='0' AND CompanyId={0} ", companyId); if (info != null) { if (info.AreaId.HasValue && info.AreaId.Value > 0) { strWhere.AppendFormat(" AND AreaId={0} ", info.AreaId.Value); } if (info.ROperatorId.HasValue && info.ROperatorId.Value > 0) { strWhere.AppendFormat(" AND OperatorId={0} ", info.ROperatorId.Value); } if (info.RouteDays.HasValue && info.RouteDays.Value > 0) { strWhere.AppendFormat(" AND RouteDays={0} ", info.RouteDays.Value); } if (!string.IsNullOrEmpty(info.RouteName)) { strWhere.AppendFormat(" AND RouteName like '%{0}%' ", info.RouteName); } if (info.RSDate.HasValue) { strWhere.AppendFormat(" AND datediff(dd,IssueTime,'{0}')<=0 ", info.RSDate.Value.ToString()); } if (info.REDate.HasValue) { strWhere.AppendFormat(" AND datediff(dd,IssueTime,'{0}')>=0 ", info.REDate.Value.ToString()); } if (!string.IsNullOrEmpty(info.OperatorName)) { strWhere.AppendFormat(" AND OperatorName like '%{0}%' ", info.OperatorName); } } if (!string.IsNullOrEmpty(us)) { strWhere.AppendFormat(" AND OperatorId in({0}) ", us.TrimEnd(',')); } if (ReleaseType.HasValue) { strWhere.AppendFormat(" AND RouteIssueTypeId={0} ", (int)ReleaseType.Value); } #endregion using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderStrBy)) { while (dr.Read()) { EyouSoft.Model.RouteStructure.RouteBaseInfo model = new EyouSoft.Model.RouteStructure.RouteBaseInfo(); if (!dr.IsDBNull(dr.GetOrdinal("AreaId"))) { model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); } if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.CreateTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { model.RouteId = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("RouteName"))) { model.RouteName = dr[dr.GetOrdinal("RouteName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorId"))) { model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId")); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorName"))) { model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("RouteDays"))) { model.RouteDays = dr.GetInt32(dr.GetOrdinal("RouteDays")); } if (!dr.IsDBNull(dr.GetOrdinal("TourCount"))) { model.TourCount = dr.GetInt32(dr.GetOrdinal("TourCount")); } if (!dr.IsDBNull(dr.GetOrdinal("VisitorCount"))) { model.VisitorCount = dr.GetInt32(dr.GetOrdinal("VisitorCount")); } if (!dr.IsDBNull(dr.GetOrdinal("RouteIssueTypeId"))) { model.ReleaseType = (EyouSoft.Model.EnumType.TourStructure.ReleaseType) int.Parse(dr[dr.GetOrdinal("RouteIssueTypeId")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("AreaName"))) { model.AreaName = dr[dr.GetOrdinal("AreaName")].ToString(); } list.Add(model); model = null; } } return(list); }
/// <summary> /// 获取标准版线路信息集合 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="info">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.RouteStructure.RouteBaseInfo> GetNormalRoutes(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.RouteStructure.RouteSearchInfo info) { return(dal.GetRoutes(companyId, pageSize, pageIndex, ref recordCount, info, base.HaveUserIds, EyouSoft.Model.EnumType.TourStructure.ReleaseType.Normal)); }