public string UpdateColumnCRUDData(ColumnCRUDDataModel columnCRUDDataModel)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始修改一筆ColumnCRUD資料", columnCRUDDataModel, null);
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDDataModel.Id
select column).FirstOrDefault();
//查無資料，修改失敗
if (columnCRUD == null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "查無無該筆資料需要修改的資料", columnCRUDDataModel.Id, null);
return("查無此修改資料，請確認人員編號是否異動或刪除");
}
_db.ColumnCRUD.Attach(columnCRUD);
columnCRUD.Address = columnCRUDDataModel.Address;
columnCRUD.Name = columnCRUDDataModel.Name;
columnCRUD.Sex = columnCRUDDataModel.Sex;
columnCRUD.Tel = columnCRUDDataModel.Tel;
columnCRUD.Type = columnCRUDDataModel.Type;
columnCRUD.Upuser = "******";
columnCRUD.Updatetime = DateTime.Now;
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "修改一筆ColumnCRUD資料結束", columnCRUDDataModel.Id, null);
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public string UpdateColumnCRUDData(ColumnCRUDDataModel columnCRUDDataModel)
{
try
{
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDDataModel.Id
select column).FirstOrDefault();
//查無資料，修改失敗
if (columnCRUD == null)
{
return("查無此修改資料，請確認人員編號是否異動或刪除");
}
_db.ColumnCRUD.Attach(columnCRUD);
columnCRUD.Address = columnCRUDDataModel.Address;
columnCRUD.Name = columnCRUDDataModel.Name;
columnCRUD.Sex = columnCRUDDataModel.Sex;
columnCRUD.Tel = columnCRUDDataModel.Tel;
columnCRUD.Type = columnCRUDDataModel.Type;
columnCRUD.Upuser = "******";
columnCRUD.Updatetime = DateTime.Now;
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
/// <summary>
/// 新增或修改資料
/// </summary>
/// <returns></returns>
public JsonResult UpdateColumnCRUDData(ColumnCRUDDataModel columnCRUDDataModel)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(columnCRUDDataModel.Id))
{
return(Json(new { result = "false" }));
}
var result = _service.UpdateColumnCRUDData(columnCRUDDataModel);
return(Json(new { result = result }));
}
catch (Exception ex)
{
return(Json(new { result = "false" }));
}
}
/// <summary>
/// 新增或修改資料
/// </summary>
/// <returns></returns>
public JsonResult UpdateColumnCRUDData(ColumnCRUDDataModel columnCRUDDataModel)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(columnCRUDDataModel.Id))
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_NullException, LogManagement.SystemName.基本作業, "傳入修改ColumnCRUD參數的Pkey為Null", columnCRUDDataModel, null);
return(Json(new { result = "false" }));
}
Log.LogInfoWriter(userName, LogManagement.LogType.OP, LogManagement.EventLevel.Info, LogManagement.LogAction.USER_Action_Update, LogManagement.SystemName.基本作業, "使用者修改一筆ColumnCRUD資料", columnCRUDDataModel, null);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始修改一筆ColumnCRUD資料", columnCRUDDataModel, null);
var result = _service.UpdateColumnCRUDData(columnCRUDDataModel);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "修改一筆ColumnCRUD資料結束", columnCRUDDataModel, null);
return(Json(new { result = result }));
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "修改一筆ColumnCRUD資料發生錯誤", columnCRUDDataModel, ex);
return(Json(new { result = "false" }));
}
}
