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