public void StatusManage()
{
DmsBiz biz = new DmsBiz();
NpgsqlTransaction tran = biz.dbCon.DBBeginTrans();
try
{
var distList = biz.GetDistList();
if (!(distList == null || distList.Count == 0))
{
foreach (DistMasterModel dist in distList)
{
DateTime chkDt;
string sChkDate = string.Empty;
string sStatus = dist.dist_st;
string sNextStatus = string.Empty;
sChkDate = dist.finish_date;
chkDt = DateTime.Parse(sChkDate);
TimeSpan TS = chkDt - DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
int diffDay = TS.Days;
if (diffDay >= 0)
{
continue;
}
biz.UpdateDistStatus(tran, new DistMasterModel()
{
dist_idx = dist.dist_idx, dist_st = "DF"
});
ActionHistoryModel log = new ActionHistoryModel();
log.action_module = dist.action_module;
log.action_module_idx = dist.action_module_idx;
log.action_type = eActionType.Expire;
log.action_target_idx = dist.target_idx;
biz.UpdateLog(log);
}
}
var recvDistList = biz.GetRecvDistList();
if (!(recvDistList == null || recvDistList.Count == 0))
{
foreach (DistReceiverModel recv in recvDistList)
{
DateTime chkDt;
string sChkDate = string.Empty;
string sStatus = recv.recv_dist_st;
string sNextStatus = string.Empty;
sChkDate = recv.recv_finish_date;
chkDt = DateTime.Parse(sChkDate);
TimeSpan TS = chkDt - DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
int diffDay = TS.Days;
if (diffDay >= 0)
{
continue;
}
biz.UpdateRecvDistStatus(tran, new DistReceiverModel()
{
recv_idx = recv.recv_idx, recv_dist_st = "DF"
});
ActionHistoryModel log = new ActionHistoryModel();
log.action_module = recv.action_module;
log.action_module_idx = recv.action_module_idx;
log.action_type = eActionType.Expire;
log.action_target_idx = recv.target_idx;
biz.UpdateLog(log);
}
}
biz.dbCon.DBCommit(tran);
}
catch (Exception ex)
{
biz.dbCon.DBRollBack(tran);
throw ex;
}
finally
{
biz.dbCon.DBDisconnect();
}
}
