public static string GetOperationTypeName(DataPgEvidence.geOperationType type) { switch ((int)type) { case 0: return "開始"; case 1: return "終了"; case 2: return "検索"; case 3: return "更新"; case 4: return "追加"; case 5: return "削除"; case 6: return "PDF出力"; case 7: return "Excel出力"; case 8: return "CSV出力"; case 9: return "削除/追加"; default: return ""; } }
public static void gAddEvidence(int saveFlg, string companyId, string userId, string ipAdress, string sessionString, string pgId, DataPgEvidence.geOperationType type, string memo) { if (saveFlg != 1) return; StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString); // 日時取得 string date = ""; string time = ""; int millisecond = 0; DateTime now = DateTime.Now; date = now.ToString("yyyy/MM/dd"); time = now.ToString("HH:mm:ss"); millisecond = now.Millisecond; // PG実行履歴登録 try { sb.Length = 0; sb.Append("INSERT INTO H_PG_EXEC_HISTORY " + Environment.NewLine); sb.Append(" (COMPANY_ID" + Environment.NewLine); sb.Append(" ,USER_ID" + Environment.NewLine); sb.Append(" ,PG_ID" + Environment.NewLine); sb.Append(" ,OPERATION_DATE" + Environment.NewLine); sb.Append(" ,OPERATION_TIME" + Environment.NewLine); sb.Append(" ,OPERATION_MILLISECOND" + Environment.NewLine); sb.Append(" ,OPERATION_TYPE" + Environment.NewLine); sb.Append(" ,PG_NAME" + Environment.NewLine); sb.Append(" ,OPERATION_TYPE_NAME" + Environment.NewLine); sb.Append(" ,MEMO" + Environment.NewLine); sb.Append(" ,UPDATE_FLG" + Environment.NewLine); sb.Append(" ,DELETE_FLG" + Environment.NewLine); sb.Append(" ,CREATE_PG_ID" + Environment.NewLine); sb.Append(" ,CREATE_ADRESS" + Environment.NewLine); sb.Append(" ,CREATE_USER_ID" + Environment.NewLine); sb.Append(" ,CREATE_DATE" + Environment.NewLine); sb.Append(" ,CREATE_TIME" + Environment.NewLine); sb.Append(" ,UPDATE_PG_ID" + Environment.NewLine); sb.Append(" ,UPDATE_ADRESS" + Environment.NewLine); sb.Append(" ,UPDATE_USER_ID" + Environment.NewLine); sb.Append(" ,UPDATE_DATE" + Environment.NewLine); sb.Append(" ,UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("VALUES (" + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + userId + Environment.NewLine); // USER_ID sb.Append(" ," + ExEscape.zRepStr(pgId) + Environment.NewLine); // PG_ID sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // OPERATION_DATE sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // OPERATION_TIME sb.Append(" ," + millisecond.ToString() + Environment.NewLine); // OPERATION_MILLISECOND sb.Append(" ," + (int)type + Environment.NewLine); // OPERATION_TYPE sb.Append(" ," + ExEscape.zRepStr(DataPgEvidence.GetPgName(pgId)) + Environment.NewLine); // PG_NAME sb.Append(" ," + ExEscape.zRepStr(DataPgEvidence.GetOperationTypeName(type)) + Environment.NewLine); // OPERATION_TYPE_NAME sb.Append(" ," + ExEscape.zRepStr(memo) + Environment.NewLine); // MEMO sb.Append(" ,0" + Environment.NewLine); // UPDATE_FLG sb.Append(" ,0" + Environment.NewLine); // DELETE_FLG sb.Append(" ,'SYSTEM'" + Environment.NewLine); // CREATE_PG_ID sb.Append(" ," + ExEscape.zRepStr(ipAdress) + Environment.NewLine); // CREATE_ADRESS sb.Append(" ," + ExEscape.zRepStr(userId) + Environment.NewLine); // CREATE_USER_ID sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // CREATE_DATE sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // CREATE_TIME sb.Append(" ,'SYSTEM'" + Environment.NewLine); // UPDATE_PG_ID sb.Append(" ," + ExEscape.zRepStr(ipAdress) + Environment.NewLine); // UPDATE_ADRESS sb.Append(" ," + ExEscape.zRepStr(userId) + Environment.NewLine); // UPDATE_USER_ID sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // UPDATE_DATE sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // UPDATE_TIME sb.Append(")"); if (db.ExecuteSQL(sb.ToString(), true) == false) { CommonUtl.ExLogger.Error(CLASS_NM + ".gAddEvidence(ExecuteSQL) : " + Environment.NewLine + ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString).errMessage); return; } switch (type) { case DataPgEvidence.geOperationType.Start: case DataPgEvidence.geOperationType.End: if (pgId == DataPgEvidence.PGName.System) { DataPgLock.DelLockPg(companyId, userId, "", "", ipAdress, true, db); } else { DataPgLock.DelLockPg(companyId, userId, pgId, "", ipAdress, true, db); } break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".gAddEvidence(Insert)", ex); db.ExRollbackTransaction(); } }