public ActionResult WDTHandOrderCheckReport(int ID) { T_WDTHandOrder Model = db.T_WDTHandOrder.SingleOrDefault(a => a.ID == ID); T_WDTHandOrderApprove modelApprove = db.T_WDTHandOrderApprove.SingleOrDefault(a => a.Pid == ID && a.ApproveTime == null); if (Model.ProvinceAddress == "null") { Model.ProvinceAddress = ""; } if (Model.CityAddress == "null") { Model.CityAddress = ""; } if (Model.AreaAddress == "null") { Model.AreaAddress = ""; } List <T_WDTHandOrderApprove> approve = db.T_WDTHandOrderApprove.Where(a => a.Pid == ID).ToList(); string table = "<table class=\"fromEditTable setTextWidth300\"> <tbody><tr><td>审核人</td><td>审核结果</td><td>审核时间</td><td>备注</td></tr>"; string tr = ""; foreach (var item in approve) { string s = ""; if (item.ApproveStatus == -1) { s = "<font color=#d02e2e>未审核</font>"; } if (item.ApproveStatus == 1) { s = "<font color=#1fc73a>已同意</font>"; } if (item.ApproveStatus == 2) { s = "<font color=#d02e2e>不同意</font>"; } tr += string.Format("<tr><td><label>{0}</label></td><td>{1}</td><td>{2}</td><td>{3}</td></tr>", item.ApproveName, s, item.ApproveTime, item.Memo); } ViewData["history"] = table + tr + "</tbody></table>"; ViewData["approveid"] = Model.OrderID; ViewData["ID"] = Model.OrderID; ViewData["Approve"] = modelApprove.ApproveUser; return(View(Model)); }
//审核 public JsonResult WDTHandOrderCheckCheck(T_WDTHandOrder model, string status, string Memo) { using (TransactionScope sc = new TransactionScope()) { int ID = model.ID; T_WDTHandOrder Invoicemodel = db.T_WDTHandOrder.SingleOrDefault(a => a.ID == ID && a.Isdelete == 0); if (Invoicemodel == null) { return(Json("数据可能被删除", JsonRequestBehavior.AllowGet)); } T_WDTHandOrderApprove modelApprove = db.T_WDTHandOrderApprove.FirstOrDefault(a => a.Pid == ID && a.ApproveTime == null); string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); string result = ""; modelApprove.ApproveName = Nickname; modelApprove.Memo = Memo; modelApprove.ApproveTime = DateTime.Now; modelApprove.ApproveStatus = int.Parse(status); db.Entry <T_WDTHandOrderApprove>(modelApprove).State = System.Data.EntityState.Modified; int i = db.SaveChanges(); string Upde = "0"; if (i > 0) { if (status == "1") { T_WDTHandOrderApprove newApprove = new T_WDTHandOrderApprove(); int step = int.Parse(Invoicemodel.Step.ToString()); step++; IQueryable <T_WDTHandOrderConfig> config = db.T_WDTHandOrderConfig.AsQueryable(); int stepLength = config.Count();//总共步骤 if (step < stepLength) { Invoicemodel.Status = 0; T_WDTHandOrderConfig stepMod = db.T_WDTHandOrderConfig.SingleOrDefault(a => a.Step == step); string nextName = stepMod.Name; newApprove.Memo = ""; newApprove.Pid = ID; newApprove.ApproveStatus = -1; if (nextName != null) { newApprove.ApproveName = nextName; newApprove.ApproveUser = stepMod.ApproveType; } else { newApprove.ApproveName = stepMod.ApproveType; newApprove.ApproveUser = stepMod.ApproveType; } db.T_WDTHandOrderApprove.Add(newApprove); db.SaveChanges(); } else { Upde = UpToGY(Invoicemodel.ID); Invoicemodel.Status = int.Parse(status); } Invoicemodel.Step = step; db.Entry <T_WDTHandOrder>(Invoicemodel).State = System.Data.EntityState.Modified; int j = db.SaveChanges(); if (Upde == "1" && j > 0) { sc.Complete(); result = "保存成功"; } else { if (Upde == "0") { result = "上传旺店通失败导致保存失败"; } else { result = "保存失败"; } } } else { //不同意 Invoicemodel.Step = 0; Invoicemodel.Status = 2; db.Entry <T_WDTHandOrder>(Invoicemodel).State = System.Data.EntityState.Modified; int j = db.SaveChanges(); //审核流程结束 申请人编辑后插入下一条记录 sc.Complete(); if (j > 0) { result = "保存成功"; } else { result = "保存失败"; } } } else { result = "保存失败"; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public JsonResult WDTHOrderAdd(T_WDTHandOrder model, string jsonStr, string province, string city, string area) { //如果进入数据库失败就全部回滚 using (TransactionScope sc = new TransactionScope()) { //监控插入语句的异常 try { string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); //给主表T_WDTHandOrder缺少值的字段赋值 string orderNum = "7" + DateTime.Now.ToString("yyyyMMddHHmmssffff"); model.OrderID = orderNum; model.SingleShotTime = DateTime.Now; model.deliverGoodsTime = DateTime.Now; if (province == null) { province = ""; } if (city == null) { city = ""; } if (area == "") { area = ""; } model.ProvinceAddress = province; model.CityAddress = city; model.AreaAddress = area; model.CreateTime = DateTime.Now; model.CreateName = Nickname; model.Isdelete = 0; model.Status = -1; model.Step = 0; decimal cost = 0; List <T_WDTHandOrderDetail> details = App_Code.Com.Deserialize <T_WDTHandOrderDetail>(jsonStr); foreach (var item in details) { decimal num = decimal.Parse(item.num.ToString()); decimal Price = decimal.Parse(item.UnitPrice.ToString()); cost = (num * Price) + cost; item.PorderID = model.OrderID; db.T_WDTHandOrderDetail.Add(item); } cost += decimal.Parse(model.PostAmount.ToString()); //把计算的总金额赋值 model.Cost = cost; db.T_WDTHandOrder.Add(model); int i = db.SaveChanges(); if (i > 0) { T_WDTHandOrderConfig modelconfig = db.T_WDTHandOrderConfig.SingleOrDefault(a => a.Step == 0 && a.Reson == 1); T_WDTHandOrderApprove AppRoveModel = new T_WDTHandOrderApprove(); AppRoveModel.ApproveStatus = -1; if (modelconfig.Name == null || modelconfig.Name == "") { AppRoveModel.ApproveName = modelconfig.ApproveType; } else { AppRoveModel.ApproveName = modelconfig.Name; } AppRoveModel.ApproveUser = modelconfig.ApproveType; AppRoveModel.Pid = model.ID; db.T_WDTHandOrderApprove.Add(AppRoveModel); db.SaveChanges(); } else { return(Json(new { State = "Faile" }, JsonRequestBehavior.AllowGet)); } sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } }