public JsonResult SetDepartment(DeptModel SearchDept)
{
try
{
int resultInt = 0;
if (SearchDept.dept_idx == null)
{
SearchDept.create_us = Convert.ToInt32(Session["USER_IDX"]);
resultInt = (int)Mapper.Instance().Insert("User.insDepartment", SearchDept);
SearchDept.dept_idx = resultInt;
LogCtrl.SetLog(SearchDept, eActionType.DataInsert, this.HttpContext, SearchDept.dept_nm);
}
else
{
resultInt = Mapper.Instance().Update("User.udtDepartment", SearchDept);
LogCtrl.SetLog(SearchDept, eActionType.DataUpdate, this.HttpContext, SearchDept.dept_nm);
}
return(Json(resultInt));
}
catch (Exception ex)
{
logger.Error(string.Format("ERROR : 부서저장"), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public JsonResult SetCommCode(CommLibraryModel commcode)
{
try
{
int resultInt = 0;
if (commcode.idx == null)
{
commcode.create_us = Convert.ToInt32(Session["USER_IDX"]);
resultInt = (int)Mapper.Instance().Insert("Common.insCommCode", commcode);
commcode.idx = resultInt;
LogCtrl.SetLog(commcode, eActionType.DataInsert, this.HttpContext, commcode.kor_nm);
}
else
{
resultInt = Mapper.Instance().Update("Common.udtCommCode", commcode);
LogCtrl.SetLog(commcode, eActionType.DataUpdate, this.HttpContext, commcode.kor_nm);
}
return(Json(resultInt));
}
catch (Exception ex)
{
logger.Error(string.Format("ERROR : 공통코드 저장"), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public ActionResult RecvView(int?dist_idx)
{
if (dist_idx == null)
{
return(RedirectToAction("ErrorView", "Error", Resources.Resource.res0270 /*잘못된 페이지를 호출하셨습니다*/));
}
var distModel = Mapper.Instance().QueryForObject <DistMasterModel>("Recv.selReciverDistInfo", new DistMasterModel {
dist_idx = dist_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
var distEoModel = Mapper.Instance().QueryForObject <DistEoModel>("DIST.selDistEo", new DistEoModel {
dist_idx = dist_idx
});
var distRecvFile = Mapper.Instance().QueryForList <DistRecvFileModel>("DIST.selDistRecvFile", new DistRecvFileModel {
dist_idx = dist_idx, recv_us = Convert.ToInt32(Session["USER_IDX"]), use_fl = "Y"
});
var distRecieverInfo = Mapper.Instance().QueryForObject <DistReceiverModel>("DIST.selDistReceiver", new DistReceiverModel {
dist_idx = dist_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
var eoBom = Mapper.Instance().QueryForList <ItfBomInfo>("Part.selPartBom", new ItfBomInfo {
eo_idx = distModel.eo_idx
});
ViewBag.distModel = distModel;
ViewBag.distEoModel = distEoModel;
ViewBag.distRecvFile = distRecvFile;
ViewBag.eoBomList = eoBom;
ViewBag.distRecieverInfo = distRecieverInfo;
LogCtrl.SetLog(distModel, eActionType.RecvView, this.HttpContext, distModel.dist_title);
return(View());
}
public JsonResult SetVender(VendModel argModel)
{
try
{
int resultInt = 0;
if (argModel.vend_idx == null)
{
argModel.create_us = Convert.ToInt32(Session["USER_IDX"]);
resultInt = (int)Mapper.Instance().Insert("User.insVender", argModel);
argModel.vend_idx = resultInt;
LogCtrl.SetLog(argModel, eActionType.DataInsert, this.HttpContext, argModel.vend_nm);
}
else
{
resultInt = Mapper.Instance().Update("User.udtVender", argModel);
LogCtrl.SetLog(argModel, eActionType.DataUpdate, this.HttpContext, argModel.vend_nm);
}
return(Json(resultInt));
}
catch (Exception ex)
{
logger.Error(string.Format("ERROR : 협력사 저장"), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public JsonResult SetDistFinish(DistMasterModel distModel)
{
try
{
if (distModel.dist_idx == null)
{
throw new Exception(Resources.Resource.res0219); /*잘못된 호출입니다*/
}
distModel.dist_st = "DF";
Mapper.Instance().Update("DIST.udtDistMaster", distModel);
Mapper.Instance().Update("DIST.udtDistReceiverStatus", new DistReceiverModel {
dist_idx = distModel.dist_idx, recv_dist_st = "DF"
});
DistMasterModel distMaster = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel {
dist_idx = distModel.dist_idx
});
LogCtrl.SetLog(distModel, eActionType.CompulsionExpire, this.HttpContext, distMaster.dist_title);
return(Json("1"));
}
catch (Exception ex)
{
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public ActionResult PdfViewer(int?link_file_idx, string is_itf)
{
string fileOrgName = string.Empty;
string fileConvName = string.Empty;
string filePath = string.Empty;
if (is_itf == "N")
{
DistTempFileModel fileInfo = Mapper.Instance().QueryForObject <DistTempFileModel>("DIST.selDistTempFile", new DistTempFileModel {
temp_file_idx = link_file_idx
});
if (fileInfo == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
fileOrgName = fileInfo.file_org_nm;
fileConvName = fileInfo.file_conv_nm;
filePath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString() + "\\" + fileInfo.dist_idx;
LogCtrl.SetLog(fileInfo, eActionType.FileView, this.HttpContext, fileInfo.file_org_nm);
}
else
{
ItfFileInfo fileInfo = Mapper.Instance().QueryForObject <ItfFileInfo>("ITF.selItfFIleInfo", new ItfFileInfo {
file_idx = link_file_idx
});
if (fileInfo == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
fileOrgName = fileInfo.file_org_nm;
fileConvName = fileInfo.file_conv_nm;
filePath = System.Configuration.ConfigurationManager.AppSettings["EoFilePath"].ToString() + "\\" + fileInfo.part_no;
LogCtrl.SetLog(fileInfo, eActionType.FileView, this.HttpContext, fileInfo.file_org_nm);
}
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = @Resources.Resource.res0366; // 파일이 없습니다.
return(View());
}
PdfWatermark watermark = new PdfWatermark();
string watermarkFile = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
string fPath = System.Configuration.ConfigurationManager.AppSettings["ViewTempFileUrl"].ToString() + "/" + Path.GetFileName(watermarkFile);
ViewBag.Massage = null;
ViewBag.FileName = fPath;
return(View());
//return View("PdfFileViewer" + (System.Web.HttpUtility.UrlEncode(fPath, System.Text.Encoding.GetEncoding("utf-8"))).Replace("+", "%20"));
}
public JsonResult SetDistEoInfo(DistEoModel distEo)
{
try
{
bool isNew = distEo.dist_idx == null ? true : false;
Mapper.Instance().BeginTransaction();
// 신규
if (isNew)
{
distEo.dist_idx = SetDistMaster(new DistMasterModel()
{
eo_fl = "Y", dist_st = "CR", create_us = Convert.ToInt32(Session["USER_IDX"])
});
Mapper.Instance().Insert("DIST.insDistEo", distEo);
}
else
{
DistEoModel compareEo = Mapper.Instance().QueryForObject <DistEoModel>("DIST.selDistEo", new DistEoModel()
{
dist_idx = distEo.dist_idx
});
// 기존 EO에 속한 파일이 있을 경우 지워버린다.
if (compareEo != null)
{
Mapper.Instance().Delete("DIST.delDistRecvEoFile", new DistRecvFileModel {
dist_idx = distEo.dist_idx, eo_idx = compareEo.eo_idx
});
Mapper.Instance().Update("DIST.udtDistEo", distEo);
}
else
{
Mapper.Instance().Insert("DIST.insDistEo", distEo);
}
SetUdtDistMaster(new DistMasterModel {
dist_idx = distEo.dist_idx
});
}
SetRecieverLinkFile(distEo.dist_idx);
DistMasterModel dist = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel()
{
dist_idx = distEo.dist_idx
});
LogCtrl.SetLog(distEo, eActionType.DistEoSave, this.HttpContext, dist.dist_title);
Mapper.Instance().CommitTransaction();
return(Json(distEo.dist_idx));
}
catch (Exception ex)
{
Mapper.Instance().RollBackTransaction();
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public int SetDistMaster(DistMasterModel distMaster)
{
int distIDX = (int)Mapper.Instance().Insert("DIST.insDistMaster", distMaster);
LogCtrl.SetLog(new DistMasterModel {
dist_idx = distIDX
}, eActionType.DistInsert, this.HttpContext, distMaster.dist_title);
return(distIDX);
}
public ActionResult BbsFileDownload(int?bbs_file_idx) //11
{
System.IO.Stream fStream = null;
string fileOrgName = string.Empty;
string fileConvName = string.Empty;
string filePath = string.Empty;
BbsFileModel bbsfile = Mapper.Instance().QueryForObject <BbsFileModel>("Bbs.selBbsFile", new BbsFileModel {
bbs_file_idx = bbs_file_idx
});
if (bbsfile == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
//foreach () { }
fileOrgName = bbsfile.file_org_nm;
fileConvName = bbsfile.file_conv_nm;
filePath = System.Configuration.ConfigurationManager.AppSettings["BbsFilePath"].ToString() + "\\" + bbsfile.bbs_idx;
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = Resources.Resource.res0366; // 파일이 없습니다.
return(View());
}
if (fileConvName.ToLower().Contains(".pdf"))
{
PdfWatermark watermark = new PdfWatermark();
string watermarkFile = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
fStream = CommonUtil.FileStream(watermarkFile);
}
else
{
fStream = CommonUtil.FileStream(filePath, fileConvName);
}
LogCtrl.SetLog(bbsfile, eActionType.FileDown, this.HttpContext, bbsfile.file_org_nm);
if (Request.Browser.Browser == "IE" || Request.Browser.Browser == "InternetExplorer")
{
return(File(fStream, MediaTypeNames.Application.Octet, HttpUtility.UrlEncode(fileOrgName, System.Text.Encoding.UTF8)));
}
else
{
return(File(fStream, MediaTypeNames.Application.Octet, fileOrgName));
}
}
public ActionResult DistPdfViewer(int?dist_file_idx)
{
string fileOrgName = string.Empty;
string fileConvName = string.Empty;
string filePath = string.Empty;
DistRecvFileModel distFile = Mapper.Instance().QueryForObject <DistRecvFileModel>("DIST.selDistRecvFile", new DistRecvFileModel {
dist_file_idx = dist_file_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
if (distFile == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
if (distFile.recv_dist_st == "DF")
{
throw new Exception(Resources.Resource.res0297);//배포가 만료된 파일입니다.
}
fileOrgName = distFile.file_org_nm;
fileConvName = distFile.file_conv_nm;
if (distFile.is_itf == "N")
{
filePath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString() + "\\" + distFile.dist_idx;
}
else
{
filePath = System.Configuration.ConfigurationManager.AppSettings["EoFilePath"].ToString() + "\\" + distFile.part_no;
}
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = Resources.Resource.res0366; //파일이 없습니다.
return(View());
}
PdfWatermark watermark = new PdfWatermark();
string watermarkFile = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
LogCtrl.SetLog(distFile, eActionType.FileView, this.HttpContext, distFile.file_org_nm);
string fPath = System.Configuration.ConfigurationManager.AppSettings["ViewTempFileUrl"].ToString() + "/" + Path.GetFileName(watermarkFile);
ViewBag.Massage = null;
ViewBag.FileName = fPath;
return(View("PdfViewer"));
}
public JsonResult DelDepartment(int deptIdx)
{
try
{
int resultInt = 0;
UserModel SearchUser = new UserModel();
SearchUser.isVender = "N";
SearchUser.isLowDepartment = "Y";
SearchUser.us_group = deptIdx;
var userList = Mapper.Instance().QueryForList <UserModel>("User.selUser", SearchUser);
if (userList.Count() > 0)
{
throw new Exception(Resources.Resource.res0309);//사용자가 있는 부서는 삭제할수 없습니다.
}
DeptModel dept = Mapper.Instance().QueryForObject <DeptModel>("User.selDepartment", new DeptModel {
dept_idx = deptIdx
});
var SonDepartment = Mapper.Instance().QueryForList <Hashtable>("User.selTargetSonDept", deptIdx);
if (SonDepartment.Count() > 1)
{
throw new Exception(Resources.Resource.res0326);//하위 부서가 존재하여 삭제 할 수 없습니다.
}
resultInt = (int)Mapper.Instance().Delete("User.delDepartment", deptIdx);
if (resultInt < 1)
{
throw new Exception(Resources.Resource.res0310);//삭제되지 않았습니다. 관리자에게 문의해주세요.
}
LogCtrl.SetLog(new DeptModel {
dept_idx = deptIdx
}, eActionType.DataDelete, this.HttpContext, dept.dept_nm);
return(Json(resultInt));
}
catch (Exception ex)
{
logger.Error(string.Format("ERROR : 부서저장"), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public ActionResult BoardModify(int?bbs_idx)
{
var bbsContentsModel = Mapper.Instance().QueryForObject <BbsContentsModel>("Bbs.selBbsContent", new BbsContentsModel {
bbs_idx = bbs_idx
});
var bbsFileModel = Mapper.Instance().QueryForList <BbsFileModel>("Bbs.selBbsFile", new BbsFileModel {
bbs_idx = bbs_idx
});
ViewBag.bbsContentsModel = bbsContentsModel;
ViewBag.bbsFileModel = bbsFileModel;
LogCtrl.SetLog(bbsContentsModel, eActionType.DataSelect, this.HttpContext);
return(View());
}
public JsonResult SetDelDistReceiver(List <DistReceiverModel> receiverModel)
{
try
{
Mapper.Instance().BeginTransaction();
DistMasterModel dist = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel()
{
dist_idx = receiverModel[0].dist_idx
});
SetUdtDistMaster(new DistMasterModel {
dist_idx = receiverModel[0].dist_idx
});
foreach (DistReceiverModel distRecv in receiverModel)
{
// 1. 수신자에 속한 배포 파일 삭제
Mapper.Instance().Delete("DIST.delDistRecvFile", new DistRecvFileModel {
dist_idx = distRecv.dist_idx, recv_idx = distRecv.recv_idx
});
// 2. 수신자 삭제
int i = (int)Mapper.Instance().Delete("DIST.delDistReceiver", new DistReceiverModel {
dist_idx = distRecv.dist_idx, recv_idx = distRecv.recv_idx
});
LogCtrl.SetLog(distRecv, eActionType.DistReceiverDelete, this.HttpContext, dist.dist_title);
if (i == 0)
{
throw new Exception(Resources.Resource.res0312);//수신자 삭제가 실패했습니다
}
}
Mapper.Instance().CommitTransaction();
return(Json(1));
}
catch (Exception ex)
{
Mapper.Instance().RollBackTransaction();
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public ActionResult BoardView(int?bbs_idx)
{//쓰고-view-list로
//내용
var bbsContentsModel = Mapper.Instance().QueryForObject <BbsContentsModel>("Bbs.selBbsContent", new BbsContentsModel {
bbs_idx = bbs_idx
});
//현재처럼 idx를 각각 가져오면 단일건을 가져오는 것. bbs_idx로 조회해서 가져와야함.
//댓글
//var bbsReplyModel = Mapper.Instance().QueryForList<BbsReplyModel>("Bbs.selBbsReply", new BbsReplyModel { bbs_idx = bbs_idx });
//파일
var bbsFileModel = Mapper.Instance().QueryForList <BbsFileModel>("Bbs.selBbsFile", new BbsFileModel {
bbs_idx = bbs_idx
});
ViewBag.bbsContentsModel = bbsContentsModel;
ViewBag.bbsFileModel = bbsFileModel;
//ViewBag.bbsReplyModel = bbsReplyModel;ajax로 보내야함.
LogCtrl.SetLog(bbsContentsModel, eActionType.DataSelect, this.HttpContext);
return(View());
}
public ActionResult BoardModify(int?bbs_idx)
{ //카테고리
var getBbsCategory = Mapper.Instance().QueryForList <CommLibraryModel>("Common.selCommCode", new CommLibraryModel {
parent_code = "Category", use_fl = "Y"
});
ViewBag.BbsCategory = getBbsCategory;
//내용
var bbsContentsModel = Mapper.Instance().QueryForObject <BbsContentsModel>("Bbs.selBbsContent", new BbsContentsModel {
bbs_idx = bbs_idx
});
//파일
var bbsFileModel = Mapper.Instance().QueryForList <BbsFileModel>("Bbs.selBbsFile", new BbsFileModel {
bbs_idx = bbs_idx
});
ViewBag.bbsContentsModel = bbsContentsModel;
ViewBag.bbsFileModel = bbsFileModel;
LogCtrl.SetLog(bbsContentsModel, eActionType.DataSelect, this.HttpContext);
return(View());
}
/// <summary>
/// 일반 사용자가 내부 파일 받을 때 쓰는 함수
/// </summary>
/// <param name="link_file_idx"></param>
/// <param name="is_itf"></param>
/// <returns></returns>
public ActionResult FileDownload(int?link_file_idx, string is_itf)
{
System.IO.Stream fStream = null;
string fileOrgName = string.Empty;
string fileConvName = string.Empty;
string filePath = string.Empty;
if (is_itf == "N")
{
DistTempFileModel fileInfo = Mapper.Instance().QueryForObject <DistTempFileModel>("DIST.selDistTempFile", new DistTempFileModel {
temp_file_idx = link_file_idx
});
if (fileInfo == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
fileOrgName = fileInfo.file_org_nm;
fileConvName = fileInfo.file_conv_nm;
filePath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString() + "\\" + fileInfo.dist_idx;
LogCtrl.SetLog(fileInfo, eActionType.FileDown, this.HttpContext, fileInfo.file_org_nm);
}
else
{
ItfFileInfo fileInfo = Mapper.Instance().QueryForObject <ItfFileInfo>("ITF.selItfFIleInfo", new ItfFileInfo {
file_idx = link_file_idx
});
if (fileInfo == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
fileOrgName = fileInfo.file_org_nm;
fileConvName = fileInfo.file_conv_nm;
filePath = System.Configuration.ConfigurationManager.AppSettings["EoFilePath"].ToString() + "\\" + fileInfo.part_no;
LogCtrl.SetLog(fileInfo, eActionType.FileDown, this.HttpContext, fileInfo.file_org_nm);
}
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = Resources.Resource.res0366; // 파일이 없습니다.
return(View());
}
if (fileConvName.ToLower().Contains(".pdf"))
{
PdfWatermark watermark = new PdfWatermark();
string watermarkFile = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
fStream = CommonUtil.FileStream(watermarkFile);
}
else
{
fStream = CommonUtil.FileStream(filePath, fileConvName);
}
if (Request.Browser.Browser == "IE" || Request.Browser.Browser == "InternetExplorer")
{
return(File(fStream, MediaTypeNames.Application.Octet, HttpUtility.UrlEncode(fileOrgName, System.Text.Encoding.UTF8)));
}
else
{
return(File(fStream, MediaTypeNames.Application.Octet, fileOrgName));
}
}
public ActionResult DistTempFileUpload(int?dist_idx)
{
try
{
if (Request.Files == null)
{
throw new Exception(Resources.Resource.res0221); /*업로드할 파일이 존재하지 않습니다*/
}
try
{
Mapper.Instance().BeginTransaction();
if (dist_idx == null)
{
dist_idx = SetDistMaster(new DistMasterModel()
{
eo_fl = "Y", dist_st = "CR", create_us = Convert.ToInt32(Session["USER_IDX"])
});
}
foreach (string f in Request.Files)
{
HttpPostedFileBase file = Request.Files[f];
DistTempFileModel distTempFileList = Mapper.Instance().QueryForObject <DistTempFileModel>("DIST.selDistTempFile", new DistTempFileModel()
{
dist_idx = dist_idx, file_org_nm = file.FileName
});
if (distTempFileList != null)
{
throw new Exception(Resources.Resource.res0327);//한 배포 건 안에 동일한 이름의 파일을 업로드 할 수 없습니다
}
string fileOrgName = file.FileName;
string fileExtension = Path.GetExtension(file.FileName);
string fileName = Path.GetFileNameWithoutExtension(file.FileName);
string fileConvNm = AESEncrypt.AESEncrypt256(fileName, dist_idx.ToString());
int?tempFileIdx = (int)Mapper.Instance().Insert("DIST.insDistTempFile", new DistTempFileModel {
dist_idx = dist_idx, file_org_nm = file.FileName, file_conv_nm = fileConvNm + fileExtension
});
string valutPath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString();
CommonUtil.FileSave(valutPath + "\\" + dist_idx, file, fileConvNm + fileExtension);
LogCtrl.SetLog(new DistTempFileModel {
dist_idx = dist_idx, temp_file_idx = tempFileIdx
}, eActionType.DistLocalFileSave, this.HttpContext, fileOrgName);
}
SetRecieverLinkFile(dist_idx);
Mapper.Instance().CommitTransaction();
return(Json(dist_idx));
}
catch (Exception ex)
{
Mapper.Instance().RollBackTransaction();
throw ex;
}
}
catch (Exception ex)
{
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public JsonResult StartDist(DistMasterModel distModel, List <DistReceiverModel> recvList)
{
try
{
Mapper.Instance().BeginTransaction();
if (recvList == null)
{
throw new Exception(Resources.Resource.res0311);// 선택 된 수신자가 없습니다
}
var distFileList = Mapper.Instance().QueryForList <DistRecvFileModel>("DIST.selDistRecvFile", new DistRecvFileModel {
dist_idx = distModel.dist_idx, use_fl = "Y"
});
if (distFileList.Count == 0)
{
throw new Exception(Resources.Resource.res0296);//"배포 할 파일이 없습니다."
}
TimeSpan TS = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")) - DateTime.Parse(distModel.finish_date);
int diffDay = TS.Days;
if (diffDay >= 0)
{
throw new Exception(Resources.Resource.res0294);//만료일은 금일 보다 이후여야 합니다
}
//selConfig
//DIST EXPIRE_TERM 10
//DIST DISCARD_TERM 20
//
ConfigModel disuseTerm = Mapper.Instance().QueryForObject <ConfigModel>("Common.selConfig", new ConfigModel {
comm_section = "DIST", comm_code = "DISCARD_TERM"
});
DateTime now = DateTime.Now;
distModel.dist_st = "DS";
distModel.dist_dt = now;
SetUdtDistMaster(distModel);
foreach (DistReceiverModel recv in recvList)
{
recv.recv_finish_dt = distModel.finish_dt;
recv.recv_dist_st = "DS";
Mapper.Instance().Update("DIST.udtDistReceiver", recv);
}
DistMasterModel distMaster = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel {
dist_idx = distModel.dist_idx
});
UserModel distUsr = Mapper.Instance().QueryForObject <UserModel>("User.selUser", new UserModel {
us_idx = distMaster.create_us
});
List <DistReceiverModel> distRecvList = Mapper.Instance().QueryForList <DistReceiverModel>("DIST.selDistReceiver", new DistReceiverModel {
dist_idx = distModel.dist_idx
}).Cast <DistReceiverModel>().ToList();
// Transaction 이 걸려 있어 임시로 데이터 대입
distMaster.dist_dt = now;
distMaster.finish_dt = distModel.finish_dt;
distMaster.dist_title = distModel.dist_title;
distMaster.dist_msg = distModel.dist_msg;
DistMail smtpMail = new DistMail(Request);
smtpMail.SetMailInfo(distMaster, distUsr, distRecvList);
smtpMail.SendMail();
LogCtrl.SetLog(distModel, eActionType.DistStart, this.HttpContext, distModel.dist_title);
Mapper.Instance().CommitTransaction();
return(Json(1));
}
catch (Exception ex)
{
Mapper.Instance().RollBackTransaction();
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public JsonResult SetVendUserEdit(UserModel user)
{
try
{
if (user.login_id.Trim() == "")
{
throw new Exception(Resources.Resource.res0157);//로그인 아이디를 입력해주세요
}
if (user.us_nm.Trim() == "")
{
throw new Exception(Resources.Resource.res0168);//사용자 이름을 입력해주세요.
}
if (user.us_email.Trim() == "")
{
throw new Exception(Resources.Resource.res0169);//사용자 이메일을 입력해주세요
}
UserModel chkUser = Mapper.Instance().QueryForObject <UserModel>("User.selUser", new UserModel {
login_id = user.login_id.Trim()
});
if (chkUser != null && chkUser.us_idx != user.us_idx)
{
throw new Exception(Resources.Resource.res0291);//"동일한 로그인 계정이 존재합니다. 로그인 아이디를 확인해주세요."
}
UserModel chkUserEmail = Mapper.Instance().QueryForObject <UserModel>("User.selUser", new UserModel {
us_email = user.us_email.Trim()
});
if (chkUserEmail != null && chkUser.us_idx != user.us_idx)
{
throw new Exception(Resources.Resource.res0292);//"동일한 메일 계정이 존재합니다. 메일을 확인해주세요."
}
user.us_role = 10;
int resultInt = 0;
user.login_id = user.login_id.Trim();
if (user.us_idx == null)
{
user.create_us = Convert.ToInt32(Session["USER_IDX"]);
user.login_pw = AESEncrypt.AESEncrypt256(CommonUtil.DefaultPassword(), user.login_id.Trim());
resultInt = (int)Mapper.Instance().Insert("User.insUser", user);
user.us_idx = resultInt;
LogCtrl.SetLog(user, eActionType.DataInsert, this.HttpContext, user.us_nm);
}
else
{
resultInt = Mapper.Instance().Update("User.udtUser", user);
LogCtrl.SetLog(user, eActionType.DataUpdate, this.HttpContext, user.us_nm);
}
return(Json(resultInt));
}
catch (Exception ex)
{
logger.Error(string.Format("ERROR : 사용자 저장"), ex);
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
public JsonResult SetDistReceiver(int?dist_idx, List <DistReceiverModel> receiverModel)
{
try
{
Mapper.Instance().BeginTransaction();
DistMasterModel dist = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel()
{
dist_idx = dist_idx
});
if (dist_idx == null)
{
dist_idx = SetDistMaster(new DistMasterModel()
{
eo_fl = "Y", dist_st = "CR", create_us = Convert.ToInt32(Session["USER_IDX"])
});
}
else
{
SetUdtDistMaster(new DistMasterModel {
dist_idx = dist_idx
});
}
var prevRecvList = Mapper.Instance().QueryForList <DistReceiverModel>("DIST.selDistReceiver", new DistReceiverModel {
dist_idx = dist_idx
});
foreach (DistReceiverModel recv in receiverModel)
{
var chkRecv = from rcv in prevRecvList
where rcv.recv_us == recv.recv_us
select rcv;
if (chkRecv.Count() > 0)
{
continue;
}
else
{
recv.dist_idx = dist_idx;
Mapper.Instance().Insert("DIST.insDistReceiver", recv);
LogCtrl.SetLog(recv, eActionType.DistReceiverSave, this.HttpContext, dist.dist_title);
}
}
SetRecieverLinkFile(dist_idx);
Mapper.Instance().CommitTransaction();
return(Json(dist_idx));
}
catch (Exception ex)
{
Mapper.Instance().RollBackTransaction();
return(Json(new ResultJsonModel {
isError = true, resultMessage = ex.Message, resultDescription = ex.ToString()
}));
}
}
/// <summary>
/// 수신자가 다운로드 받는 함수
/// </summary>
/// <param name="dist_file_idx"></param>
/// <returns></returns>
public ActionResult DistFileDownload(int?dist_file_idx)
{
System.IO.Stream fStream = null;
string fileOrgName = string.Empty;
string fileConvName = string.Empty;
string filePath = string.Empty;
DistRecvFileModel distFile = Mapper.Instance().QueryForObject <DistRecvFileModel>("DIST.selDistRecvFile", new DistRecvFileModel {
dist_file_idx = dist_file_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
DistMasterModel dist = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel {
dist_idx = distFile.dist_idx
});
if (distFile == null)
{
throw new Exception(Resources.Resource.res0320);//잘못된 파일을 호출하셨습니다.
}
if (dist.dist_st == "CR")
{
throw new Exception("배포가 진행되지 않는 파일입니다.");
}
if (dist.dist_st == "DF" && distFile.recv_dist_st == "DF")
{
throw new Exception(Resources.Resource.res0297);//배포가 만료된 파일입니다.
}
fileOrgName = distFile.file_org_nm;
fileConvName = distFile.file_conv_nm;
if (distFile.is_itf == "N")
{
filePath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString() + "\\" + distFile.dist_idx;
}
else
{
filePath = System.Configuration.ConfigurationManager.AppSettings["EoFilePath"].ToString() + "\\" + distFile.part_no;
}
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = Resources.Resource.res0366; // 파일이 없습니다.
return(View());
}
if (fileConvName.ToLower().Contains(".pdf"))
{
PdfWatermark watermark = new PdfWatermark();
string watermarkFile = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
fStream = CommonUtil.FileStream(watermarkFile);
}
else
{
fStream = CommonUtil.FileStream(filePath, fileConvName);
}
LogCtrl.SetLog(distFile, eActionType.FileDown, this.HttpContext, distFile.file_org_nm);
if (Request.Browser.Browser == "IE" || Request.Browser.Browser == "InternetExplorer")
{
return(File(fStream, MediaTypeNames.Application.Octet, HttpUtility.UrlEncode(fileOrgName, System.Text.Encoding.UTF8)));
}
else
{
return(File(fStream, MediaTypeNames.Application.Octet, fileOrgName));
}
}
public int SetUdtDistMaster(DistMasterModel distMaster)
{
LogCtrl.SetLog(distMaster, eActionType.DistSave, this.HttpContext, distMaster.dist_title);
return((int)Mapper.Instance().Update("DIST.udtDistMaster", distMaster));
}
public ActionResult DistAllFileDownload(int?dist_idx)
{
if (dist_idx == null)
{
throw new Exception(Resources.Resource.res0598);//잘못된 호출방식입니다.
}
DistMasterModel dist = Mapper.Instance().QueryForObject <DistMasterModel>("DIST.selDistMaster", new DistMasterModel {
dist_idx = dist_idx
});
DistReceiverModel recv = Mapper.Instance().QueryForObject <DistReceiverModel>("DIST.selDistReceiver", new DistReceiverModel {
dist_idx = dist_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
if (dist.dist_st == "CR")
{
throw new Exception(Resources.Resource.res0328);//"해당 배포 파일은 다운로드 할 수 없습니다."
}
if (dist.dist_st == "DF" && recv.recv_dist_st == "DF")
{
throw new Exception(Resources.Resource.res0297);//배포가 만료된 파일입니다.
}
var distFile = Mapper.Instance().QueryForList <DistRecvFileModel>("DIST.selDistRecvFile", new DistRecvFileModel {
dist_idx = dist_idx, recv_us = Convert.ToInt32(Session["USER_IDX"])
});
List <string[]> files = new List <string[]>();
foreach (DistRecvFileModel recvFile in distFile)
{
//System.IO.Stream fStream = null;
string fileOrgName = recvFile.file_org_nm;
string fileConvName = recvFile.file_conv_nm;
string filePath = string.Empty;
if (recvFile.is_itf == "N")
{
filePath = System.Configuration.ConfigurationManager.AppSettings["LocalFilePath"].ToString() + "\\" + recvFile.dist_idx;
}
else
{
filePath = System.Configuration.ConfigurationManager.AppSettings["EoFilePath"].ToString() + "\\" + recvFile.part_no;
}
string downloadFileFullPath = string.Empty;
if (!CommonUtil.IsFile(filePath, fileConvName))
{
ViewBag.Massage = Resources.Resource.res0366; // 파일이 없습니다.
return(View("Common/DistFileDownload"));
}
if (fileConvName.ToLower().Contains(".pdf"))
{
PdfWatermark watermark = new PdfWatermark();
downloadFileFullPath = watermark.SetWaterMarkPdf(filePath, fileConvName, Convert.ToInt32(Session["USER_IDX"]), CommonUtil.GetRemoteIP(this.Request));
}
else
{
downloadFileFullPath = Path.Combine(filePath, fileConvName);
}
files.Add(new string[] { downloadFileFullPath, recvFile.file_org_nm });
LogCtrl.SetLog(recvFile, eActionType.FileDown, this.HttpContext, "전체 다운로드 : " + dist.dist_title);
}
using (var memoryStream = new MemoryStream())
{
using (ZipArchive ziparchive = new ZipArchive(memoryStream, ZipArchiveMode.Create, true))
{
for (int i = 0; i < files.Count; i++)
{
if (System.IO.File.Exists(files[i][0].ToString()))
{
ziparchive.CreateEntryFromFile(files[i][0].ToString(), files[i][1].ToString());
}
}
}
return(File(memoryStream.ToArray(), "application/zip", HttpUtility.UrlEncode(dist.dist_title + ".zip", System.Text.Encoding.UTF8)));
}
}
