/// <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));
}
}
}
