/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">News对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.News model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("newsClassID=@newsClassID,");
strSql.Append("routeClassID=@routeClassID,");
strSql.Append("Title=@Title,");
strSql.Append("Editor=@Editor,");
strSql.Append("Source=@Source,");
strSql.Append("Image=@Image,");
strSql.Append("Content=@Content,");
strSql.Append("seoKeyword=@seoKeyword,");
strSql.Append("seoDescription=@seoDescription,");
strSql.Append("IsDisplay=@IsDisplay,");
strSql.Append("LocationID=@LocationID,");
strSql.Append("IsSanxia=@IsSanxia,");
strSql.Append("Ntag=@Ntag");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 6),
new SqlParameter("@newsClassID", SqlDbType.Int, 4),
new SqlParameter("@routeClassID", SqlDbType.NVarChar, 100),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Editor", SqlDbType.NVarChar, 40),
new SqlParameter("@Source", SqlDbType.NVarChar, 200),
new SqlParameter("@Image", SqlDbType.NVarChar, 50),
new SqlParameter("@Content", SqlDbType.Text),
new SqlParameter("@seoKeyword", SqlDbType.NVarChar, 100),
new SqlParameter("@seoDescription", SqlDbType.NVarChar, 200),
new SqlParameter("@IsDisplay", SqlDbType.Bit, 1),
new SqlParameter("@LocationID", SqlDbType.Int, 4),
new SqlParameter("@IsSanxia", SqlDbType.Bit, 1),
new SqlParameter("@Ntag", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.newsClassID;
parameters[2].Value = model.routeClassID;
parameters[3].Value = model.Title;
parameters[4].Value = model.Editor;
parameters[5].Value = model.Source;
parameters[6].Value = model.Image;
parameters[7].Value = model.Content;
parameters[8].Value = model.Keywords;
parameters[9].Value = model.Description;
parameters[10].Value = model.Display;
parameters[11].Value = model.LocationID;
parameters[12].Value = model.IsSanxia;
parameters[13].Value = model.Ntag;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
//新闻详情
private void BindInfo()
{
news = newsBll.GetModel(newsID);
if (news.Title == "")
{
Response.StatusCode = 404;
Response.End();
//Response.Redirect("/nopage/");
}
mipUrl = SysConfig.webSiteApp + "/mip/" + Enum.GetName(typeof(SysConfig.NewsClassPY), news.newsClassID) + "/" + newsID + ".html";
articleTitle = news.Title;
articleData = news.Content.Replace(SysConfig.webSite, SysConfig.webSiteApp)
.Replace(SysConfig.webSiteApp + "/images/", SysConfig.webSite + "/images/")
.Replace("\"/images/", "\"" + SysConfig.webSite + "/images/");
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">News对象</param>
public int Add(ClassLibrary.Model.News model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("newsClassID,routeClassID,Title,Editor,Source,ViewCount,Image,Content,CreatedTime,seoKeyword,seoDescription,IsDisplay,LocationID,IsSanxia,ZanCount,Ntag");
strSql.Append(") VALUES (");
strSql.Append("@newsClassID,@routeClassID,@Title,@Editor,@Source,@ViewCount,@Image,@Content,@CreatedTime,@seoKeyword,@seoDescription,@IsDisplay,@LocationID,@IsSanxia,@ZanCount,@Ntag)");
SqlParameter[] parameters =
{
new SqlParameter("@newsClassID", SqlDbType.Int, 4),
new SqlParameter("@routeClassID", SqlDbType.NVarChar, 100),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Editor", SqlDbType.NVarChar, 40),
new SqlParameter("@Source", SqlDbType.NVarChar, 200),
new SqlParameter("@ViewCount", SqlDbType.Int, 6),
new SqlParameter("@Image", SqlDbType.NVarChar, 50),
new SqlParameter("@Content", SqlDbType.Text),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@seoKeyword", SqlDbType.NVarChar, 100),
new SqlParameter("@seoDescription", SqlDbType.NVarChar, 200),
new SqlParameter("@IsDisplay", SqlDbType.Bit, 1),
new SqlParameter("@LocationID", SqlDbType.Int, 4),
new SqlParameter("@IsSanxia", SqlDbType.Bit, 1),
new SqlParameter("@ZanCount", SqlDbType.Int, 4),
new SqlParameter("@Ntag", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.newsClassID;
parameters[1].Value = model.routeClassID;
parameters[2].Value = model.Title;
parameters[3].Value = model.Editor;
parameters[4].Value = model.Source;
parameters[5].Value = model.ViewCount;
parameters[6].Value = model.Image;
parameters[7].Value = model.Content;
parameters[8].Value = model.CreatedTime;
parameters[9].Value = model.Keywords;
parameters[10].Value = model.Description;
parameters[11].Value = model.Display;
parameters[12].Value = model.LocationID;
parameters[13].Value = model.IsSanxia;
parameters[14].Value = model.ZanCount;
parameters[15].Value = model.Ntag;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
//新闻详情
private void BindInfo()
{
news = newsBll.GetModel(newsID);
if (news.Title == "")
{
Response.StatusCode = 404;
Response.End();
}
routeClassId = news.LocationID;
gList = rcBll.GetModelList(String.Empty);
ClassLibrary.Model.RouteClass rcmodel = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); });
displayPing = rcmodel.ClassNamePY;
displayName = rcmodel.ClassName;
ntag = news.Ntag.Replace(",", " ").Replace("，", " ");
zanCount = news.ZanCount;
articleTitle = news.Title;
}
//新闻详情
private void BindInfo()
{
news = newsBll.GetModel(newsID);
if (news.Title == "")
{
Response.StatusCode = 404;
Response.End();
//Response.Redirect("/nopage/");
}
mipUrl = SysConfig.webSiteApp + "/" + Enum.GetName(typeof(SysConfig.NewsClassPY), news.newsClassID) + "/" + newsID + ".html";
articleTitle = news.Title;
articleData = news.Content.Replace(SysConfig.webSite, SysConfig.webSiteApp)
.Replace(SysConfig.webSiteApp + "/images/", SysConfig.webSite + "/images/")
.Replace("\"/images/", "\"" + SysConfig.webSite + "/images/");
//.Replace("<img", "<mip-img layout='responsive'").Replace("<IMG", "<mip-img layout='responsive'")
//.Replace("</img>", "</mip-img>").Replace("</IMG>", "</mip-img>");
articleData = Function.UpdateImgTagForMip(articleData);
articleData = Function.UpdateStyleForMip(articleData);
articleData = Function.AddTargetForMip(articleData);
}
public void AddNews()
{
ClassLibrary.BLL.News newsBLL = new ClassLibrary.BLL.News();
ClassLibrary.Model.News newsModel = new ClassLibrary.Model.News();
newsModel.newsClassID = Convert.ToInt32(Request.Form["newsClassID"]);
string province = Request.Form["ProvinceCheckBox"];
string scenic = Request.Form["ScenicCheckBox"];
if (scenic == null)
{
scenic = "";
}
if (province == null)
{
province = "";
}
if (province == "")
{
Response.Write("<script>alert('请至少选择一个所属区域！');history.back(-1);</script>");
return;
}
newsModel.LocationID = Convert.ToInt32(province.Split(',')[0]);
newsModel.routeClassID = "," + ParentClassIDList(province) + ",";
if (scenic != "")
{
string[] temScenics = scenic.Split(',');
foreach (string temScenic in temScenics)
{
if (!newsModel.routeClassID.Contains("," + temScenic + ","))
{
newsModel.routeClassID += temScenic + ",";
}
}
}
newsModel.routeClassID = newsModel.routeClassID.Substring(1, newsModel.routeClassID.Length - 2);
newsModel.Title = Request.Form["Title"];
newsModel.Content = ClassLibrary.BLL.WebClass.addInternelLink(Request.Form["Content"].ToString(), SysConfig.linkCount, null); //添加内部链接
newsModel.Editor = Request.Form["Editor"];
newsModel.Source = Request.Form["Source"];
newsModel.Image = string.Empty;
newsModel.Ntag = Request.Form["Ntag"];
newsModel.Description = Request.Form["SeoDescription"];
newsModel.Keywords = Request.Form["SeoKeywords"];
newsModel.Display = Convert.ToBoolean(Request.Form["Isdisplay"]);
newsModel.IsSanxia = Convert.ToBoolean(Request.Form["IsSanxia"]);
if (newsModel.IsSanxia)
{
newsModel.LocationID = (int)SysConfig.RouteClass.峡旅游;
}
if (newsModel.newsClassID == 0)
{
Response.Write("<script>alert('请选择文章类型！');history.back(-1);</script>");
return;
}
if (newsModel.routeClassID == "")
{
Response.Write("<script>alert('请选择所属区域！');history.back(-1);</script>");
return;
}
if (string.IsNullOrEmpty(newsModel.Title))
{
Response.Write("<script>alert('请输入标题！');history.back(-1);</script>");
return;
}
if (string.IsNullOrEmpty(newsModel.Content))
{
Response.Write("<script>alert('请输入文章内容！');history.back(-1);</script>");
return;
}
int width = 300;
int height = 186;
HttpPostedFile file = Request.Files["Image"];
if (file.ContentLength > 0)
{
string ext = Path.GetExtension(file.FileName);
string fileName = Function.GetRandomTime() + ext;
string fileFullPath = Server.MapPath(SysConfig.UploadFilePathNewsImg);
Function.CreatedDirectory(fileFullPath);
file.SaveAs(fileFullPath + fileName);
//缩图
Bitmap tmp = new Bitmap(fileFullPath + fileName);
Bitmap bmp0 = Function.MakeThumNail(tmp, width, height);
tmp.Dispose();
//bmp0.Save(fileFullPath + fileName);
Function.SaveBitmapImg(bmp0, fileFullPath + fileName, ((long)88));
bmp0.Dispose();
newsModel.Image = fileName;
}
else //if (newsModel.newsClassID == 6 || newsModel.newsClassID == 7) 概述和景点介绍
{
Response.Write("<script>alert('请选择文章图片！');history.back(-1);</script>");
return;
}
if (newsBLL.Add(newsModel) > 0)
{
Function.goMessagePage("添加文章", "操作成功", "News/NewsList.aspx?cid=" + newsClassIDs);
}
else
{
Function.goMessagePage("添加文章", "操作失败，请稍后再试", "News/NewsList.aspx?cid=" + newsClassIDs);
}
}
//网站信息
private void GetWebInfo()
{
webMeta.Title = "重庆青年旅行社_重庆旅行社_重庆中国青年旅行社_重庆中青旅行社";
webMeta.Description = "重庆中国青年旅行社（www.qu17.com）称重庆青旅，旅游热线：400-017-5761.共青团市委直属重庆旅行社，中青旅集团成员单位，优质服务示范重庆旅行社，重庆青年旅行社具有国家旅游局颁证的出境旅游资质的国际旅行社，旅游品质最高的重庆旅行社，重庆十大金牌旅行社，出入境游、国内游、重庆周边游、长江三峡游为主导。";
webMeta.Keyword = "重庆旅行社,重庆青年旅行社,重庆中青旅,重庆中国青年旅行社,重庆旅游网";
string url = HttpContext.Current.Request.CurrentExecutionFilePath.ToLower();
string tmpTitle = "_重庆中国青年旅行社";
if (url.IndexOf("approutesearch.aspx") > -1)
{
webMeta.Title = "旅游线路搜索结果" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("approutelist.aspx") > -1)
{
string ping = Function.GetQueryString("py");
ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass();
List <ClassLibrary.Model.RouteClass> rcList = routeClassBll.GetModelList("classNamePy='" + ping + "'");
if (rcList.Count > 0)
{
ClassLibrary.Model.RouteClass rc = rcList[0];
if (rc.ClassLevel == 4)
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
else if (rc.ClassLevel == 3)
{
if (rc.ID == (int)SysConfig.RouteClass.重庆)
{
webMeta.Title = "重庆周边游_重庆周边旅游线路报价_重庆中国青年旅行社";
webMeta.Keyword = "重庆周边旅游,重庆周边旅游线路,重庆周边旅游行程,重庆周边旅游报价";
webMeta.Description = "重庆周边旅游线路、周边旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ParentID == (int)SysConfig.RouteClass.豪华船)
{
webMeta.Title = string.Format("重庆三峡{0}旅游_{0}三峡旅游报价", rc.ClassName);
webMeta.Keyword = string.Format("重庆三峡{0}旅游,三峡{0}旅游报价,重庆三峡旅游", rc.ClassName);
webMeta.Description = string.Format("重庆青年旅行社提供重庆三峡{0}旅游线路报价,重庆三峡{0}旅游费用,长江三峡豪华游船旅游价格,三峡{0}旅游要多少钱,详询中青旅电话400-017-5761.", rc.ClassName);
}
else
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
}
else if (rc.ClassLevel == 2)
{
if (rc.ParentID == (int)SysConfig.RouteClass.峡旅游)
{
if (rc.ID == (int)SysConfig.RouteClass.豪华船)
{
webMeta.Title = "三峡豪华游船_豪华游船航期表_重庆三峡豪华游轮_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡豪华游船,长江三峡游船,豪华游船航期表,三峡涉外豪华游轮";
webMeta.Description = "重庆中国青年旅行社提供各系列长江三峡豪华游轮,以及三峡涉外豪华游轮旅游品质服务,重庆三峡涉外豪华游轮预定,重庆中青旅热线：400-017-5761";
}
else
{
webMeta.Title = "三峡国内游船_重庆三峡国内船_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡国内游船,长江三峡游船,三峡国内游轮";
webMeta.Description = "重庆中国青年旅行社提供长江三峡国内游船,长江三峡旅游品质服务,重庆三峡国内游船预定,重庆中青旅热线：400-017-5761";
}
}
else
{
webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName);
webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName);
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName);
}
}
else
{
if (rc.ID == (int)SysConfig.RouteClass.国内旅游)
{
webMeta.Title = "国内旅游线路行程_重庆出发国内旅游线路_重庆中国青年旅行社";
webMeta.Keyword = "国内游线路,国内游行程,国内游报价,国内游跟团,重庆出发国内游";
webMeta.Description = "重庆出发国内旅游线路、国内旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ID == (int)SysConfig.RouteClass.出境旅游)
{
webMeta.Title = "出境旅游线路行程_重庆出发出境旅游线路_重庆中国青年旅行社";
webMeta.Keyword = "出境游线路,出境游行程,出境游报价,出境游跟团,重庆出发出境游";
webMeta.Description = "重庆出发出境旅游线路、出境旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
else if (rc.ID == (int)SysConfig.RouteClass.峡旅游)
{
webMeta.Title = "重庆长江三峡旅游_重庆三峡旅游行程景点_重庆中国青年旅行社";
webMeta.Keyword = "重庆三峡旅游,长江三峡旅游线路,三峡旅游报价,三峡游景点,三峡游船预定";
webMeta.Description = "重庆三峡旅游行程、三峡游线路、长江三峡旅游报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761.";
}
}
}
else
{
ClassLibrary.BLL.RouteType rtBll = new ClassLibrary.BLL.RouteType();
List <ClassLibrary.Model.RouteType> rtList = rtBll.GetModelList("classNamePy='" + ping + "'");
if (rtList.Count > 0)
{
ClassLibrary.Model.RouteType rtc = rtList[0];
webMeta.Title = string.Format("{0}旅游线路_重庆出发{0}旅游报价", rtc.ClassName.Replace("游", "")) + tmpTitle;
webMeta.Keyword = string.Format("{0}旅游,{0}旅游报价,{0}旅游线路", rtc.ClassName.Replace("游", ""));
webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆出发{0}旅游最新报价,{0}跟团游价格,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rtc.ClassName.Replace("游", ""));
}
}
}
else if (url.IndexOf("approutedetail.aspx") > -1)
{
int id = Convert.ToInt32(Function.GetQueryString("id"));
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
ClassLibrary.Model.Routes rModel = routeBll.GetModel(id);
webMeta.Title = rModel.Title + tmpTitle;
if (rModel.SeoTitle != null && rModel.SeoTitle.Trim() != "")
{
webMeta.Title = rModel.SeoTitle;
}
webMeta.Keyword = rModel.SeoKeywords;
if (webMeta.Keyword == "")
{
webMeta.Keyword = rModel.Title;
}
webMeta.Description = rModel.SeoDescription;
if (webMeta.Description == "")
{
webMeta.Description = Function.Clip(Function.ClearHtml(rModel.RouteFeature + rModel.DescriptionRoute).Replace(" ", "").Replace(" ", ""), 80, false);
}
}
else if (url.IndexOf("appabout.aspx") > -1)
{
webMeta.Title = "重庆中国青年旅行社简介";
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("apparticlelist.aspx") > -1)
{
string strId = Function.GetQueryString("id");
if (strId != "")
{
int classid = Convert.ToInt32(strId);
if (classid == (int)SysConfig.NewsClass.旅游资讯)
{
webMeta.Title = "重庆旅行社旅游资讯_最新旅游资讯指南" + tmpTitle;
webMeta.Description = "重庆旅游资讯,重庆旅游指南,旅游最新资讯,重庆旅行社资讯";
webMeta.Keyword = "重庆青年旅行社旅游资讯大致包含旅行社资讯,旅游相关实时新闻,旅游行业最新资讯消息,重庆以及周边旅游指南,重庆中青旅一如既往的高品质服务游客.";
}
else if (classid == (int)SysConfig.NewsClass.旅游攻略)
{
webMeta.Title = "重庆旅行社旅游攻略_最新旅游攻略" + tmpTitle;
webMeta.Description = "重庆旅游攻略,重庆旅游指南,旅游最新攻略";
webMeta.Keyword = "重庆青年旅行社旅游攻略大致包含旅游的吃、住、行、游、购、娱方面的介绍以及方式方法,重庆青旅更新的旅游攻略内容板块将更加方便您的出游.";
}
}
else
{
webMeta.Title = "旅游攻略网_旅游景点网_最新旅游指南_重庆中国青年旅行社";
webMeta.Keyword = "旅游攻略网,旅游景点网,最新旅游指南";
webMeta.Description = "重庆中国青年旅行社旅游攻略网旅游景点网提供各种旅游攻略,旅游景点排行,最新旅游资讯,旅游景点推荐,详情请咨询中青旅400-017-5761";
}
}
else if (url.IndexOf("apparticledetail.aspx") > -1)
{
int id = Convert.ToInt32(Function.GetQueryString("id"));
ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News();
ClassLibrary.Model.News rModel = newsBll.GetModel(id);
webMeta.Title = rModel.Title + tmpTitle;
webMeta.Keyword = rModel.Keywords;
if (webMeta.Keyword == "")
{
webMeta.Keyword = rModel.Title;
}
webMeta.Description = rModel.Description;
if (webMeta.Description == "")
{
webMeta.Description = Function.Clip(Function.ClearHtml(rModel.Description).Replace(" ", "").Replace(" ", ""), 80, false);
}
}
else if (url.IndexOf("appnav.aspx") > -1)
{
webMeta.Title = "旅游目的地导航" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("apporder.aspx") > -1)
{
webMeta.Title = "订单提交信息" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("appshopcart.aspx") > -1)
{
webMeta.Title = "旅游订单信息" + tmpTitle;
webMeta.Keyword = "";
webMeta.Description = "";
}
else if (url.IndexOf("appsaleslist.aspx") > -1)
{
webMeta.Title = "特价旅游专区_最划算的旅游" + tmpTitle;
webMeta.Keyword = "青旅特价旅游,特价旅游旅行社,重庆旅行社特价团";
webMeta.Description = "重庆中国青年旅行社特价旅游专区产品为限时限量旅游线路,由于游客临时退位置或者旅行社原因,导致紧急处理的旅游产品,在整个旅游行业可以说是性价比最高,超级划算的特价旅游产品.";
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>News对象</returns>
public ClassLibrary.Model.News GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID,newsClassID,routeClassID,Title,Editor,Source,ViewCount,Image,Content,CreatedTime,seoKeyword,seoDescription,IsDisplay,LocationID,IsSanxia,ZanCount,Ntag");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 6)
};
parameters[0].Value = ID;
ClassLibrary.Model.News model = new ClassLibrary.Model.News();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["newsClassID"] != DBNull.Value)
{
model.newsClassID = Convert.ToInt32(dt.Rows[0]["newsClassID"]);
}
if (dt.Rows[0]["routeClassID"] != DBNull.Value)
{
model.routeClassID = Convert.ToString(dt.Rows[0]["routeClassID"]);
}
if (dt.Rows[0]["Title"] != DBNull.Value)
{
model.Title = Convert.ToString(dt.Rows[0]["Title"]);
}
if (dt.Rows[0]["Editor"] != DBNull.Value)
{
model.Editor = Convert.ToString(dt.Rows[0]["Editor"]);
}
if (dt.Rows[0]["Source"] != DBNull.Value)
{
model.Source = Convert.ToString(dt.Rows[0]["Source"]);
}
if (dt.Rows[0]["ViewCount"] != DBNull.Value)
{
model.ViewCount = Convert.ToInt32(dt.Rows[0]["ViewCount"]);
}
if (dt.Rows[0]["Image"] != DBNull.Value)
{
model.Image = Convert.ToString(dt.Rows[0]["Image"]);
}
if (dt.Rows[0]["Content"] != DBNull.Value)
{
model.Content = Convert.ToString(dt.Rows[0]["Content"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
if (dt.Rows[0]["Ntag"] != DBNull.Value)
{
model.Ntag = Convert.ToString(dt.Rows[0]["Ntag"]);
}
if (dt.Rows[0]["seoKeyword"] != DBNull.Value)
{
model.Keywords = Convert.ToString(dt.Rows[0]["seoKeyword"]);
}
if (dt.Rows[0]["seoDescription"] != DBNull.Value)
{
model.Description = Convert.ToString(dt.Rows[0]["seoDescription"]);
}
if (dt.Rows[0]["IsDisplay"] != DBNull.Value)
{
model.Display = Convert.ToBoolean(dt.Rows[0]["IsDisplay"]);
}
if (dt.Rows[0]["LocationID"] != DBNull.Value)
{
model.LocationID = Convert.ToInt32(dt.Rows[0]["LocationID"]);
}
if (dt.Rows[0]["IsSanxia"] != DBNull.Value)
{
model.IsSanxia = Convert.ToBoolean(dt.Rows[0]["IsSanxia"]);
}
if (dt.Rows[0]["ZanCount"] != DBNull.Value)
{
model.ZanCount = Convert.ToInt32(dt.Rows[0]["ZanCount"]);
}
}
return(model);
}
