/// <summary> /// ²éÕÒ²»´æÔÚµÄͼƬ²¢É¾³ýÒÑɾ³ýµÄͼƬ¼°Êý¾Ý /// </summary> public void DeleteList(SqlConnection conn, SqlTransaction trans, List <Model.article_albums> models, int article_id) { StringBuilder idList = new StringBuilder(); if (models != null) { foreach (Model.article_albums modelt in models) { if (modelt.id > 0) { idList.Append(modelt.id + ","); } } } string id_list = Utils.DelLastChar(idList.ToString(), ","); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,big_img,small_img from dt_article_albums where article_id=" + article_id); if (!string.IsNullOrEmpty(id_list)) { strSql.Append(" and id not in(" + id_list + ")"); } DataSet ds = DbHelperSQL2.Query(conn, trans, strSql.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { int rows = DbHelperSQL2.ExecuteSql(conn, trans, "delete from dt_article_albums where id=" + dr["id"].ToString()); //ɾ³ýÊý¾Ý¿â if (rows > 0) { Utils.DeleteFile(dr["big_img"].ToString()); //ɾ³ýÔͼ Utils.DeleteFile(dr["small_img"].ToString()); //ɾ³ýËõÂÔͼ } } }
/// <summary> /// 查找不存在的文件并删除已删除的附件及数据 /// </summary> public void DeleteList(SqlConnection conn, SqlTransaction trans, List <Model.download_attach> models, int article_id) { StringBuilder idList = new StringBuilder(); if (models != null) { foreach (Model.download_attach modelt in models) { if (modelt.id > 0) { idList.Append(modelt.id + ","); } } } string id_list = Utils.DelLastChar(idList.ToString(), ","); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,file_path from dt_download_attach where article_id=" + article_id); if (!string.IsNullOrEmpty(id_list)) { strSql.Append(" and id not in(" + id_list + ")"); } DataSet ds = DbHelperSQL2.Query(conn, trans, strSql.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { int rows = DbHelperSQL2.ExecuteSql(conn, trans, "delete from dt_download_attach where id=" + dr["id"].ToString()); //删除数据库 if (rows > 0) { Utils.DeleteFile(dr["file_path"].ToString()); //删除文件 } } }
/// <summary> /// 删除一条数据 /// </summary> public void Delete(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_category "); strSql.Append(" where class_list like '%," + id + ",%' "); DbHelperSQL2.Query(strSql.ToString()); }
/// <summary> /// 获得数据列表 /// </summary> public List <Model.download_attach> GetList(int article_id) { List <Model.download_attach> modelList = new List <Model.download_attach>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,title,file_path,file_ext,file_size,down_num,point "); strSql.Append(" FROM dt_download_attach "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL2.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.download_attach model; for (int n = 0; n < rowsCount; n++) { model = new Model.download_attach(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["title"] != null && dt.Rows[n]["title"].ToString() != "") { model.title = dt.Rows[n]["title"].ToString(); } if (dt.Rows[n]["file_path"] != null && dt.Rows[n]["file_path"].ToString() != "") { model.file_path = dt.Rows[n]["file_path"].ToString(); } if (dt.Rows[n]["file_ext"] != null && dt.Rows[n]["file_ext"].ToString() != "") { model.file_ext = dt.Rows[n]["file_ext"].ToString(); } if (dt.Rows[n]["file_size"] != null && dt.Rows[n]["file_size"].ToString() != "") { model.file_size = int.Parse(dt.Rows[n]["file_size"].ToString()); } if (dt.Rows[n]["down_num"] != null && dt.Rows[n]["down_num"].ToString() != "") { model.down_num = int.Parse(dt.Rows[n]["down_num"].ToString()); } if (dt.Rows[n]["point"] != null && dt.Rows[n]["point"].ToString() != "") { model.point = int.Parse(dt.Rows[n]["point"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.download_attach GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,article_id,title,file_path,file_ext,file_size,down_num,point from dt_download_attach "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.download_attach model = new Model.download_attach(); DataSet ds = DbHelperSQL2.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["article_id"] != null && ds.Tables[0].Rows[0]["article_id"].ToString() != "") { model.article_id = int.Parse(ds.Tables[0].Rows[0]["article_id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["file_path"] != null && ds.Tables[0].Rows[0]["file_path"].ToString() != "") { model.file_path = ds.Tables[0].Rows[0]["file_path"].ToString(); } if (ds.Tables[0].Rows[0]["file_ext"] != null && ds.Tables[0].Rows[0]["file_ext"].ToString() != "") { model.file_ext = ds.Tables[0].Rows[0]["file_ext"].ToString(); } if (ds.Tables[0].Rows[0]["file_size"] != null && ds.Tables[0].Rows[0]["file_size"].ToString() != "") { model.file_size = int.Parse(ds.Tables[0].Rows[0]["file_size"].ToString()); } if (ds.Tables[0].Rows[0]["down_num"] != null && ds.Tables[0].Rows[0]["down_num"].ToString() != "") { model.down_num = int.Parse(ds.Tables[0].Rows[0]["down_num"].ToString()); } if (ds.Tables[0].Rows[0]["point"] != null && ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 取得指定类别下的列表 /// </summary> /// <param name="parent_id">父ID</param> /// <param name="channel_id">频道ID</param> /// <returns></returns> public DataTable GetChildList(int parent_id, int channel_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description from dt_category"); strSql.Append(" where channel_id=" + channel_id + " and parent_id=" + parent_id + " order by sort_id asc,id desc"); DataSet ds = DbHelperSQL2.Query(strSql.ToString()); return(ds.Tables[0]); }
/// <summary> /// 取得某个频道下父节点下的id /// </summary> /// <param name="parent_id"></param> /// <param name="channel_id"></param> /// <returns></returns> public DataTable GetTopList(int parent_id, int channel_id) { StringBuilder strsql = new StringBuilder(); strsql.Append("select * from dt_category "); strsql.Append(" where channel_id=" + channel_id + " and parent_id=" + parent_id + " order by sort_id asc"); DataSet ds = DbHelperSQL2.Query(strsql.ToString()); DataTable dt = ds.Tables[0] as DataTable; return(dt); }
/// <summary> /// 获得查询分页数据 /// </summary> public DataSet GetNewsList(int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * FROM view_article_news"); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } recordCount = Convert.ToInt32(DbHelperSQL2.GetSingle(PagingHelper.CreateCountingSql(strSql.ToString()))); return(DbHelperSQL2.Query(PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, strSql.ToString(), filedOrder))); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select BarCode,Tf_TrayId,cTray,FileName,fltCapacity,fltVol,fltResistance,tf_CheckGrade,tf_Group,tf_GroupNum,tf_Location,cState,cDate,cStateCode "); strSql.Append(" FROM Tb_CheckData "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(DbHelperSQL2.Query(strSql.ToString())); }
/// <summary> /// »ñµÃÊý¾ÝÁбí /// </summary> public List <Model.article_albums> GetList(int article_id) { List <Model.article_albums> modelList = new List <Model.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,big_img,small_img,remark "); strSql.Append(" FROM dt_article_albums "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL2.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.article_albums(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["big_img"] != null && dt.Rows[n]["big_img"].ToString() != "") { model.big_img = dt.Rows[n]["big_img"].ToString(); } if (dt.Rows[n]["small_img"] != null && dt.Rows[n]["small_img"].ToString() != "") { model.small_img = dt.Rows[n]["small_img"].ToString(); } if (dt.Rows[n]["remark"] != null && dt.Rows[n]["remark"].ToString() != "") { model.remark = dt.Rows[n]["remark"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetNewsList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" id,channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time,author,[from],zhaiyao,is_msg,is_top,is_red,is_hot,is_slide "); //strSql.Append(" id,channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time,author,[from],zhaiyao,is_msg,is_top,is_red,is_hot,is_slide,digg_good,digg_bad "); strSql.Append(" FROM view_article_news "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(DbHelperSQL2.Query(strSql.ToString())); }
/// <summary> /// 取得所有类别列表 /// </summary> /// <param name="parent_id">父ID</param> /// <param name="channel_id">频道ID</param> /// <returns></returns> public DataTable GetList(int parent_id, int channel_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description from dt_category"); strSql.Append(" where channel_id=" + channel_id + " order by sort_id asc,id desc"); DataSet ds = DbHelperSQL2.Query(strSql.ToString()); DataTable oldData = ds.Tables[0] as DataTable; if (oldData == null) { return(null); } //复制结构 DataTable newData = oldData.Clone(); //调用迭代组合成DAGATABLE GetChilds(oldData, newData, parent_id, channel_id); return(newData); }
/// <summary> /// 修改子节点的ID列表及深度(自身迭代) /// </summary> /// <param name="parent_id"></param> private void UpdateChilds(SqlConnection conn, SqlTransaction trans, int parent_id) { //查找父节点信息 Model.category model = GetModel(conn, trans, parent_id); if (model != null) { //查找子节点 string strSql = "select id from dt_category where parent_id=" + parent_id; DataSet ds = DbHelperSQL2.Query(conn, trans, strSql); //带事务 foreach (DataRow dr in ds.Tables[0].Rows) { //修改子节点的ID列表及深度 int id = int.Parse(dr["id"].ToString()); string class_list = model.class_list + id + ","; int class_layer = model.class_layer + 1; DbHelperSQL2.ExecuteSql(conn, trans, "update dt_category set class_list='" + class_list + "', class_layer=" + class_layer + " where id=" + id); //带事务 //调用自身迭代 this.UpdateChilds(conn, trans, id); //带事务 } } }
/// <summary> /// 得到一个对象实体 /// </summary> public DBAccess.Model.Tb_CheckDataModel GetModel(string BarCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 BarCode,Tf_TrayId,cTray,FileName,fltCapacity,fltVol,fltResistance,tf_CheckGrade,tf_Group,tf_GroupNum,tf_Location,cState,cDate,cStateCode from Tb_CheckData "); strSql.Append(" where BarCode=@BarCode "); SqlParameter[] parameters = { new SqlParameter("@BarCode", SqlDbType.NVarChar, 32) }; parameters[0].Value = BarCode; DBAccess.Model.Tb_CheckDataModel model = new DBAccess.Model.Tb_CheckDataModel(); DataSet ds = DbHelperSQL2.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.article_news GetNewsModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time,author,[from],zhaiyao,is_msg,is_top,is_red,is_hot,is_slide from view_article_news "); //strSql.Append("select top 1 id,channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time,author,[from],zhaiyao,is_msg,is_top,is_red,is_hot,is_slide,digg_good,digg_bad from view_article_news "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.article_news model = new Model.article_news(); DataSet ds = DbHelperSQL2.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "") { model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString()); } if (ds.Tables[0].Rows[0]["category_id"] != null && ds.Tables[0].Rows[0]["category_id"].ToString() != "") { model.category_id = int.Parse(ds.Tables[0].Rows[0]["category_id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["link_url"] != null && ds.Tables[0].Rows[0]["link_url"].ToString() != "") { model.link_url = ds.Tables[0].Rows[0]["link_url"].ToString(); } if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "") { model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); } if (ds.Tables[0].Rows[0]["seo_title"] != null && ds.Tables[0].Rows[0]["seo_title"].ToString() != "") { model.seo_title = ds.Tables[0].Rows[0]["seo_title"].ToString(); } if (ds.Tables[0].Rows[0]["seo_keywords"] != null && ds.Tables[0].Rows[0]["seo_keywords"].ToString() != "") { model.seo_keywords = ds.Tables[0].Rows[0]["seo_keywords"].ToString(); } if (ds.Tables[0].Rows[0]["seo_description"] != null && ds.Tables[0].Rows[0]["seo_description"].ToString() != "") { model.seo_description = ds.Tables[0].Rows[0]["seo_description"].ToString(); } if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "") { model.content = ds.Tables[0].Rows[0]["content"].ToString(); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["click"] != null && ds.Tables[0].Rows[0]["click"].ToString() != "") { model.click = int.Parse(ds.Tables[0].Rows[0]["click"].ToString()); } if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "") { model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } if (ds.Tables[0].Rows[0]["author"] != null && ds.Tables[0].Rows[0]["author"].ToString() != "") { model.author = ds.Tables[0].Rows[0]["author"].ToString(); } if (ds.Tables[0].Rows[0]["from"] != null && ds.Tables[0].Rows[0]["from"].ToString() != "") { model.from = ds.Tables[0].Rows[0]["from"].ToString(); } if (ds.Tables[0].Rows[0]["zhaiyao"] != null && ds.Tables[0].Rows[0]["zhaiyao"].ToString() != "") { model.zhaiyao = ds.Tables[0].Rows[0]["zhaiyao"].ToString(); } if (ds.Tables[0].Rows[0]["is_msg"] != null && ds.Tables[0].Rows[0]["is_msg"].ToString() != "") { model.is_msg = int.Parse(ds.Tables[0].Rows[0]["is_msg"].ToString()); } if (ds.Tables[0].Rows[0]["is_top"] != null && ds.Tables[0].Rows[0]["is_top"].ToString() != "") { model.is_top = int.Parse(ds.Tables[0].Rows[0]["is_top"].ToString()); } if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "") { model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString()); } if (ds.Tables[0].Rows[0]["is_hot"] != null && ds.Tables[0].Rows[0]["is_hot"].ToString() != "") { model.is_hot = int.Parse(ds.Tables[0].Rows[0]["is_hot"].ToString()); } if (ds.Tables[0].Rows[0]["is_slide"] != null && ds.Tables[0].Rows[0]["is_slide"].ToString() != "") { model.is_slide = int.Parse(ds.Tables[0].Rows[0]["is_slide"].ToString()); } //if (ds.Tables[0].Rows[0]["digg_good"] != null && ds.Tables[0].Rows[0]["digg_good"].ToString() != "") //{ // model.digg_good = int.Parse(ds.Tables[0].Rows[0]["digg_good"].ToString()); //} //if (ds.Tables[0].Rows[0]["digg_bad"] != null && ds.Tables[0].Rows[0]["digg_bad"].ToString() != "") //{ // model.digg_bad = int.Parse(ds.Tables[0].Rows[0]["digg_bad"].ToString()); //} #endregion 父表信息end model.albums = new article_albums().GetList(id); //相册信息 // model.attribute_values = new attribute_value().GetList(id); //扩展属性 return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体(重载,带事务) /// </summary> public DTcms.Model.category GetModel(SqlConnection conn, SqlTransaction trans, int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description from dt_category "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DTcms.Model.category model = new DTcms.Model.category(); DataSet ds = DbHelperSQL2.Query(conn, trans, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "") { model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["call_index"] != null && ds.Tables[0].Rows[0]["call_index"].ToString() != "") { model.call_index = ds.Tables[0].Rows[0]["call_index"].ToString(); } if (ds.Tables[0].Rows[0]["parent_id"] != null && ds.Tables[0].Rows[0]["parent_id"].ToString() != "") { model.parent_id = int.Parse(ds.Tables[0].Rows[0]["parent_id"].ToString()); } if (ds.Tables[0].Rows[0]["class_list"] != null && ds.Tables[0].Rows[0]["class_list"].ToString() != "") { model.class_list = ds.Tables[0].Rows[0]["class_list"].ToString(); } if (ds.Tables[0].Rows[0]["class_layer"] != null && ds.Tables[0].Rows[0]["class_layer"].ToString() != "") { model.class_layer = int.Parse(ds.Tables[0].Rows[0]["class_layer"].ToString()); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["link_url"] != null && ds.Tables[0].Rows[0]["link_url"].ToString() != "") { model.link_url = ds.Tables[0].Rows[0]["link_url"].ToString(); } if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "") { model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); } if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "") { model.content = ds.Tables[0].Rows[0]["content"].ToString(); } if (ds.Tables[0].Rows[0]["seo_title"] != null && ds.Tables[0].Rows[0]["seo_title"].ToString() != "") { model.seo_title = ds.Tables[0].Rows[0]["seo_title"].ToString(); } if (ds.Tables[0].Rows[0]["seo_keywords"] != null && ds.Tables[0].Rows[0]["seo_keywords"].ToString() != "") { model.seo_keywords = ds.Tables[0].Rows[0]["seo_keywords"].ToString(); } if (ds.Tables[0].Rows[0]["seo_description"] != null && ds.Tables[0].Rows[0]["seo_description"].ToString() != "") { model.seo_description = ds.Tables[0].Rows[0]["seo_description"].ToString(); } return(model); } else { return(null); } }