public JsonResult AddPdfBypic(string CoANo, string path, string CASNo)
{
string serverFilepath = Server.MapPath(string.Format("/Storage/PDF/{0}/ ", base.CurrentUser.Id));
if (!System.IO.Directory.Exists(serverFilepath))
{
System.IO.Directory.CreateDirectory(serverFilepath);
}
string serverFileName = "CoAReports" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".pdf";
string pdfpath = serverFilepath + serverFileName;
string[] list = path.Split(';');
Result res = new Result();
res.success = ExportDataIntoPDF(pdfpath, list.ToList <string>());
if (res.success)
{
string str = ImgHelper.PostImg(pdfpath, "coapic");
COAList cr = new COAList()
{
Addtime = DateTime.Now,
CoANo = CoANo,
URL = str,
UserId = base.CurrentUser.Id,
AddUserType = 2,
CASNo = CASNo
};
ServiceHelper.Create <ICOAListService>().AddCoAReportInfo(cr);
}
return(Json(res));
}
public ActionResult Detail(long id)
{
OrderInfo order = ServiceHelper.Create <IOrderService>().GetOrder(id);
ViewBag.Coupon = 0;
foreach (var r in order.OrderItemInfo)
{
r.ImagePath = ServiceHelper.Create <IProductService>().GetProduct(r.ProductId) == null ? "" : (ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).ImagePath == null ? "" : ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).ImagePath);
r.ThumbnailsUrl = ServiceHelper.Create <IProductService>().GetProduct(r.ProductId) == null ? "" : (ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).STRUCTURE_2D == null ? "" : ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).STRUCTURE_2D);
}
ViewBag.COA = "";
if (ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id) != null)
{
string strcoa = ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id).CoaNo;
if (!string.IsNullOrEmpty(strcoa))
{
COAList Coa = ServiceHelper.Create <ICOAListService>().GetCoAReportInfo(strcoa);
if (Coa != null)
{
string coaurl = ChemCloud.Core.Common.GetRootUrl("") + "/search/Search_COA?key=" + Coa.CoANo;
ViewBag.COA = coaurl;
}
}
}
return(View(order));
}
public void AddCoAReportInfo(COAList cr)
{
if (cr == null)
{
return;
}
context.COAList.Add(cr);
context.SaveChanges();
}
public ActionResult Search_COA(string key)
{
COAList Coa = ServiceHelper.Create <ICOAListService>().GetCoAReportInfo(key);
if (Coa != null)
{
ViewBag.Url = Coa.URL;
}
return(View());
}
public void DeleteCoAReportInfo(long id)
{
COAList cr = context.COAList.FindById <COAList>(id);
if (cr.Id == 0 || cr == null)
{
return;
}
context.COAList.Remove(cr);
context.SaveChanges();
}
public JsonResult AddPdf(string CoANo, string filename, string CASNo)
{
COAList cr = new COAList()
{
Addtime = DateTime.Now,
CoANo = CoANo,
URL = filename,
UserId = base.CurrentUser.Id,
AddUserType = 2,
CASNo = CASNo
};
ServiceHelper.Create <ICOAListService>().AddCoAReportInfo(cr);
Result res = new Result();
res.success = true;
return(Json(res));
}
public ActionResult Detail(long id)
{
OrderInfo order = ServiceHelper.Create <IOrderService>().GetOrder(id, base.CurrentUser.Id);
IEnumerable <long> nums = (
from d in order.OrderItemInfo
select d.ProductId).AsEnumerable <long>();
var list = (
from d in ServiceHelper.Create <IProductService>().GetProductByIds(nums)
select new { Id = d.Id, ProductCode = d.ProductCode }).ToList();
foreach (OrderItemInfo orderItemInfo in order.OrderItemInfo)
{
var variable = list.Find((d) => d.Id == orderItemInfo.ProductId);
if (variable == null)
{
continue;
}
orderItemInfo.ProductCode = variable.ProductCode;
orderItemInfo.Pub_CID = ServiceHelper.Create <IProductService>().GetProduct(orderItemInfo.ProductId) == null ? 0 :
(ServiceHelper.Create <IProductService>().GetProduct(orderItemInfo.ProductId).Pub_CID == null ? 0 : ServiceHelper.Create <IProductService>().GetProduct(orderItemInfo.ProductId).Pub_CID);
}
ViewBag.COA = "";
if (ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id) != null)
{
string strcoa = ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id).CoaNo;
if (!string.IsNullOrEmpty(strcoa))
{
COAList Coa = ServiceHelper.Create <ICOAListService>().GetCoAReportInfo(strcoa);
if (Coa != null)
{
string coaurl = ChemCloud.Core.Common.GetRootUrl("") + "/search/Search_COA?key=" + Coa.CoANo;
ViewBag.COA = coaurl;
}
}
}
ViewBag.ShopName = order.ShopName == null ? "" : order.ShopName;
return(View(order));
}
//private Cell CreateCell(int cellID, Row row)
//{
// Cell cell = row.GetCell(cellID) ?? row.CreateCell(cellID);
// return cell;
//}
//private Row CreateRow(int rowID, HSSFSheet excelSheet)
//{
// Row row = excelSheet.GetRow(rowID) ?? excelSheet.CreateRow(rowID);
// return row;
//}
public ActionResult Detail(long id, bool updatePrice = false)
{
OrderInfo order = ServiceHelper.Create <IOrderService>().GetOrder(id);
if (order == null || order.ShopId != base.CurrentSellerManager.ShopId)
{
throw new HimallException("订单已被删除，或者不属于该供应商！");
}
ViewBag.UpdatePrice = updatePrice;
ViewBag.COA = "";
if (ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id) != null)
{
string strcoa = ServiceHelper.Create <IChemCloud_OrderWithCoaService>().GetChemCloud_OrderWithCoaByOrderid(id).CoaNo;
if (!string.IsNullOrEmpty(strcoa))
{
COAList Coa = ServiceHelper.Create <ICOAListService>().GetCoAReportInfo(strcoa);
if (Coa != null)
{
string coaurl = ChemCloud.Core.Common.GetRootUrl("") + "/search/Search_COA?key=" + Coa.CoANo;
ViewBag.COA = coaurl;
}
}
}
foreach (var r in order.OrderItemInfo)
{
/*订单查看时候，加载cas#产品图片*/
r.Id = r.Id;
r.CASNo = ServiceHelper.Create <ChemCloud.IServices.IProductService>().GetProduct(r.ProductId) != null?ServiceHelper.Create <ChemCloud.IServices.IProductService>().GetProduct(r.ProductId).CASNo : "";
r.MolecularFormula = ServiceHelper.Create <ChemCloud.IServices.IProductService>().GetProduct(r.ProductId) != null?ServiceHelper.Create <ChemCloud.IServices.IProductService>().GetProduct(r.ProductId).MolecularFormula : "";
r.Pub_CID = ServiceHelper.Create <IProductService>().GetProduct(r.ProductId) == null ? 0 : (ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).Pub_CID == null ? 0 : ServiceHelper.Create <IProductService>().GetProduct(r.ProductId).Pub_CID);
}
return(View(order));
}
public JsonResult AddPdfByHtml(string CoANo, string Html, string titles, string CASNo, string Specification)
{
titles = titles.Substring(0, titles.Length - 1);
Specification = Specification.Substring(0, Specification.Length - 1);
ChemCloud_COA model = Newtonsoft.Json.JsonConvert.DeserializeObject <ChemCloud_COA>(Html);
List <string> titlelist = titles.Split(';').ToList <string>();
List <string> SpecificationList = Specification.Split(';').ToList <string>();
string serverFilepath = Server.MapPath(string.Format("/Storage/PDF/{0}/ ", base.CurrentUser.Id));
if (!System.IO.Directory.Exists(serverFilepath))
{
System.IO.Directory.CreateDirectory(serverFilepath);
}
string serverFileName = "CoAReports" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".pdf";
Result res = new Result();
iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4);
try
{
iTextSharp.text.pdf.PdfWriter.GetInstance(document, new FileStream(serverFilepath + serverFileName, FileMode.Create));
document.Open();
iTextSharp.text.pdf.BaseFont bfChinese = iTextSharp.text.pdf.BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", iTextSharp.text.pdf.BaseFont.IDENTITY_H, iTextSharp.text.pdf.BaseFont.NOT_EMBEDDED);
iTextSharp.text.Font Titlefont = new iTextSharp.text.Font(bfChinese, 16, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font titleDetial = new iTextSharp.text.Font(bfChinese, 11, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font normall = new iTextSharp.text.Font(bfChinese, 11, iTextSharp.text.Font.NORMAL);
iTextSharp.text.Font newtable = new iTextSharp.text.Font(bfChinese, 12, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font newtableInner = new iTextSharp.text.Font(bfChinese, 12, iTextSharp.text.Font.NORMAL);
Paragraph p = new Paragraph("CERTIFICATE OF ANALYSIS" + "\n\n", Titlefont);
p.Alignment = iTextSharp.text.Element.ALIGN_CENTER;
document.Add(p);
PdfPTable table = new PdfPTable(4);
table.DefaultCell.MinimumHeight = 30;
table.SetWidths(new int[] { 35, 15, 35, 15 });
PdfPCell cell;
cell = new PdfPCell();
Paragraph pCell;
pCell = new Paragraph("CertificateNumber", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.CertificateNumber, normall);
table.AddCell(pCell);
pCell = new Paragraph("Suppiler", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(ServiceHelper.Create <IShopService>().GetShopName(base.CurrentSellerManager.ShopId), normall);
table.AddCell(pCell);
cell = new PdfPCell();
pCell = new Paragraph("Product Code", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.ProductCode, normall);
table.AddCell(pCell);
pCell = new Paragraph("Manufacturer's Batch #", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.ManufacturersBatchNo, normall);
table.AddCell(pCell);
cell = new PdfPCell();
pCell = new Paragraph("Product", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.ProductName, normall);
table.AddCell(pCell);
pCell = new Paragraph("Sydco's Lab.Batch #", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.SydcosLabBatchNo, normall);
table.AddCell(pCell);
cell = new PdfPCell();
pCell = new Paragraph("Date of Manufacture", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.DateofManufacture.ToShortDateString(), normall);
table.AddCell(pCell);
pCell = new Paragraph("ExpiryDate", titleDetial);
table.AddCell(pCell);
pCell = new Paragraph(model.ExpiryDate.ToShortDateString(), normall);
table.AddCell(pCell);
document.Add(table);
Paragraph pfoot = new Paragraph("\n The undersigned hereby certifies the following data to be true specification" + "\n\n\n\n\n", titleDetial);
p.Alignment = iTextSharp.text.Element.ALIGN_CENTER;
document.Add(pfoot);
foreach (ChemCloud_COADetails item in model.ChemCloud_COADetails)
{
PdfPTable table1 = new PdfPTable(3);
table1.DefaultCell.MinimumHeight = 30;
table1.SetWidths(new int[] { 40, 20, 35 });
pCell = new Paragraph("Tests", newtable);
table1.AddCell(pCell);
pCell = new Paragraph("Results", newtable);
table1.AddCell(pCell);
pCell = new Paragraph("Specifications(BP)", newtable);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[0], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Appearance, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[0], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[1], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.IIdentity, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[1], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[2], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Carbonates, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[2], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[3], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Solubility, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[3], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[4], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Ammonium, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[4], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[5], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Calcium, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[5], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[6], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Arsenic, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[6], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[7], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.HeavyMetals, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[7], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[8], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Iron, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[8], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[9], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Sulphates, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[9], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[10], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Chlorides, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[10], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[11], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.Appearanceofsolution, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[11], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(titlelist[12], newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(item.MicroStatus, newtableInner);
table1.AddCell(pCell);
pCell = new Paragraph(SpecificationList[12], newtableInner);
table1.AddCell(pCell);
document.Add(table1);
Paragraph ppp = new Paragraph("\n\n\n\n\n\n", titleDetial);
ppp.Alignment = iTextSharp.text.Element.ALIGN_CENTER;
document.Add(ppp);
}
}
catch (Exception de)
{
res.success = false;
return(Json(res));
}
document.Close();
res.success = true;
//string pdfpath1 = string.Format("/Storage/PDF/{0}/", base.CurrentUser.Id);
string str = ImgHelper.PostImg(serverFilepath + serverFileName, "coapic");
COAList cr = new COAList()
{
Addtime = DateTime.Now,
CoANo = CoANo,
URL = str,
UserId = base.CurrentUser.Id,
AddUserType = 2,
CASNo = CASNo
};
ServiceHelper.Create <ICOAListService>().AddCoAReportInfo(cr);
return(Json(res));
}
