public IActionResult ParameterChangeOrderNo(Int64 ParameterID1, Int64 ParameterID2, int OrderNo1, int OrderNo2)
{
ExcelHepler Helper = new ExcelHepler(_hostingEnvironment);
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
ParameterService parameterService = new ParameterService(_context);
FileService FileService = new FileService(_hostingEnvironment, _context);
PDC_Parameter item1 = parameterService.GetParameterOne(ParameterID1);
PDC_Parameter item2 = parameterService.GetParameterOne(ParameterID2);
string ErrorMsg = string.Empty;
item1.OrderNo = OrderNo1;
item1.Modifyer = userId;
item1.ModifyerName = userName;
item1.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(item1, ref ErrorMsg);
item2.OrderNo = OrderNo2;
item2.Modifyer = userId;
item2.ModifyerName = userName;
item2.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(item2, ref ErrorMsg);
return(Json(ErrorMsg));
}
public IActionResult UploadWorkDetail(string ParameterText, string ParameterValue, IFormFile file)
{
ParameterService parameterService = new ParameterService(_context);
FileService FileService = new FileService(_hostingEnvironment, _context);
string ErrorMsg = string.Empty;
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
PDC_File newFile = new PDC_File();
PDC_Parameter item = parameterService.GetParameterOne("ConfigurationWorkDetail");
if (file.Length > 0)
{
PDC_File WorkDetail_File = FileService.GetFileList("ConfigurationWorkDetail", item.ParameterID).FirstOrDefault();
if (WorkDetail_File != null)
{
FileService.FileRemove(WorkDetail_File.FileID);
}
FileService.FileAdd(file, "ConfigurationWorkDetail", userId, userName, out newFile, item.ParameterID);
}
item.ParameterText = ParameterText;
item.ParameterValue = ParameterValue;
item.Modifyer = userId;
item.ModifyerName = userName;
item.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(item, ref ErrorMsg);
return(Json(new { ErrorMsg = ErrorMsg, File = newFile }));
}
public bool UpdateParameter(PDC_Parameter NewParameter, ref string ErrorMsg)
{
ErrorMsg = string.Empty;
try
{
PDC_Parameter OldParameter = GetParameterOne(NewParameter.ParameterID);
OldParameter.ParameterValue = NewParameter.ParameterValue;
OldParameter.ParameterType = NewParameter.ParameterType;
OldParameter.ParameterText = NewParameter.ParameterText;
OldParameter.ParameterParentID = NewParameter.ParameterParentID;
OldParameter.ParameterNote = NewParameter.ParameterNote;
OldParameter.ParameterName = NewParameter.ParameterName;
OldParameter.ParameterGroup = NewParameter.ParameterGroup;
OldParameter.ParameterDesc = NewParameter.ParameterDesc;
OldParameter.Modifyer = NewParameter.Modifyer;
OldParameter.ModifyerName = NewParameter.ModifyerName;
OldParameter.ModifyerDate = NewParameter.ModifyerDate;
_context.SaveChanges();
ErrorMsg = "儲存成功";
}
catch (Exception ex)
{
ErrorMsg = "儲存失敗";
return(false);
}
return(true);
}
public PDC_Parameter GetParameterOne(string ParameterGroup)
{
PDC_Parameter item = new PDC_Parameter();
item = _context.PDC_Parameter.Where(x => x.ParameterGroup == ParameterGroup).FirstOrDefault();
return(item);
}
public PDC_Parameter GetParameterOne(Int64 ParameterID)
{
PDC_Parameter item = new PDC_Parameter();
item = _context.PDC_Parameter.Where(x => x.ParameterID == ParameterID).FirstOrDefault();
return(item);
}
public m_ConfigurationPartial()
{
CNS_Sample = new PDC_File();
HomeLinkList = new List <PDC_Parameter>();
HomeLinkFileList = new List <PDC_File>();
m_HomeLink = new PDC_Parameter();
m_HomeLinkFile = new PDC_File();
PCBTypeList = new List <SelectListItem>();
PCBTypeItemList = new List <SelectListItem>();
}
public IActionResult PCBParameterDelete(Int64 ParameterID)
{
ExcelHepler Helper = new ExcelHepler(_hostingEnvironment);
if (_context.PDC_Parameter.Where(x => x.ParameterID == ParameterID).Any())
{
PDC_Parameter item = _context.PDC_Parameter.Where(x => x.ParameterID == ParameterID).SingleOrDefault();
_context.PDC_Parameter.Remove(item);
_context.SaveChanges();
}
return(Json("刪除成功"));
}
public bool AddParameter(ref PDC_Parameter NewParameter, ref string ErrorMsg)
{
ErrorMsg = string.Empty;
try
{
_context.PDC_Parameter.Add(NewParameter);
_context.SaveChanges();
ErrorMsg = "儲存成功";
}
catch (Exception ex)
{
ErrorMsg = "儲存失敗";
return(false);
}
return(true);
}
public IActionResult PCBParameterAdd(string ParameterText, Int64 ParameterID, int OrderNo)
{
ExcelHepler Helper = new ExcelHepler(_hostingEnvironment);
PDC_Parameter item = new PDC_Parameter();
item.IsSync = false;
item.OrderNo = OrderNo;
item.ParameterText = ParameterText;
item.ParameterGroup = "PCBTypeList_Item";
item.ParameterParentID = ParameterID;
item.Creator = "c5805dbf-dac5-41e6-bb72-5eb0b449134d";
item.CreatorDate = DateTime.Now;
item.CreatorName = "*****@*****.**";
_context.PDC_Parameter.Add(item);
_context.SaveChanges();
return(Json(item));
}
public IActionResult SavePCB(Int64 ParameterID, string ParameterDesc)
{
ParameterService parameterService = new ParameterService(_context);
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
PDC_Parameter m_PCBParameter = parameterService.GetParameterOne(ParameterID);
string ErrorMsg = string.Empty;
m_PCBParameter.ParameterDesc = ParameterDesc;
m_PCBParameter.Modifyer = userId;
m_PCBParameter.ModifyerName = userName;
m_PCBParameter.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(m_PCBParameter, ref ErrorMsg);
return(Json(ErrorMsg));
}
public IActionResult UploadProjectTime(string ApplyDrawText, string SendReturnText, string ReleaseText, string RejectText)
{
ParameterService parameterService = new ParameterService(_context);
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
string ErrorMsg = string.Empty;
PDC_Parameter ApplyDrawitem = parameterService.GetParameterOne("ConfigurationApplyDraw");
ApplyDrawitem.ParameterText = ApplyDrawText;
ApplyDrawitem.Modifyer = userId;
ApplyDrawitem.ModifyerName = userName;
ApplyDrawitem.ModifyerDate = DateTime.Now;
PDC_Parameter SendReturnitem = parameterService.GetParameterOne("ConfigurationSendReturn");
SendReturnitem.ParameterText = SendReturnText;
SendReturnitem.Modifyer = userId;
SendReturnitem.ModifyerName = userName;
SendReturnitem.ModifyerDate = DateTime.Now;
PDC_Parameter Releaseitem = parameterService.GetParameterOne("ConfigurationRelease");
Releaseitem.ParameterText = ReleaseText;
Releaseitem.Modifyer = userId;
Releaseitem.ModifyerName = userName;
Releaseitem.ModifyerDate = DateTime.Now;
PDC_Parameter Rejectitem = parameterService.GetParameterOne("ConfigurationReject");
Rejectitem.ParameterText = RejectText;
Rejectitem.Modifyer = userId;
Rejectitem.ModifyerName = userName;
Rejectitem.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(ApplyDrawitem, ref ErrorMsg);
parameterService.UpdateParameter(SendReturnitem, ref ErrorMsg);
parameterService.UpdateParameter(Releaseitem, ref ErrorMsg);
parameterService.UpdateParameter(Rejectitem, ref ErrorMsg);
return(Json(ErrorMsg));
}
public IActionResult HomeLinkDelete(Int64 ParameterID)
{
ExcelHepler Helper = new ExcelHepler(_hostingEnvironment);
if (_context.PDC_Parameter.Where(x => x.ParameterID == ParameterID).Any())
{
PDC_Parameter item = _context.PDC_Parameter.Where(x => x.ParameterID == ParameterID).SingleOrDefault();
_context.PDC_Parameter.Remove(item);
if (_context.PDC_File.Where(x => x.SourceID == ParameterID).Any())
{
PDC_File File = _context.PDC_File.Where(x => x.SourceID == ParameterID && x.FunctionName == "Configuration_HomeLink").SingleOrDefault();
_context.PDC_File.Remove(File);
}
_context.SaveChanges();
}
return(Json("刪除成功"));
}
public IActionResult UploadDescription(string ParameterText)
{
ParameterService parameterService = new ParameterService(_context);
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
string ErrorMsg = string.Empty;
PDC_Parameter item = parameterService.GetParameterOne("ConfigurationDescription");
item.ParameterText = ParameterText;
item.Modifyer = userId;
item.ModifyerName = userName;
item.ModifyerDate = DateTime.Now;
parameterService.UpdateParameter(item, ref ErrorMsg);
return(Json(ErrorMsg));
}
public IActionResult HomeLinkAdd(IFormFile file, string ParameterText, int IsSync, string Link, int HomeLinkOrderNo)
{
ExcelHepler Helper = new ExcelHepler(_hostingEnvironment);
ParameterService parameterService = new ParameterService(_context);
FileService FileService = new FileService(_hostingEnvironment, _context);
string userId = _userManager.GetUserId(HttpContext.User);
string userName = HttpContext.User.Identity.Name;
m_ConfigurationPartial ViewModel = new m_ConfigurationPartial();
if (!string.IsNullOrEmpty(Link))
{
string ErrorMsg = string.Empty;
PDC_Parameter NewParameter = new PDC_Parameter();
NewParameter.IsSync = IsSync == 1 ? true : false;
NewParameter.OrderNo = HomeLinkOrderNo;
NewParameter.ParameterText = ParameterText;
NewParameter.ParameterGroup = "Configuration_HomeLink";
NewParameter.Creator = userId;
NewParameter.CreatorName = userName;
NewParameter.CreatorDate = DateTime.Now;
if (parameterService.AddParameter(ref NewParameter, ref ErrorMsg))
{
PDC_File NewFile = new PDC_File();
NewFile.SourceID = NewParameter.ParameterID;
NewFile.FunctionName = "Configuration_HomeLink";
NewFile.FileType = 5;
NewFile.FileName = Link;
NewFile.FileCategory = 2;
NewFile.Creator = userId;
NewFile.CreatorName = userName;
NewFile.CreatorDate = DateTime.Now;
FileService.FileAdd(ref NewFile);
ViewModel.m_HomeLink = NewParameter;
ViewModel.m_HomeLinkFile = NewFile;
}
}
else
{
//存檔並返回檔案路徑
string FilePath = Helper.SaveAndGetExcelPath(file);
if (FilePath != "Error")
{
ViewModel.m_HomeLink.IsSync = IsSync == 1 ? true : false;
ViewModel.m_HomeLink.OrderNo = HomeLinkOrderNo;
ViewModel.m_HomeLink.ParameterText = ParameterText;
ViewModel.m_HomeLink.ParameterGroup = "Configuration_HomeLink";
ViewModel.m_HomeLink.Creator = "m901c018";
ViewModel.m_HomeLink.CreatorDate = DateTime.Now;
ViewModel.m_HomeLink.CreatorName = "Mike";
_context.PDC_Parameter.Add(ViewModel.m_HomeLink);
_context.SaveChanges();
ViewModel.m_HomeLinkFile.SourceID = ViewModel.m_HomeLink.ParameterID;
ViewModel.m_HomeLinkFile.FunctionName = "Configuration_HomeLink";
ViewModel.m_HomeLinkFile.FileFullName = Path.GetFileName(FilePath);
ViewModel.m_HomeLinkFile.FileName = file.FileName;
ViewModel.m_HomeLinkFile.FileExtension = Path.GetExtension(FilePath);
ViewModel.m_HomeLinkFile.FileType = 2;
ViewModel.m_HomeLinkFile.FileCategory = 1;
ViewModel.m_HomeLinkFile.FileSize = file.Length;
ViewModel.m_HomeLinkFile.Creator = "m901c018";
ViewModel.m_HomeLinkFile.CreatorDate = DateTime.Now;
ViewModel.m_HomeLinkFile.CreatorName = "Mike";
_context.PDC_File.Add(ViewModel.m_HomeLinkFile);
_context.SaveChanges();
}
}
//存檔並返回檔案路徑UserManager<IdentityUser>
//string FilePath = Helper.SaveAndGetExcelPath(file);
return(Json(ViewModel));
}
