public string UpdateSingleCRUDData(SingleCRUDModel singleCRUDDataModel)
{
try
{
SingleCRUD singleCRUD = (from single in _db.SingleCRUD
where single.Id == singleCRUDDataModel.Id
select single).FirstOrDefault();
//查無資料，修改失敗
if (singleCRUD == null)
{
return("查無此修改資料，請確認人員編號是否異動或刪除");
}
_db.SingleCRUD.Attach(singleCRUD);
singleCRUD.Name = singleCRUDDataModel.Name;
singleCRUD.Headcount = singleCRUDDataModel.HeadCount;
singleCRUD.Dtype = singleCRUDDataModel.Dtype;
singleCRUD.Upuser = "******";
singleCRUD.Updatetime = DateTime.Now;
singleCRUD.Cruser = "******";
singleCRUD.Crdatetime = DateTime.Now;
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public string InsertSingleCRUDData(SingleCRUD singleCRUDData)
{
try
{
SingleCRUD singleCRUD = (from singleData in _db.SingleCRUD
where singleData.Id == singleCRUDData.Id
select singleData).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (singleCRUD != null)
{
return("新增到重複SingleCRUD資料，新增失敗");
}
singleCRUDData.Upuser = "******";
singleCRUDData.Updatetime = DateTime.Now;
singleCRUDData.Cruser = "******";
singleCRUDData.Crdatetime = DateTime.Now;
_db.SingleCRUD.Add(singleCRUDData);
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
public string InsertSingleCRUDData(SingleCRUD singleCRUDData)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆SingleCRUD資料", singleCRUDData, null);
SingleCRUD singleCRUD = (from singleData in _db.SingleCRUD
where singleData.Id == singleCRUDData.Id
select singleData).FirstOrDefault();
//搜尋出重複資料，新增失敗
if (singleCRUD != null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增到重複PKey的SingleCRUD資料，取消新增動作", singleCRUDData.Id, null);
return("新增到重複SingleCRUD資料，新增失敗");
}
singleCRUDData.Upuser = "******";
singleCRUDData.Updatetime = DateTime.Now;
singleCRUDData.Cruser = "******";
singleCRUDData.Crdatetime = DateTime.Now;
_db.SingleCRUD.Add(singleCRUDData);
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆SingleCRUD資料結束", singleCRUDData.Id, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆SingleCRUD資料，發生錯誤", singleCRUDData, ex);
return("false");
}
}
/// <summary>
/// 刪除多筆資料
/// </summary>
/// <param name="didList"></param>
/// <returns></returns>
public string DeleteSingleCRUDDataList(List <string> didList)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始刪除一筆ColumnCRUD資料", didList, null);
foreach (var item in didList)
{
SingleCRUD singleCRUD = (from single in _db.SingleCRUD
where single.Id == item
select single).FirstOrDefault();
//查無資料刪除失敗
if (singleCRUD == null)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "查無該筆資料需要刪除的資料", didList, null);
return("查無此刪除資料，請確認人員編號是否異動或已刪除");
}
_db.SingleCRUD.Remove(singleCRUD);
}
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "刪除一筆ColumnCRUD資料結束", didList, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "刪除一筆ColumnCRUD資料，發生錯誤", didList, ex);
return("false");
}
}
public string UpdateSingleCRUDData(SingleCRUDModel singleCRUDDataModel)
{
try
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始修改一筆SingleCRUD資料", singleCRUDDataModel, null);
SingleCRUD singleCRUD = (from single in _db.SingleCRUD
where single.Id == singleCRUDDataModel.Id
select single).FirstOrDefault();
//查無資料，修改失敗
if (singleCRUD == null)
{
return("查無此修改資料，請確認人員編號是否異動或刪除");
}
_db.SingleCRUD.Attach(singleCRUD);
singleCRUD.Name = singleCRUDDataModel.Name;
singleCRUD.Headcount = singleCRUDDataModel.HeadCount;
singleCRUD.Dtype = singleCRUDDataModel.Dtype;
singleCRUD.Upuser = "******";
singleCRUD.Updatetime = DateTime.Now;
singleCRUD.Cruser = "******";
singleCRUD.Crdatetime = DateTime.Now;
_db.SaveChanges();
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆SingleCRUD資料結束", singleCRUDDataModel.Id, null);
return("true");
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆SingleCRUD資料，發生錯誤", singleCRUDDataModel, ex);
return("false");
}
}
/// <summary>
/// 新增資料
/// </summary>
/// <returns></returns>
public JsonResult InsertColumnCRUDData(SingleCRUD singleCRUDData)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(singleCRUDData.Id))
{
return(Json(new { result = "人員代號為必填欄位" }));
}
var result = _service.InsertSingleCRUDData(singleCRUDData);
return(Json(new { result = result }));
}
catch (Exception ex)
{
return(Json(new { result = "false" }));
}
}
/// <summary>
/// 新增資料
/// </summary>
/// <returns></returns>
public JsonResult InsertColumnCRUDData(SingleCRUD singleCRUDData)
{
try
{
//判斷PKEY是否有填寫
if (string.IsNullOrEmpty(singleCRUDData.Id))
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_NullException, LogManagement.SystemName.基本作業, "傳入新增參數的Pkey為Null", singleCRUDData.Id, null);
return(Json(new { result = "人員代號為必填欄位" }));
}
Log.LogInfoWriter(userName, LogManagement.LogType.OP, LogManagement.EventLevel.Info, LogManagement.LogAction.USER_Action_Insert, LogManagement.SystemName.基本作業, "使用者新增一筆SingleCRUD資料", singleCRUDData, null);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆SingleCRUD資料", singleCRUDData, null);
var result = _service.InsertSingleCRUDData(singleCRUDData);
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆資料SingleCRUD結束", singleCRUDData, null);
return(Json(new { result = result }));
}
catch (Exception ex)
{
Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆資料SingleCRUD時，發生錯誤", singleCRUDData, ex);
return(Json(new { result = "false" }));
}
}
/// <summary>
/// 刪除多筆資料
/// </summary>
/// <param name="didList"></param>
/// <returns></returns>
public string DeleteSingleCRUDDataList(List <string> didList)
{
try
{
foreach (var item in didList)
{
SingleCRUD singleCRUD = (from single in _db.SingleCRUD
where single.Id == item
select single).FirstOrDefault();
//查無資料刪除失敗
if (singleCRUD == null)
{
return("查無此刪除資料，請確認人員編號是否異動或已刪除");
}
_db.SingleCRUD.Remove(singleCRUD);
}
_db.SaveChanges();
return("true");
}
catch (Exception ex)
{
return("false");
}
}
