/// <summary>
/// 修改参数
/// </summary>
public bool UpdateParameter(RouterParameter model)
{
var dal = new DalRouter();
using (var connection = ProcessConnection.OpenGungnir)
{
return(dal.UpdateParameter(connection, model));
}
}
/// <summary>
/// 修改参数
/// </summary>
public bool UpdateParameter(SqlConnection connection, RouterParameter model)
{
var sql = @"UPDATE Configuration.dbo.RouterParameter SET
Content=@Content ,
Discription=@Discription ,
UpdateDateTime=GetDate(),
Kind=@Kind,
LinkKind=@LinkKind
WHERE PKID=@PKID";
return(connection.Execute(sql, model) > 0);
}
/// <summary>
/// 新建参数
/// </summary>
public bool AddParameter(SqlConnection connection, RouterParameter model)
{
var sql = @"INSERT INTO Configuration.dbo.RouterParameter
( CreateDateTime ,
UpdateDateTime ,
[Content],
Discription,
Kind,
LinkKind
)
VALUES ( GETDATE() , -- CreateDateTime - datetime
GETDATE() , -- UpdateDateTime - datetime
@Content, -- Content - varchar(1000)
@Discription, -- Discription - varchar(100)
@Kind, -- Kind - int
@LinkKind -- LinkKind - int
)";
return(connection.Execute(sql, model) > 0);
}
/// <summary>
/// 保存参数的新增或修改操作
/// </summary>
public ActionResult ParameterSave(RouterParameter model)
{
RouterConfigManager manger = new RouterConfigManager();
if (model.PKID == 0)
{
if (manger.AddParameter(model))
{
LoggerManager.InsertOplog(new ConfigHistory()
{
AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, BeforeValue = "", ChangeDatetime = DateTime.Now, ObjectID = model.PKID.ToString(), ObjectType = "Parameter", Operation = "新增参数配置" + model.Discription
});
return(Json(1));
}
else
{
return(Json(0));
}
}
else
{
var before = manger.GetParameter(model.PKID);
if (manger.UpdateParameter(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 = "Parameter", Operation = "编辑参数配置" + model.Discription
});
return(Json(1));
}
else
{
return(Json(0));
}
}
}
