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