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();
}
}
}
