/// <summary>
/// 列表初始化
/// </summary>
protected void InitListData()
{
this.pageIndex = Utils.GetInt(Request.QueryString["Page"], 1);
string kw = Server.UrlDecode(Utils.GetQueryStringValue("kw"));//关键字（标题、发布单位、资讯相关）
MQueryPeerNews Model = new MQueryPeerNews();
Model.KeyWord = kw.Trim();
Model.CompanyId = this.SiteUserInfo.CompanyID;
IPeerNews BLL = BPeerNews.CreateInstance();
IList <MPeerNews> lst = BLL.GetGetPeerNewsList(this.pageSize, this.pageIndex, ref this.recordCount, Model);
if (null != lst && lst.Count > 0)
{
this.RepList.DataSource = lst;
this.RepList.DataBind();
this.BindPage(kw);
}
else
{
this.RepList.Controls.Add(new Literal()
{
Text = "<tr><td colspan='4' align='center'>暂无信息！</td></tr>"
});
this.ExportPageInfo1.Visible = false;
}
}
protected void InitData()
{
this.pageIndex = Utils.GetInt(Request.QueryString["Page"], 1);
//是否显示”添加“按钮 //说明：添加按钮只对“专线商（地接）、景区、酒店“显示
bool myShopFlag = !this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.组团);//this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.专线)||this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.地接) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.机票供应商) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.酒店) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.景区) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.车队) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.旅游用品店);
this.btnAddInfo.Visible = myShopFlag;
string kw = Server.UrlDecode(Utils.GetQueryStringValue("kw")); //关键字（标题、发布单位）
int type = Utils.GetInt(Utils.GetQueryStringValue("type"), -1); //分类
MQueryPeerNews Model = new MQueryPeerNews();
Model.KeyWord = kw.Trim();
if (type != -1)
{
Model.TypeId = (PeerNewType)type;
}
IPeerNews BLL = BPeerNews.CreateInstance();
IList <MPeerNews> lst = BLL.GetGetPeerNewsList(this.pageSize, this.pageIndex, ref this.recordCount, Model);
if (null != lst && lst.Count > 0)
{
this.RepList.DataSource = lst;
this.RepList.DataBind();
this.BindPage(kw, type.ToString());
}
else
{
this.RepList.Controls.Add(new Literal()
{
Text = "<tr><td colspan='4' align='center'>暂无信息！</td></tr>"
});
this.ExportPageInfo1.Visible = false;
}
}
/// <summary>
/// 获取同业资讯列表
/// </summary>
/// <param name="topNum">top数量</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回同业资讯信息集合</returns>
public IList <MPeerNews> GetGetPeerNewsList(int topNum, MQueryPeerNews queryModel)
{
var strSql = new StringBuilder();
strSql.Append(" select ");
if (topNum > 0)
{
strSql.AppendFormat(" top {0} ", topNum);
}
strSql.Append(
@" [NewId],[Title],[TypeId],[Content],[CompanyId],[CompanyName],[OperatorId],[OperatorName]
,[B2BDisplay],[SortId],[ClickNum],[IP],[IssueTime],[LastUpdateTime],[MQ],[AreaId],[AreaName],[AreaType],[ScenicId] ");
strSql.Append(" from view_PeerNewsUserInfo ");
strSql.Append(" where 1 = 1 ");
if (queryModel != null)
{
if (!string.IsNullOrEmpty(queryModel.CompanyId))
{
strSql.AppendFormat(" and [CompanyId] = '{0}' ", queryModel.CompanyId);
}
if (!string.IsNullOrEmpty(queryModel.Title))
{
strSql.AppendFormat(" and [Title] like '%{0}%' ", queryModel.Title);
}
if (!string.IsNullOrEmpty(queryModel.KeyWord))
{
strSql.AppendFormat(" and isnull([Title],'') + isnull([CompanyName],'') like '%{0}%' ", queryModel.KeyWord);
}
if (queryModel.TypeId.HasValue)
{
strSql.AppendFormat(" and [TypeId] = {0} ", (int)queryModel.TypeId.Value);
}
if (!queryModel.IsShowHideNew)
{
strSql.AppendFormat(" and [B2BDisplay] <> {0} ", (int)NewsB2BDisplay.隐藏);
}
strSql.Append(" order by ");
switch (queryModel.OrderIndex)
{
case 0:
strSql.Append(" LastUpdateTime desc ");
break;
case 1:
strSql.Append(" LastUpdateTime asc ");
break;
case 2:
strSql.Append(" IssueTime desc ");
break;
case 3:
strSql.Append(" IssueTime asc ");
break;
case 4:
strSql.Append(" B2BDisplay desc,SortId asc,IssueTime desc ");
break;
case 5:
strSql.Append(" B2BDisplay asc,SortId desc,IssueTime asc ");
break;
default:
strSql.Append(" LastUpdateTime desc ");
break;
}
}
DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());
IList <MPeerNews> list;
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
list = new List <MPeerNews>();
while (dr.Read())
{
var model = new MPeerNews();
if (!dr.IsDBNull(dr.GetOrdinal("NewId")))
{
model.NewId = dr.GetString(dr.GetOrdinal("NewId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Title")))
{
model.Title = dr.GetString(dr.GetOrdinal("Title"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeId")))
{
model.TypeId = (PeerNewType)dr.GetByte(dr.GetOrdinal("TypeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Content")))
{
model.Content = dr.GetString(dr.GetOrdinal("Content"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyName")))
{
model.CompanyName = dr.GetString(dr.GetOrdinal("CompanyName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorName")))
{
model.OperatorName = dr.GetString(dr.GetOrdinal("OperatorName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("B2BDisplay")))
{
model.B2BDisplay = (NewsB2BDisplay)dr.GetByte(dr.GetOrdinal("B2BDisplay"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SortId")))
{
model.SortId = dr.GetInt32(dr.GetOrdinal("SortId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ClickNum")))
{
model.ClickNum = dr.GetInt32(dr.GetOrdinal("ClickNum"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IP")))
{
model.Ip = dr.GetString(dr.GetOrdinal("IP"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LastUpdateTime")))
{
model.LastUpdateTime = dr.GetDateTime(dr.GetOrdinal("LastUpdateTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MQ")))
{
model.OperatorMQ = dr.GetString(dr.GetOrdinal("MQ"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaId")))
{
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaName")))
{
model.AreaName = dr.GetString(dr.GetOrdinal("AreaName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaType")))
{
model.AreaType = (Model.SystemStructure.AreaType)dr.GetByte(dr.GetOrdinal("AreaType"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ScenicId")))
{
model.ScenicId = dr.GetString(dr.GetOrdinal("ScenicId"));
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取同业资讯列表
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回同业资讯信息集合</returns>
public IList <MPeerNews> GetGetPeerNewsList(int pageSize, int pageIndex, ref int recordCount
, MQueryPeerNews queryModel)
{
string fileds = @" [NewId]
,[Title],[TypeId],[Content],[CompanyId],[CompanyName],[OperatorId],[OperatorName],[B2BDisplay],[SortId]
,[ClickNum],[IP],[IssueTime],[LastUpdateTime],[MQ],[AreaId],[AreaName],[AreaType],[ScenicId] ";
string tableName = "view_PeerNewsUserInfo";
string orderby = " LastUpdateTime desc ";
var strWhere = new StringBuilder(" 1 = 1 ");
if (queryModel != null)
{
if (!string.IsNullOrEmpty(queryModel.CompanyId))
{
strWhere.AppendFormat(" and [CompanyId] = '{0}' ", queryModel.CompanyId);
}
if (!string.IsNullOrEmpty(queryModel.Title))
{
strWhere.AppendFormat(" and [Title] like '%{0}%' ", queryModel.Title);
}
if (!string.IsNullOrEmpty(queryModel.KeyWord))
{
strWhere.AppendFormat(" and isnull([Title],'') + isnull([CompanyName],'') like '%{0}%' ", queryModel.KeyWord);
}
if (queryModel.TypeId.HasValue)
{
strWhere.AppendFormat(" and [TypeId] = {0} ", (int)queryModel.TypeId.Value);
}
if (!queryModel.IsShowHideNew)
{
strWhere.AppendFormat(" and [B2BDisplay] <> {0} ", (int)NewsB2BDisplay.隐藏);
}
switch (queryModel.OrderIndex)
{
case 0:
orderby = " LastUpdateTime desc ";
break;
case 1:
orderby = " LastUpdateTime asc ";
break;
case 2:
orderby = " IssueTime desc ";
break;
case 3:
orderby = " IssueTime asc ";
break;
case 4:
orderby = " B2BDisplay desc,SortId asc,IssueTime desc ";
break;
case 5:
orderby = " B2BDisplay asc,SortId desc,IssueTime asc ";
break;
default:
orderby = " LastUpdateTime desc ";
break;
}
}
IList <MPeerNews> list;
using (IDataReader dr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount
, tableName, "NewId", fileds, strWhere.ToString(), orderby))
{
list = new List <MPeerNews>();
while (dr.Read())
{
var model = new MPeerNews();
if (!dr.IsDBNull(dr.GetOrdinal("NewId")))
{
model.NewId = dr.GetString(dr.GetOrdinal("NewId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Title")))
{
model.Title = dr.GetString(dr.GetOrdinal("Title"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeId")))
{
model.TypeId = (PeerNewType)dr.GetByte(dr.GetOrdinal("TypeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Content")))
{
model.Content = dr.GetString(dr.GetOrdinal("Content"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyName")))
{
model.CompanyName = dr.GetString(dr.GetOrdinal("CompanyName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorName")))
{
model.OperatorName = dr.GetString(dr.GetOrdinal("OperatorName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("B2BDisplay")))
{
model.B2BDisplay = (NewsB2BDisplay)dr.GetByte(dr.GetOrdinal("B2BDisplay"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SortId")))
{
model.SortId = dr.GetInt32(dr.GetOrdinal("SortId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ClickNum")))
{
model.ClickNum = dr.GetInt32(dr.GetOrdinal("ClickNum"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IP")))
{
model.Ip = dr.GetString(dr.GetOrdinal("IP"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LastUpdateTime")))
{
model.LastUpdateTime = dr.GetDateTime(dr.GetOrdinal("LastUpdateTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MQ")))
{
model.OperatorMQ = dr.GetString(dr.GetOrdinal("MQ"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaId")))
{
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaName")))
{
model.AreaName = dr.GetString(dr.GetOrdinal("AreaName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaType")))
{
model.AreaType = (Model.SystemStructure.AreaType)dr.GetByte(dr.GetOrdinal("AreaType"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ScenicId")))
{
model.ScenicId = dr.GetString(dr.GetOrdinal("ScenicId"));
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取同业资讯列表
/// </summary>
/// <param name="topNum">top数量</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回同业资讯信息集合</returns>
/// <remarks>
/// 1.用户后台->我的网店->我的同业资讯 这个列表查询实体中的公司编号(CompanyId)必须传值
/// 2.网店（高级、普通）同业资讯列表 查询实体中的公司编号(CompanyId)必须传值
/// 3.用户后台->营销工具->同业资讯 这个列表查询实体中的公司编号(CompanyId)不要传值
/// </remarks>
public IList <MPeerNews> GetGetPeerNewsList(int topNum, MQueryPeerNews queryModel)
{
return(_dal.GetGetPeerNewsList(topNum, queryModel));
}
/// <summary>
/// 获取同业资讯列表
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回同业资讯信息集合</returns>
/// <remarks>
/// 1.用户后台->我的网店->我的同业资讯 这个列表查询实体中的公司编号(CompanyId)必须传值
/// 2.网店（高级、普通）同业资讯列表 查询实体中的公司编号(CompanyId)必须传值
/// 3.用户后台->营销工具->同业资讯 这个列表查询实体中的公司编号(CompanyId)不要传值
/// </remarks>
public IList <MPeerNews> GetGetPeerNewsList(int pageSize, int pageIndex, ref int recordCount
, MQueryPeerNews queryModel)
{
return(_dal.GetGetPeerNewsList(pageSize, pageIndex, ref recordCount, queryModel));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (_setareatype == null)
{
ICompanyUser companyUserBLL = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance();
EyouSoft.Model.CompanyStructure.CompanyUser companyUserModel = companyUserBLL.GetModel(UserId);
if (companyUserModel != null && companyUserModel.Area != null && companyUserModel.Area.Count > 0)
{
rpt_line1.DataSource = companyUserModel.Area;
}
}
else
{
switch (_setareatype)
{
case AreaType.国际线:
rpt_line1.DataSource = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetSysAreaList(EyouSoft.Model.SystemStructure.AreaType.国际线);
break;
case AreaType.国内长线:
rpt_line1.DataSource = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetLongAreaSiteControl(ProvinceID);
break;
case AreaType.地接线路:
case AreaType.国内短线:
{
rpt_line1.DataSource = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetShortAreaSiteControl(SiteUserInfo_CityId);
}
break;
}
}
rpt_line1.DataBind();
rpt_line2.DataSource = rpt_line1.DataSource;
rpt_line2.DataBind();
int recordCount = 0;
//绑定同业资讯
if (IsTongYe)
{
MQueryPeerNews queryModel = new MQueryPeerNews();
switch (_setareatype)
{
case AreaType.国际线:
queryModel.AreaType = AreaType.国际线;
break;
case AreaType.国内长线:
queryModel.AreaType = AreaType.国内长线;
break;
case AreaType.地接线路:
case AreaType.国内短线:
queryModel.AreaType = AreaType.国内短线;
break;
}
IList <MPeerNews> lst = BPeerNews.CreateInstance().GetGetPeerNewsList(10, queryModel);
if (null != lst && lst.Count > 0)
{
this.RepList.DataSource = lst;
this.RepList.DataBind();
}
else
{
IsTongYe = false;
}
}
}
}
