public ActionResult qryEquipByKey(string equipId)
{
TreaEquipDao treaEquipDao = new TreaEquipDao();
try
{
TREA_EQUIP equip = new TREA_EQUIP();
equip = treaEquipDao.qryByKey(equipId);
return(Json(new { success = true, equip = equip }));
}
catch (Exception e)
{
logger.Error("[qryEquipByKey]:" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
/// <summary>
/// 金庫進出管理作業-覆核
/// </summary>
/// <param name="db">Entities</param>
/// <param name="aplyNos">覆核的申請單號</param>
/// <param name="logStr">log</param>
/// <param name="dt">執行時間</param>
/// <param name="userId">覆核人ID</param>
/// <returns></returns>
public Tuple <bool, string> TinApproved(TreasuryDBEntities db, List <string> aplyNos, string logStr, DateTime dt, string userId)
{
SysSeqDao sysSeqDao = new SysSeqDao();
foreach (var aplyNo in aplyNos)
{
var _TreaEquipHisList = db.TREA_EQUIP_HIS.AsNoTracking().Where(x => x.APLY_NO == aplyNo).ToList();
if (_TreaEquipHisList.Any())
{
foreach (var TreaEquipHis in _TreaEquipHisList)
{
var _Trea_Equip_Id = string.Empty;
//金庫設備設定檔
var _TreaEquip = db.TREA_EQUIP.FirstOrDefault(x => x.TREA_EQUIP_ID == TreaEquipHis.TREA_EQUIP_ID);
if (_TreaEquip != null)
{
_TreaEquip.DATA_STATUS = "1";//可異動
_TreaEquip.EQUIP_NAME = TreaEquipHis.EQUIP_NAME;
_TreaEquip.CONTROL_MODE = TreaEquipHis.CONTROL_MODE;
_TreaEquip.NORMAL_CNT = TreaEquipHis.NORMAL_CNT;
_TreaEquip.RESERVE_CNT = TreaEquipHis.RESERVE_CNT;
_TreaEquip.MEMO = TreaEquipHis.MEMO;
_TreaEquip.IS_DISABLED = TreaEquipHis.IS_DISABLED;
_TreaEquip.FREEZE_DT = null;
_TreaEquip.FREEZE_UID = null;
_TreaEquip.APPR_UID = userId;
_TreaEquip.APPR_DT = dt;
logStr += _TreaEquip.modelToString(logStr);
}
else
{
_Trea_Equip_Id = $@"D2{sysSeqDao.qrySeqNo("D2", string.Empty).ToString().PadLeft(3, '0')}";
//新增至TREA_EQUIP
var _TE = new TREA_EQUIP()
{
TREA_EQUIP_ID = _Trea_Equip_Id,
EQUIP_NAME = TreaEquipHis.EQUIP_NAME,
CONTROL_MODE = TreaEquipHis.CONTROL_MODE,
NORMAL_CNT = TreaEquipHis.NORMAL_CNT,
RESERVE_CNT = TreaEquipHis.RESERVE_CNT,
MEMO = TreaEquipHis.MEMO,
IS_DISABLED = TreaEquipHis.IS_DISABLED,
DATA_STATUS = "1",//可異動
CREATE_UID = TreaEquipHis.APLY_UID,
CREATE_DT = dt,
LAST_UPDATE_UID = TreaEquipHis.APLY_UID,
LAST_UPDATE_DT = dt,
APPR_UID = userId,
APPR_DT = dt
};
logStr += _TE.modelToString();
db.TREA_EQUIP.Add(_TE);
}
//金庫設備異動檔
var _TreaEquipHis = db.TREA_EQUIP_HIS.FirstOrDefault(x => x.APLY_NO == TreaEquipHis.APLY_NO && x.HIS_ID == TreaEquipHis.HIS_ID);
if (_TreaEquipHis != null)
{
if (_TreaEquipHis.TREA_EQUIP_ID.IsNullOrWhiteSpace())
{
_TreaEquipHis.TREA_EQUIP_ID = _Trea_Equip_Id;
}
_TreaEquipHis.APPR_STATUS = "2";//覆核完成
_TreaEquipHis.APPR_DATE = dt;
_TreaEquipHis.APPR_UID = userId;
logStr = _TreaEquipHis.modelToString(logStr);
}
else
{
return(new Tuple <bool, string>(false, logStr));
}
}
}
else
{
return(new Tuple <bool, string>(false, logStr));
}
}
return(new Tuple <bool, string>(true, logStr));
}
/// <summary>
/// 金庫進出管理作業-申請覆核
/// </summary>
/// <param name="saveData">申請覆核的資料</param>
/// <param name="searchModel">查詢ViwModel</param>
/// <returns></returns>
public MSGReturnModel <IEnumerable <ITinItem> > TinApplyAudit(IEnumerable <ITinItem> saveData, ITinItem searchModel)
{
var searchData = (TreasuryMaintainSearchViewModel)searchModel;
var result = new MSGReturnModel <IEnumerable <ITinItem> >();
result.RETURN_FLAG = false;
DateTime dt = DateTime.Now;
try
{
if (saveData != null)
{
var datas = (List <TreasuryMaintainViewModel>)saveData;
if (datas.Any())
{
using (TreasuryDBEntities db = new TreasuryDBEntities())
{
//取得流水號
SysSeqDao sysSeqDao = new SysSeqDao();
String qPreCode = DateUtil.getCurChtDateTime().Split(' ')[0];
string _Aply_No = string.Empty;
var cId = sysSeqDao.qrySeqNo("G2", qPreCode).ToString().PadLeft(3, '0');
_Aply_No = $@"G2{qPreCode}{cId}"; //申請單號 G2+系統日期YYYMMDD(民國年)+3碼流水號
string logStr = string.Empty; //log
foreach (var item in datas)
{
var _Trea_Equip_Id = string.Empty;
var _TE = new TREA_EQUIP();
#region 金庫設備設定檔
//判斷執行功能
switch (item.vExec_Action)
{
case "A": //新增
_Trea_Equip_Id = "";
//_Trea_Equip_Id = sysSeqDao.qrySeqNo("D2", string.Empty).ToString().PadLeft(3, '0');
//_Trea_Equip_Id = $@"D2{_Trea_Equip_Id}";
//_TE = new TREA_EQUIP()
//{
// TREA_EQUIP_ID = _Trea_Equip_Id,
// EQUIP_NAME = item.vEquip_Name,
// CONTROL_MODE = item.vControl_Mode,
// NORMAL_CNT = item.vNormal_Cnt,
// RESERVE_CNT = item.vReserve_Cnt,
// MEMO = item.vMemo,
// IS_DISABLED = "N",
// DATA_STATUS = "2",//凍結中
// CREATE_UID = searchData.vLast_Update_Uid,
// CREATE_DT = dt,
// LAST_UPDATE_UID = searchData.vLast_Update_Uid,
// LAST_UPDATE_DT = dt,
// FREEZE_UID = searchData.vLast_Update_Uid,
// FREEZE_DT = dt
//};
//db.TREA_EQUIP.Add(_TE);
//logStr += "|";
//logStr += _TE.modelToString();
break;
case "U": //修改
_TE = db.TREA_EQUIP.FirstOrDefault(x => x.TREA_EQUIP_ID == item.vTrea_Equip_Id);
if (_TE.LAST_UPDATE_DT != null && _TE.LAST_UPDATE_DT > item.vLast_Update_Dt)
{
result.DESCRIPTION = Ref.MessageType.already_Change.GetDescription();
return(result);
}
_Trea_Equip_Id = item.vTrea_Equip_Id;
_TE.DATA_STATUS = "2";//凍結中
_TE.LAST_UPDATE_UID = searchData.vLast_Update_Uid;
_TE.LAST_UPDATE_DT = dt;
_TE.FREEZE_UID = searchData.vLast_Update_Uid;
_TE.FREEZE_DT = dt;
logStr += "|";
logStr += _TE.modelToString();
break;
case "D": //刪除
_TE = db.TREA_EQUIP.FirstOrDefault(x => x.TREA_EQUIP_ID == item.vTrea_Equip_Id);
if (_TE.LAST_UPDATE_DT != null && _TE.LAST_UPDATE_DT > item.vLast_Update_Dt)
{
result.DESCRIPTION = Ref.MessageType.already_Change.GetDescription();
return(result);
}
_Trea_Equip_Id = item.vTrea_Equip_Id;
_TE.DATA_STATUS = "2";//凍結中
_TE.LAST_UPDATE_UID = searchData.vLast_Update_Uid;
_TE.LAST_UPDATE_DT = dt;
_TE.FREEZE_UID = searchData.vLast_Update_Uid;
_TE.FREEZE_DT = dt;
logStr += "|";
logStr += _TE.modelToString();
break;
default:
break;
}
#endregion 金庫設備設定檔
#region 金庫設備異動檔
var _TE_Data = db.TREA_EQUIP.FirstOrDefault(x => x.TREA_EQUIP_ID == item.vTrea_Equip_Id);
if (_TE_Data == null)
{
var _TEH = new TREA_EQUIP_HIS()
{
APLY_NO = _Aply_No,
TREA_EQUIP_ID = _Trea_Equip_Id,
EXEC_ACTION = item.vExec_Action,
EQUIP_NAME = item.vEquip_Name,
CONTROL_MODE = item.vControl_Mode,
NORMAL_CNT = item.vNormal_Cnt,
RESERVE_CNT = item.vReserve_Cnt,
MEMO = item.vMemo,
IS_DISABLED = item.vIs_Disabled,
APPR_STATUS = "1",//表單申請
APLY_UID = searchData.vLast_Update_Uid,
APLY_DATE = dt
};
db.TREA_EQUIP_HIS.Add(_TEH);
logStr += "|";
logStr += _TEH.modelToString();
}
else
{
var _TEH = new TREA_EQUIP_HIS()
{
APLY_NO = _Aply_No,
TREA_EQUIP_ID = _Trea_Equip_Id,
EXEC_ACTION = item.vExec_Action,
EQUIP_NAME = item.vEquip_Name,
CONTROL_MODE = item.vControl_Mode,
NORMAL_CNT = item.vNormal_Cnt,
RESERVE_CNT = item.vReserve_Cnt,
MEMO = item.vMemo,
IS_DISABLED = item.vIs_Disabled,
APPR_STATUS = "1",//表單申請
EQUIP_NAME_B = _TE_Data.EQUIP_NAME,
CONTROL_MODE_B = _TE_Data.CONTROL_MODE,
NORMAL_CNT_B = _TE_Data.NORMAL_CNT,
RESERVE_CNT_B = _TE_Data.RESERVE_CNT,
MEMO_B = _TE_Data.MEMO,
IS_DISABLED_B = _TE_Data.IS_DISABLED,
APLY_UID = searchData.vLast_Update_Uid,
APLY_DATE = dt
};
db.TREA_EQUIP_HIS.Add(_TEH);
logStr += "|";
logStr += _TEH.modelToString();
}
#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, searchData.vLast_Update_Uid);
#endregion LOG
result.RETURN_FLAG = true;
result.DESCRIPTION = Ref.MessageType.Apply_Audit_Success.GetDescription(null, $@"單號為{_Aply_No}");
}
catch (DbUpdateException ex)
{
result.DESCRIPTION = ex.exceptionMessage();
}
}
#endregion Save Db
}
}
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);
}
