/// <summary>
/// 紀錄事件
/// </summary>
public static void logEvent(string eventCode, string userId, string objectId)
{
var qry = new NsDmQuery();
{
var t1 = qry.from <EO_UserEvent>();
qry.Where = t1.EOUE_EventCode == eventCode.toConstReq1();
}
var row = qry.queryData <EO_UserEventDataTable>().FirstRow;
//不存在自動新增
{
if (row == null)
{
var dt = new EO_UserEventDataTable();
row = dt.newTypedRow();
row.ns_AssignNewId();
row.EOUE_Description = string.Empty;
row.EOUE_EventCode = eventCode;
row.EOUE_KindName = eventCode;
row.EOUE_ListOrder = 1;
dt.addTypedRow(row);
dt.ns_update();
dt.AcceptChanges();
}
}
////不重複才新增
//if (LastEventCode == eventCode + "_" + objectId)
// return;
//新增此事件
{
var sourceIP = getSourceIP();
var dt2 = new EO_UserEventLogDataTable();
var row2 = dt2.newTypedRow();
row2.ns_AssignNewId();
row2.EOUEL_EventDate = DateTime.Now;
row2.EOUEL_UserEventId = row.EOUE_UserEventId;
row2.EOUEL_UserId = userId;
row2.EOUEL_ObjectId = objectId;
row2.EOUEL_SourceIP = sourceIP;
dt2.addTypedRow(row2);
dt2.ns_update();
}
//LastEventCode = eventCode + "_" + objectId;
}
public EO_UserEventLogDataTable EoUserEventLog_create(int rowCount = 1)
{
var dt = new EO_UserEventLogDataTable();
if (rowCount < 0)
{
rowCount = 0;
}
for (int i = 0; i < rowCount; i++)
{
var row = dt.newTypedRow();
row.ns_AssignNewId();
dt.addTypedRow(row);
}
return(dt);
}
public ActionResult Edit(FormCollection collection)
{
var token = collection["__RequestVerificationToken"];
var mode = collection["ViewMode"];
var id = collection[AppDataName.EOUEL_UserEventLogId];
var msgOK = "OK";
EO_UserEventLogDataTable dt = null;
EO_UserEventLogRow row = null;
try
{
if (mode.equalIgnoreCase("create"))
{
dt = new EO_UserEventLogDataTable();
row = dt.newTypedRow();
row.ns_AssignNewId();
dt.addTypedRow(row);
msgOK = FtdStatus.InsertSuccess.ToString();
}
else
{
//找出該筆資料
dt = EoDataService.Instance.EoUserEventLog_getById(id);
if (dt == null || dt.Count == 0)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = "資料不存在" }));
}
msgOK = FtdStatus.UpdateSuccess.ToString();
}
//將Form sumit的資料更新至DataRow
row = dt.FirstRow;
var isOK = this.TryUpdateModel(row);
//若驗證失敗-->回傳錯誤訊息
if (!ModelState.IsValid)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = string.Join("<br/>", ModelState.Values) }));
}
#region //驗證欄位
List <string> lstError = new List <string>();
if (row.EOUEL_UserEventLogId.isNullOrEmpty())
{
lstError.Add("事件檔紀錄ID不能為空");
}
if (!row.EOUEL_EventDate.HasValue)
{
lstError.Add("事件日期不能為空");
}
if (row.EOUEL_UserEventCode_XX.isNullOrEmpty())
{
lstError.Add("事件代號不能為空");
}
if (row.EOUEL_UserEventId.isNullOrEmpty())
{
lstError.Add("事件Id不能為空");
}
if (row.EOUEL_UserEventName_XX.isNullOrEmpty())
{
lstError.Add("事件類型不能為空");
}
//回傳錯誤訊息
if (lstError.Count > 0)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = string.Join("<br/>", lstError.ToArray()) }));
}
//檢查鍵值是否重覆
#endregion
dt.ns_update();
dt.AcceptChanges();
return(Json(new { Result = msgOK }));
}
catch (Exception ex)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = ex.Message }));
}
}
