public List <EntityInquiry> GetInquiry(string random, long no)
{
List <EntityInquiry> entityList = new List <EntityInquiry>();
#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 != "")
{
EntityInquiry entity = new EntityInquiry();
entity.MESSAGE = _message;
entityList.Add(entity);
return(entityList);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetInquiry(認証処理)", ex);
EntityInquiry entity = new EntityInquiry();
entity.MESSAGE = CLASS_NM + ".GetInquiry : 認証処理に失敗しました。" + 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();
if (no == 0)
{
// 一覧表示時
#region SQL
// 返答時
sb.Append("SELECT DISTINCT " + Environment.NewLine);
sb.Append(" IH.NO " + Environment.NewLine);
sb.Append(" ,IH.DATE " + Environment.NewLine);
sb.Append(" ,IH.TIME " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_DIVISION_ID " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS INQUIRY_DIVISION_NAME " + Environment.NewLine);
sb.Append(" ,IH.TITLE " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_STATE_ID " + Environment.NewLine);
sb.Append(" ,NM3.DESCRIPTION AS INQUIRY_STATE_NAME " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_LEVEL_ID " + Environment.NewLine);
sb.Append(" ,NM2.DESCRIPTION AS INQUIRY_LEVEL_NAME " + Environment.NewLine);
sb.Append(" FROM SYS_T_INQUIRY_H AS IH" + Environment.NewLine);
#region Join
// 担当者(ヘッダ)
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 = IH.COMPANY_ID " + Environment.NewLine);
sb.Append(" AND PS.ID = IH.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.INQUIRY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM1.ID = IH.INQUIRY_DIVISION_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.LEVEL_ID + Environment.NewLine);
sb.Append(" AND NM2.ID = IH.INQUIRY_LEVEL_ID" + Environment.NewLine);
// 問い合わせ状態ID
sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine);
sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_STATE_ID + Environment.NewLine);
sb.Append(" AND NM3.ID = IH.INQUIRY_STATE_ID" + Environment.NewLine);
#endregion
sb.Append(" WHERE IH.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND IH.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" ORDER BY IH.DATE DESC " + Environment.NewLine);
sb.Append(" ,IH.TIME DESC " + Environment.NewLine);
#endregion
}
else
{
#region SQL
// 返答時
sb.Append("SELECT IH.NO " + Environment.NewLine);
sb.Append(" ,IH.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,CP.NAME AS COMPANY_NAME " + Environment.NewLine);
sb.Append(" ,IH.GROUP_ID " + Environment.NewLine);
sb.Append(" ,GP.NAME AS GROUP_NAME " + Environment.NewLine);
sb.Append(" ,IH.PERSON_ID " + Environment.NewLine);
sb.Append(" ,PS.NAME AS PERSON_NAME " + Environment.NewLine);
sb.Append(" ,IH.DATE " + Environment.NewLine);
sb.Append(" ,IH.TIME " + Environment.NewLine);
sb.Append(" ,IH.TITLE " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_DIVISION_ID " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS INQUIRY_DIVISION_NAME " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_LEVEL_ID " + Environment.NewLine);
sb.Append(" ,NM2.DESCRIPTION AS INQUIRY_LEVEL_NAME " + Environment.NewLine);
sb.Append(" ,IH.INQUIRY_STATE_ID " + Environment.NewLine);
sb.Append(" ,NM3.DESCRIPTION AS INQUIRY_STATE_NAME " + Environment.NewLine);
sb.Append(" ,IH.MEMO " + Environment.NewLine);
sb.Append(" ,ID.REC_NO " + Environment.NewLine);
sb.Append(" ,ID.DATE AS D_DATE" + Environment.NewLine);
sb.Append(" ,ID.TIME AS D_TIME" + Environment.NewLine);
sb.Append(" ,ID.KBN " + Environment.NewLine);
sb.Append(" ,ID.PERSON_ID AS D_PERSON_ID " + Environment.NewLine);
sb.Append(" ,PS2.NAME AS D_PERSON_NAME " + Environment.NewLine);
sb.Append(" ,ID.SUPPORT_PERSON_NAME " + Environment.NewLine);
sb.Append(" ,ID.UPLOAD_FILE_PATH1 " + Environment.NewLine);
sb.Append(" ,ID.UPLOAD_FILE_PATH2 " + Environment.NewLine);
sb.Append(" ,ID.UPLOAD_FILE_PATH3 " + Environment.NewLine);
sb.Append(" ,ID.UPLOAD_FILE_PATH4 " + Environment.NewLine);
sb.Append(" ,ID.UPLOAD_FILE_PATH5 " + Environment.NewLine);
sb.Append(" ,ID.CONTENT " + Environment.NewLine);
sb.Append(" FROM SYS_T_INQUIRY_H AS IH" + Environment.NewLine);
#region Join
sb.Append(" INNER JOIN SYS_T_INQUIRY_D AS ID" + Environment.NewLine);
sb.Append(" ON ID.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND ID.NO = IH.NO" + Environment.NewLine);
// 会社
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 = IH.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 = IH.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 = IH.COMPANY_ID " + Environment.NewLine);
sb.Append(" AND PS.ID = IH.PERSON_ID" + Environment.NewLine);
// 担当者(明細)
sb.Append(" LEFT JOIN M_PERSON AS PS2" + Environment.NewLine);
sb.Append(" ON PS2.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND PS2.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND PS2.COMPANY_ID = IH.COMPANY_ID " + Environment.NewLine);
sb.Append(" AND PS2.ID = ID.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.INQUIRY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM1.ID = IH.INQUIRY_DIVISION_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.LEVEL_ID + Environment.NewLine);
sb.Append(" AND NM2.ID = IH.INQUIRY_LEVEL_ID" + Environment.NewLine);
// 問い合わせ緊急度ID
sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine);
sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_STATE_ID + Environment.NewLine);
sb.Append(" AND NM3.ID = IH.INQUIRY_STATE_ID" + Environment.NewLine);
#endregion
sb.Append(" WHERE IH.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND IH.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND IH.NO = " + no + Environment.NewLine);
sb.Append(" ORDER BY IH.DATE DESC " + Environment.NewLine);
sb.Append(" ,IH.TIME DESC " + Environment.NewLine);
sb.Append(" ,ID.REC_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++)
{
EntityInquiry entity = new EntityInquiry();
// 排他制御
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 + ".GetInquiry : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
}
}
#region Set Entity
entity.no = ExCast.zCLng(dt.DefaultView[i]["NO"]);
entity.date_time = ExCast.zDateNullToDefault(dt.DefaultView[i]["DATE"]) + " " + ExCast.zCStr(dt.DefaultView[i]["TIME"]);
entity.title = ExCast.zCStr(dt.DefaultView[i]["TITLE"]);
entity.inquiry_division_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_DIVISION_ID"]);
entity.inquiry_division_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_DIVISION_NAME"]);
entity.inquiry_level_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_LEVEL_ID"]);
entity.inquiry_level_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_LEVEL_NAME"]);
entity.inquiry_level_state_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_STATE_ID"]);
entity.inquiry_level_state_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_STATE_NAME"]);
if (no != 0)
{
// 返答時
entity.company_id = ExCast.zCInt(dt.DefaultView[i]["COMPANY_ID"]);
entity.company_nm = ExCast.zCStr(dt.DefaultView[i]["COMPANY_NAME"]);
entity.gropu_id = ExCast.zCInt(dt.DefaultView[i]["GROUP_ID"]);
entity.gropu_nm = ExCast.zCStr(dt.DefaultView[i]["GROUP_NAME"]);
entity.person_id = ExCast.zCInt(dt.DefaultView[i]["PERSON_ID"]);
entity.person_nm = ExCast.zCStr(dt.DefaultView[i]["PERSON_NAME"]);
entity.rec_no = ExCast.zCInt(dt.DefaultView[i]["REC_NO"]);
entity.d_date_time = ExCast.zDateNullToDefault(dt.DefaultView[i]["D_DATE"]) + " " + ExCast.zCStr(dt.DefaultView[i]["D_TIME"]);
entity.kbn = ExCast.zCInt(dt.DefaultView[i]["KBN"]);
entity.d_person_id = ExCast.zCInt(dt.DefaultView[i]["D_PERSON_ID"]);
entity.d_person_nm = ExCast.zCStr(dt.DefaultView[i]["D_PERSON_NAME"]);
entity.support_person_nm = ExCast.zCStr(dt.DefaultView[i]["SUPPORT_PERSON_NAME"]);
entity.content = ExCast.zCStr(dt.DefaultView[i]["CONTENT"]);
entity.lock_flg = (int)lockFlg;
entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]);
}
#endregion
entityList.Add(entity);
}
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetInquiry", ex);
entityList.Clear();
EntityInquiry entity = new EntityInquiry();
entity.MESSAGE = CLASS_NM + ".GetInquiry : 予期せぬエラーが発生しました。" + 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);
}
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);
}
