public async Task <IActionResult> SaveUBDate(F340_PpdDto dto)
{
_logger.LogInformation(String.Format(@"******DKSController SaveUBDate fired!! ******"));
var partNo = dto.PartName.Split(" ")[0];
var treatMentNo = dto.TreatMent.Split(" ")[0];
DevTreatment model = _devTreatmentDAO.FindSingle(
x => x.SAMPLENO.Trim() == dto.SampleNo.Trim() &&
x.PARTNO.Trim() == partNo &&
x.TREATMENTCODE.Trim() == treatMentNo &&
x.FACTORYID == dto.Factory);
if (model != null)
{
if (!String.IsNullOrEmpty(dto.CardDate))
{
model.B_COLORCARD = dto.CardDate.ToDateTime(); //底部色卡
}
if (!String.IsNullOrEmpty(dto.ConfirmDate))
{
model.U_REALCARD = dto.ConfirmDate.ToDateTime(); //面部實務卡
}
if (!String.IsNullOrEmpty(dto.ProcessDate))
{
model.WORKFLOW = dto.ProcessDate.ToDateTime(); //跨單位作業流程
}
_devTreatmentDAO.Update(model);
await _devTreatmentDAO.SaveAll();
}
return(Ok());
}
public async Task <IActionResult> EditF340Ppd(F340_PpdDto dto, string type)
{
_logger.LogInformation(String.Format(@"******DKSController EditF340Ppd fired!! ******"));
var isSuccess = false;
if (dto.PartName.Trim().Length < 1 || dto.TreatMent.Trim().Length < 1 || dto.ReleaseType.Trim() != "CWA")
{
return(Ok(isSuccess));
}
var partNo = dto.PartName.Trim().Split(" ")[0];
var treatMentNo = dto.TreatMent.Trim().Split(" ")[0];
DevTreatment model = _devTreatmentDAO.FindSingle(
x => x.SAMPLENO.Trim() == dto.SampleNo.Trim() &&
x.PARTNO.Trim() == partNo &&
x.TREATMENTCODE.Trim() == treatMentNo &&
x.FACTORYID == dto.Factory);
if (model != null)
{
// type is here
if (type == "PhotoComment")
{
model.PHOTO_COMMENT = dto.PhotoComment.Trim();
_logger.LogInformation(String.Format(@"******DKSController EditF340Ppd Add a PhotoComment: {0}!! ******", dto.PhotoComment));
}
if (type == "PpdRemark")
{
model.PPD_REMARK = dto.PpdRemark.Trim();
_logger.LogInformation(String.Format(@"******DKSController EditF340Ppd Add a PpdRemark: {0}!! ******", dto.PhotoComment));
}
_devTreatmentDAO.Update(model);
}
await _devTreatmentDAO.SaveAll();
return(Ok(isSuccess));
}
public async Task <IActionResult> EditPdfF340Ppd()
{
_logger.LogInformation(String.Format(@"****** DKSController EditPdfF340Ppd fired!! ******"));
var sampleNo = HttpContext.Request.Form["sampleNo"].ToString().Trim();
var treatMent = HttpContext.Request.Form["treatMent"].ToString().Trim();
var partName = HttpContext.Request.Form["partName"].ToString().Trim();
var article = HttpContext.Request.Form["article"].ToString().Trim();
var devSeason = HttpContext.Request.Form["devSeason"].ToString().Trim();
var fileName = HttpContext.Request.Form["pdf"].ToString().Trim();
var loginUser = HttpContext.Request.Form["loginUser"].ToString().Trim();
var factoryId = HttpContext.Request.Form["factoryId"].ToString().Trim();
var partNo = partName.Split(" ")[0];
var treatMentNo = treatMent.Split(" ")[0];
DateTime nowtime = DateTime.Now;
var updateTimeStr = nowtime.ToString("yyyy-MM-dd HH:mm:ss");
DateTime updateTime = updateTimeStr.ToDateTime();
if (fileName == "")
{
//fileName + yyyy_MM_dd_HH_mm_ss_
var formateDate = nowtime.ToString("yyyyMMddHHmmss");
fileName = string.Format("{0}_{1}_{2}_{3}.pdf", article, partNo, treatMentNo, formateDate);
}
List <string> nastFileName = new List <string>();
nastFileName.Add(devSeason);
nastFileName.Add(article);
nastFileName.Add(fileName);
DevTreatment model = _devTreatmentDAO.FindSingle(
x => x.SAMPLENO.Trim() == sampleNo.Trim() &&
x.PARTNO.Trim() == partNo &&
x.TREATMENTCODE.Trim() == treatMentNo &&
x.FACTORYID == factoryId);
if (HttpContext.Request.Form.Files.Count > 0)
{
var file = HttpContext.Request.Form.Files[0];
if (await _fileService.SaveFiletoServer(file, "F340PpdPic", nastFileName))
{
model.PDF = fileName;
_devTreatmentDAO.Update(model);
DevTreatmentFile opRecord = new DevTreatmentFile();
opRecord.ARTICLE = article;
opRecord.PARTNO = partNo;
opRecord.TREATMENTCODE = treatMentNo;
opRecord.FILE_NAME = fileName;
opRecord.KIND = "2";// 1: JPG 2:PDF
opRecord.FILE_COMMENT = "";
opRecord.UPUSR = loginUser;
opRecord.UPTIME = updateTime;
_devTreatmentFileDAO.Add(opRecord);
_logger.LogInformation(String.Format(@"******DKSController EditPdfF340Ppd Add a Pdf: {0}!! ******", fileName));
}
}
else
{ //do CRUD-D here.
if (await _fileService.SaveFiletoServer(null, "F340PpdPic", nastFileName))
{
model.PDF = "";
_devTreatmentDAO.Update(model);
DevTreatmentFile opRecord = _devTreatmentFileDAO.FindSingle(
x => x.FILE_NAME.Trim() == fileName.Trim());
_devTreatmentFileDAO.Remove(opRecord);
_logger.LogInformation(String.Format(@"******DKSController EditPdfF340Ppd Delete a Pdf: {0}!! ******", fileName));
}
}
await _devTreatmentDAO.SaveAll();
await _devTreatmentFileDAO.SaveAll();
return(Ok(model));
}
public async Task <IActionResult> EditPicF340Ppd()
{
_logger.LogInformation(String.Format(@"****** DKSController EditPicF340Ppd fired!! ******"));
var sampleNo = HttpContext.Request.Form["sampleNo"].ToString().Trim();
var treatMent = HttpContext.Request.Form["treatMent"].ToString().Trim();
var partName = HttpContext.Request.Form["partName"].ToString().Trim();
var article = HttpContext.Request.Form["article"].ToString().Trim();
var devSeason = HttpContext.Request.Form["devSeason"].ToString().Trim();
var fileName = HttpContext.Request.Form["photo"].ToString().Trim();
var loginUser = HttpContext.Request.Form["loginUser"].ToString().Trim();
var factoryId = HttpContext.Request.Form["factoryId"].ToString().Trim();
var partNo = partName.Split(" ")[0];
var treatMentNo = treatMent.Split(" ")[0];
DateTime nowtime = DateTime.Now;
var updateTimeStr = nowtime.ToString("yyyy-MM-dd HH:mm:ss");
DateTime updateTime = updateTimeStr.ToDateTime();
if (fileName == "")
{
//fileName + yyyy_MM_dd_HH_mm_ss_
var formateDate = nowtime.ToString("yyyyMMddHHmmss");
fileName = string.Format("{0}_{1}_{2}_{3}.jpg", article, partNo, treatMentNo, formateDate);
}
List <string> nastFileName = new List <string>();
nastFileName.Add(devSeason);
nastFileName.Add(article);
nastFileName.Add(fileName);
DevTreatment model = _devTreatmentDAO.FindSingle(
x => x.SAMPLENO.Trim() == sampleNo.Trim() &&
x.PARTNO.Trim() == partNo &&
x.TREATMENTCODE.Trim() == treatMentNo &&
x.FACTORYID == factoryId);
if (HttpContext.Request.Form.Files.Count > 0)
{
var file = HttpContext.Request.Form.Files[0];
//IformFile ==> img ==>byte array ==> IformFile
Image image = Image.FromStream(file.OpenReadStream(), true, true);
var newImage = new Bitmap(1024, 768);
using (var g = Graphics.FromImage(newImage))
{
g.DrawImage(image, 0, 0, 1024, 768);
}
ImageConverter converter = new ImageConverter();
byte[] bt = (byte[])converter.ConvertTo(newImage, typeof(byte[]));
var stream = new MemoryStream(bt);
IFormFile resizeFile = new FormFile(stream, 0, bt.Length, file.Name, file.FileName);
if (await _fileService.SaveFiletoServer(resizeFile, "F340PpdPic", nastFileName))
{
model.PHOTO = fileName;
_devTreatmentDAO.Update(model);
DevTreatmentFile opRecord = new DevTreatmentFile();
opRecord.ARTICLE = article;
opRecord.PARTNO = partNo;
opRecord.TREATMENTCODE = treatMentNo;
opRecord.FILE_NAME = fileName;
opRecord.KIND = "1";// 1: JPG 2:PDF
opRecord.FILE_COMMENT = "";
opRecord.UPUSR = loginUser;
opRecord.UPTIME = updateTime;
_devTreatmentFileDAO.Add(opRecord);
_logger.LogInformation(String.Format(@"******DKSController EditPicF340Ppd Add a Picture: {0}!! ******", fileName));
}
}
else
{ //do CRUD-D here.
if (await _fileService.SaveFiletoServer(null, "F340PpdPic", nastFileName))
{
model.PHOTO = "";
_devTreatmentDAO.Update(model);
DevTreatmentFile opRecord = _devTreatmentFileDAO.FindSingle(
x => x.FILE_NAME.Trim() == fileName.Trim());
_devTreatmentFileDAO.Remove(opRecord);
_logger.LogInformation(String.Format(@"******DKSController EditPicF340Ppd Delete a Picture: {0}!! ******", fileName));
}
}
await _devTreatmentDAO.SaveAll();
await _devTreatmentFileDAO.SaveAll();
return(Ok(model));
}
