Exemple #1
0
        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"));
        }
Exemple #2
0
        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"));
        }