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"));
}
