/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.Article GetModel(long ArticleID) { XCLCMS.Data.Model.Article model = new XCLCMS.Data.Model.Article(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand("select * from Article WITH(NOLOCK) where ArticleID=@ArticleID"); db.AddInParameter(dbCommand, "ArticleID", DbType.Int64, ArticleID); using (var dr = db.ExecuteReader(dbCommand)) { return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.Article>(dr)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.Article GetModel(long ArticleID) { XCLCMS.Data.Model.Article model = new XCLCMS.Data.Model.Article(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand("select * from Article where ArticleID=@ArticleID"); db.AddInParameter(dbCommand, "ArticleID", DbType.Int64, ArticleID); DataSet ds = db.ExecuteDataSet(dbCommand); var lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.Article>(ds.Tables[0]); return(null != lst && lst.Count > 0 ? lst[0] : null); }
public async Task <APIResponseEntity <bool> > IsExistCode([FromUri] APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.Article.IsExistCodeEntity> request) { return(await Task.Run(() => { #region 初始化 var response = new APIResponseEntity <bool>() { IsSuccess = true, Message = "该唯一标识可以使用!" }; request.Body.Code = (request.Body.Code ?? "").Trim(); XCLCMS.Data.Model.Article model = null; #endregion 初始化 #region 数据校验 if (string.IsNullOrEmpty(request.Body.Code)) { response.Message = "请指定Code参数!"; response.IsSuccess = false; return response; } #endregion 数据校验 #region 构建response if (request.Body.ArticleID > 0) { model = articleBLL.GetModel(request.Body.ArticleID); if (null != model && string.Equals(request.Body.Code, model.Code, StringComparison.OrdinalIgnoreCase)) { return response; } } if (articleBLL.IsExistCode(request.Body.Code)) { response.IsSuccess = false; response.Message = "该唯一标识已被占用!"; return response; } return response; #endregion 构建response })); }
public APIResponseEntity <bool> IsExistCode([FromUri] string json) { #region 初始化 var request = Newtonsoft.Json.JsonConvert.DeserializeObject <APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.Article.IsExistCodeEntity> >(System.Web.HttpUtility.UrlDecode(json)); var response = new APIResponseEntity <bool>() { IsSuccess = true, Message = "该唯一标识可以使用!" }; request.Body.Code = (request.Body.Code ?? "").Trim(); XCLCMS.Data.Model.Article model = null; #endregion 初始化 #region 数据校验 if (string.IsNullOrEmpty(request.Body.Code)) { response.Message = "请指定Code参数!"; response.IsSuccess = false; return(response); } #endregion 数据校验 #region 构建response if (request.Body.ArticleID > 0) { model = articleBLL.GetModel(request.Body.ArticleID); if (null != model && string.Equals(request.Body.Code, model.Code, StringComparison.OrdinalIgnoreCase)) { return(response); } } if (articleBLL.IsExistCode(request.Body.Code)) { response.IsSuccess = false; response.Message = "该唯一标识已被占用!"; return(response); } return(response); #endregion 构建response }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLCMS.Data.Model.Article model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(XCLCMS.Data.Model.Article model) { return(dal.Add(model)); }
public override ActionResult UpdateSubmit(FormCollection fm) { XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel(); var viewModel = this.GetViewModel(fm); var model = new XCLCMS.Data.Model.Article(); model.ArticleID = viewModel.Article.ArticleID; model.RecordState = viewModel.Article.RecordState; model.ArticleContentType = viewModel.Article.ArticleContentType; model.ArticleState = viewModel.Article.ArticleState; model.AuthorName = viewModel.Article.AuthorName; model.BadCount = viewModel.Article.BadCount; if (string.IsNullOrWhiteSpace(viewModel.Article.Code)) { model.Code = model.ArticleID.ToString(); } else { model.Code = viewModel.Article.Code; } model.CommentCount = viewModel.Article.CommentCount; model.Comments = viewModel.Article.Comments; model.Contents = viewModel.Article.Contents; model.FromInfo = viewModel.Article.FromInfo; model.GoodCount = viewModel.Article.GoodCount; model.HotCount = viewModel.Article.HotCount; model.IsCanComment = viewModel.Article.IsCanComment; model.IsEssence = viewModel.Article.IsEssence; model.IsRecommend = viewModel.Article.IsRecommend; model.IsTop = viewModel.Article.IsTop; model.KeyWords = viewModel.Article.KeyWords; model.LinkUrl = viewModel.Article.LinkUrl; model.MainImage1 = viewModel.Article.MainImage1; model.MainImage2 = viewModel.Article.MainImage2; model.MainImage3 = viewModel.Article.MainImage3; model.MiddleCount = viewModel.Article.MiddleCount; model.PublishTime = viewModel.Article.PublishTime; model.SubTitle = viewModel.Article.SubTitle; model.Summary = viewModel.Article.Summary; model.Tags = viewModel.Article.Tags; model.Title = viewModel.Article.Title; model.TopBeginTime = viewModel.Article.TopBeginTime; model.TopEndTime = viewModel.Article.TopEndTime; model.UpdaterID = base.UserID; model.UpdaterName = base.CurrentUserModel.UserName; model.UpdateTime = DateTime.Now; model.URLOpenType = viewModel.Article.URLOpenType; model.VerifyState = viewModel.Article.VerifyState; model.ViewCount = viewModel.Article.ViewCount; model.FK_MerchantAppID = viewModel.Article.FK_MerchantAppID; model.FK_MerchantID = viewModel.Article.FK_MerchantID; var request = XCLCMS.Lib.WebAPI.Library.CreateRequest <XCLCMS.Data.WebAPIEntity.RequestEntity.Article.AddOrUpdateEntity>(base.UserToken); request.Body = new Data.WebAPIEntity.RequestEntity.Article.AddOrUpdateEntity(); request.Body.Article = model; request.Body.ArticleAttachmentIDList = viewModel.AttachmentIDList; request.Body.ArticleTypeIDList = viewModel.ArticleTypeIDList; var response = XCLCMS.Lib.WebAPI.ArticleAPI.Update(request); return(Json(response)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLCMS.Data.Model.Article model) { Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("sp_Article_Update"); db.AddInParameter(dbCommand, "ArticleID", DbType.Int64, model.ArticleID); db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code); db.AddInParameter(dbCommand, "Title", DbType.String, model.Title); db.AddInParameter(dbCommand, "SubTitle", DbType.String, model.SubTitle); db.AddInParameter(dbCommand, "AuthorName", DbType.String, model.AuthorName); db.AddInParameter(dbCommand, "FromInfo", DbType.String, model.FromInfo); db.AddInParameter(dbCommand, "ArticleContentType", DbType.AnsiString, model.ArticleContentType); db.AddInParameter(dbCommand, "Contents", DbType.String, model.Contents); db.AddInParameter(dbCommand, "Summary", DbType.String, model.Summary); db.AddInParameter(dbCommand, "MainImage1", DbType.Int64, model.MainImage1); db.AddInParameter(dbCommand, "MainImage2", DbType.Int64, model.MainImage2); db.AddInParameter(dbCommand, "MainImage3", DbType.Int64, model.MainImage3); db.AddInParameter(dbCommand, "ViewCount", DbType.Int32, model.ViewCount); db.AddInParameter(dbCommand, "IsCanComment", DbType.AnsiString, model.IsCanComment); db.AddInParameter(dbCommand, "CommentCount", DbType.Int32, model.CommentCount); db.AddInParameter(dbCommand, "GoodCount", DbType.Int32, model.GoodCount); db.AddInParameter(dbCommand, "MiddleCount", DbType.Int32, model.MiddleCount); db.AddInParameter(dbCommand, "BadCount", DbType.Int32, model.BadCount); db.AddInParameter(dbCommand, "HotCount", DbType.Int32, model.HotCount); db.AddInParameter(dbCommand, "URLOpenType", DbType.AnsiString, model.URLOpenType); db.AddInParameter(dbCommand, "ArticleState", DbType.AnsiString, model.ArticleState); db.AddInParameter(dbCommand, "VerifyState", DbType.AnsiString, model.VerifyState); db.AddInParameter(dbCommand, "IsRecommend", DbType.AnsiString, model.IsRecommend); db.AddInParameter(dbCommand, "IsEssence", DbType.AnsiString, model.IsEssence); db.AddInParameter(dbCommand, "IsTop", DbType.AnsiString, model.IsTop); db.AddInParameter(dbCommand, "TopBeginTime", DbType.DateTime, model.TopBeginTime); db.AddInParameter(dbCommand, "TopEndTime", DbType.DateTime, model.TopEndTime); db.AddInParameter(dbCommand, "KeyWords", DbType.String, model.KeyWords); db.AddInParameter(dbCommand, "Tags", DbType.String, model.Tags); db.AddInParameter(dbCommand, "Comments", DbType.String, model.Comments); db.AddInParameter(dbCommand, "LinkUrl", DbType.AnsiString, model.LinkUrl); db.AddInParameter(dbCommand, "PublishTime", DbType.DateTime, model.PublishTime); db.AddInParameter(dbCommand, "FK_MerchantID", DbType.Int64, model.FK_MerchantID); db.AddInParameter(dbCommand, "FK_MerchantAppID", DbType.Int64, model.FK_MerchantAppID); db.AddInParameter(dbCommand, "RecordState", DbType.AnsiString, model.RecordState); db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime); db.AddInParameter(dbCommand, "CreaterID", DbType.Int64, model.CreaterID); db.AddInParameter(dbCommand, "CreaterName", DbType.String, model.CreaterName); db.AddInParameter(dbCommand, "UpdateTime", DbType.DateTime, model.UpdateTime); db.AddInParameter(dbCommand, "UpdaterID", DbType.Int64, model.UpdaterID); db.AddInParameter(dbCommand, "UpdaterName", DbType.String, model.UpdaterName); db.AddOutParameter(dbCommand, "ResultCode", DbType.Int32, 4); db.AddOutParameter(dbCommand, "ResultMessage", DbType.String, 1000); db.ExecuteNonQuery(dbCommand); var result = XCLCMS.Data.DAL.Common.Common.GetProcedureResult(dbCommand.Parameters); if (result.IsSuccess) { return(true); } else { throw new Exception(result.ResultMessage); } }