// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[3];
prm[0] = (int)upd;
string upload_filePath = _entityUpdate._upload_file_path1;
string upload_fileName = _entityUpdate._upload_file_name1;
_entityUpdate = new EntityDuties();
_entityUpdate._upload_file_path1 = upload_filePath;
_entityUpdate._upload_file_name1 = upload_fileName;
if (this.ProcKbn == eProcKbn.Update)
{
prm[1] = this._entity._no;
_entityUpdate._no = this._entity._no;
}
else
{
prm[1] = 0;
_entityUpdate._no = 0;
}
_entityUpdate._title = this.txtTitle.Text;
if (ExCast.zCStr(this.cmbGroup.SelectedValue) == "全グループ")
{
_entityUpdate._gropu_id = 0;
}
else
{
for (int i = 0; i <= _entityGroupList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbGroup.SelectedValue) == _entityGroupList[i].name)
{
_entityUpdate._gropu_id = ExCast.zCInt(_entityGroupList[i].id);
}
}
}
for (int i = 0; i <= _entityPersonList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbPerson.SelectedValue) == _entityPersonList[i].name)
{
_entityUpdate._person_id = ExCast.zCInt(_entityPersonList[i].id);
}
}
if (this.cmbLevel.SelectedValue != null)
{
_entityUpdate._duties_level_id = MeiNameList.GetID(MeiNameList.geNameKbn.LEVEL_ID, ExCast.zCStr(this.cmbLevel.SelectedValue));
}
if (this.cmbState.SelectedValue != null)
{
_entityUpdate._duties_state_id = MeiNameList.GetID(MeiNameList.geNameKbn.DISPLAY_DIVISION_ID, ExCast.zCStr(this.cmbState.SelectedValue)) - 1;
}
_entityUpdate._content = this.txtContent.Text;
prm[2] = _entityUpdate;
webService.objWindow = this;
webService.CallWebService(ExWebService.geWebServiceCallKbn.UpdateDuties,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
public List <EntityDuties> GetDuties(string random, long no, int kbn)
{
List <EntityDuties> entityList = new List <EntityDuties>();
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
EntityDuties entity = new EntityDuties();
entity.MESSAGE = _message;
entityList.Add(entity);
return(entityList);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetDuties(認証処理)", ex);
EntityDuties entity = new EntityDuties();
entity.MESSAGE = CLASS_NM + ".GetDuties : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();;
entityList.Add(entity);
return(entityList);
}
#endregion
StringBuilder sb;
DataTable dt;
ExMySQLData db;
try
{
db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]),
ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]));
sb = new StringBuilder();
#region SQL
// 返答時
sb.Append("SELECT T.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,CP.NAME AS COMPANY_NAME " + Environment.NewLine);
sb.Append(" ,T.NO " + Environment.NewLine);
sb.Append(" ,T.GROUP_ID " + Environment.NewLine);
sb.Append(" ,GP.NAME AS GROUP_NAME " + Environment.NewLine);
sb.Append(" ,T.DATE " + Environment.NewLine);
sb.Append(" ,T.TIME " + Environment.NewLine);
sb.Append(" ,T.PERSON_ID " + Environment.NewLine);
sb.Append(" ,PS.NAME AS PERSON_NAME " + Environment.NewLine);
sb.Append(" ,T.DUTIES_LEVEL_ID " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS DUTIES_LEVEL_NAME " + Environment.NewLine);
sb.Append(" ,T.DUTIES_STATE_ID " + Environment.NewLine);
sb.Append(" ,NM2.DESCRIPTION AS DUTIES_STATE_NAME " + Environment.NewLine);
sb.Append(" ,T.TITLE " + Environment.NewLine);
sb.Append(" ,T.CONTENT " + Environment.NewLine);
sb.Append(" ,T.UPLOAD_FILE_PATH1 " + Environment.NewLine);
sb.Append(" ,T.UPLOAD_FILE_PATH2 " + Environment.NewLine);
sb.Append(" ,T.UPLOAD_FILE_PATH3 " + Environment.NewLine);
sb.Append(" ,T.UPLOAD_FILE_PATH4 " + Environment.NewLine);
sb.Append(" ,T.UPLOAD_FILE_PATH5 " + Environment.NewLine);
sb.Append(" ,T.MEMO " + Environment.NewLine);
sb.Append(" FROM T_DUTIES_COMMUNICATION AS T" + Environment.NewLine);
#region Join
// 会社
sb.Append(" LEFT JOIN SYS_M_COMPANY AS CP" + Environment.NewLine);
sb.Append(" ON CP.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CP.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CP.ID = T.COMPANY_ID " + Environment.NewLine);
// グループ
sb.Append(" LEFT JOIN SYS_M_COMPANY_GROUP AS GP" + Environment.NewLine);
sb.Append(" ON GP.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND GP.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND GP.ID = T.GROUP_ID " + Environment.NewLine);
// 担当者
sb.Append(" LEFT JOIN M_PERSON AS PS" + Environment.NewLine);
sb.Append(" ON PS.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND PS.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND PS.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine);
sb.Append(" AND PS.ID = T.PERSON_ID" + Environment.NewLine);
// レベルID
sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine);
sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.LEVEL_ID + Environment.NewLine);
sb.Append(" AND NM1.ID = T.DUTIES_LEVEL_ID" + Environment.NewLine);
// 状態ID
sb.Append(" LEFT JOIN SYS_M_NAME AS NM2" + Environment.NewLine);
sb.Append(" ON NM2.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM2.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM2.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM2.ID = T.DUTIES_STATE_ID" + Environment.NewLine);
#endregion
sb.Append(" WHERE T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.DELETE_FLG = 0 " + Environment.NewLine);
if (no != 0)
{
sb.Append(" AND T.NO = " + no + Environment.NewLine);
}
// 参照確認時
if (kbn == 1)
{
sb.Append(" AND T.DUTIES_STATE_ID = 1 " + Environment.NewLine); // 表示区分 1:表示するのみ
sb.Append(" AND (T.GROUP_ID = " + groupId + " OR T.GROUP_ID = 0)" + Environment.NewLine);
}
sb.Append(" ORDER BY T.DATE DESC " + Environment.NewLine);
sb.Append(" ,T.TIME DESC " + Environment.NewLine);
sb.Append(" ,T.NO DESC " + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
for (int i = 0; i <= dt.DefaultView.Count - 1; i++)
{
EntityDuties entity = new EntityDuties();
// 排他制御
DataPgLock.geLovkFlg lockFlg = DataPgLock.geLovkFlg.UnLock;
if (no != 0) // 返答時
{
string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, no.ToString(), ipAdress, db, out lockFlg);
if (strErr != "")
{
entity.MESSAGE = CLASS_NM + ".GetDuties : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
}
}
#region Set Entity
entity.company_id = ExCast.zCInt(dt.DefaultView[i]["COMPANY_ID"]);
entity.company_nm = ExCast.zCStr(dt.DefaultView[i]["COMPANY_NAME"]);
entity.no = ExCast.zCLng(dt.DefaultView[i]["NO"]);
entity.gropu_id = ExCast.zCInt(dt.DefaultView[i]["GROUP_ID"]);
entity.gropu_nm = ExCast.zCStr(dt.DefaultView[i]["GROUP_NAME"]);
if (entity.gropu_id == 0)
{
entity.gropu_nm = "全グループ";
}
entity.duties_ymd = ExCast.zDateNullToDefault(dt.DefaultView[i]["DATE"]);
entity.duties_time = ExCast.zCStr(dt.DefaultView[i]["TIME"]);
entity.duties_date_time = ExCast.zDateNullToDefault(dt.DefaultView[i]["DATE"]) + " " + ExCast.zCStr(dt.DefaultView[i]["TIME"]);
entity.person_id = ExCast.zCInt(dt.DefaultView[i]["PERSON_ID"]);
entity.person_nm = ExCast.zCStr(dt.DefaultView[i]["PERSON_NAME"]);
entity.duties_level_id = ExCast.zCInt(dt.DefaultView[i]["DUTIES_LEVEL_ID"]);
entity.duties_level_nm = ExCast.zCStr(dt.DefaultView[i]["DUTIES_LEVEL_NAME"]);
entity.duties_state_id = ExCast.zCInt(dt.DefaultView[i]["DUTIES_STATE_ID"]);
entity.duties_state_nm = ExCast.zCStr(dt.DefaultView[i]["DUTIES_STATE_NAME"]);
entity.title = ExCast.zCStr(dt.DefaultView[i]["TITLE"]);
entity.content = ExCast.zCStr(dt.DefaultView[i]["CONTENT"]);
entity.upload_file_path1 = ExCast.zCStr(dt.DefaultView[i]["UPLOAD_FILE_PATH1"]);
entity.upload_file_path2 = ExCast.zCStr(dt.DefaultView[i]["UPLOAD_FILE_PATH2"]);
entity.upload_file_path3 = ExCast.zCStr(dt.DefaultView[i]["UPLOAD_FILE_PATH3"]);
entity.upload_file_path4 = ExCast.zCStr(dt.DefaultView[i]["UPLOAD_FILE_PATH4"]);
entity.upload_file_path5 = ExCast.zCStr(dt.DefaultView[i]["UPLOAD_FILE_PATH5"]);
if (!string.IsNullOrEmpty(entity.upload_file_path1))
{
entity.upload_file_name1 = System.IO.Path.GetFileName(entity.upload_file_path1);
}
if (!string.IsNullOrEmpty(entity.upload_file_path2))
{
entity.upload_file_name2 = System.IO.Path.GetFileName(entity.upload_file_path2);
}
if (!string.IsNullOrEmpty(entity.upload_file_path3))
{
entity.upload_file_name3 = System.IO.Path.GetFileName(entity.upload_file_path3);
}
if (!string.IsNullOrEmpty(entity.upload_file_path4))
{
entity.upload_file_name4 = System.IO.Path.GetFileName(entity.upload_file_path4);
}
if (!string.IsNullOrEmpty(entity.upload_file_path5))
{
entity.upload_file_name5 = System.IO.Path.GetFileName(entity.upload_file_path5);
}
entity.memo = ExCast.zCStr(dt.DefaultView[i]["MEMO"]);
#endregion
entityList.Add(entity);
}
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetDuties", ex);
entityList.Clear();
EntityDuties entity = new EntityDuties();
entity.MESSAGE = CLASS_NM + ".GetDuties : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();;
entityList.Add(entity);
return(entityList);
}
finally
{
db = null;
}
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Select,
"NO:" + no.ToString());
return(entityList);
}
// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[3];
prm[0] = (int)upd;
string upload_filePath = _entityUpdate._upload_file_path1;
string upload_fileName = _entityUpdate._upload_file_name1;
_entityUpdate = new EntityDuties();
_entityUpdate._upload_file_path1 = upload_filePath;
_entityUpdate._upload_file_name1 = upload_fileName;
if (this.ProcKbn == eProcKbn.Update)
{
prm[1] = this._entity._no;
_entityUpdate._no = this._entity._no;
}
else
{
prm[1] = 0;
_entityUpdate._no = 0;
}
_entityUpdate._title = this.txtTitle.Text;
if (ExCast.zCStr(this.cmbGroup.SelectedValue) == "全グループ")
{
_entityUpdate._gropu_id = 0;
}
else
{
for (int i = 0; i <= _entityGroupList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbGroup.SelectedValue) == _entityGroupList[i].name)
{
_entityUpdate._gropu_id = ExCast.zCInt(_entityGroupList[i].id);
}
}
}
for (int i = 0; i <= _entityPersonList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbPerson.SelectedValue) == _entityPersonList[i].name)
{
_entityUpdate._person_id = ExCast.zCInt(_entityPersonList[i].id);
}
}
if (this.cmbLevel.SelectedValue != null)
{
_entityUpdate._duties_level_id = MeiNameList.GetID(MeiNameList.geNameKbn.LEVEL_ID, ExCast.zCStr(this.cmbLevel.SelectedValue));
}
if (this.cmbState.SelectedValue != null)
{
_entityUpdate._duties_state_id = MeiNameList.GetID(MeiNameList.geNameKbn.DISPLAY_DIVISION_ID, ExCast.zCStr(this.cmbState.SelectedValue)) - 1;
}
_entityUpdate._content = this.txtContent.Text;
prm[2] = _entityUpdate;
webService.objWindow = this;
webService.CallWebService(ExWebService.geWebServiceCallKbn.UpdateDuties,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
public string UpdateDuties(string random, int type, long no, EntityDuties entity)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
string personId = "";
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
return(_message);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(認証処理)", ex);
return(CLASS_NM + ".UpdateDuties : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string _no = "";
DateTime now = DateTime.Now;
string date = now.ToString("yyyy/MM/dd");
string time = now.ToString("HH:mm:ss");
#endregion
#region Databese Open
try
{
db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR]));
db.DbOpen();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(DbOpen)", ex);
return(CLASS_NM + ".UpdateDuties(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
if (CommonUtl.gSysDbKbn == 0)
{
db.ExBeginTransaction();
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(BeginTransaction)", ex);
return(CLASS_NM + ".UpdateDuties(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Get Max ID
if (type == 1)
{
try
{
DataMaxId.GetMaxId(db,
"T_DUTIES_COMMUNICATION",
"NO",
out _no);
if (_no == "")
{
return("業務連絡NOの取得に失敗しました。");
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(GetMaxId)", ex);
return(CLASS_NM + ".UpdateDuties(GetMaxId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
else
{
_no = no.ToString();
}
#endregion
#region Upload File Set
if (type <= 1)
{
if (!string.IsNullOrEmpty(entity.upload_file_path1))
{
if (System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDutiesDir + entity.upload_file_path1) && !System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDutiesDir + _no + "-" + date.Replace("/", "") + time.Replace(":", "")))
{
System.IO.Directory.Move(CommonUtl.gstrFileUpLoadDutiesDir + entity.upload_file_path1, CommonUtl.gstrFileUpLoadDutiesDir + _no + "-" + date.Replace("/", "") + time.Replace(":", ""));
entity.upload_file_path1 = CommonUtl.gstrFileUpLoadDutiesDir + _no + "-" + date.Replace("/", "") + time.Replace(":", "") + "\\" + entity.upload_file_name1;
}
}
}
#endregion
#region Insert
if (type == 1)
{
try
{
#region Insert SQL
sb.Length = 0;
sb.Append("INSERT INTO T_DUTIES_COMMUNICATION " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , NO" + Environment.NewLine);
sb.Append(" , GROUP_ID" + Environment.NewLine);
sb.Append(" , DATE" + Environment.NewLine);
sb.Append(" , TIME" + Environment.NewLine);
sb.Append(" , PERSON_ID" + Environment.NewLine);
sb.Append(" , DUTIES_LEVEL_ID" + Environment.NewLine);
sb.Append(" , DUTIES_STATE_ID" + Environment.NewLine);
sb.Append(" , TITLE" + Environment.NewLine);
sb.Append(" , CONTENT" + Environment.NewLine);
sb.Append(" , UPLOAD_FILE_PATH1" + Environment.NewLine);
sb.Append(" , UPLOAD_FILE_PATH2" + Environment.NewLine);
sb.Append(" , UPLOAD_FILE_PATH3" + Environment.NewLine);
sb.Append(" , UPLOAD_FILE_PATH4" + Environment.NewLine);
sb.Append(" , UPLOAD_FILE_PATH5" + 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_PERSON_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_PERSON_ID" + Environment.NewLine);
sb.Append(" , UPDATE_DATE" + Environment.NewLine);
sb.Append(" , UPDATE_TIME" + Environment.NewLine);
sb.Append(")" + Environment.NewLine);
sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" ," + _no + Environment.NewLine); // NO
sb.Append(" ," + entity.gropu_id + Environment.NewLine); // GROUP_ID
sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // DATE
sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // TIME
sb.Append(" ," + entity.person_id + Environment.NewLine); // PERSON_ID
sb.Append(" ," + entity.duties_level_id + Environment.NewLine); // DUTIES_LEVEL_ID
sb.Append(" ," + entity.duties_state_id + Environment.NewLine); // DUTIES_STATE_ID
sb.Append(" ," + ExEscape.zRepStr(entity.title) + Environment.NewLine); // TITLE
sb.Append(" ," + ExEscape.zRepStr(entity.content) + Environment.NewLine); // CONTENT
sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path1) + Environment.NewLine); // UPLOAD_FILE_PATH1
sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path2) + Environment.NewLine); // UPLOAD_FILE_PATH2
sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path3) + Environment.NewLine); // UPLOAD_FILE_PATH3
sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path4) + Environment.NewLine); // UPLOAD_FILE_PATH4
sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path5) + Environment.NewLine); // UPLOAD_FILE_PATH5
sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"T_DUTIES_COMMUNICATION",
ExCast.zCInt(personId),
_no,
ipAdress,
userId));
#endregion
db.ExecuteSQL(sb.ToString(), false);
if (CommonUtl.gSysDbKbn == 0)
{
db.ExecuteSQL(sb.ToString(), false);
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(Insert)", ex);
return(CLASS_NM + ".UpdateDuties(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region Update
if (type == 0)
{
#region Update
try
{
#region SQL
sb.Length = 0;
sb.Append("UPDATE T_DUTIES_COMMUNICATION " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
0));
sb.Append(" ,GROUP_ID = " + entity.gropu_id + Environment.NewLine);
sb.Append(" ,DATE = " + ExEscape.zRepStr(date) + Environment.NewLine);
sb.Append(" ,TIME = " + ExEscape.zRepStr(time) + Environment.NewLine);
sb.Append(" ,PERSON_ID = " + entity.person_id + Environment.NewLine);
sb.Append(" ,DUTIES_LEVEL_ID = " + entity.duties_level_id + Environment.NewLine);
sb.Append(" ,DUTIES_STATE_ID = " + entity.duties_state_id + Environment.NewLine);
sb.Append(" ,TITLE = " + ExEscape.zRepStr(entity.title) + Environment.NewLine);
sb.Append(" ,CONTENT = " + ExEscape.zRepStr(entity.content) + Environment.NewLine);
sb.Append(" ,UPLOAD_FILE_PATH1 = " + ExEscape.zRepStr(entity.upload_file_path1) + Environment.NewLine);
sb.Append(" ,UPLOAD_FILE_PATH2 = " + ExEscape.zRepStr(entity.upload_file_path2) + Environment.NewLine);
sb.Append(" ,UPLOAD_FILE_PATH3 = " + ExEscape.zRepStr(entity.upload_file_path3) + Environment.NewLine);
sb.Append(" ,UPLOAD_FILE_PATH4 = " + ExEscape.zRepStr(entity.upload_file_path4) + Environment.NewLine);
sb.Append(" ,UPLOAD_FILE_PATH5 = " + ExEscape.zRepStr(entity.upload_file_path5) + Environment.NewLine);
sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine);
sb.Append(" WHERE NO = " + _no + Environment.NewLine);
#endregion
db.ExecuteSQL(sb.ToString(), false);
if (CommonUtl.gSysDbKbn == 0)
{
db.ExecuteSQL(sb.ToString(), false);
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(Update Head)", ex);
return(CLASS_NM + ".UpdateDuties(Update Head) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
#endregion
#region Delete
if (type == 2)
{
}
#endregion
#region PG排他制御
if (type == 0 || type == 2)
{
try
{
DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(DelLockPg)", ex);
return(CLASS_NM + ".UpdateDuties(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(CommitTransaction)", ex);
return(CLASS_NM + ".UpdateDuties(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(DbClose)", ex);
return(CLASS_NM + ".UpdateDuties(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
finally
{
db = null;
}
#endregion
#region Add Evidence
try
{
switch (type)
{
case 0:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Update,
"NO:" + _no);
break;
case 1:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Insert,
"NO:" + _no);
break;
case 2:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Delete,
"NO:" + _no);
break;
default:
break;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateDuties(Add Evidence)", ex);
return(CLASS_NM + ".UpdateDuties(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Return
if (type == 1)
{
return("Auto Insert success : " + "NO : " + _no + "で登録しました。");
}
else
{
return("");
}
#endregion
}
