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