public ActionResult Save(System.Int32 id, string tag) { CurUser = Session["UserModel"] as SysUser; T_SHDModels model = new T_SHDModels(); //加载产品列表 T_YLCPModels ylcpQymode = new T_YLCPModels(); ylcpQymode.DataModel = ylcpQymode.DataModel ?? new T_YLCP(); ylcpQymode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpQymode.DataModel).Where(p => p.CPStatus == Convert.ToInt32("1")).ToList(); ViewData["YLCP"] = new SelectList(ylcpQymode.DataList, "CPID", "CPMC"); //获取本企业下的人员列表 T_Person person = new T_Person(); person.PsQYID = (int)CurUser.UserCompanyID; ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ"); model.DataModel = new T_SHD(); if (id != 0) { model.DataModel = T_SHDDomain.GetInstance().GetModelById(id); model.SHMXList = T_SHDDomain.GetInstance().GetT_SHMXByshid(id); } else { model.DataModel.SHDH = T_SHDDomain.GetInstance().GetSHOrderNum(CurUser); model.DataModel.SHCJR = CurUser.UserAccount; model.DataModel.SHCJRQ = DateTime.Now; } model.Tag = tag; model.RoleCode = GetRoleCode(); return(View("~/Views/T_SHD/Save.cshtml", model)); }
public void Delete(System.Int32 id) { //var rCode = GetRoleCode(); var temp = T_SHDDomain.GetInstance().GetModelById(id); if (temp != null) { if (temp.ISSH == 1) { Response.Write("{\"statusCode\":\"300\", \"message\":\"已审批通过的数据不能删除!\"}"); return; } } int result = T_SHDDomain.GetInstance().Delete(id); Response.ContentType = "text/json"; if (result > 0) { Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_SHD/Index\"}"); } else { Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}"); } }
// GET: T_SHD public ActionResult Index(T_SHDModels evalModel) { try { evalModel.currentPage = int.Parse(Request["pageNum"].ToString()); } catch { } string order = ""; try { order = Request["orderField"].ToString(); } catch { } if (order.Trim() == "${param.orderField}") { order = ""; } int pagesize = Convert.ToInt32(evalModel.pageSize); int pagecount = Convert.ToInt32(evalModel.pagecount); int currentPage = Convert.ToInt32(evalModel.currentPage); evalModel.DataModel = evalModel.DataModel ?? new T_SHD(); if (Request["strSHDH"] != null) { string str = Request["strSHDH"].ToString(); if (!String.IsNullOrEmpty(str)) { evalModel.DataModel.SHDH = str.Trim(); } ViewData["strSHDH"] = str; } if (Request["strSHSQPerson"] != null) { string str = Request["strSHSQPerson"].ToString(); if (!String.IsNullOrEmpty(str)) { evalModel.DataModel.SQR = str.Trim(); } ViewData["strSHSQPerson"] = str; } //获取本企业下的人员列表 SysUser UserModel = Session["UserModel"] as SysUser; T_Person person = new T_Person(); person.PsQYID = (int)UserModel.UserCompanyID; ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ"); evalModel.DataList = T_SHDDomain.GetInstance().PageT_SHD(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount); evalModel.resultCount = resultCount; return(View("~/Views/T_SHD/Index.cshtml", evalModel)); }
public ActionResult SHMXTable(System.Int32 id, string ckdh, int canEdit, int isSH) { T_SHDModels model = new T_SHDModels(); if (id != 0) { model.SHMXList = T_SHDDomain.GetInstance().GetT_SHMXByshid(id); } else { model.SHMXList = T_SHDDomain.GetInstance().GetT_SHMXByCkdh(ckdh); } model.RoleCode = GetRoleCode(); model.DataModel = new T_SHD(); model.DataModel.ISSH = isSH; model.DataModel.SHID = id; return(View("~/Views/T_SHD/SHMXTable.cshtml", model)); }
public void through(T_SHDModels model, int id) { int result = 0; try { Int32 xsdid = model.DataModel.SHID; result = T_SHDDomain.GetInstance().Sh(xsdid, id); } catch { } Response.ContentType = "text/json"; if (result > 0) { Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"closeCurrentReloadTab\",\"forwardUrl\":\"/T_SHD/Index\"}"); } else { Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}"); } }
public void Save(T_SHDModels model) { int result = 0; try { if (model.Tag == "Add") { model.DataModel.ISSH = 0; var temp = T_SHDDomain.GetInstance().GetAllModels <string>(p => p.SHDH == model.DataModel.SHDH).FirstOrDefault(); if (temp != null && temp.SHID != 0) { var CurUser1 = Session["UserModel"] as SysUser; model.DataModel.SHDH = T_SHDDomain.GetInstance().GetSHOrderNum(CurUser1); } result = T_SHDDomain.GetInstance().AddModel(model.DataModel); } else if (model.Tag == "Edit") { model.DataModel.ISSH = 0; result = T_SHDDomain.GetInstance().UpdateModel(model.DataModel, model.DataModel.SHID); } } catch { } Response.ContentType = "text/json"; if (result > 0) { Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"closeCurrentReloadTab\",\"forwardUrl\":\"/T_SHD/Index\"}"); } else { Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}"); } }
private string ExportExcelPRNew(System.Int32 id) { //获取需要打印的数据 var ckdinfo = T_SHDDomain.GetInstance().GetModelById(id); List <T_SHMX> ckmxList = T_SHMXDomain.GetInstance().GetListModelById(id); T_WhsQY qy = new T_WhsQY(); Expression <Func <T_WhsQY, bool> > where = PredicateBuilder.True <T_WhsQY>(); var lst = T_WhsQYDomain.GetInstance().GetAllModels <int>(where); if (lst != null && lst.Count > 0) { qy = lst[0]; } //命名导出表格的StringBuilder变量 StringBuilder sHtml = new StringBuilder(string.Empty); //打印表头 sHtml.Append("<table style='border-collapse:collapse;'>"); sHtml.Append("<tr height=\"40\"><td colspan=\"12\" align=\"center\" style='font-size:24px;border:0px;'><b>" + qy.WhsMC + "损耗单" + "</b></td></tr>"); sHtml.Append("<tr height=\"40\"><td align=\"left\" colspan=\"8\" style='border:0px;'>日 期:" + DateTime.Now.ToString("yyyy-MM-dd") + "</td><td align=\"right\" colspan=\"4\" style='border:0px;'>单据编号:" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + "</td></tr>"); //sHtml.Append("</table>"); //sHtml.Append("<table border=\"1\" width=\"100%\" style='border-collapse:collapse;border:1px solid black;'>"); sHtml.Append("<tr align=\"center\" ><td style='width: 80px;'>产品名称</td><td style='width: 40px;'>规格</td><td style='width: 40px;'>型号</td><td style='width: 100px;'>生产企业</td><td style='width: 70px;'>生产日期</td><td style='width: 35px;'>单位</td><td style='width: 35px;'>数量</td><td style='width: 40px;'>单价</td>" + "<td style='width: 60px;'>金额</td><td style='width: 70px;'>产品批号</td><td style='width: 80px;'>产品有效期</td><td style='width: 80px;'>经营许可证号</td><td style='width: 70px;'>注册证号</td></tr>"); //合计 double total = 0.0; double NumCpNum = 0.0; for (int i = 0; i < ckmxList.Count; i++) { var ckmx = ckmxList[i]; //产品名称 string cpName = ckmx.T_YLCP.CPMC; //规格 string cpGg = ckmx.T_YLCP.CPGG ?? ""; var cpxh = ckmx.T_YLCP.CPXH ?? ""; //单位 string cpDw = ckmx.T_YLCP.CPDW ?? ""; //数量 double cpDj = ckmx.CPNUM ?? 0; //产品批号 string scPh = ckmx.CPPH ?? ""; //产品有效期 string scRq = ""; if (ckmx.CPYXQ != null) { scRq = ckmx.CPYXQ.Value.ToString("yyyyMMdd"); } var scrq = ""; if (ckmx.CPSCRQ != null) { scrq = ckmx.CPSCRQ.Value.ToString("yyyyMMdd"); } //生产企业 string cpScqy = ""; if (ckmx.T_YLCP != null && ckmx.T_YLCP.T_SupQY1 != null && !string.IsNullOrEmpty(ckmx.T_YLCP.T_SupQY1.SupMC)) { cpScqy = ckmx.T_YLCP.T_SupQY1.SupMC; } //单价 double cpPrice = Math.Round(ckmx.T_YLCP.CPPrice ?? 0.0, 2); //产品总价 double rowTotal = Math.Round(cpDj * cpPrice, 2); total = total + rowTotal; NumCpNum = NumCpNum + cpDj; //经营许可证号 string xkzbh = ""; if (ckmx.T_YLCP != null && ckmx.T_YLCP.T_SupQY1 != null && !string.IsNullOrEmpty(ckmx.T_YLCP.T_SupQY1.SupXKZBH)) { xkzbh = ckmx.T_YLCP.T_SupQY1.SupXKZBH; } //注册证号 string cpzczh = ckmx.T_YLCP.CPZCZ; sHtml.Append("<tr align=\"center\"><td>" + cpName + "</td><td>" + cpGg + "</td><td>" + cpxh + "</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>" + scRq + "</td><td>" + xkzbh + "</td><td>" + cpzczh + "</td></tr>"); } //打印表尾 sHtml.Append("<tr id='trtotal' height=\"40\" align=\"center\"><td colspan=\"9\">合计金额:(大写)" + MoneySmallToBig(total.ToString()) + "</td><td colspan=\"4\">(小写)" + total.ToString("0.00") + "</td></tr>"); //sHtml.Append("</table>"); //sHtml.Append("<table border=\"0\" width=\"100%\">"); sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"7\" align=\"left\" style='border:0px;'>申请人: " + ckdinfo.SQR + "</td><td align=\"left\" colspan='5' style='border:0px;'>复核员: " + ckdinfo.FHY + "</td></tr>"); sHtml.Append("</table>"); return(sHtml.ToString()); }
/// <summary> /// 获取提示信息 /// </summary> public string GetTipInfo() { var strHtml = new StringBuilder(); Expression <Func <ActivityInfo, bool> > whereActivityInfo = p => (p.EndTime != null && DateTime.Now <= p.EndTime.Value); whereActivityInfo = whereActivityInfo.And(p => p.StartTime != null && DateTime.Now >= p.StartTime.Value); var ActivityInfoCount = ActivityInfoDomain.GetInstance().GetAllModels <int>(whereActivityInfo).Count; //有效的公告数量 var AlarmCount = T_BJDDomain.GetInstance().GetCount(); //报警数量 if (AlarmCount > 0) { strHtml.Append(string.Format(strTemplete, "alarmManage", "/T_BJD/Index/", "预警通知", AlarmCount, "报警")); } if (ActivityInfoCount > 0) { strHtml.Append(string.Format(strTemplete, "ActivityInfoManage", "/ActivityInfo/Index/", "公告管理", ActivityInfoCount, "公告")); } var RoleCode = GetRoleCode(); if (RoleCode == "2") { #region Expression <Func <T_SupQY, bool> > whereSupQY = p => p.SupStatus == 0; var SupQYCount = T_SupQYDomain.GetInstance().GetAllModels <int>(whereSupQY).Count; //待审批的供货企业数量 Expression <Func <T_YLCP, bool> > whereYLCP = p => p.CPStatus == 0; var YLCPCount = T_YLCPDomain.GetInstance().GetAllModels <int>(whereYLCP).Count; //待审批的医疗产品数量 Expression <Func <T_CusQY, bool> > whereCusQY = p => p.CusStatus == 0; var CusQYCount = T_CusQYDomain.GetInstance().GetAllModels <int>(whereCusQY).Count; //待审批的购货企业数量 Expression <Func <T_CGD, bool> > whereCGD = p => p.ISSH == 0; var CGDCount = T_CGDDomain.GetInstance().GetAllModels <int>(whereCGD).Count; //待审批的采购单数量 Expression <Func <T_RKD, bool> > whereRKD = p => p.ISSH == 0; var RKDCount = T_RKDDomain.GetInstance().GetAllModels <int>(whereRKD).Count; //待审批的入库单数量 Expression <Func <T_XSD, bool> > whereXSD = p => p.XSFLAG == 0; var XSDCount = T_XSDDomain.GetInstance().GetAllModels <int>(whereXSD).Count; //待审批的销售单数量 Expression <Func <T_SHD, bool> > whereSHD = p => p.ISSH == 0; var SHDCount = T_SHDDomain.GetInstance().GetAllModels <int>(whereSHD).Count; //待审批的损耗单数量 Expression <Func <T_THD, bool> > whereTHD = p => p.ISSH == 0; var THHDCount = T_THDDomain.GetInstance().GetAllModels <int>(whereTHD).Count; //待审批的退货单数量 if (SupQYCount > 0) { strHtml.Append(string.Format(strTemplete, "SupQYManage", "/T_SupQY/Index/", "供货企业", SupQYCount, "供货企业待审批")); } if (YLCPCount > 0) { strHtml.Append(string.Format(strTemplete, "YLCPManage", "/T_YLCP/Index/", "产品信息", YLCPCount, "产品待审批")); } if (CusQYCount > 0) { strHtml.Append(string.Format(strTemplete, "CusQYManage", "/T_CusQY/Index/", "购货企业", CusQYCount, "购货企业待审批")); } if (CGDCount > 0) { strHtml.Append(string.Format(strTemplete, "CGDManage", "/T_CGD/Index/", "采购管理", CGDCount, "采购单待审批")); } if (RKDCount > 0) { strHtml.Append(string.Format(strTemplete, "RKDManage", "/T_RKD/Index/", "入库管理", RKDCount, "入库单待审批")); } if (XSDCount > 0) { strHtml.Append(string.Format(strTemplete, "XSDManage", "/T_XSD/Index/", "销售管理", XSDCount, "销售单待审批")); } if (SHDCount > 0) { strHtml.Append(string.Format(strTemplete, "SHDManage", "/T_SHD/Index/", "损耗管理", SHDCount, "损耗单待审批")); } if (THHDCount > 0) { strHtml.Append(string.Format(strTemplete, "THDManage", "/T_THD/Index/", "退货管理", THHDCount, "退货单待审批")); } #endregion } return(strHtml.ToString()); }