public List <AdInfoItem> GetAdInfo(int articelid)
{
//获取IP，根据IP做广告推荐或是相关资讯推荐
List <AdInfoItem> list = new List <AdInfoItem>();
//推荐新闻
ArticleInfoPara aip = new ArticleInfoPara();
aip.PageIndex = 0;
aip.PageSize = 2;
aip.OrderBy = " newid() ";
var alist = ArticleInfoBLL.Instance.GetModels(ref aip);
foreach (var item in alist)
{
AdInfoItem info = new AdInfoItem();
info.Url = "/Wap/Detail.aspx?id=" + item.Id.ToString();
info.Title = item.Title;
info.TitleImg = item.TitleImg;
info.TitleShort = item.TitleShort;
list.Add(info);
}
return(list);
}
public override List <ArticleInfoVO> GetModels(ref ArticleInfoPara mp)
{
string where = GetConditionByPara(mp);
int pStart = mp.PageIndex.Value * mp.PageSize.Value;
int pEnd = mp.PageSize.Value;
string cmd = QUERYPAGE
.Replace("@PAGESIZE", pEnd.ToString())
.Replace("@PTOP", pStart.ToString())
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
CodeCommand command = new CodeCommand();
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <ArticleInfoVO> list = new List <ArticleInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new ArticleInfoVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
public override string GetOrderByPara(ArticleInfoPara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
public override ArticleInfoVO GetSingle(ArticleInfoPara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(ArticleInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = QUERYCOUNT + where;
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Delete(ArticleInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = DELETE + where;
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
private void Bind(int pageIndex = 1)
{
ArticleInfoPara aip = new ArticleInfoPara();
if (!string.IsNullOrEmpty(hidChannelId.Value))
{
aip.ChannelId = int.Parse(hidChannelId.Value);
}
aip.PageIndex = pageIndex - 1;
aip.PageSize = 10;
aip.OrderBy = " LastDate desc ";
var list = ArticleInfoBLL.Instance.GetModels(ref aip);
rptTable.DataSource = list;
rptTable.DataBind();
}
public override List <ArticleInfoVO> GetModels(ArticleInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
string cmd = LOAD
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <ArticleInfoVO> list = new List <ArticleInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new ArticleInfoVO(table.Rows[i]));
}
return(list);
}
private void Bind(int pageIndex = 1)
{
ArticleInfoPara aip = new ArticleInfoPara();
aip.PageIndex = pageIndex - 1;
aip.PageSize = 10;
aip.OrderBy = " LastDate desc ";
aip.CreateUserId = Account.UserId;
if (!string.IsNullOrEmpty(ddlChannel.SelectedValue))
{
aip.ChannelId = int.Parse(ddlChannel.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlArticleType.SelectedValue))
{
aip.ArticleTypeId = int.Parse(ddlArticleType.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlTop.SelectedValue))
{
aip.IsTop = int.Parse(ddlTop.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlHot.SelectedValue))
{
aip.IsHot = int.Parse(ddlHot.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlState.SelectedValue))
{
aip.IsState = int.Parse(ddlState.SelectedValue);
}
var list = ArticleInfoBLL.Instance.GetModels(ref aip);
rptTables.DataSource = list;
rptTables.DataBind();
apPager.RecordCount = aip.Recount.Value;
}
public override string GetOtherConditionByPara(ArticleInfoPara mp)
{
return("");
}
public override string GetConditionByPara(ArticleInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.ChannelId.HasValue)
{
sb.AppendFormat(" AND [ChannelId]='{0}' ", mp.ChannelId);
}
if (mp.ArticleTypeId.HasValue)
{
sb.AppendFormat(" AND [ArticleTypeId]='{0}' ", mp.ArticleTypeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Title)))
{
sb.AppendFormat(" AND [Title]='{0}' ", mp.Title);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleImg)))
{
sb.AppendFormat(" AND [TitleImg]='{0}' ", mp.TitleImg);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleShort)))
{
sb.AppendFormat(" AND [TitleShort]='{0}' ", mp.TitleShort);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LinkUrl)))
{
sb.AppendFormat(" AND [LinkUrl]='{0}' ", mp.LinkUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageKey)))
{
sb.AppendFormat(" AND [PageKey]='{0}' ", mp.PageKey);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageDesc)))
{
sb.AppendFormat(" AND [PageDesc]='{0}' ", mp.PageDesc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ConetntShort)))
{
sb.AppendFormat(" AND [ConetntShort]='{0}' ", mp.ConetntShort);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Content)))
{
sb.AppendFormat(" AND [Content]='{0}' ", mp.Content);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ContentGroup)))
{
sb.AppendFormat(" AND [ContentGroup]='{0}' ", mp.ContentGroup);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Lable)))
{
sb.AppendFormat(" AND [Lable]='{0}' ", mp.Lable);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Source)))
{
sb.AppendFormat(" AND [Source]='{0}' ", mp.Source);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.EditUser)))
{
sb.AppendFormat(" AND [EditUser]='{0}' ", mp.EditUser);
}
if (mp.IsContributions.HasValue)
{
sb.AppendFormat(" AND [IsContributions]='{0}' ", mp.IsContributions);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.IsShow.HasValue)
{
sb.AppendFormat(" AND [IsShow]='{0}' ", mp.IsShow);
}
if (mp.ContributionsUserId.HasValue)
{
sb.AppendFormat(" AND [ContributionsUserId]='{0}' ", mp.ContributionsUserId);
}
if (mp.OrderIndex.HasValue)
{
sb.AppendFormat(" AND [OrderIndex]='{0}' ", mp.OrderIndex);
}
if (mp.IsHot.HasValue)
{
sb.AppendFormat(" AND [IsHot]='{0}' ", mp.IsHot);
}
if (mp.IsHeadline.HasValue)
{
sb.AppendFormat(" AND [IsHeadline]='{0}' ", mp.IsHeadline);
}
if (mp.IsTop.HasValue)
{
sb.AppendFormat(" AND [IsTop]='{0}' ", mp.IsTop);
}
if (mp.OpenCount.HasValue)
{
sb.AppendFormat(" AND [OpenCount]='{0}' ", mp.OpenCount);
}
if (mp.CommentCount.HasValue)
{
sb.AppendFormat(" AND [CommentCount]='{0}' ", mp.CommentCount);
}
if (mp.LikeCount.HasValue)
{
sb.AppendFormat(" AND [LikeCount]='{0}' ", mp.LikeCount);
}
if (mp.StepCount.HasValue)
{
sb.AppendFormat(" AND [StepCount]='{0}' ", mp.StepCount);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.LastDate.HasValue)
{
sb.AppendFormat(" AND [LastDate]='{0}' ", mp.LastDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.AuditUserId.HasValue)
{
sb.AppendFormat(" AND [AuditUserId]='{0}' ", mp.AuditUserId);
}
if (mp.AuditState.HasValue)
{
sb.AppendFormat(" AND [AuditState]='{0}' ", mp.AuditState);
}
if (mp.AuditDate.HasValue)
{
sb.AppendFormat(" AND [AuditDate]='{0}' ", mp.AuditDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AuditDesc)))
{
sb.AppendFormat(" AND [AuditDesc]='{0}' ", mp.AuditDesc);
}
if (mp.IsAd.HasValue)
{
sb.AppendFormat(" AND [IsAd]='{0}' ", mp.IsAd);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
