public CourserWareModel GetCourserModel(decimal courserId, string userid) { using (var db = new eduEntities()) { var model = (from a in db.COURSEWARE join b in db.JY_Channellesson on a.COURSE_ID equals(decimal) b.lessionid join c in db.JY_Channel on b.Channelid equals(short) c.ChannelID join d in db.JY_Lession on a.COURSE_NUMBER equals d.Course_number join e in db.jy_lessionimage on d.id equals e.LID where a.COURSE_ID == courserId select new CourserWareModel { channelName = c.ChannelName, ClickCount = a.topnum.Value, CourseSize = a.LIMIT_TIME.ToString(), CreateDate = a.COURSE_CREATEDATE.Value, Credit = a.credit_hour.Value, Exam = a.exam_id.ToString(), Id = a.COURSE_ID, Img = e.Path, Description = a.DESCRIPTION, Name = a.COURSE_NAME, Learning = db.AICC_J_HIGH_SCORE.Where(m => m.COURSE_ID == a.COURSE_NUMBER && m.STUDENT_ID == userid).FirstOrDefault() == null ? "0" : db.AICC_J_HIGH_SCORE.Where(m => m.COURSE_ID == a.COURSE_NUMBER && m.STUDENT_ID == userid).FirstOrDefault().timems.Value.ToString(), Teacher = a.teachername, Standards = a.TYPE_ID.Value, Duration = a.LIMIT_TIME.Value, CommentCredit = a.Recommend, Type = a.COURSE_TYPE, Score = a.Recommend.ToString() }).FirstOrDefault(); return(model); } }
public List <Jy_Article> GetArtList(string articltName, int pageIndex, int pageSize, out int totalCount, int type = 0) { using (var db = new eduEntities()) { IQueryable <Jy_Article> list = db.Jy_Article; if (type != 0) { list = list.Where(m => m.Type == type); } if (!string.IsNullOrEmpty(articltName)) { list = list.Where(m => m.title.Contains(articltName)); } totalCount = list.Count(); var date = list.OrderBy(" IsTop desc,time desc").Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); var fujian = new Jy_Article_Fujian(); date.ForEach(p => { fujian = db.Jy_Article_Fujian.Where(pp => pp.ArticleID == p.id).FirstOrDefault(); if (fujian != null) { p.url = fujian.fujian; } if (!p.ClickRate.HasValue && p.ClickRate < 0) { p.ClickRate = 0; } }); return(date); } }
public JY_UrlMms Getfirst(decimal id) { using (var db = new eduEntities()) { var date = db.JY_UrlMms.Where(m => m.CourseID == id).FirstOrDefault(); return(date); } }
public List <JY_Channel> GetChannelList(out int totalCount) { using (var db = new eduEntities()) { IQueryable <JY_Channel> list = db.JY_Channel.Where(p => p.parentid != -1); totalCount = list.Count(); return(list.OrderByDescending(m => m.OrderID).ToList()); } }
public string IsAny(string userid, string courseId) { using (var db = new eduEntities()) { if (userid == "") { return("未选"); } else if (db.AICC_J_HIGH_SCORE.Any(m => m.COURSE_ID.Equals(courseId) && m.STUDENT_ID == userid)) { return("已选"); } else { return("未选"); } } }
public int Resister(USERS user) { using (var db = new eduEntities()) { string strsql = " exec InsertMobileUSERS @USER_STATUS,@LAST_LOGIN_TIME,@USER_GROUP_ID,@USER_ID,@USER_TYPE,@USER_NAME,@USER_PWD,@USER_TEL,@LOGIN_TIMES,@id_card,@zj"; SqlParameter[] parms = new SqlParameter[11]; parms[0] = new SqlParameter("@USER_STATUS", user.user_state.Value); parms[1] = new SqlParameter("@LAST_LOGIN_TIME", user.LAST_LOGIN_TIME.Value); parms[2] = new SqlParameter("@USER_GROUP_ID", user.USER_GROUP_ID.Value); parms[3] = new SqlParameter("@USER_ID", user.USER_ID); parms[4] = new SqlParameter("@USER_TYPE", user.USER_TYPE.Value); parms[5] = new SqlParameter("@USER_NAME", user.USER_NAME); parms[6] = new SqlParameter("@USER_PWD", user.USER_PWD); parms[7] = new SqlParameter("@USER_TEL", user.USER_TEL); parms[8] = new SqlParameter("@LOGIN_TIMES", user.LOGIN_TIMES.Value); parms[9] = new SqlParameter("@id_card", user.id_card); parms[10] = new SqlParameter("@zj", user.zj.Value); return(db.Database.ExecuteSqlCommand(strsql, parms)); } }
public List <CourserWareModel> GetCourseWareList(string name, string teacher, int channel, int pageIndex, int pageSize, out int totalCount) { using (var db = new eduEntities()) { var list = (from a in db.COURSEWARE join b in db.JY_Channellesson on a.COURSE_ID equals(decimal) b.lessionid join c in db.JY_Channel on b.Channelid equals(short) c.ChannelID join d in db.JY_Lession on a.COURSE_NUMBER equals d.Course_number join e in db.jy_lessionimage on d.id equals e.LID where (channel != 0 ? b.Channelid == channel : b.Channelid == 58) && (!string.IsNullOrEmpty(teacher) ? a.teachername == teacher : true) && (!string.IsNullOrEmpty(name) ? a.COURSE_NAME.Contains(name) : true) select new CourserWareModel { channelName = c.ChannelName, ClickCount = a.topnum != null ? a.topnum.Value : 0, CourseSize = a.LIMIT_TIME.ToString(), CreateDate = a.COURSE_CREATEDATE.Value, Credit = a.credit_hour != null ? a.credit_hour.Value : 0, Exam = a.exam_id.ToString(), Id = a.COURSE_ID, Img = e.Path, Description = a.DESCRIPTION, Name = a.COURSE_NAME, Learning = "0", Teacher = a.teachername, Standards = a.TYPE_ID != null ? a.TYPE_ID.Value : 0, Duration = a.LIMIT_TIME != null ? a.LIMIT_TIME.Value : 0, CommentCredit = a.Recommend, Type = a.COURSE_TYPE }).OrderByDescending(m => m.CreateDate); totalCount = list.Count(); return(list.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
public List <CourserWareModel> RelatedFinishCourseList(string userid, int isFinish, int pageIndex, int pageSize, out int totalCount) { using (var db = new eduEntities()) { DateTime apptime = Convert.ToDateTime("2017-1-1"); var list = (from a in db.AICC_J_HIGH_SCORE join b in db.COURSEWARE on a.COURSE_ID equals b.COURSE_NUMBER join d in db.JY_Lession on a.COURSE_ID equals d.Course_number join e in db.jy_lessionimage on d.id equals e.LID where a.STUDENT_ID == userid && a.OBJ_FIRST_DATE > apptime && (isFinish == 1 ? a.length <= a.timems : a.length > a.timems) orderby a.OBJ_FIRST_DATE descending select new CourserWareModel { channelName = "", ClickCount = b.topnum.Value, CourseSize = b.LIMIT_TIME.ToString(), CreateDate = b.COURSE_CREATEDATE.Value, Credit = b.credit_hour.Value, Exam = b.exam_id.ToString(), Id = b.COURSE_ID, Img = e.Path, Description = b.DESCRIPTION, Name = b.COURSE_NAME, Teacher = b.teachername, Standards = b.TYPE_ID.Value, Duration = b.LIMIT_TIME.Value, CommentCredit = b.Recommend, Times = a.timems.Value, Length = a.length.Value, Type = b.COURSE_TYPE }); totalCount = list.Count(); return(list.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
public List <ArticleAndFujian> GetArticleAndFujian(int type, int pageIndex, int pageSize, out int totalCount) { using (var db = new eduEntities()) { var list = (from a in db.Jy_Article join b in db.JY_Atype on a.Type equals b.ID join c in db.Jy_Article_Fujian on a.id equals c.ArticleID where b.ID == type select new ArticleAndFujian() { Fujian = c.fujian, Id = a.id, Name = a.title, TypeId = b.ID, TypeName = b.TypeName, IsTop = a.IsTop.Value } ); totalCount = list.Count(); var data = list.OrderByDescending(m => m.IsTop).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); return(data); } }