/// <summary> /// 修改全品类内容 /// </summary> public bool UpdateListConfig(AllSortListConfig model) { var dal = new DalSort(); using (var connection = ProcessConnection.OpenGungnir) { return(dal.UpdateListEntity(connection, model)); } }
/// <summary> /// 新建全品类内容 /// </summary> public bool AddListConfig(SqlConnection connection, AllSortListConfig model) { var sql = @"INSERT INTO Configuration.dbo.AllSortListConfig ( CreateDateTime , UpdateDateTime , Title, State , TitleColor , TitleBgColor , StartVersion , EndVersion , ButtonImage , BannerImage , JumpUrl , XiaoJumpUrl, Priority, [Statistics], StartTime , EndTime, ParentId ) VALUES ( GETDATE() , -- CreateDateTime - datetime GETDATE() , -- UpdateDateTime - datetime @Title, -- Title - varchar(100) @State , -- State - int @TitleColor , -- TitleColor - varchar(50) @TitleBgColor , -- TitleBgColor - varchar(50) @StartVersion , -- StartVersion - varchar(50) @EndVersion , -- EndVersion - varchar(50) @ButtonImage , -- ButtonImage - varchar(1000) @BannerImage , -- BannerImage - varchar(1000) @JumpUrl , -- JumpUrl - varchar(1000) @XiaoJumpUrl , -- XiaoJumpUrl - varchar(1000) @Priority, -- Priority - int @Statistics , -- [Statistics] - varchar(100) @StartTime , -- StartTime - datetime @EndTime, -- EndTime - datetime @ParentId -- ParentId - int )"; return(connection.Execute(sql, model) > 0); }
/// <summary> /// 修改全品类内容 /// </summary> public bool UpdateListEntity(SqlConnection connection, AllSortListConfig model) { var sql = @"UPDATE Configuration.dbo.AllSortListConfig SET Title=@Title, State=@State , TitleColor=@TitleColor , TitleBgColor=@TitleBgColor , StartVersion=@StartVersion , EndVersion=@EndVersion , ButtonImage=@ButtonImage , BannerImage=@BannerImage , JumpUrl=@JumpUrl , XiaoJumpUrl=@XiaoJumpUrl , Priority=@Priority, [Statistics]=@Statistics , StartTime=@StartTime , EndTime=@EndTime, ParentId=@ParentId , UpdateDateTime=GetDate() WHERE PKID=@PKID"; return(connection.Execute(sql, model) > 0); }
/// <summary> /// 保存内容栏的新增或修改操作 /// </summary> public ActionResult ConfigListSave(AllSortListConfig model) { AllSortManager manger = new AllSortManager(); if (model.PKID == 0) { if (manger.AddListConfig(model)) { LoggerManager.InsertOplog(new ConfigHistory() { AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, BeforeValue = "", ChangeDatetime = DateTime.Now, ObjectID = model.PKID.ToString(), ObjectType = "SortList", Operation = "新增内容栏配置" + model.Title }); return(Json(1)); } else { return(Json(0)); } } else { var title = ""; var before = manger.GetListEntity(model.PKID, title); if (manger.UpdateListConfig(model)) { LoggerManager.InsertOplog(new ConfigHistory() { AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, BeforeValue = JsonConvert.SerializeObject(before), ChangeDatetime = DateTime.Now, ObjectID = model.PKID.ToString(), ObjectType = "SortList", Operation = "编辑内容栏配置" + model.Title }); return(Json(1)); } else { return(Json(0)); } } }