/// <summary> /// 更新一条数据 /// </summary> public bool Update(EyouSoft.Model.MTravelArticle model) { if (model != null && !string.IsNullOrEmpty(model.ArticleID) && !string.IsNullOrEmpty(model.ArticleTitle)) { return(dal.Update(model)); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EyouSoft.Model.MTravelArticle model) { if (model != null && !string.IsNullOrEmpty(model.ArticleTitle)) { model.ArticleID = Guid.NewGuid().ToString(); return(dal.Add(model)); } else { return(false); } }
private void PageInit(string id, string dotype) { if (id != "" && dotype != "add") { EyouSoft.BLL.OtherStructure.BTravelArticle bll = new EyouSoft.BLL.OtherStructure.BTravelArticle(); EyouSoft.Model.MTravelArticle model = bll.GetModel(id); if (model != null) { this.txtArticleTitle.Text = model.ArticleTitle; this.ddlClassId.SelectedValue = model.ClassId.ToString(); //this.txtArticleTag.Text = model.ArticleTag; //this.txtKeyWords.Text = model.KeyWords; //this.txtDescription.Text = model.Description; this.txtArticleText.Text = model.ArticleText; //this.txtASource.Text = model.Source; //this.txtLinkUrl.Text = model.LinkUrl; //this.ddlIsFrontPage.SelectedValue = model.IsFrontPage.HasValue ? (model.IsFrontPage.Value ? "1" : "0") : ""; //this.ddlIsHot.SelectedValue = model.IsHot.HasValue ? (model.IsHot.Value ? "1" : "0") : ""; //this.ddlSort.SelectedValue = model.SortRule.ToString(); //this.hdTitleColor.Value = model.TitleColor; //if (!string.IsNullOrEmpty(model.TitleColor)) //{ // this.txtArticleTitle.Attributes["style"] = string.Format("color:{0}", model.TitleColor); //} upload1.YuanFiles = new List <EyouSoft.Web.UserControl.MFileInfo>() { new EyouSoft.Web.UserControl.MFileInfo() { FileName = "附件", FilePath = model.ImgPath } }; if (dotype.Equals("show")) { this.ltClicks.Text = model.Click.ToString(); this.btn.Visible = false; } } } }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <param name="filedOrder">排序字段</param> /// <returns></returns> public IList<EyouSoft.Model.MTravelArticle> GetTopList(int Top, EyouSoft.Model.MTravelArticleCX chaXun, IList<EyouSoft.Model.TravelArticleOrderBy> FiledOrder) { IList<EyouSoft.Model.MTravelArticle> ResultList = null; string StrSql = string.Format("SELECT {0} ArticleID,Source,ArticleTitle,ImgPath,Description,ArticleText,ArticleTag,TitleColor,KeyWords,ClassId,(select top 1 ClassName,IsSystem from tbl_TravelArticleClass where ClassId=tbl_TravelArticle.ClassId for xml raw,root('Root')) as ClassName,IsFrontPage,IsHot,IssueTime,OperatorId,(select ContactName from tbl_User where UserID=tbl_TravelArticle.OperatorId) as OperatorName,LinkUrl,Click,SortRule FROM tbl_TravelArticle WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : "")); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.Source)) { StrSql = StrSql + string.Format(" AND Source like '%{0}%'", chaXun.Source); } if (!string.IsNullOrEmpty(chaXun.ArticleTitle)) { StrSql = StrSql + string.Format(" AND ArticleTitle like '%{0}%'", chaXun.ArticleTitle); } if (!string.IsNullOrEmpty(chaXun.KeyWords)) { StrSql = StrSql + string.Format(" AND KeyWords like '%{0}%'", chaXun.KeyWords); } if (!string.IsNullOrEmpty(chaXun.ArticleTag)) { StrSql = StrSql + string.Format(" AND ArticleTag like '%{0}%'", chaXun.ArticleTag); } if (chaXun.ClassId > 0) { StrSql = StrSql + string.Format(" AND ClassId={0}", chaXun.ClassId); } if (chaXun.IsFrontPage.HasValue) { StrSql = StrSql + string.Format(" AND IsFrontPage='{0}'", chaXun.IsFrontPage.Value ? 1 : 0); } if (chaXun.IsHot.HasValue) { StrSql = StrSql + string.Format(" AND IsHot='{0}'", chaXun.IsHot.Value ? 1 : 0); } if (chaXun.IssueTimeBegin != null) { StrSql = StrSql + string.Format(" AND IssueTime>='{0}' ", chaXun.IssueTimeBegin.Value.ToShortDateString() + " 00:00:00"); } if (chaXun.IssueTimeEnd != null) { StrSql = StrSql + string.Format(" AND IssueTime<='{0}' ", chaXun.IssueTimeEnd.Value.ToShortDateString() + " 23:59:59"); } if (!string.IsNullOrEmpty(chaXun.OperatorId)) { StrSql = StrSql + string.Format(" AND OperatorId='{0}'", chaXun.OperatorId); } if (chaXun.IsSystem != null && chaXun.IsSystem.Length > 0) { StrSql = StrSql + string.Format(" AND exists(select 1 from tbl_TravelArticleClass where ClassId=tbl_TravelArticle.ClassId and IsSystem in ({0})) ", Utils.GetSqlIn(chaXun.IsSystem)); } } string orderByString = ""; if (FiledOrder != null && FiledOrder.Count > 0) { for (int i = 0; i < FiledOrder.Count; i++) { orderByString += "," + FiledOrder[i].FiledOrder.ToString() + " " + FiledOrder[i].OrderBy.ToString(); } orderByString = orderByString.Substring(1); } else { orderByString = "SortRule DESC,IssueTime DESC"; } StrSql = StrSql + " ORDER BY " + orderByString; DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { ResultList = new List<EyouSoft.Model.MTravelArticle>(); while (dr.Read()) { EyouSoft.Model.MTravelArticle model = new EyouSoft.Model.MTravelArticle(); model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID")); model.Source = dr.IsDBNull(dr.GetOrdinal("Source")) ? "" : dr.GetString(dr.GetOrdinal("Source")); model.ArticleTitle = dr.IsDBNull(dr.GetOrdinal("ArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTitle")); model.ImgPath = dr.IsDBNull(dr.GetOrdinal("ImgPath")) ? "" : dr.GetString(dr.GetOrdinal("ImgPath")); model.Description = dr.IsDBNull(dr.GetOrdinal("Description")) ? "" : dr.GetString(dr.GetOrdinal("Description")); model.ArticleText = dr.IsDBNull(dr.GetOrdinal("ArticleText")) ? "" : dr.GetString(dr.GetOrdinal("ArticleText")); model.ArticleTag = dr.IsDBNull(dr.GetOrdinal("ArticleTag")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTag")); model.TitleColor = dr.IsDBNull(dr.GetOrdinal("TitleColor")) ? "" : dr.GetString(dr.GetOrdinal("TitleColor")); model.KeyWords = dr.IsDBNull(dr.GetOrdinal("KeyWords")) ? "" : dr.GetString(dr.GetOrdinal("KeyWords")); model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId")); model.IsFrontPage = dr.GetString(dr.GetOrdinal("IsFrontPage")) == "1" ? true : false; model.IsHot = dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false; model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName")) ? "" : dr.GetString(dr.GetOrdinal("OperatorName")); model.LinkUrl = dr.IsDBNull(dr.GetOrdinal("LinkUrl")) ? "" : dr.GetString(dr.GetOrdinal("LinkUrl")); model.Click = dr.IsDBNull(dr.GetOrdinal("Click")) ? 0 : dr.GetInt32(dr.GetOrdinal("Click")); model.SortRule = dr.IsDBNull(dr.GetOrdinal("SortRule")) ? 0 : dr.GetInt32(dr.GetOrdinal("SortRule")); if (!dr.IsDBNull(dr.GetOrdinal("ClassName"))) { this.GetClassBySqlXml(dr.GetString(dr.GetOrdinal("ClassName")), ref model); } ResultList.Add(model); model = null; } } return ResultList; }
/// <summary> /// 得到一个对象实体 /// </summary> public EyouSoft.Model.MTravelArticle GetModel(string ArticleID) { EyouSoft.Model.MTravelArticle model = null; string StrSql = "SELECT ArticleID,Source,ArticleTitle,ImgPath,Description,ArticleText,ArticleTag,TitleColor,KeyWords,ClassId,(select top 1 ClassName from tbl_TravelArticleClass where ClassId=tbl_TravelArticle.ClassId) as ClassName,IsFrontPage,IsHot,IssueTime,OperatorId,(select ContactName from tbl_User where UserID=tbl_TravelArticle.OperatorId) as OperatorName,LinkUrl,Click,SortRule FROM tbl_TravelArticle WHERE ArticleID=@ArticleID"; DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); this._db.AddInParameter(dc, "ArticleID", DbType.AnsiStringFixedLength, ArticleID); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new EyouSoft.Model.MTravelArticle(); model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID")); model.Source = dr.IsDBNull(dr.GetOrdinal("Source")) ? "" : dr.GetString(dr.GetOrdinal("Source")); model.ArticleTitle = dr.IsDBNull(dr.GetOrdinal("ArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTitle")); model.ImgPath = dr.IsDBNull(dr.GetOrdinal("ImgPath")) ? "" : dr.GetString(dr.GetOrdinal("ImgPath")); model.Description = dr.IsDBNull(dr.GetOrdinal("Description")) ? "" : dr.GetString(dr.GetOrdinal("Description")); model.ArticleText = dr.IsDBNull(dr.GetOrdinal("ArticleText")) ? "" : dr.GetString(dr.GetOrdinal("ArticleText")); model.ArticleTag = dr.IsDBNull(dr.GetOrdinal("ArticleTag")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTag")); model.TitleColor = dr.IsDBNull(dr.GetOrdinal("TitleColor")) ? "" : dr.GetString(dr.GetOrdinal("TitleColor")); model.KeyWords = dr.IsDBNull(dr.GetOrdinal("KeyWords")) ? "" : dr.GetString(dr.GetOrdinal("KeyWords")); model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId")); model.ClassName = dr.IsDBNull(dr.GetOrdinal("ClassName")) ? "" : dr.GetString(dr.GetOrdinal("ClassName")); model.IsFrontPage = dr.GetString(dr.GetOrdinal("IsFrontPage")) == "1" ? true : false; model.IsHot = dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false; model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName")) ? "" : dr.GetString(dr.GetOrdinal("OperatorName")); model.LinkUrl = dr.IsDBNull(dr.GetOrdinal("LinkUrl")) ? "" : dr.GetString(dr.GetOrdinal("LinkUrl")); model.Click = dr.IsDBNull(dr.GetOrdinal("Click")) ? 0 : dr.GetInt32(dr.GetOrdinal("Click")); model.SortRule = dr.IsDBNull(dr.GetOrdinal("SortRule")) ? 0 : dr.GetInt32(dr.GetOrdinal("SortRule")); } }; return model; }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <param name="filedOrder">排序字段</param> /// <returns></returns> public IList<EyouSoft.Model.MTravelArticle> GetList(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MTravelArticleCX chaXun, IList<EyouSoft.Model.TravelArticleOrderBy> FiledOrder) { IList<EyouSoft.Model.MTravelArticle> ResultList = null; string tableName = "tbl_TravelArticle"; StringBuilder fields = new StringBuilder(); fields.Append("ArticleID,Source,ArticleTitle,ImgPath,Description,ArticleText,ArticleTag,TitleColor,KeyWords,ClassId,IsFrontPage,IsHot,IssueTime,OperatorId,LinkUrl,Click,SortRule,"); fields.Append("(select top 1 ClassName,IsSystem from tbl_TravelArticleClass where ClassId=tbl_TravelArticle.ClassId for xml raw,root('Root')) as ClassName,(select ContactName from tbl_User where UserID=tbl_TravelArticle.OperatorId) as OperatorName"); string query = " 1=1 "; if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.Source)) { query = query + string.Format(" AND Source like '%{0}%'", chaXun.Source); } if (!string.IsNullOrEmpty(chaXun.ArticleTitle)) { query = query + string.Format(" AND ArticleTitle like '%{0}%'", chaXun.ArticleTitle); } if (!string.IsNullOrEmpty(chaXun.KeyWords)) { query = query + string.Format(" AND KeyWords like '%{0}%'", chaXun.KeyWords); } if (!string.IsNullOrEmpty(chaXun.ArticleTag)) { query = query + string.Format(" AND ArticleTag like '%{0}%'", chaXun.ArticleTag); } if (chaXun.ClassId > 0) { query = query + string.Format(" AND ClassId={0}", chaXun.ClassId); } if (chaXun.IsFrontPage.HasValue) { query = query + string.Format(" AND IsFrontPage='{0}'", chaXun.IsFrontPage.Value ? 1 : 0); } if (chaXun.IsHot.HasValue) { query = query + string.Format(" AND IsHot='{0}'", chaXun.IsHot.Value ? 1 : 0); } if (chaXun.IssueTimeBegin != null) { query = query + string.Format(" AND IssueTime>='{0}' ", chaXun.IssueTimeBegin.Value.ToShortDateString() + " 00:00:00"); } if (chaXun.IssueTimeEnd != null) { query = query + string.Format(" AND IssueTime<='{0}' ", chaXun.IssueTimeEnd.Value.ToShortDateString() + " 23:59:59"); } if (!string.IsNullOrEmpty(chaXun.OperatorId)) { query = query + string.Format(" AND OperatorId='{0}'", chaXun.OperatorId); } if (chaXun.IsSystem != null && chaXun.IsSystem.Length > 0) { query = query + string.Format(" AND exists(select 1 from tbl_TravelArticleClass where ClassId=tbl_TravelArticle.ClassId and IsSystem in ({0})) ", Utils.GetSqlIn(chaXun.IsSystem)); } if (!string.IsNullOrEmpty(chaXun.OperatorName)) { query = query + string.Format(" AND exists(select 1 from tbl_User where UserID=tbl_TravelArticle.OperatorId and ContactName like '%{0}%') ", chaXun.OperatorName); } if (chaXun.ZXtype != null && chaXun.ZXtype.Length > 0) { query = query + string.Format(" AND ClassId IN (select ClassId from tbl_TravelArticleClass where ClassName in ({0})) ", Utils.GetSqlIn(chaXun.ZXtype)); } } string orderByString = ""; if (FiledOrder != null && FiledOrder.Count > 0) { for (int i = 0; i < FiledOrder.Count; i++) { orderByString += "," + FiledOrder[i].FiledOrder.ToString() + " " + FiledOrder[i].OrderBy.ToString(); } orderByString = orderByString.Substring(1); } else { orderByString = "SortRule DESC,IssueTime DESC"; } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), query, orderByString, null)) { ResultList = new List<EyouSoft.Model.MTravelArticle>(); while (dr.Read()) { EyouSoft.Model.MTravelArticle model = new EyouSoft.Model.MTravelArticle(); model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID")); model.Source = dr.IsDBNull(dr.GetOrdinal("Source")) ? "" : dr.GetString(dr.GetOrdinal("Source")); model.ArticleTitle = dr.IsDBNull(dr.GetOrdinal("ArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTitle")); model.ImgPath = dr.IsDBNull(dr.GetOrdinal("ImgPath")) ? "" : dr.GetString(dr.GetOrdinal("ImgPath")); model.Description = dr.IsDBNull(dr.GetOrdinal("Description")) ? "" : dr.GetString(dr.GetOrdinal("Description")); model.ArticleText = dr.IsDBNull(dr.GetOrdinal("ArticleText")) ? "" : dr.GetString(dr.GetOrdinal("ArticleText")); model.ArticleTag = dr.IsDBNull(dr.GetOrdinal("ArticleTag")) ? "" : dr.GetString(dr.GetOrdinal("ArticleTag")); model.TitleColor = dr.IsDBNull(dr.GetOrdinal("TitleColor")) ? "" : dr.GetString(dr.GetOrdinal("TitleColor")); model.KeyWords = dr.IsDBNull(dr.GetOrdinal("KeyWords")) ? "" : dr.GetString(dr.GetOrdinal("KeyWords")); model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId")); model.IsFrontPage = dr.GetString(dr.GetOrdinal("IsFrontPage")) == "1" ? true : false; model.IsHot = dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false; model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName")) ? "" : dr.GetString(dr.GetOrdinal("OperatorName")); model.LinkUrl = dr.IsDBNull(dr.GetOrdinal("LinkUrl")) ? "" : dr.GetString(dr.GetOrdinal("LinkUrl")); model.Click = dr.IsDBNull(dr.GetOrdinal("Click")) ? 0 : dr.GetInt32(dr.GetOrdinal("Click")); model.SortRule = dr.IsDBNull(dr.GetOrdinal("SortRule")) ? 0 : dr.GetInt32(dr.GetOrdinal("SortRule")); if (!dr.IsDBNull(dr.GetOrdinal("ClassName"))) { this.GetClassBySqlXml(dr.GetString(dr.GetOrdinal("ClassName")), ref model); } ResultList.Add(model); model = null; } }; return ResultList; }
/// <summary> /// 保存或修改信息 /// </summary> private string PageSave(string id, string dotype) { //t为true 新增,false 修改 bool t = string.IsNullOrEmpty(id) && dotype == "add"; string msg = string.Empty; EyouSoft.BLL.OtherStructure.BTravelArticle bll = new EyouSoft.BLL.OtherStructure.BTravelArticle(); EyouSoft.Model.MTravelArticle model = new EyouSoft.Model.MTravelArticle(); model.ArticleTitle = Utils.GetFormValue(this.txtArticleTitle.UniqueID); model.ClassId = Utils.GetInt(Utils.GetFormValue(this.ddlClassId.UniqueID)); //model.ArticleTag = Utils.GetFormValue(this.txtArticleTag.UniqueID); //model.KeyWords = Utils.GetFormValue(this.txtKeyWords.UniqueID); //model.Description = Utils.GetFormValue(this.txtDescription.UniqueID); model.ArticleText = Utils.GetFormValue(this.txtArticleText.UniqueID); //model.Source = Utils.GetFormValue(this.txtASource.UniqueID); //model.LinkUrl = Utils.GetFormValue(this.txtLinkUrl.UniqueID); model.IsFrontPage = false; model.IsFrontPage = false; model.IsHot = false; ; //model.SortRule = Utils.GetInt(Utils.GetFormValue(this.ddlSort.UniqueID)); //model.TitleColor = Utils.GetFormValue(this.hdTitleColor.UniqueID); var newFiles = upload1.Files; if (newFiles == null || !newFiles.Any()) { var oldFiles = upload1.YuanFiles; if (oldFiles != null && oldFiles.Any()) { model.ImgPath = oldFiles[0].FilePath; } else { model.ImgPath = string.Empty; } } else { model.ImgPath = newFiles[0].FilePath; } model.IssueTime = DateTime.Now; model.OperatorId = userinfo.UserId; bool result = false; if (t) { result = bll.Add(model); } else { model.ArticleID = id; result = bll.Update(model); } switch (result) { case true: msg = Utils.AjaxReturnJson("1", (t ? "新增" : "修改") + "成功"); break; case false: msg = Utils.AjaxReturnJson("0", (t ? "新增" : "修改") + "失败"); break; default: break; } return msg; }
/// <summary> /// 保存或修改信息 /// </summary> private string PageSave(string id, string dotype) { //t为true 新增,false 修改 bool t = string.IsNullOrEmpty(id) && dotype == "add"; string msg = string.Empty; EyouSoft.BLL.OtherStructure.BTravelArticle bll = new EyouSoft.BLL.OtherStructure.BTravelArticle(); EyouSoft.Model.MTravelArticle model = new EyouSoft.Model.MTravelArticle(); model.ArticleTitle = Utils.GetFormValue(this.txtArticleTitle.UniqueID); model.ClassId = Utils.GetInt(Utils.GetFormValue(this.ddlClassId.UniqueID)); //model.ArticleTag = Utils.GetFormValue(this.txtArticleTag.UniqueID); //model.KeyWords = Utils.GetFormValue(this.txtKeyWords.UniqueID); //model.Description = Utils.GetFormValue(this.txtDescription.UniqueID); model.ArticleText = Utils.GetFormValue(this.txtArticleText.UniqueID); //model.Source = Utils.GetFormValue(this.txtASource.UniqueID); //model.LinkUrl = Utils.GetFormValue(this.txtLinkUrl.UniqueID); model.IsFrontPage = false; model.IsFrontPage = false; model.IsHot = false;; //model.SortRule = Utils.GetInt(Utils.GetFormValue(this.ddlSort.UniqueID)); //model.TitleColor = Utils.GetFormValue(this.hdTitleColor.UniqueID); var newFiles = upload1.Files; if (newFiles == null || !newFiles.Any()) { var oldFiles = upload1.YuanFiles; if (oldFiles != null && oldFiles.Any()) { model.ImgPath = oldFiles[0].FilePath; } else { model.ImgPath = string.Empty; } } else { model.ImgPath = newFiles[0].FilePath; } model.IssueTime = DateTime.Now; model.OperatorId = userinfo.UserId; bool result = false; if (t) { result = bll.Add(model); } else { model.ArticleID = id; result = bll.Update(model); } switch (result) { case true: msg = Utils.AjaxReturnJson("1", (t ? "新增" : "修改") + "成功"); break; case false: msg = Utils.AjaxReturnJson("0", (t ? "新增" : "修改") + "失败"); break; default: break; } return(msg); }