예제 #1
0
        /// <summary>
        /// 获取教材
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public C_Textbook GetTextbookById(int id)
        {
            using (var db = new fz_basicEntities())
            {
                dict_textbook s = db.dict_textbook.Find(id);

                return(new C_Textbook
                {
                    Id = s.Id,
                    BookName = s.BookName,
                    Stage = s.Stage,
                    Subject = s.Subject,
                    Grade = s.Grade,
                    Edition = s.Edition,
                    Booklet = s.Booklet,
                    BookCover = s.Cover,
                    BookConfig = s.ConfigFile
                });
            }
        }
예제 #2
0
        /// <summary>
        /// 根据教材id更新教材配置文件与教材封面
        /// </summary>
        /// <param name="id">教材id</param>
        /// <param name="stage">教材所属学段</param>
        /// <param name="subject">教材所属学科</param>
        /// <param name="grade">教材所属年级</param>
        /// <param name="booklet">教材所属册别</param>
        /// <param name="edition">教材所属版本</param>
        /// <param name="bookName">教材名称</param>
        /// <param name="config">教材db.js路径</param>
        /// <param name="cover">教材封面路径</param>
        /// <param name="remark">备注</param>
        public void UpdateTextbook(int id, int stage, int subject, int grade, int booklet, int edition, string bookName, string config, string cover, string remark)
        {
            using (var db = new fz_basicEntities())
            {
                dict_textbook m = db.dict_textbook.Find(id);
                if (m == null)//没找到新增
                {
                    db.dict_textbook.Add(new dict_textbook
                    {
                        Id             = id,
                        Stage          = stage,
                        Subject        = subject,
                        Grade          = grade,
                        Booklet        = booklet,
                        Edition        = edition,
                        BookName       = bookName,
                        ConfigFile     = config,
                        Cover          = cover,
                        Remark         = remark,
                        Deleted        = 0,
                        CreateDateTime = System.DateTime.Now
                    });
                }
                else//找到修改
                {
                    m.Stage      = stage;
                    m.Subject    = subject;
                    m.Grade      = grade;
                    m.Booklet    = booklet;
                    m.Edition    = edition;
                    m.BookName   = bookName;
                    m.ConfigFile = config;
                    m.Cover      = cover;
                    m.Remark     = remark;
                    m.Deleted    = 0;
                }

                db.SaveChanges();
            }
        }