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 String Add(ForeExhibitionApplicationViewPage ExhibitionApplicationAdd, string id, string UserID)
        {
            TradeExamine TradeExamineInfo = new TradeExamine();

            var UserInfo = db.UsersInfo.Where(a => a.UserName == UserID).FirstOrDefault();

            var TradeExamineInfoxx  = db.TradeExamine.Where(a => a.UserID == UserInfo.UserID).ToList();
            var TradeExamineInfoxxx = TradeExamineInfoxx.Where(a => a.TradeID == id).ToList();

            if (TradeExamineInfoxxx.Count() != 0)
            {
                return("您已申请,请勿重新申请");
            }

            TradeExamineInfo.TradeExamineID = DateTime.Now.ToString("yyyyMMddHHmmss");
            TradeExamineInfo.UserID         = UserInfo.UserID;
            TradeExamineInfo.TradeID        = id;
            if (ExhibitionApplicationAdd.TradeArea == null)
            {
                return("请输入商展面积");
            }
            TradeExamineInfo.TradeArea = ExhibitionApplicationAdd.TradeArea;
            if (ExhibitionApplicationAdd.TradeDocument == null)
            {
                return("请上传文件");
            }
            TradeExamineInfo.TradeDocument     = ExhibitionApplicationAdd.TradeDocument;
            TradeExamineInfo.TradeExamineState = TradeExamineState1.TradeExamineAccept;
            TradeExamineInfo.TradeExamineTime  = DateTime.Now;
            db.TradeExamine.Add(TradeExamineInfo);
            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 String Confirm(string id)
        {
            var          TradeExamine     = db.TradeExamine.Where(a => a.TradeExamineID == id).ToList();
            TradeExamine TradeExamineInfo = db.TradeExamine.Find(id);//寻找当前id的数据

            TradeExamineInfo.TradeExamineState = TradeExamineState1.ConfirmFeedback;
            db.SaveChanges();
            return("反馈成功");
        }
 public void NoPass(Array arr)
 {
     for (var i = 0; i < arr.Length; i++)
     {
         var          TradeExamineID = arr.GetValue(i);
         TradeExamine TradeExamine1  = db.TradeExamine.Find(TradeExamineID);
         if (TradeExamine1.TradeExamineState == TradeExamineState1.TradeExamineAccept)
         {
             TradeExamine1.TradeExamineState = TradeExamineState1.TradeExamineNoPass;
             db.SaveChanges();
         }
     }
 }