public void GetGrade(HttpContext context)
{
try
{
int uid = Convert.ToInt32(context.Request.Params["UserID"]);
//int uid = 1;
int SpotScore = Convert.ToInt32(context.Request.Params["SpotScore"]);
int DormitorySel = Convert.ToInt32(context.Request.Params["DormitorySel"]);
using (IFMPDBContext db = new IFMPDBContext())
{
var user = db.User.FirstOrDefault(x => x.ID == uid);
SpotCheck SpotCheck = new SpotCheck();
SpotCheck.SpotScore = SpotScore;
SpotCheck.DormitoryId = DormitorySel;
SpotCheck.CreateUser = user.RealName;
SpotCheck.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.SpotCheck.Add(SpotCheck);
db.SaveChanges();
var name = "{\"id\":\"" + SpotCheck.SpotId + "\",\"dormitoryid\":\"" + DormitorySel + "\"}";
sb.Append("{\"result\":\"true\",\"data\":[");
sb.Append(name.TrimEnd(','));
sb.Append("]}");
}
}
catch
{
sb.Append("{\"result\":\"false\"}");
}
context.Response.Clear();
context.Response.Write(sb.ToString().TrimEnd(','));
context.Response.End();
}
public void BindInfo()
{
using (IFMPDBContext db = new IFMPDBContext())
{
SpotProblem spotproblem = db.SpotProblem.FirstOrDefault(x => x.SpId == SpID);
if (spotproblem != null)
{
SpotCheck spotcheck = db.SpotCheck.FirstOrDefault(x => x.SpotId == spotproblem.SpotId);
Dormitory dormitory = db.Dormitory.FirstOrDefault(x => x.ID == spotcheck.DormitoryId);
this.ltl_DorName.Text = dormitory.DormiName.ToString();
this.ltl_ProDesc.Text = spotproblem.ProDesc.ToString();
this.ltl_DutyUser.Text = spotproblem.DutyUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.DutyUser).RealName;
this.ltl_SState.Text = (spotproblem.IsreView == true ? "是" : "否");
this.ltl_CreateUser.Text = spotproblem.CreateUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.CreateUser).RealName;
this.ltl_CreateDate.Text = spotproblem.CreateDate == null ? "" : spotproblem.CreateDate.Value.ToString("yyyy-MM-dd");
this.ltl_ReviewUser.Text = spotproblem.ReviewUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.ReviewUser).RealName;
this.ltl_ReviewDate.Text = spotproblem.ReviewDate == null ? "" : spotproblem.ReviewDate.Value.ToString("yyyy-MM-dd");
this.ltl_ReviewMemo.Text = spotproblem.ReviewMemo == null ? "" : spotproblem.ReviewMemo.ToString();
if (string.IsNullOrEmpty(spotproblem.SImage))
{
this.img.ImageUrl = "";
this.img.Visible = false;
}
else
{
this.img.ImageUrl = spotproblem.SImage.Length < 8 ? spotproblem.SImage : (spotproblem.SImage.ToString().Substring(0, 8) == "Templete" ? "../../DormitoryAPP/" + spotproblem.SImage : spotproblem.SImage);
}
}
}
}
public void SpotProblemAdd(HttpContext context)
{
try
{
int uid = Convert.ToInt32(context.Request.Params["UserID"]);
//int uid = 1;
int SpotScore = Convert.ToInt32(context.Request.Params["SpotScore"]);
int DormitorySel = Convert.ToInt32(context.Request.Params["DormitorySel"]);
var ProDesc = context.Request.Params["ProDesc"].TrimEnd(',').Split(',');
var DutyUser = context.Request.Params["DutyUser"].TrimEnd(',').Split(',');
using (IFMPDBContext db = new IFMPDBContext())
{
var user = db.User.FirstOrDefault(x => x.ID == uid);
SpotCheck SpotCheck = new SpotCheck();
SpotCheck.SpotScore = SpotScore;
SpotCheck.DormitoryId = DormitorySel;
SpotCheck.CreateUser = user.RealName;
SpotCheck.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.SpotCheck.Add(SpotCheck);
db.SaveChanges();
for (int i = 0; i < ProDesc.Length; i++)
{
int dutyuderid = int.Parse(DutyUser[i]);
SpotProblem SpotProblem = new SpotProblem();
SpotProblem.SpotId = SpotCheck.SpotId;
SpotProblem.ProDesc = ProDesc[i];
SpotProblem.DutyUser = db.User.FirstOrDefault(x => x.ID == dutyuderid).RealName;
SpotProblem.CreateUser = db.User.FirstOrDefault(x => x.ID == uid).RealName;
SpotProblem.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
SpotProblem.IsreView = false;
db.SpotProblem.Add(SpotProblem);
db.SaveChanges();
}
sb.Append("{\"result\":\"true\"}");
}
}
catch
{
sb.Append("{\"result\":\"false\"}");
}
context.Response.Clear();
context.Response.Write(sb.ToString().TrimEnd(','));
context.Response.End();
}
