public ForeExhibitionApplicationViewPage ExhibitionApplicatioDetail(string id, string idd)
{
ForeExhibitionApplicationViewPage xx = new ForeExhibitionApplicationViewPage();
var UserInfo = db.UsersInfo.Where(a => a.UserName == idd).FirstOrDefault();
var ExhibitionApplication = (from a in db.Trade
join b in db.TradeExamine
on a.TradeID equals b.TradeID
where b.TradeID == id && b.UserID == UserInfo.UserID
select new ForeOtherApplicationViewPage1
{
TradeExamineFeedback = b.TradeExamineFeedback,
TradeID = a.TradeID,
TradeTitle = a.TradeTitle,
TradeExamineTime = a.TradeTime,
TradeAddress = a.TradeAddress,
TradeImg = a.TradeImg,
TradeExamineState = b.TradeExamineState,
TradeContact = a.TradeContact,
TradeInfo = a.TradeInfo,
TradeIntroduction = a.TradeIntroduction,
}).ToList();
xx.aa = ExhibitionApplication;
return(xx);
}
public ForeExhibitionApplicationViewPage Index(string id)
{
ForeExhibitionApplicationViewPage xx = new ForeExhibitionApplicationViewPage();
var UserInfo = db.UsersInfo.Where(a => a.UserName == id).FirstOrDefault();
var ExhibitionApplication = (from a in db.Trade
join b in db.TradeExamine
on a.TradeID equals b.TradeID
where b.UserID == UserInfo.UserID
select new ForeOtherApplicationViewPage1
{
TradeID = a.TradeID,
TradeTitle = a.TradeTitle,
TradeExamineTime = b.TradeExamineTime,
TradeAddress = a.TradeAddress,
TradeImg = a.TradeImg,
TradeExamineState = b.TradeExamineState,
TradeContact = a.TradeContact,
ContactPhone = a.ContactPhone,
TradeInfo = a.TradeInfo,
}).ToList();
int ItemNum = ExhibitionApplication.Count();
xx.ItemNum = ItemNum.ToString();
xx.aa = ExhibitionApplication;
return(xx);
}
public ActionResult ForeExhibitionApplication1(ForeExhibitionApplicationViewPage ExhibitionApplicationAdd, string idd)
{
IForeExhibitionApplication IF = new ForeExhibitionApplicationMethod();
string UserID = System.Web.HttpContext.Current.Session["UserName"].ToString();
string fileSave = Server.MapPath("~/upload/");
try
{
HttpFileCollectionBase file = Request.Files;
if (file.Count != 0)
{
for (int i = 0; i < file.Count; i++)
{
if (file.AllKeys[i] == "TradeDocument")
{
HttpPostedFileBase file1 = file[i];
string extName = Path.GetExtension(file1.FileName);
string newName = Guid.NewGuid().ToString() + extName;
file1.SaveAs(Path.Combine(fileSave, newName));
ExhibitionApplicationAdd.TradeDocument = "../upload/" + newName;
}
}
}
}
catch
{
return(Json("文件过大", JsonRequestBehavior.AllowGet));
}
return(Json(IF.Add(ExhibitionApplicationAdd, idd, UserID), JsonRequestBehavior.AllowGet));
}
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 ActionResult TradeExamineFeedback(string id, ForeExhibitionApplicationViewPage TradeExamineFeedbackAdd)
{
IExhibitionApplication IE = new ExhibitionApplicationMethod();
string idd = "0";
try
{
idd = System.Web.HttpContext.Current.Session["UserName"].ToString();
}
catch
{
return(Json("操作时间过长请重新登录"));
}
return(Json(IE.TradeExamineFeedback(TradeExamineFeedbackAdd, id, idd), JsonRequestBehavior.AllowGet));
}
public String TradeExamineFeedback(ForeExhibitionApplicationViewPage TradeExamineFeedbackAdd, string id, string idd)
{
var UserInfo = db.UsersInfo.Where(a => a.UserName == idd).FirstOrDefault();
var TradeExamineInfo = db.TradeExamine.Where(a => a.UserID == UserInfo.UserID).ToList();//寻找当前id的数据
var TradeExamineInfo1 = TradeExamineInfo.Where(a => a.TradeID == id).FirstOrDefault();
if (TradeExamineFeedbackAdd.TradeExamineFeedback == null)
{
return("请输入反馈内容");
}
string name = "^[a-zA-Z0-9\u4e00-\u9fa5]{1,}$";//字母数字汉字
Regex rxname = new Regex(name);
if (!rxname.IsMatch(TradeExamineFeedbackAdd.TradeExamineFeedback))
{
return("请输入正确格式");
}
TradeExamineInfo1.TradeExamineFeedback = TradeExamineFeedbackAdd.TradeExamineFeedback;
TradeExamineInfo1.TradeExamineState = TradeExamineState1.ConfirmFeedback;
db.SaveChanges();
return("反馈成功");
}
