public ActionResult Save(System.Int32 id, string tag) { T_CGMXModels model = new T_CGMXModels(); model.DataModel = new T_CGMX(); Int32 did = id; if (tag != "Add") { model.DataModel = T_CGMXDomain.GetInstance().GetModelById(id); did = model.DataModel.CGID; } //加载产品列表 T_YLCPModels ylcpmode = new T_YLCPModels(); ylcpmode.DataModel = ylcpmode.DataModel ?? new T_YLCP(); ylcpmode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpmode.DataModel); ViewData["YLCP"] = new SelectList(ylcpmode.DataList, "CPID", "CPMC"); //加载企业列表 T_SupQYModels supmode = new T_SupQYModels(); supmode.DataModel = supmode.DataModel ?? new T_SupQY(); supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList(); ViewData["SupID"] = new SelectList(supmode.DataList, "SupID", "SupMC"); //加载采购单列表 T_CGDModels cgdQymode = new T_CGDModels(); cgdQymode.DataModel = cgdQymode.DataModel ?? new T_CGD(); T_CGD cgd = T_CGDDomain.GetInstance().GetModelById(did); cgdQymode.DataList = new List <T_CGD>(); cgdQymode.DataList.Add(cgd); ViewData["CGD"] = new SelectList(cgdQymode.DataList, "CGID", "CGDMC"); //if (id != 0) //{ // model.DataModel = T_CGMXDomain.GetInstance().GetModelById(id); //} model.Tag = tag; return(View("~/Views/T_CGMX/Save.cshtml", model)); }
public string ExportExcelPR(System.Int32 id) { //获取需要打印的数据 T_RKD ckdinfo = new T_RKD(); List <T_RKD> list = T_RKDDomain.GetInstance().GetListModelById(id); if (list.Count > 0) { ckdinfo = list[0]; } //验收单号 string rkysdh = ckdinfo.YSDH; //供货企业名称 T_RKMX rkdinfo = new T_RKMX(); List <T_RKMX> rkmxList = T_RKMXDomain.GetInstance().GetListModelById(id); if (rkmxList.Count > 0) { rkdinfo = rkmxList[0]; } string ghqy = rkdinfo.T_SupQY == null ? "" : rkdinfo.T_SupQY.SupMC; //命名导出表格的StringBuilder变量 StringBuilder sHtml = new StringBuilder(string.Empty); //打印表头 sHtml.Append("<table border=\"0\" width=\"100%\">"); // sHtml.Append("<tr height=\"40\"><td colspan=\"12\" align=\"center\" style='font-size:24px'><b>入库单" + "</b></td></tr>"); sHtml.Append("<tr height=\"40\"><td colspan=\"6\" align=\"left\">供货企业:" + ghqy + "</td><td align=\"center\" colspan=\"4\">日期:" + DateTime.Now.ToString("yyyy-MM-dd") + "</td><td align=\"right\" colspan=\"2\">入库单号:" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + "</td></tr>"); sHtml.Append("</table>"); sHtml.Append("<table border=\"1\" width=\"100%\" style='border-collapse:collapse;border:1px solid black;'>"); // width=\"100%\" sHtml.Append("<tr height=\"30\" align=\"center\" ><td>产品名称</td><td>产品规格</td><td>生产厂家</td><td>生产日期</td><td>单位</td><td>数量</td><td>单价</td>" + "<td>金额</td><td>产品批号</td><td>产品有效期</td><td>经营许可证号</td><td>注册证号</td></tr>"); //合计 double total = 0.0; for (int i = 0; i < rkmxList.Count; i++) { T_RKMX rkmx = rkmxList[i]; //产品名称 string cpName = rkmx.T_YLCP.CPMC; //规格 string cpGg = rkmx.T_YLCP.CPGG ?? ""; //单位 string cpDw = rkmx.T_YLCP.CPDW ?? ""; //数量 double cpDj = rkmx.CPNUM ?? 0; //产品批号 string scPh = rkmx.CPPH ?? ""; //产品有效期 string yxq = ""; if (rkmx.CPYXQ != null) { yxq = rkmx.CPYXQ.Value.ToString("yyyyMMdd"); } var scrq = ""; if (rkmx.CPSCRQ != null) { scrq = rkmx.CPSCRQ.Value.ToString("yyyyMMdd"); } //生产企业 string cpScqy = rkdinfo.T_SupQY1 == null ? "" : rkdinfo.T_SupQY1.SupMC; //单价 double cpPrice = Math.Round(rkmx.T_YLCP.CPPrice ?? 0.0, 2); //产品总价 double rowTotal = Math.Round(cpDj * cpPrice, 2); total = total + rowTotal; //注册证号 string cpzczh = rkmx.T_YLCP.CPZCZ; //经营许可证号 string xkzbh = rkmx.T_SupQY.SupXKZBH; sHtml.Append("<tr height=\"30\" align=\"center\"><td>" + cpName + "</td><td>" + cpGg + "</td><td>" + cpScqy + "</td><td>" + scrq + "</td><td>" + cpDw + "</td><td>" + cpDj.ToString() + "</td><td>" + cpPrice.ToString("0.00") + "</td><td>" + rowTotal.ToString("0.00") + "</td><td>" + scPh + "</td><td>" + yxq + "</td><td>" + xkzbh + "</td><td>" + cpzczh + "</td></tr>"); } //打印表尾 sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"5\">合计金额:(大写)" + MoneySmallToBig(total.ToString()) + "</td><td colspan=\"7\">(小写)" + total.ToString("0.00") + "</td></tr>"); sHtml.Append("</table>"); sHtml.Append("<table border=\"0\" width=\"100%\">"); // width =\"100%\" Expression <Func <T_YSD, bool> > where = p => p.YSDH == ckdinfo.YSDH; var ysd = T_YSDDomain.GetInstance().GetAllModels <int>(where).FirstOrDefault(); var cgdModel = new T_CGD(); if (ysd != null && ysd.YSID != 0 && !string.IsNullOrEmpty(ysd.CGDH)) { Expression <Func <T_CGD, bool> > where1 = p => p.CGDH == ysd.CGDH; cgdModel = T_CGDDomain.GetInstance().GetAllModels <int>(where1).FirstOrDefault(); } sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"2\" align=\"left\">制单人: " + ckdinfo.RKCJR + "</td><td align=\"left\" colspan=\"4\">审核人: " + cgdModel.SHR + "</td><td align=\"left\" colspan=\"3\">采购员: " + cgdModel.CGPERSON + "</td><td align=\"left\" colspan=\"3\">质检员: </td></tr>"); sHtml.Append("</table>"); return(sHtml.ToString()); }