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