/* For Create View's scale.*/
public IActionResult Delete3(string id = null, int seq = 0, string typ = null)
{
string WebRootPath = _hostingEnvironment.WebRootPath;
string path1 = Path.Combine(@"D:\" + "/Files/BMED/");
AttainFileModel attainfiles = _context.BMEDAttainFiles.Find(typ, id, seq);
if (attainfiles != null)
{
FileInfo ff;
try
{
if (typ == "2")
{
ff = new FileInfo(Path.Combine(path1, attainfiles.FileLink.Replace("Files/BMED/", "")));
ff.Delete();
}
else
{
ff = new FileInfo(Path.Combine(path1, attainfiles.FileLink));
ff.Delete();
}
}
catch (Exception e)
{
return(Content(e.Message));
}
_context.BMEDAttainFiles.Remove(attainfiles);
_context.SaveChanges();
}
List <AttainFileModel> af = _context.BMEDAttainFiles.Where(f => f.DocId == id)
.Where(f => f.DocType == typ).ToList();
return(ViewComponent("BMEDAttainFileList3", new { id = id, typ = typ }));
}
public async Task <IViewComponentResult> InvokeAsync(string doctype, string docid)
{
AttainFileModel attainFile = new AttainFileModel();
attainFile.DocType = doctype;
attainFile.DocId = docid;
attainFile.SeqNo = 1;
attainFile.IsPublic = "N";
attainFile.FileLink = "default";
return(View(attainFile));
}
public ActionResult Upload(string doctype, string docid)
{
AttainFileModel attainFile = new AttainFileModel();
attainFile.DocType = doctype;
attainFile.DocId = docid;
attainFile.SeqNo = 1;
attainFile.IsPublic = "N";
attainFile.FileLink = "default";
return(View(attainFile));
}
public async Task <IViewComponentResult> InvokeAsync(string doctype, string docid, string viewType)
{
AttainFileModel attainFile = new AttainFileModel();
attainFile.DocType = doctype;
attainFile.DocId = docid;
attainFile.SeqNo = 2;
attainFile.IsPublic = "N";
attainFile.FileLink = "default";
if (viewType == "AjaxView")
{
return(View("AjaxView", attainFile));
}
return(View(attainFile));
}
// GET: /BMED/AttainFile/Create
public IActionResult Create(string id = null, string typ = null, string title = null, int?vendorId = null)
{
var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
AttainFileModel a = new AttainFileModel();
a.DocType = typ;
a.DocId = id;
a.Title = title;
if (typ == "3" && vendorId != null)
{
a.Rtp = vendorId;
}
else
{
a.Rtp = ur.Id;
}
a.Rtt = DateTime.Now;
return(View(a));
}
public async Task <IActionResult> Upload(AttainFileModel attainFile)
{
var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
long size = attainFile.Files.Sum(f => f.Length);
// full path to file in temp location
var filePath = Path.GetTempFileName();
if (ModelState.IsValid)
{
try
{
string s = "/Files/BMED";
//#if DEBUG
// s = "/App_Data";
//#endif
switch (attainFile.DocType)
{
case "0":
s += "/Budget/";
break;
case "1":
s += "/Repair/";
break;
case "2":
s += "/Keep/";
break;
case "3":
s += "/BuyEvaluate/";
break;
case "4":
s += "/Delivery/";
break;
case "5":
s += "/Asset/";
break;
}
var i = _context.BMEDAttainFiles
.Where(a => a.DocType == attainFile.DocType)
.Where(a => a.DocId == attainFile.DocId).ToList();
attainFile.SeqNo = i.Count == 0 ? 1 : i.Select(a => a.SeqNo).Max() + 1;
//string WebRootPath = _hostingEnvironment.WebRootPath;
string path = Path.Combine(@"D:\" + s + attainFile.DocId + "_"
+ attainFile.SeqNo.ToString() + Path.GetExtension(attainFile.Files[0].FileName));
// Upload files.
using (var stream = new FileStream(path, FileMode.Create))
{
await attainFile.Files[0].CopyToAsync(stream);
}
// Save file details to AttainFiles table.
string filelink = attainFile.DocId + "_"
+ attainFile.SeqNo.ToString() + Path.GetExtension(attainFile.Files[0].FileName);
switch (attainFile.DocType)
{
case "0":
attainFile.FileLink = "Budget/" + filelink;
break;
case "1":
attainFile.FileLink = "Repair/" + filelink;
break;
case "2":
attainFile.FileLink = "Keep/" + filelink;
break;
case "3":
attainFile.FileLink = "BuyEvaluate/" + filelink;
break;
case "4":
attainFile.FileLink = "Delivery/" + filelink;
break;
case "5":
attainFile.FileLink = "Asset/" + filelink;
break;
}
attainFile.Rtt = DateTime.Now;
attainFile.Rtp = ur.Id;
_context.BMEDAttainFiles.Add(attainFile);
_context.SaveChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
TempData["SendMsg"] = "上傳成功";
if (attainFile.DocType == "2")
{
return(RedirectToAction("Edit", "Keep", new { area = "BMED", id = attainFile.DocId }));
}
return(RedirectToAction("Edit", "Repair", new { area = "BMED", id = attainFile.DocId }));
//return new JsonResult(attainFile)
//{
// Value = new { success = true, error = "" },
//};
}
public string ReadBudgetExcel(AttainFileModel attainfile)
{
string WebRootPath = _hostingEnvironment.WebRootPath;
string s2 = "/Files/BMED/";
string filepath = Path.Combine(@"D:\" + s2, attainfile.FileLink);
string s = "";
BudgetModel bg;
try
{
//FileStream fs = System.IO.File.Open(filepath, FileMode.Open, FileAccess.Read);
FileInfo fileinfo = new FileInfo(filepath);
//ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage package = new ExcelPackage(fileinfo);
ExcelWorksheet sheet = package.Workbook.Worksheets["全部案件"];
int lastRow = sheet.Dimension.End.Row;
int lastCol = sheet.Dimension.End.Column;
int numLOC = 0;
int numDOCID = 0;
int numPLANTNAME = 0;
int numPRICE = 0;
int numAMT = 0;
int numTOTALPRICE = 0;
int numENGNAME = 0;
int numACCDPT = 0;
int numOPINION = 0;
int numGRPOPIN = 0;
for (int j = 1; j <= lastCol; j++)
{
if (sheet.Cells[1, j].Value == null)
{
continue;
}
switch (sheet.Cells[1, j].Value.ToString())
{
case "院區":
numLOC = j;
break;
case "表單編號":
numDOCID = j;
break;
case "儀器中文名稱":
numPLANTNAME = j;
break;
case "成本中心代號":
numACCDPT = j;
break;
case "單價":
numPRICE = j;
break;
case "通過":
numAMT = j;
break;
case "通過金額":
numTOTALPRICE = j;
break;
case "工程師":
numENGNAME = j;
break;
case "醫工部意見":
numOPINION = j;
break;
case "小組意見":
numGRPOPIN = j;
break;
}
}
while (string.IsNullOrEmpty(sheet.Cells[lastRow, 6].Text.Trim()))
{
lastRow--;
}
//
string dbstring = "";
for (int i = 2; i <= lastRow; i++)
{
if (_context.Budgets.Find(sheet.Cells[i, numDOCID].Value.ToString()) == null)
{
bg = new BudgetModel();
bg.Loc = sheet.Cells[i, numLOC].Value.ToString();
bg.DocId = sheet.Cells[i, numDOCID].Value.ToString();
bg.Year = Convert.ToString(DateTime.Now.Year - 1);
bg.PlantName = sheet.Cells[i, numPLANTNAME].Value.ToString();
bg.Price = Convert.ToDecimal(sheet.Cells[i, numPRICE].Value);
bg.Amt = Convert.ToInt32(sheet.Cells[i, numAMT].Value);
bg.TotalPrice = Convert.ToDecimal(sheet.Cells[i, numTOTALPRICE].Value);
bg.EngName = sheet.Cells[i, numENGNAME].Value.ToString();
bg.AccDpt = sheet.Cells[i, numACCDPT].Value.ToString();
bg.Opinion = sheet.Cells[i, numOPINION].Value == null ? "" : sheet.Cells[i, numOPINION].Value.ToString();
bg.GrpOpin = sheet.Cells[i, numGRPOPIN].Value == null ? "" : sheet.Cells[i, numGRPOPIN].Value.ToString();
_context.Budgets.Add(bg);
}
else
{
dbstring += sheet.Cells[i, numDOCID].Value.ToString() + ";";
}
}
_context.SaveChanges();
if (dbstring != "")
{
dbstring = "重複申請：" + dbstring;
return(dbstring);
}
}
catch (Exception ex)
{
s = ex.Message;
}
return(s);
}
public async Task <IActionResult> Create(AttainFileModel attainFile, IEnumerable <IFormFile> file)
{
string s = "/Files/BMED";
switch (attainFile.DocType)
{
case "0":
s += "/Budget";
break;
case "1":
s += "/Repair";
break;
case "2":
s += "/Keep";
break;
case "3":
s += "/BuyEvaluate";
break;
case "4":
s += "/Delivery";
break;
case "5":
s += "/Asset";
break;
case "6":
s += "/DeptStok";
break;
case "7":
s += "/MContract";
break;
case "8":
s += "/PContract";
break;
case "9":
s += "/News";
break;
}
string WebRootPath = _hostingEnvironment.WebRootPath;
var bmedFile = _context.BMEDAttainFiles.Where(af => af.DocType == attainFile.DocType && af.DocId == attainFile.DocId)
.Select(af => af.SeqNo).ToList();
int?i = null;
if (bmedFile.Count() > 0)
{
i = bmedFile.Max();
}
if (i == null)
{
attainFile.SeqNo = 1;
}
else
{
attainFile.SeqNo = Convert.ToInt32(i + 1);
}
string path = Path.Combine(@"D:\" + s, attainFile.DocId + "_"
+ attainFile.SeqNo.ToString() + Path.GetExtension(Request.Form.Files[0].FileName));
string filelink = attainFile.DocId + "_"
+ attainFile.SeqNo.ToString() + Path.GetExtension(Request.Form.Files[0].FileName);
try
{
// Upload files.
using (var stream = new FileStream(path, FileMode.Create))
{
await Request.Form.Files[0].CopyToAsync(stream);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
switch (attainFile.DocType)
{
case "0":
attainFile.FileLink = "Budget/" + filelink;
break;
case "1":
attainFile.FileLink = "Repair/" + filelink;
break;
case "2":
attainFile.FileLink = "Keep/" + filelink;
break;
case "3":
attainFile.FileLink = "BuyEvaluate/" + filelink;
break;
case "4":
attainFile.FileLink = "Delivery/" + filelink;
break;
case "5":
attainFile.FileLink = "Asset/" + filelink;
break;
case "6":
attainFile.FileLink = "DeptStok/" + filelink;
break;
case "7":
attainFile.FileLink = "MContract/" + filelink;
break;
case "8":
attainFile.FileLink = "PContract/" + filelink;
break;
case "9":
attainFile.FileLink = "News/" + filelink;
break;
}
if (attainFile.IsPub)
{
attainFile.IsPublic = "Y";
}
attainFile.Rtt = DateTime.Now;
_context.BMEDAttainFiles.Add(attainFile);
try
{
_context.SaveChanges();
if (attainFile.DocType == "0")
{
string s1 = ReadBudgetExcel(attainFile);
if (!string.IsNullOrEmpty(s1))
{
throw new Exception(s1);
}
}
return(Content("檔案上載完成"));
}
catch (Exception e)
{
//throw new Exception(e.Message);
ModelState.AddModelError("", e.Message);
return(Content(e.Message));
}
}
