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);
}
}
