public ActionResult CheckChoose(int choose, int id)
{
T_TB_Choose temp = db.T_TB_Choose.Find(id);
temp.State = choose;
temp.StateReason = "";
db.SaveChanges();
return(RedirectToAction("DeanIndex"));
}
public ActionResult Edit(int Id) //编辑教材订购信息
{
if (Session["person"] == null || (int)Session["type"] != 6)
{
return(Redirect("/TBsys/Login/Index"));
}
T_TB_Choose temp = db.T_TB_Choose.Find(Id);
ViewBag.item = temp;
return(View());
}
public JsonResult CheckChoose2(int choose, int id, string reason)
{
T_TB_Choose temp = db.T_TB_Choose.Find(id);
if (temp == null)
{
return(Json(new { code = 0 }, JsonRequestBehavior.AllowGet));
}
temp.State = choose;
temp.StateReason = reason;
db.SaveChanges();
return(Json(new{ code = 1 }, JsonRequestBehavior.AllowGet));
}
public ActionResult editBook(int Id, string CourseName, string bookName, string bookId, string Author, decimal Price, string Publisher, int Edition) //修改订书信息
{
T_TB_Choose item = db.T_TB_Choose.Find(Id);
T_TB_TeachingTask item2 = db.T_TB_TeachingTask.Find(item.TeachingTaskId);
T_TB_Books item3 = db.T_TB_Books.Find(bookId);
item2.CourseName = CourseName;
item3.Id = bookId;
item3.Name = bookName;
item3.Author = Author;
item3.Price = Price;
item3.Publisher = Publisher;
item3.Edition = Edition;
db.SaveChanges();
return(RedirectToAction("BookMessage"));
}
public ActionResult Add(int cId, string bookName, string bookId, string bookAuthor, string Price, string Publisher, int Edition, string Reason, int bookCheck = 0)
{
//确定书籍书否存在，不存在则添加
T_TB_Books book = db.T_TB_Books.Find(bookId);
if (bookId != null && book == null)
{
book = new T_TB_Books();
book.Id = bookId;
book.Name = bookName;
book.Author = bookAuthor;
book.Price = Convert.ToDecimal(Price);
book.Publisher = Publisher;
book.Edition = Edition;
db.T_TB_Books.Add(book);
}
//向教材选定表添加
T_TB_Choose choose = new T_TB_Choose();
choose.BookId = bookId;
choose.TeachingTaskId = cId;
choose.Reason = Reason;
choose.State = 2;
db.T_TB_Choose.Add(choose);
//修改教学任务状态为已经填写
T_TB_TeachingTask task = db.T_TB_TeachingTask.Find(cId);
task.State = 4;
//添加老师预定书
if (bookCheck == 1)
{
T_TB_TeaYuding temp = new T_TB_TeaYuding();
temp.TeaId = (string)Session["Id"];
temp.BookId = bookId;
temp.TaskId = cId;
db.T_TB_TeaYuding.Add(temp);
}
db.SaveChanges();
return(RedirectToAction("GetLIst"));
}
public JsonResult AddChoose(string allChoose)
{
string stuId = (string)Session["Id"];
int sum = 0;
//List<int> iList = new List<int>();
foreach (char c in allChoose)
{
if (c == '&')
{
//iList.Add(sum);
T_TB_Choose choose = db.T_TB_Choose.Find(sum);
var query = db.T_TB_StuYuding.Where(m => m.StuId == stuId && m.TaskId == choose.TeachingTaskId);
if (query.Count() == 0)
{
T_TB_StuYuding item = new T_TB_StuYuding();
item.StuId = stuId;
item.BookId = choose.BookId;
item.TaskId = choose.TeachingTaskId;
item.State = 2;
db.T_TB_StuYuding.Add(item);
db.SaveChanges();
}
sum = 0;
}
else
{
sum = sum * 10 + c - '0';
}
}
return(Json(new { code = 1 }, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveEdit(int cId, string bookName, string bookId, string bookAuthor, string Price, string Publisher, int Edition, string Reason, int bookCheck = 0)
{
//确定书籍书否存在，不存在则添加,存在则修改信息
T_TB_Books book = db.T_TB_Books.Find(bookId);
if (book == null)
{
book = new T_TB_Books();
book.Id = bookId;
book.Name = bookName;
book.Author = bookAuthor;
book.Price = Convert.ToDecimal(Price);
book.Publisher = Publisher;
book.Edition = Edition;
db.T_TB_Books.Add(book);
}
else
{
book.Name = bookName;
book.Author = bookAuthor;
book.Price = Convert.ToDecimal(Price);
book.Publisher = Publisher;
book.Edition = Edition;
}
//向教材选定表修改
T_TB_Choose choose = db.T_TB_Choose.Where(m => m.TeachingTaskId == cId).First();
choose.BookId = bookId;
choose.Reason = Reason;
//无库存、不通过状态编辑后,状态改变
choose.State = 2;
//添加老师预定书修改
if (bookCheck == 0)
{
string teaId = (string)Session["Id"];
var query = db.T_TB_TeaYuding.Where(m => m.TeaId == teaId && m.TaskId == cId);
if (query.Count() != 0)
{
db.T_TB_TeaYuding.Remove(query.First());
}
}
else if (bookCheck == 1)
{
string teaId = (string)Session["Id"];
var query = db.T_TB_TeaYuding.Where(m => m.TeaId == teaId && m.TaskId == cId);
if (query.Count() == 0)
{
T_TB_TeaYuding temp = new T_TB_TeaYuding();
temp.TeaId = (string)Session["Id"];
temp.BookId = bookId;
temp.TaskId = cId;
db.T_TB_TeaYuding.Add(temp);
}
else
{
T_TB_TeaYuding temp = query.First();
temp.BookId = bookId;
}
}
db.SaveChanges();
return(RedirectToAction("GetLIst"));
}
