public JsonResult Table(int limit, int offset, string id)
{
try
{
var list = new List <SCS_SignUp>();
var result = from m in db.SCS_SignUp
where m.审阅状态 == 0
select m;
foreach (var item in result)
{
SCS_SignUp tB = new SCS_SignUp
{
姓名 = item.姓名,
班级 = item.班级,
学号 = item.学号,
电话 = item.电话,
学年成绩 = item.学年成绩,
id = item.id
};
list.Add(tB);
}
var total = list.Count;
var rows = list.Skip(offset).Take(limit).ToList();
return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public JsonResult Table_adpot(int limit, int offset)
{
try
{
int user_Login = Convert.ToInt32(Session["username"]);
var list = new List <SCS_SignUp>();
var result = db.SCS_SignUp.Where(c => c.审阅状态 == user_Login);
//where m.审阅状态>1
//select m;
foreach (var item in result)
{
SCS_SignUp tB = new SCS_SignUp();
//{
// 姓名 = item.姓名,
// 班级 = item.班级,
// 学号 = item.学号,
// 电话 = item.电话,
// 学年成绩 = item.学年成绩,
// id = item.id
//};
list.Add(tB);
}
var total = list.Count;
var rows = list.Skip(offset).Take(limit).ToList();
return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult DeleteConfirmed(int id)
{
SCS_SignUp sCS_SignUp = db.SCS_SignUp.Find(id);
db.SCS_SignUp.Remove(sCS_SignUp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,姓名,班级,学号,学年成绩,电话,比赛项目,类别,邮箱,报名时间,团队人员姓名,审阅状态")] SCS_SignUp sCS_SignUp)
{
if (ModelState.IsValid)
{
db.Entry(sCS_SignUp).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sCS_SignUp));
}
public ActionResult Create([Bind(Include = "id,姓名,班级,学号,学年成绩,电话,比赛项目,类别,邮箱,报名时间,团队人员姓名,审阅状态")] SCS_SignUp sCS_SignUp)
{
if (ModelState.IsValid)
{
db.SCS_SignUp.Add(sCS_SignUp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sCS_SignUp));
}
public JsonResult GetUserMessage(int id)
{
var result = from r in db.SCS_SignUp
where (r.id == id)
select r;
SCS_SignUp TB = new SCS_SignUp();
foreach (var r in result)
{
}
return(Json(TB));
}
public JsonResult Via(int row_id)//通过
{
var result = db.SCS_SignUp.SingleOrDefault(c => c.id == row_id);
SCS_SignUp tB = db.SCS_SignUp.Find(result.id);
tB.审阅状态 = Convert.ToInt32(Session["username"]);
db.Entry(tB).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
return(Json(tB.审阅状态));
}
// GET: Examinations/SCS_SignUp/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SCS_SignUp sCS_SignUp = db.SCS_SignUp.Find(id);
if (sCS_SignUp == null)
{
return(HttpNotFound());
}
return(View(sCS_SignUp));
}
public JsonResult Retreat(int row_id)//退回
{
var result = db.SCS_SignUp.SingleOrDefault(c => c.id == row_id);
SCS_SignUp tB = db.SCS_SignUp.Find(result.id);
tB.审阅状态 = -1;
db.Entry(tB).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
return(Json(true));
}
public JsonResult back(int id)//退回
{
SCS_SignUp tB = db.SCS_SignUp.Find(id);
tB.审阅状态 = -1;
db.Entry(tB).State = EntityState.Modified;
db.SaveChanges();
int teaid = Convert.ToInt32(Session["username"]);
var name = db.SCS_TeacherLogin.Where(c => c.职工号 == teaid).First().姓名;
SCS_Message msg = new SCS_Message
{
内容 = "报名申请被退回重填",
发件人 = name,
时间 = DateTime.Now.ToString()
};
db.SCS_Message.Add(msg);
db.SaveChanges();
return(Json(true));
}
public JsonResult NewEdit(int id)
{
SCS_SignUp tb = db.SCS_SignUp.Find(id);
return(Json(tb));
}
