public string InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆ColumnCRUD資料", columnCRUDData, null);
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDData.Id
select column).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (columnCRUD != null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增到重複PKey的ColumnCRUD資料，取消新增動作", columnCRUDData.Id, null);
return("新增到重複ColumnCRUD資料，新增失敗");
}
columnCRUDData.Upuser = "******";
columnCRUDData.Updatetime = DateTime.Now;
columnCRUDData.Cruser = "******";
columnCRUDData.Crdatetime = DateTime.Now;
_db.ColumnCRUD.Add(columnCRUDData);
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料結束", columnCRUDData.Id, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料，發生錯誤", columnCRUDData, ex);
return("false");
}
}
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 DeleteColumnCRUDData(string pid)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始刪除一筆ColumnCRUD資料", pid, null);
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == pid
select column).FirstOrDefault();
//查無資料，修改失敗
if (columnCRUD == null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "查無該筆資料需要修改的資料", pid, null);
return("查無此刪除資料，請確認人員編號是否異動或已刪除");
}
_db.ColumnCRUD.Remove(columnCRUD);
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "刪除一筆ColumnCRUD資料結束", pid, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "刪除一筆ColumnCRUD資料，發生錯誤", pid, 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");
}
}
public string InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == columnCRUDData.Id
select column).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (columnCRUD != null)
{
return("新增到重複ColumnCRUD資料，新增失敗");
}
columnCRUDData.Upuser = "******";
columnCRUDData.Updatetime = DateTime.Now;
columnCRUDData.Cruser = "******";
columnCRUDData.Crdatetime = DateTime.Now;
_db.ColumnCRUD.Add(columnCRUDData);
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
/// <summary>
/// 新增或資料
/// </summary>
/// <returns></returns>
public JsonResult InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(columnCRUDData.Id))
{
return(Json(new { result = "人員代號為必填欄位" }));
}
var result = _service.InsertColumnCRUDData(columnCRUDData);
return(Json(new { result = result }));
}
catch (Exception ex)
{
return(Json(new { result = "false" }));
}
}
/// <summary>
/// 新增或資料
/// </summary>
/// <returns></returns>
public JsonResult InsertColumnCRUDData(ColumnCRUD columnCRUDData)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(columnCRUDData.Id))
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_NullException, LogManagement.SystemName.基本作業, "傳入新增ColumnCRUD參數的Pkey為Null", columnCRUDData.Id, null);
return(Json(new { result = "人員代號為必填欄位" }));
}
Log.LogInfoWriter(userName, LogManagement.LogType.OP, LogManagement.EventLevel.Info, LogManagement.LogAction.USER_Action_Insert, LogManagement.SystemName.基本作業, "使用者新增一筆ColumnCRUD資料", columnCRUDData, null);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆ColumnCRUD資料", columnCRUDData, null);
var result = _service.InsertColumnCRUDData(columnCRUDData);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料結束", columnCRUDData, null);
return(Json(new { result = result }));
}
catch (Exception ex)
{
return(Json(new { result = "false" }));
}
}
public string DeleteColumnCRUDData(string pid)
{
try
{
ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD
where column.Id == pid
select column).FirstOrDefault();
//查無資料，修改失敗
if (columnCRUD == null)
{
return("查無此刪除資料，請確認人員編號是否異動或已刪除");
}
_db.ColumnCRUD.Remove(columnCRUD);
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public ColumnEditor()
{
InitializeComponent();
_columnCrud = new ColumnCRUD();
cCaption = 32;
}
