/// <summary>儲存系統參數資料</summary>
public static bool SaveSysParamsInfo(SysParamsDetailViewModel m)
{
//開啟資料庫存取物件
using (var db = new DataBase.DataBase(Definition.Conn))
{
//資料庫參數
var param = new DataBase.SqlParams();
param.Add("ParaCode", m.ParaCode);
param.Add("ParaValue", m.ParaValue);
param.Add("ParaDesc", m.ParaDesc);
db.SqlParams = param;
if (m.Action == "Add")
{
//驗証系統代碼是否重覆
var dtParams = GetSysParams(m.ParaCode, null, new Pages());
if (dtParams.Rows.Count > 0)
{
throw new Exception("已有重覆的系統代碼");
}
//新增系統參數
db.StrSQL = "INSERT [SysParams](ParaCode, ParaValue, ParaDesc) VALUES(@ParaCode, @ParaValue, @ParaDesc);";
}
else
{
//修改系統參數
db.StrSQL = "UPDATE [SysParams] SET ParaValue = @ParaValue, ParaDesc = @ParaDesc WHERE ParaCode = @ParaCode;";
}
int iResult = db.ExecuteSQL();
return(iResult > 0);
}
}
public ActionResult Add()
{
try
{
//初始化物件
var m = new SysParamsDetailViewModel();
m.Action = "Add";
return(View("Detail", m));
}
catch
{
return(RedirectToAction("Error", "Home"));
}
}
public JsonResult Save(SysParamsDetailViewModel m)
{
Result r = new Result();
try
{
SysParamsDataAccess.SaveSysParamsInfo(m);
r.Set(ResultCode.Success, "作業成功");
}
catch (Exception e)
{
r.Set(ResultCode.Error, e.Message);
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(string id)
{
try
{
//初始化物件
var m = new SysParamsDetailViewModel();
//取得系統參數資料
var dtParams = SysParamsDataAccess.GetSysParams(id, null, new Pages());
var listParams = Util.ToList <SysParamsDetailViewModel>(dtParams);
m = listParams[0];
m.Action = "Edit";
return(View("Detail", m));
}
catch
{
return(RedirectToAction("Error", "Home"));
}
}
