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