public String Add(TradeExamineViewPage1 VisaAdd) { Visa VisaInfo = new Visa(); var CompanyInfo = db.UsersInfo.Where(a => a.CompanyID == VisaAdd.CompanyID).FirstOrDefault(); var VisaInfo1 = db.Visa.ToList(); var VisaInfo2 = VisaInfo1.Where(s => s.CompanyName == (CompanyInfo.CompanyName)).ToList(); if (VisaInfo2.Count > 0) { return("该签证已受理"); } else { var TradeExamine = db.TradeExamine.Where(a => a.TradeExamineID == VisaAdd.TradeExamineID).ToList(); TradeExamine TradeExamineInfo = db.TradeExamine.Find(VisaAdd.TradeExamineID);//寻找当前id的数据 TradeExamineInfo.TradeExamineState = TradeExamineState1.Finish; VisaInfo.VisaID = DateTime.Now.ToString("yyyyMMddHHmmss"); VisaInfo.CompanyID = VisaAdd.CompanyID; VisaInfo.CompanyName = CompanyInfo.CompanyName; VisaInfo.VisaName = "高职校"; VisaInfo.VisaType = "中国 "; VisaInfo.VisaState = VisaState1.Reviewing; VisaInfo.VisaTime = DateTime.Now; db.Visa.Add(VisaInfo); db.SaveChanges(); } return("签证受理成功"); }
public TradeExamineViewPage1 TradeExamineDetail(string id) { TradeExamine TradeExamineInfo = db.TradeExamine.Find(id);//寻找当前id的数据 TradeExamineViewPage1 TradeExamineDetail = new TradeExamineViewPage1(); TradeExamineDetail.TradeExamineFeedback = TradeExamineInfo.TradeExamineFeedback; return(TradeExamineDetail); }
public ActionResult VisaAdd(TradeExamineViewPage1 VisaAdd) { ITradeExamine IT = new TradeExamineMethod(); return(Json(IT.Add(VisaAdd))); }