/// <summary>
/// 資料庫資料轉檔 ViewModel
/// </summary>
/// <param name="userId"></param>
/// <param name="data"></param>
/// <param name="treaItemTypes"></param>
/// <param name="formStatus"></param>
/// <param name="depts"></param>
/// <param name="emps"></param>
/// <returns></returns>
private TreasuryAccessSearchDetailViewModel TreaAplyRecToTASDViewModel(
string userId,
TREA_APLY_REC data,
List <TREA_ITEM> treaItems,
List <SYS_CODE> formStatus,
List <VW_OA_DEPT> depts,
List <V_EMPLY2> emps)
{
return(new TreasuryAccessSearchDetailViewModel()
{
vACCESS_REASON = data.ACCESS_REASON,
vAPLY_DT = data.APLY_DT?.DateToTaiwanDate(9),
vAPLY_NO = data.APLY_NO,
vAPLY_STATUS = data.APLY_STATUS,
vAPLY_STATUS_D = formStatus.FirstOrDefault(x => x.CODE == data.APLY_STATUS)?.CODE_VALUE,
vAPLY_UNIT = depts.FirstOrDefault(y => y.DPT_CD.Trim() == data.APLY_UNIT)?.DPT_NAME,
vAPLY_UID = data.APLY_UID,
vAPLY_UID_NAME = emps.FirstOrDefault(x => x.USR_ID == data.APLY_UID)?.EMP_NAME,
vCancleFlag = data.APLY_STATUS == Ref.AccessProjectFormStatus.A01.ToString() && data.CREATE_UID == userId ? "Y" : "N",
vInvalidFlag = invalidStatus.Contains(data.APLY_STATUS) &&
data.CREATE_UID == userId ? "Y" : "N",
vPrintFlag = printsStatus.Contains(data.APLY_STATUS) ? "Y" : "N",
vItem = data.ITEM_ID,
vItemDec = treaItems.FirstOrDefault(x => x.ITEM_ID == data.ITEM_ID)?.ITEM_DESC,
vDESC = !data.APLY_APPR_DESC.IsNullOrWhiteSpace() ? data.APLY_APPR_DESC : data.CUSTODY_APPR_DESC,
vACCESS_TYPE = data.ACCESS_TYPE,
vLast_Update_Time = data.LAST_UPDATE_DT
});
}
private TreasuryAccessApprSearchDetailViewModel TreaAplyRecToTAASDViewModel(
string userId,
TREA_APLY_REC data,
List <TREA_ITEM> treaItems,
List <VW_OA_DEPT> depts,
List <V_EMPLY2> emps,
List <SYS_CODE> formStatus,
bool vAPPRFlag = true
)
{
return(new TreasuryAccessApprSearchDetailViewModel()
{
vItem = data.ITEM_ID,
vACCESS_TYPE = data.ACCESS_TYPE,
vAPLY_STATUS = data.APLY_STATUS,
vAPLY_STATUS_D = formStatus.FirstOrDefault(x => x.CODE == data.APLY_STATUS)?.CODE_VALUE,
vItemDec = treaItems.FirstOrDefault(x => x.ITEM_ID == data.ITEM_ID)?.ITEM_DESC,
vAPLY_DT = data.APLY_DT?.ToString("yyyy/MM/dd"),
vAPLY_NO = data.APLY_NO,
vAPLY_UNIT = depts.FirstOrDefault(y => y.DPT_CD.Trim() == data.APLY_UNIT)?.DPT_NAME,
vAPLY_UID = data.APLY_UID,
vAPLY_UID_NAME = emps.FirstOrDefault(x => x.USR_ID == data.APLY_UID)?.EMP_NAME,
vCUSTODY_UID = emps.FirstOrDefault(x => x.USR_ID == data.CUSTODY_UID)?.EMP_NAME,
vAPPR_DESC = data.CUSTODY_APPR_DESC.IsNullOrWhiteSpace() ? data.APLY_APPR_DESC : data.CUSTODY_APPR_DESC,
vAPPRFlag = vAPPRFlag || (data.CUSTODY_UID != userId),
vACCESS_REASON = data.ACCESS_REASON,
vLast_Update_Time = data.LAST_UPDATE_DT
});
}
/// <summary>
/// 共用存檔 申請單紀錄檔 回傳參數1 (APLY_NO) 回傳參數2 (log訊息)
/// </summary>
/// <param name="db">Entity</param>
/// <param name="taData">viewModel</param>
/// <param name="logStr">紀錄訊息</param>
/// <param name="dt">修改時間</param>
/// <returns></returns>
protected Tuple <string, string> SaveTREA_APLY_REC(TreasuryDBEntities db, TreasuryAccessViewModel taData, string logStr, DateTime dt)
{
//取得流水號
SysSeqDao sysSeqDao = new SysSeqDao();
String qPreCode = DateUtil.getCurChtDateTime().Split(' ')[0];
var cId = sysSeqDao.qrySeqNo("G6", qPreCode).ToString().PadLeft(3, '0');
if (logStr.IsNullOrWhiteSpace())
{
logStr = string.Empty;
}
#region 申請單紀錄檔
var _TAR = new TREA_APLY_REC()
{
APLY_NO = $@"G6{qPreCode}{cId}", //申請單號 G6+系統日期YYYMMDD(民國年)+3碼流水號
APLY_FROM = Ref.AccessProjectStartupType.M.ToString(), //人工
ITEM_ID = taData.vItem, //申請項目
ACCESS_TYPE = taData.vAccessType, //存入(P) or 取出(G)
ACCESS_REASON = taData.vAccessReason, //申請原因
APLY_STATUS = Ref.AccessProjectFormStatus.A01.ToString(), //表單申請
EXPECTED_ACCESS_DATE = TypeTransfer.stringToDateTimeN(taData.vExpectedAccessDate), //預計存取日期
APLY_UNIT = taData.vAplyUnit, //申請單位
APLY_UID = taData.vAplyUid, //申請人
APLY_DT = dt,
CREATE_UNIT = taData.vCreateUnit, //新增單位
CREATE_UID = taData.vCreateUid, //新增人
CREATE_DT = dt,
LAST_UPDATE_UID = taData.vCreateUid,
LAST_UPDATE_DT = dt
};
if (taData.vAplyUid != taData.vCreateUid) //當申請人不是新增人(代表為保管單位代申請)
{
_TAR.CUSTODY_UID = taData.vCreateUid; //保管單位直接帶 新增人
_TAR.CUSTODY_DT = dt;
}
logStr += _TAR.modelToString(logStr);
db.TREA_APLY_REC.Add(_TAR);
#endregion
#region 申請單歷程檔
var _ARH = new APLY_REC_HIS()
{
APLY_NO = _TAR.APLY_NO,
APLY_STATUS = _TAR.APLY_STATUS,
PROC_DT = dt,
PROC_UID = _TAR.CREATE_UID
};
logStr += _ARH.modelToString(logStr);
db.APLY_REC_HIS.Add(_ARH);
#endregion
return(new Tuple <string, string>(_TAR.APLY_NO, logStr));
}
private TreasuryAccessApprSearchDetailViewModel TreaAplyRecToTAASDViewModel(
string userId,
TREA_APLY_REC data,
List <TREA_ITEM> treaItems,
List <VW_OA_DEPT> depts,
List <V_EMPLY2> emps
)
{
return(new TreasuryAccessApprSearchDetailViewModel()
{
vItem = data.ITEM_ID,
vItemDec = treaItems.FirstOrDefault(x => x.ITEM_ID == data.ITEM_ID)?.ITEM_DESC,
vAPLY_DT = data.APLY_DT?.ToString("yyyy/MM/dd"),
vAPLY_NO = data.APLY_NO,
vAPLY_UNIT = depts.FirstOrDefault(y => y.DPT_CD.Trim() == data.APLY_UNIT)?.DPT_NAME,
vAPLY_UID = data.APLY_UID,
vAPLY_UID_NAME = emps.FirstOrDefault(x => x.USR_ID == data.APLY_UID)?.EMP_NAME,
vAPPRFlag = data.CREATE_UID != userId,
vACCESS_REASON = data.ACCESS_REASON,
vLast_Update_Time = data.LAST_UPDATE_DT
});
}
/// <summary>
/// 申請覆核 電子憑證
/// </summary>
/// <param name="insertDatas">資料</param>
/// <param name="taData">申請單資料</param>
/// <returns></returns>
public MSGReturnModel <IEnumerable <ITreaItem> > ApplyAudit(IEnumerable <ITreaItem> insertDatas, TreasuryAccessViewModel taData)
{
var result = new MSGReturnModel <IEnumerable <ITreaItem> >();
result.RETURN_FLAG = false;
DateTime dt = DateTime.Now;
try
{
if (insertDatas != null)
{
var datas = (List <CAViewModel>)insertDatas;
if (datas.Any())
{
using (TreasuryDBEntities db = new TreasuryDBEntities())
{
//取得流水號
SysSeqDao sysSeqDao = new SysSeqDao();
string logStr = string.Empty; //log
var item_Seq = "E5"; //電子憑證流水號開頭編碼
String qPreCode = DateUtil.getCurChtDateTime().Split(' ')[0];
var _TAR = new TREA_APLY_REC(); //申請單號
var _APLY_STATUS = Ref.AccessProjectFormStatus.A01.ToString(); //表單申請
if (!taData.vAplyNo.IsNullOrWhiteSpace()) //修改已存在申請單
{
#region 申請單紀錄檔
_TAR = db.TREA_APLY_REC.First(x => x.APLY_NO == taData.vAplyNo);
if (CustodyAppr.Contains(_TAR.APLY_STATUS))
{
_APLY_STATUS = CustodyConfirmStatus;
_TAR.CUSTODY_UID = AccountController.CurrentUserId; //保管單位直接帶使用者
_TAR.CUSTODY_DT = dt;
}
else
{
if (_TAR.APLY_STATUS != _APLY_STATUS) //申請紀錄檔狀態不是在表單申請狀態
{
_APLY_STATUS = Ref.AccessProjectFormStatus.A05.ToString(); //為重新申請案例
}
}
_TAR.APLY_STATUS = _APLY_STATUS;
_TAR.LAST_UPDATE_DT = dt;
logStr += _TAR.modelToString(logStr);
#endregion
#region 申請單歷程檔
var _ARH = new APLY_REC_HIS()
{
APLY_NO = taData.vAplyNo,
APLY_STATUS = _APLY_STATUS,
PROC_DT = dt,
PROC_UID = taData.vCreateUid
};
logStr += _ARH.modelToString(logStr);
db.APLY_REC_HIS.Add(_ARH);
#endregion
#region 電子憑證庫存資料檔
var _dept = intra.getDept_Sect(taData.vAplyUnit);
List <string> oldItemIds = db.OTHER_ITEM_APLY.Where(x => x.APLY_NO == taData.vAplyNo).Select(x => x.ITEM_ID).ToList(); //原有 itemId
List <string> updateItemIds = new List <string>(); //更新 itemId
List <string> cancelItemIds = new List <string>(); //取消 itemId
List <ITEM_CA> inserts = new List <ITEM_CA>(); //新增資料
//抓取有修改註記的
foreach (var item in datas)
{
var _IC_Item_Id = string.Empty;
if (taData.vAccessType == Ref.AccessProjectTradeType.P.ToString()) //存入
{
//只抓取預約存入
if (item.vStatus == Ref.AccessInventoryType._3.GetDescription())
{
var _IC = new ITEM_CA();
if (item.vItemId.StartsWith(item_Seq)) //舊有資料
{
_IC = db.ITEM_CA.FirstOrDefault(x => x.ITEM_ID == item.vItemId);
if (_IC.LAST_UPDATE_DT > item.vLast_Update_Time)
{
result.DESCRIPTION = Ref.MessageType.already_Change.GetDescription();
return(result);
}
_IC.CA_DESC = item.vCA_Desc; //電子憑證品項
_IC.CA_USE = item.vCA_Use; //電子憑證用途
_IC.BANK = item.vBank; //銀行/廠商
_IC.CA_NUMBER = item.vCA_Number; //電子憑證號碼
_IC.MEMO = item.vMemo; //備註說明
updateItemIds.Add(item.vItemId);
logStr += _IC.modelToString(logStr);
}
else
{
var item_id = sysSeqDao.qrySeqNo(item_Seq, string.Empty).ToString().PadLeft(8, '0');
_IC = new ITEM_CA()
{
ITEM_ID = $@"{item_Seq}{item_id}", //物品編號
INVENTORY_STATUS = "3", //預約存入
CA_DESC = item.vCA_Desc, //電子憑證品項
CA_USE = item.vCA_Use, //電子憑證用途
BANK = item.vBank, //銀行/廠商
CA_NUMBER = item.vCA_Number, //電子憑證號碼
MEMO = item.vMemo, //備註說明
APLY_DEPT = _dept.Item1, //申請人部門
APLY_SECT = _dept.Item2, //申請人科別
APLY_UID = taData.vAplyUid, //申請人
CHARGE_DEPT = _dept.Item1, //權責部門
CHARGE_SECT = _dept.Item2, //權責科別
//PUT_DATE = dt, //存入日期時間
LAST_UPDATE_DT = dt, //最後修改時間
};
_IC_Item_Id = _IC.ITEM_ID;
inserts.Add(_IC);
logStr += _IC.modelToString(logStr);
}
}
}
else if (taData.vAccessType == Ref.AccessProjectTradeType.G.ToString() && (_APLY_STATUS != CustodyConfirmStatus))//取出
{
var _IC = db.ITEM_CA.FirstOrDefault(x => x.ITEM_ID == item.vItemId);
if (_IC.LAST_UPDATE_DT > item.vLast_Update_Time)
{
result.DESCRIPTION = Ref.MessageType.already_Change.GetDescription();
return(result);
}
//預約取出
if (item.vtakeoutFlag)
{
if (_IC.INVENTORY_STATUS == "1") //原先為在庫
{
_IC.INVENTORY_STATUS = "4"; //預約取出
_IC.LAST_UPDATE_DT = dt; //最後修改時間
updateItemIds.Add(_IC.ITEM_ID);
}
else if (_IC.INVENTORY_STATUS == "4") //原先為預約取出
{
updateItemIds.Add(_IC.ITEM_ID);
}
}
else
{
if (_IC.INVENTORY_STATUS == "4") //原先為在庫
{
_IC.INVENTORY_STATUS = "1"; //預約取出
_IC.LAST_UPDATE_DT = dt; //最後修改時間
}
}
}
}
if (taData.vAccessType == Ref.AccessProjectTradeType.P.ToString()) //存入
{
var delItemId = oldItemIds.Where(x => !updateItemIds.Contains(x)).ToList();
db.OTHER_ITEM_APLY.RemoveRange(db.OTHER_ITEM_APLY.Where(x => x.APLY_NO == taData.vAplyNo && delItemId.Contains(x.ITEM_ID)).ToList());
db.ITEM_CA.RemoveRange(db.ITEM_CA.Where(x => delItemId.Contains(x.ITEM_ID)).ToList());
db.OTHER_ITEM_APLY.AddRange(inserts.Select(x => new OTHER_ITEM_APLY()
{
APLY_NO = taData.vAplyNo,
ITEM_ID = x.ITEM_ID
}));
db.ITEM_CA.AddRange(inserts);
}
else if (taData.vAccessType == Ref.AccessProjectTradeType.G.ToString() && (_APLY_STATUS != CustodyConfirmStatus))//取出
{
db.OTHER_ITEM_APLY.RemoveRange(db.OTHER_ITEM_APLY.Where(x => x.APLY_NO == taData.vAplyNo).ToList());
db.OTHER_ITEM_APLY.AddRange(updateItemIds.Select(x => new OTHER_ITEM_APLY()
{
APLY_NO = taData.vAplyNo,
ITEM_ID = x
}));
}
#endregion
}
else
{
#region 申請單紀錄檔 & 申請單歷程檔
var data = SaveTREA_APLY_REC(db, taData, logStr, dt);
_TAR.APLY_NO = data.Item1;
logStr = data.Item2;
#endregion
#region 電子憑證庫存資料檔
var _dept = intra.getDept_Sect(taData.vAplyUnit);
//抓取有修改註記的
foreach (var item in datas)
{
var _IC_Item_Id = string.Empty;
if (taData.vAccessType == Ref.AccessProjectTradeType.P.ToString()) //存入
{
//只抓取預約存入
if (item.vStatus == Ref.AccessInventoryType._3.GetDescription())
{
var item_id = sysSeqDao.qrySeqNo(item_Seq, string.Empty).ToString().PadLeft(8, '0');
var _IC = new ITEM_CA()
{
ITEM_ID = $@"{item_Seq}{item_id}", //物品編號
INVENTORY_STATUS = "3", //預約存入
CA_DESC = item.vCA_Desc, //電子憑證品項
CA_USE = item.vCA_Use, //電子憑證用途
BANK = item.vBank, //銀行/廠商
CA_NUMBER = item.vCA_Number, //電子憑證號碼
MEMO = item.vMemo, //備註說明
APLY_DEPT = _dept.Item1, //申請人部門
APLY_SECT = _dept.Item2, //申請人科別
APLY_UID = taData.vAplyUid, //申請人
CHARGE_DEPT = _dept.Item1, //權責部門
CHARGE_SECT = _dept.Item2, //權責科別
//PUT_DATE = dt, //存入日期時間
LAST_UPDATE_DT = dt, //最後修改時間
};
_IC_Item_Id = _IC.ITEM_ID;
db.ITEM_CA.Add(_IC);
logStr += _IC.modelToString(logStr);
}
}
else if (taData.vAccessType == Ref.AccessProjectTradeType.G.ToString())//取出
{
//只抓取預約取出
if (item.vStatus == Ref.AccessInventoryType._4.GetDescription())
{
var _IC = db.ITEM_CA.FirstOrDefault(x => x.ITEM_ID == item.vItemId);
_IC_Item_Id = _IC.ITEM_ID;
if (_IC.LAST_UPDATE_DT > item.vLast_Update_Time)
{
result.DESCRIPTION = Ref.MessageType.already_Change.GetDescription();
return(result);
}
_IC.INVENTORY_STATUS = "4"; //預約取出
//_IRE.GET_DATE = dt; //取出日期時間
_IC.LAST_UPDATE_DT = dt; //最後修改時間
}
}
#region 其它存取項目申請資料檔
if (!_IC_Item_Id.IsNullOrWhiteSpace())
{
db.OTHER_ITEM_APLY.Add(
new OTHER_ITEM_APLY()
{
APLY_NO = _TAR.APLY_NO,
ITEM_ID = _IC_Item_Id
});
}
#endregion
}
#endregion
}
#region Save Db
var validateMessage = db.GetValidationErrors().getValidateString();
if (validateMessage.Any())
{
result.DESCRIPTION = validateMessage;
}
else
{
try
{
db.SaveChanges();
#region LOG
//新增LOG
Log log = new Log();
log.CFUNCTION = "申請覆核-新增電子憑證";
log.CACTION = "A";
log.CCONTENT = logStr;
LogDao.Insert(log, taData.vCreateUid);
#endregion
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.Apply_Audit_Success.GetDescription(null, $@"單號為{_TAR.APLY_NO}");
}
catch (DbUpdateException ex)
{
result.DESCRIPTION = ex.exceptionMessage();
}
}
#endregion
}
}
else
{
result.DESCRIPTION = Ref.MessageType.not_Find_Audit_Data.GetDescription();
}
}
else
{
result.DESCRIPTION = Ref.MessageType.not_Find_Audit_Data.GetDescription();
}
}
catch (Exception ex)
{
result.DESCRIPTION = ex.exceptionMessage();
}
return(result);
}