public ActionResult ViewSecurityCodeReportCheck(int ID) { ViewData["ID"] = ID; T_SecurityCode Model = db.T_SecurityCode.SingleOrDefault(a => a.ID == ID); if (ID == 0) { return(HttpNotFound()); } ViewData["ID"] = ID; var history = db.T_SecurityCodeAppRove.Where(a => a.Oid == ID); string table = "<table class=\"fromEditTable setTextWidth300\"> <tbody><tr><td>审核人</td><td>审核结果</td><td>审核时间</td><td>备注</td></tr>"; string tr = ""; foreach (var item in history) { string s = ""; if (item.Status == -1) { s = "<font color=blue>未审核</font>"; } if (item.Status == 1) { s = "<font color=green>已同意</font>"; } if (item.Status == 2) { s = "<font color=red>不同意</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>"; return(View(Model)); }
public JsonResult DeleteSecurityCodeFinance(int ID) { T_SecurityCode model = db.T_SecurityCode.Find(ID); model.Isdelete = 1; db.Entry <T_SecurityCode>(model).State = System.Data.Entity.EntityState.Modified; int i = db.SaveChanges(); return(Json(i, JsonRequestBehavior.AllowGet)); }
public JsonResult SecurityCodeApp(T_SecurityCode model) { string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); model.ApplyName = Nickname; model.ApplyDate = DateTime.Now; model.Status = -1; model.Step = 0; model.Isdelete = 0; db.T_SecurityCode.Add(model); int i = db.SaveChanges(); if (i > 0) { T_SecurityCodeConfig modelconfig = db.T_SecurityCodeConfig.SingleOrDefault(a => a.Step == 0 && a.Reason == "1"); T_SecurityCodeAppRove AppRoveModel = new T_SecurityCodeAppRove(); AppRoveModel.Status = -1; AppRoveModel.Step = "0"; if (modelconfig.Name == null || modelconfig.Name == "") { AppRoveModel.ApproveName = modelconfig.Type; } else { AppRoveModel.ApproveName = modelconfig.Name; } AppRoveModel.ApproveDName = modelconfig.Type; AppRoveModel.Oid = model.ID; db.T_SecurityCodeAppRove.Add(AppRoveModel); db.SaveChanges(); return(Json(i, JsonRequestBehavior.AllowGet)); } else { return(Json(i, JsonRequestBehavior.AllowGet)); } }
public ContentResult GetSecurityCodeCheckenList(Lib.GridPager pager, string queryStr) { string name = Server.UrlDecode(Request.Cookies["Name"].Value); string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); List <T_SecurityCodeAppRove> ApproveMod = db.T_SecurityCodeAppRove.Where(a => (a.ApproveName == name || a.ApproveName == Nickname) && (a.Status == 1 || a.Status == 2)).ToList(); int[] Arry = new int[ApproveMod.Count]; for (int i = 0; i < ApproveMod.Count; i++) { Arry[i] = int.Parse(ApproveMod[i].Oid.ToString()); } IQueryable <T_SecurityCode> queryData = from r in db.T_SecurityCode where Arry.Contains(r.ID) && r.Isdelete == 0 select r; if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => (a.ProductName != null && a.ProductName.Contains(queryStr))); } pager.totalRows = queryData.Count(); //分页 queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_SecurityCode> list = new List <T_SecurityCode>(); foreach (var item in queryData) { T_SecurityCode i = new T_SecurityCode(); i = item; list.Add(i); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
//审核 public JsonResult SecurityCodeCheck(T_SecurityCode model, string status, string Memo) { using (TransactionScope sc = new TransactionScope()) { int ID = model.ID; T_SecurityCode Invoicemodel = db.T_SecurityCode.SingleOrDefault(a => a.ID == ID && a.Isdelete == 0); if (Invoicemodel == null) { return(Json("数据可能被删除", JsonRequestBehavior.AllowGet)); } T_SecurityCodeAppRove modelApprove = db.T_SecurityCodeAppRove.FirstOrDefault(a => a.Oid == 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.Status = int.Parse(status); db.Entry <T_SecurityCodeAppRove>(modelApprove).State = System.Data.Entity.EntityState.Modified; int i = db.SaveChanges(); if (i > 0) { if (status == "1") { T_SecurityCodeAppRove newApprove = new T_SecurityCodeAppRove(); int step = int.Parse(Invoicemodel.Step.ToString()); step++; IQueryable <T_SecurityCodeConfig> config = db.T_SecurityCodeConfig.AsQueryable(); int stepLength = config.Count();//总共步骤 if (step < stepLength) { Invoicemodel.Status = 0; T_SecurityCodeConfig stepMod = db.T_SecurityCodeConfig.SingleOrDefault(a => a.Step == step); string nextName = stepMod.Name; newApprove.Memo = ""; newApprove.Oid = ID; newApprove.Status = -1; newApprove.Step = step.ToString(); if (nextName != null) { newApprove.ApproveName = nextName; newApprove.ApproveDName = stepMod.Type; } else { newApprove.ApproveName = stepMod.Type; newApprove.ApproveDName = stepMod.Type; } db.T_SecurityCodeAppRove.Add(newApprove); db.SaveChanges(); } else { Invoicemodel.Status = int.Parse(status); } Invoicemodel.Step = step; db.Entry <T_SecurityCode>(Invoicemodel).State = System.Data.Entity.EntityState.Modified; int j = db.SaveChanges(); if (j > 0) { result = "保存成功"; } else { result = "保存失败"; } } else { //不同意 Invoicemodel.Step = 0; Invoicemodel.Status = 2; db.Entry <T_SecurityCode>(Invoicemodel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //审核流程结束 申请人编辑后插入下一条记录 result = "保存成功"; } } else { result = "保存失败"; } sc.Complete(); return(Json(result, JsonRequestBehavior.AllowGet)); } }