/// <summary> /// 新建全品类分类 /// </summary> public bool AddConfig(SqlConnection connection, AllSortConfig model) { var sql = @"INSERT INTO Configuration.dbo.AllSortConfig ( CreateDateTime , UpdateDateTime , Maintitle , StartVersion , EndVersion , Priority , State , MaintitleColor , [Statistics] , StartTime , EndTime ) VALUES ( GETDATE() , -- CreateDateTime - datetime GETDATE() , -- UpdateDateTime - datetime @Maintitle, -- Maintitle - varchar(100) @StartVersion , -- StartVersion - varchar(50) @EndVersion , -- EndVersion - varchar(50) @Priority , -- Priority - int @State , -- State - bit @MaintitleColor , -- MaintitleColor - varchar(50) @Statistics , -- [Statistics] - varchar(100) @StartTime , -- StartTime - datetime @EndTime -- EndTime - datetime )"; return(connection.Execute(sql, model) > 0); }
/// <summary> /// 新建全品类分类 /// </summary> public bool AddConfig(AllSortConfig model) { var dal = new DalSort(); using (var connection = ProcessConnection.OpenGungnir) { return(dal.AddConfig(connection, model)); } }
/// <summary> /// 修改全品类分类 /// </summary> public bool UpdateEntity(SqlConnection connection, AllSortConfig model) { var sql = @"UPDATE Configuration.dbo.AllSortConfig SET Maintitle=@Maintitle , StartVersion=@StartVersion , EndVersion=@EndVersion , Priority=@Priority , State=@State , MaintitleColor=@MaintitleColor , [Statistics]=@Statistics , StartTime=@StartTime , EndTime=@EndTime, UpdateDateTime=GetDate() WHERE PKID=@PKID"; return(connection.Execute(sql, model) > 0); }
/// <summary> /// 保存全品类分类栏目的新增或修改操作 /// </summary> public ActionResult ConfigSave(AllSortConfig model) { AllSortManager manger = new AllSortManager(); if (model.PKID == 0) { if (manger.AddConfig(model)) { LoggerManager.InsertOplog(new ConfigHistory() { AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, BeforeValue = "", ChangeDatetime = DateTime.Now, ObjectID = model.PKID.ToString(), ObjectType = "AllSort", Operation = "新增全品类分类配置" + model.Maintitle }); return(Json(1)); } else { return(Json(0)); } } else { var before = manger.GetEntity(model.PKID); if (manger.UpdateConfig(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 = "AllSort", Operation = "编辑全品类分类配置" + model.Maintitle }); return(Json(1)); } else { return(Json(0)); } } }