public void FileRemove() { NpgsqlTransaction tran = biz.dbCon.DBBeginTrans(); try { FileControl fileCtrl = new FileControl(); string isFileDelete = biz.SysConfigValue("FILE", "IS_DEL"); if (isFileDelete != "Y") { return; } string iniPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + @"\ini\app.ini"; string filePath = CfgControl.IniReadValue("PROCESS", "ITF_FILE_FOLDER", iniPath); int fileDelTermDay = Convert.ToInt32(biz.SysConfigValue("FILE", "DEL_TERM")); List <ItfFileInfo> fileList = biz.TermFileList(fileDelTermDay); if (fileList.Count == 0) { return; } foreach (ItfFileInfo file in fileList) { string fileFullPath = Path.Combine(filePath, file.part_no); try { fileCtrl.DeleteFile(fileFullPath, file.file_org_nm); } catch { } biz.UpdateFileStatus(tran, file.file_idx); ActionHistoryModel log = new ActionHistoryModel(); log.action_module = file.action_module; log.action_module_idx = null; log.action_type = eActionType.FileDelete; log.action_target_idx = file.target_idx; biz.UpdateLog(log); } biz.dbCon.DBCommit(tran); } catch (Exception ex) { biz.dbCon.DBRollBack(tran); throw ex; } finally { biz.dbCon.DBDisconnect(); } }
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(); } }