public async Task <IActionResult> Machine_action(machine doc, int?idx, string mode_type) { #region 기본 사용자 정보 string user_id = User.Identity.Name; int department_idx = Convert.ToInt32(UserData.user_get(user_id, "department_idx")); int company_idx = Convert.ToInt32(UserData.user_get(user_id, "company_idx")); int auth = Convert.ToInt32(UserData.user_get(user_id, "auth")); #endregion if (idx == null) { #region 저장 doc.company_idx = company_idx; doc.use_yn = "Y"; doc.writeDate = DateTime.Now; db.machine.Add(doc); await db.SaveChangesAsync(); #endregion } else { if (mode_type == "D") { #region 사용안함 machine _update = (from a in db.machine where a.idx == idx select a).Single(); _update.use_yn = "N"; await db.SaveChangesAsync(); #endregion } else { #region 수정 doc.writeDate = DateTime.Now; db.Entry(doc).State = EntityState.Modified; await db.SaveChangesAsync(); return(Redirect("/management/Machine_set?idx=" + idx)); #endregion } } return(Redirect("/management/Machine_list")); }
public ActionResult code_nationality_action(code_nationality doc, string mode_type, string idx) { string msg = ""; if (string.IsNullOrEmpty(idx)) { #region 저장 doc.write_date = DateTime.Now; doc.writer_id = User.Identity.Name; doc.index_order = 9; doc.use_yn = "Y"; db.code_nationality.Add(doc); db.SaveChanges(); // 실제로 저장 msg = Util.msg.msg_insert; #endregion } else { if (mode_type == "D") { #region 삭제 code_nationality doc_del = db.code_nationality.Single(x => x.code_id == idx); db.code_nationality.Remove(doc_del); db.SaveChanges(); msg = Util.msg.msg_del; #endregion } else { #region 수정 doc.writer_id = User.Identity.Name; doc.write_date = DateTime.Now; doc.index_order = 9; doc.use_yn = "Y"; db.Entry(doc).State = EntityState.Modified; db.SaveChanges(); msg = Util.msg.msg_edit; #endregion } } return(Redirect("/code/code_nationality_list")); }
public async Task <IActionResult> sample_action(sample doc, int?idx, string mode_type) { if (idx == null) { #region 저장 doc.use_yn = "Y"; doc.writeDate = DateTime.Now; db.sample.Add(doc); await db.SaveChangesAsync(); #endregion } else { if (mode_type == "D") { #region 사용안함 sample _update = (from a in db.sample where a.idx == idx select a).Single(); _update.use_yn = "N"; await db.SaveChangesAsync(); #endregion } else { #region 수정 doc.writeDate = DateTime.Now; db.Entry(doc).State = EntityState.Modified; await db.SaveChangesAsync(); return(Redirect("/samples/sample_set?idx=" + idx)); #endregion } } return(Redirect("/samples/sample_list")); }
public async Task <IActionResult> Board_action(BoardList doc, int?idx, int cate, string mode_type, List <IFormFile> files) { string file_id = ""; string user_id = User.Identity.Name; string msg = ""; if (idx == null) { msg = "입력"; file_id = DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); #region 저장 doc.fileId = file_id; doc.useable = "Y"; doc.writeDate = DateTime.Now; doc.editDate = DateTime.Now; db.BoardList.Add(doc); db.SaveChanges(); // 실제로 저장 #endregion } else { int _idx = Convert.ToInt32(idx); if (mode_type == "D") { #region 삭제 msg = "삭제"; BoardList _update = (from a in db.BoardList where a.idx == idx select a).Single(); _update.useable = "N"; _update.delDate = DateTime.Now; db.SaveChanges(); // 실제로 저장 #endregion } else { #region 수정 msg = "수정"; #region 일 아이디 file_id = doc.fileId; if (string.IsNullOrEmpty(file_id)) { file_id = user_id + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); doc.fileId = file_id; } #endregion doc.editDate = DateTime.Now; doc.writeDate = DateTime.Now; db.Entry(doc).State = EntityState.Modified; //idx 제외 업데이트================================= db.Entry(doc).Property("idx").IsModified = false; //================================================== db.SaveChanges(); #endregion } } #region 일 올리기 var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json"); Configuration = builder.Build(); string Models_photo = Configuration["user_app:file_list_url"]; string company_id = UserData.user_get(user_id, "company_id"); int s = 1; foreach (var formFile in files) { double file_size = formFile.Length; if (file_size < _fileSizeLimit) { var formFileContent = await FileHelpers .ProcessFormFile <IFormFile>( formFile, ModelState, _permittedExtensions, _fileSizeLimit); #region 변수 // 변수 ========================================================================================================================= string only = user_id + DateTime.Today.ToShortDateString().Replace("-", "") + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); // var trustedFileNameForFileStorage = Path.GetRandomFileName(); //랜덤이름 string file_ex = ""; // 확장자 try { file_ex = Path.GetFileName(formFile.FileName).Split('.').Last(); } catch { } var _fileName = only + "." + file_ex; // 신규 파일 이름 var _local_path = _targetFilePath + company_id + "/"; // 신규 파일 경로 var filePath = Path.Combine(_local_path, _fileName); // 전체 경로 string desiredThumbPath = _local_path + "s/"; // 작은 이미지 전체 경로 string ore_fileName = Path.GetFileName(formFile.FileName); #endregion //경로에 폴더가 없으면 만들어준다.============================================= var dInfo = new DirectoryInfo(_local_path); var dInfo_s = new DirectoryInfo(desiredThumbPath); if (!dInfo.Exists) { dInfo.Create(); } if (!dInfo_s.Exists) { dInfo_s.Create(); } //================================================================================= using (var fileStream = System.IO.File.Create(filePath)) { await fileStream.WriteAsync(formFileContent); } if (get_word.img_check(file_ex) == "img") { // 세로 기준 ResizeImage(desiredThumbPath, formFile, _fileName, 300, 0); } var _insert = new BoardFile() { Md_id = file_id, ImagePath = Models_photo + company_id + "/" + _fileName, fileName = ore_fileName, use_yn = "Y", file_ex = file_ex, file_size = file_size, r_date = DateTime.Now, write_id = user_id, sImagePath = Models_photo + company_id + "/s/" + _fileName, }; db.BoardFile.Add(_insert); db.SaveChanges(); } s++; } #endregion //=============================================================================== UserData history = new UserData(); history.History_write(User.Identity.Name, "/board/boardwrite/cate=" + cate, msg); //============================================================================== string returnUrl = "/board/board_list?cate=" + cate; return(Redirect(returnUrl)); }
public async Task <IActionResult> company_set_action(List <IFormFile> ImageFile, company doc, string mode_type, string idx) { string msg = ""; #region 기본 사용자 정보 string user_id = User.Identity.Name; string company_id = UserData.user_get(user_id, "company_id"); string department_idx = UserData.user_get(user_id, "department_idx"); string auth = UserData.user_get(user_id, "auth"); string file_id = ""; #endregion int _id = 1; try { _id = (from a in db.company select a.idx).Max() + 1; } catch { } if (doc.use_yn == "on") { doc.use_yn = "Y"; } else { doc.use_yn = "N"; } if (idx == null) { #region 저장 file_id = company_id + department_idx + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); doc.write_date = DateTime.Now; doc.file_id = file_id; doc.index_order = _id; db.company.Add(doc); db.SaveChanges(); // 실제로 저장 msg = Util.msg.msg_insert; #endregion } else { if (mode_type == "D") { #region 삭제 //int _idx = Convert.ToInt32(idx); //company doc_del = db.company.Single(x => x.idx == _idx); //db.company.Remove(doc_del); //db.SaveChanges(); doc.write_date = DateTime.Now; doc.use_yn = "N"; db.Entry(doc).State = EntityState.Modified; //idx 제외 업데이트================================= db.Entry(doc).Property("company_id").IsModified = false; db.Entry(doc).Property("company_name").IsModified = false; db.Entry(doc).Property("nationality").IsModified = false; //================================================== db.SaveChanges(); msg = Util.msg.msg_del; #endregion } else { #region 수정 file_id = doc.file_id; if (string.IsNullOrEmpty(file_id)) { file_id = company_id + department_idx + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); doc.file_id = file_id; } doc.write_date = DateTime.Now; doc.index_order = _id; db.Entry(doc).State = EntityState.Modified; //idx 제외 업데이트================================= db.Entry(doc).Property("company_id").IsModified = false; //================================================== db.SaveChanges(); msg = Util.msg.msg_edit; #endregion } } #region 일 올리기 var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json"); Configuration = builder.Build(); string Models_photo = Configuration["user_app:file_list_url"]; int s = 1; foreach (var formFile in ImageFile) { double file_size = formFile.Length; if (file_size < _fileSizeLimit) { var formFileContent = await FileHelpers .ProcessFormFile <IFormFile>( formFile, ModelState, _permittedExtensions, _fileSizeLimit); #region 변수 // 변수 ========================================================================================================================= string only = user_id + DateTime.Today.ToShortDateString().Replace("-", "") + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); // var trustedFileNameForFileStorage = Path.GetRandomFileName(); //랜덤이름 string file_ex = ""; // 확장자 try { file_ex = Path.GetFileName(formFile.FileName).Split('.').Last(); } catch { } var _fileName = only + "." + file_ex; // 신규 파일 이름 var _local_path = _targetFilePath + company_id + "/"; // 신규 파일 경로 var filePath = Path.Combine(_local_path, _fileName); // 전체 경로 string desiredThumbPath = _local_path + "s/"; // 작은 이미지 전체 경로 string ore_fileName = Path.GetFileName(formFile.FileName); #endregion //경로에 폴더가 없으면 만들어준다.============================================= var dInfo = new DirectoryInfo(_local_path); var dInfo_s = new DirectoryInfo(desiredThumbPath); if (!dInfo.Exists) { dInfo.Create(); } if (!dInfo_s.Exists) { dInfo_s.Create(); } //================================================================================= using (var fileStream = System.IO.File.Create(filePath)) { await fileStream.WriteAsync(formFileContent); } if (get_word.img_check(file_ex) == "img") { // 세로 기준 ResizeImage(desiredThumbPath, formFile, _fileName, 300, 0); } var _insert = new Md_Image() { Md_id = file_id, ImagePath = Models_photo + company_id + "/" + _fileName, fileName = ore_fileName, use_yn = "Y", file_ex = file_ex, file_size = file_size, r_date = DateTime.Now, write_id = doc.company_id, sImagePath = Models_photo + company_id + "/s/" + _fileName, }; db.Md_Image.Add(_insert); db.SaveChanges(); } s++; } #endregion return(Redirect("/sys/company_set_list")); }