/// <summary> /// 根据地点ID查询地点名称 /// </summary> /// <param name="locaId">地点ID</param> /// <returns></returns> public static List <Location> GetLoctionById(long locaId) { var db = new LAActivityEntities(); var loction = db.Location.Where(lc => lc.LocationID == locaId).ToList();//获取对应ParentID的学习地点 return(loction); }
/// <summary> /// 查询数据库中所有学习对象 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public static List <LearningObject> GetLObjectsByUserId(long userId) { var db = new LAActivityEntities(); var lObjects = db.LearningObject.Where(lo => lo.CreatedBy == userId).ToList();//获取指定用户的学习对象 return(lObjects); }
/// <summary> /// 查询数据库中所有学习地点 /// </summary> /// <returns></returns> public static List <Location> GetLoctionsByParentId(long parentId) { var db = new LAActivityEntities(); List <Location> loctions = db.Location.Where(lt => lt.ParentID == parentId).ToList();//获取对应ParentID的学习地点 return(loctions); }
/// <summary> /// 根据类别ID查询地点类别 /// </summary> /// <param name="typeId">类别ID</param> /// <returns></returns> public static ActivityType GetTypeById(long typeId) { var db = new LAActivityEntities(); var types = db.ActivityType.FirstOrDefault(tp => tp.ActivityTypeID == typeId);//获取对应ParentID的学习地点 return(types); }
public static List <FileType> GetFileTypesByParentId(long parentId) { LAActivityEntities db = new LAActivityEntities(); List <FileType> ftList = db.FileType.Where(ft => ft.ParentID == parentId).ToList(); return(ftList); }
public static List <QuerylearningActivity> GetAllLA() { using (var db = new LAActivityEntities()) { return(db.QuerylearningActivity.OrderByDescending(q => q.开始时间).ToList()); } }
public static long GetWorksId(string wName) { var db = new LAActivityEntities(); WorksFile works = db.WorksFile.FirstOrDefault(w => w.FileName.Equals(wName)); long WorksId = works.WorksFileID; return(WorksId); }
private void AddActivity() { LAActivityEntities db = new LAActivityEntities(); LADLL.LearningActivity la = new LADLL.LearningActivity(); la.UserID = 1; db.LearningActivity.Add(la); }
public static List <LearningObject> GetLObjects() { long userId = DAL.UserDAL.GetUserId(); var db = new LAActivityEntities(); List <LearningObject> lObjects = db.LearningObject.Where(lo => lo.CreatedBy == userId || lo.IsShare == 1).ToList();//获取所有学习对象 return(lObjects); }
public static List <Location> GetLoctions() { long userId = DAL.UserDAL.GetUserId(); var db = new LAActivityEntities(); List <Location> loctions = db.Location.Where(lc => lc.CreatBy == userId || lc.IsShare == 1).ToList();//获取对应ParentID的学习地点 return(loctions); }
/// <summary> /// 获取每个父级类别下的所有子级类别 /// </summary> /// <param name="parentId">父级类别ID</param> /// <returns></returns> public static List <ActivityType> GetTypesByparentId(long parentId) { using (LAActivityEntities db = new LAActivityEntities()) { List <ActivityType> atList = db.ActivityType.Where(at => at.ParentID == parentId).ToList(); return(atList); } }
public static List <laCountsbyUser> GetLaCountsbyUsers() { List <LADLL.laCountsbyUser> laList; using (var db = new LAActivityEntities()) { laList = db.laCountsbyUser.OrderByDescending(la => la.counts).ToList(); } return(laList); }
/// <summary> /// 查询指定活动ID的学习活动 /// </summary> /// <param name="laId">活动ID</param> /// <returns></returns> public static List <LADLL.LearningActivity> GetActivityById(long laId) { List <LADLL.LearningActivity> laList; using (var db = new LAActivityEntities()) { laList = db.LearningActivity.Where(la => la.LearningActivityID == laId).ToList(); } return(laList); }
public static List <ActivityType> GetTypes() { long userID = DAL.UserDAL.GetUserId(); using (LAActivityEntities db = new LAActivityEntities()) { List <ActivityType> atList = db.ActivityType.Where(t => t.ParentID != 0 && t.CreatBy == userID || t.IsShare == 1).ToList(); return(atList); } }
/// <summary> /// 新增父级活动类别 /// </summary> /// <param name="action">类别名称</param> /// <param name="description">类别描述</param> /// <returns>新增的父级类别ID</returns> public static long AddParentType(string action, string description) { LAActivityEntities db = new LAActivityEntities(); LADLL.ActivityType at = new LADLL.ActivityType(); at.Action = action; at.Description = description; at.ParentID = 0; db.ActivityType.Add(at); db.SaveChanges(); return(at.ActivityTypeID); }
public static void DelActivity(long id) { using (var db = new LAActivityEntities()) { var result = from la in db.LearningActivity where la.LearningActivityID == id select la; var target = result.FirstOrDefault <LADLL.LearningActivity>(); if (target != null) { target.Flag = 0; target.ModifyDate = DateTime.Now; } db.SaveChanges(); } }
/// <summary> /// 获取指定用户(userId!=0在指定活动类型(typeId)的活动 /// </summary> /// <param name="userId">用户ID</param> /// <param name="typeId">活动类型ID</param> /// <returns></returns> public static List <LADLL.QuerylearningActivity> GetActivitiesByType(long userId, long typeId) { var userActivities = new List <LADLL.QuerylearningActivity>(); using (var db = new LAActivityEntities()) { userActivities = db.QuerylearningActivity.Where(la => la.ActivityTypeID == typeId).ToList(); if (userId != 0) { userActivities = userActivities.Where(la => la.UserID == userId).ToList(); } } return(userActivities); }
/// <summary> /// 新增活动类别 /// </summary> /// <param name="action">类别名称</param> /// <param name="description">类别描述</param> /// <param name="userId">创建者ID</param> /// <param name="isShare">其他人可见</param> /// <param name="parentId">父级类别ID</param> /// <returns>新增的类别ID</returns> public static long AddActivityType(string action, string description, long userId, int isShare, long parentId) { LAActivityEntities db = new LAActivityEntities(); LADLL.ActivityType at = new LADLL.ActivityType(); at.Action = action; at.Description = description; at.ParentID = parentId; at.IsShare = isShare; at.CreatBy = userId; db.ActivityType.Add(at); db.SaveChanges(); return(at.ActivityTypeID); }
/// <summary> /// 获取指定用户的活动列表 /// </summary> /// <returns></returns> public static List <QuerylearningActivity> GetlearningActivityByUser(long userId) { List <QuerylearningActivity> qActivities = GetAllLA(); using (var db = new LAActivityEntities()) { //qActivities = db.QuerylearningActivity.OrderByDescending(q => q.开始时间).ToList(); //qActivities = GetAllLA; if (userId != 0) { qActivities = qActivities.Where(q => q.UserID == userId).ToList(); } } return(qActivities); }
public static long InsertWorkFile(string fileName, string filePath, int fSize, long flag) { var db = new LAActivityEntities(); WorksFile works = new WorksFile(); works.FileName = fileName; works.FilePath = filePath; works.FileSize = fSize; works.CreatedBy = DAL.UserDAL.GetUserId(); works.Created = DateTime.Now; works.Flag = flag; db.WorksFile.Add(works); db.SaveChanges(); return(works.WorksFileID); }
/// <summary> /// 新增活动地点 /// </summary> /// <param name="locName">地点名称</param> /// <param name="description">类别描述</param> /// <param name="isShare">其他人可见</param> /// <param name="parentId">父级类别ID</param> /// <param name="userId">创建者ID</param> /// <returns>新增的地点ID</returns> public static long AddLocation(string locName, string description, long userId, int isShare, long parentId) { var db = new LAActivityEntities(); var loc = new Location { Address = locName, Description = description, ParentID = parentId, IsShare = isShare, CreatBy = userId }; db.Location.Add(loc); db.SaveChanges(); return(loc.LocationID); }
/// <summary> /// 新增学习对象 /// </summary> /// <param name="title">对象名称</param> /// <param name="desc">对象描述</param> /// <param name="isShare">其他人可见</param> /// <param name="lContent">学习内容</param> /// <param name="userId">创建者ID</param> /// <returns>新增对象的ID</returns> public static long AddNewOject(string title, string desc, int isShare, long userId, string lContent) { var db = new LAActivityEntities(); var lo = new LearningObject { Title = title, Description = desc, LearningContent = lContent, IsShare = isShare, CreatedBy = userId, CreatedDate = DateTime.Now }; db.LearningObject.Add(lo); db.SaveChanges(); return(lo.LearningObjectID); }
/// <summary> /// 获取某个用户近几天之内的所有活动 /// </summary> /// <param name="userid">用户ID</param> /// <param name="days">统计天数</param> public static List <LADLL.LearningActivity> GetLAbyUserIdandDate(long userid, int days) { DateTime dt = DateTime.Now.AddDays(-days).Date; using (var db = new LAActivityEntities()) { List <LADLL.LearningActivity> userActivities; if (userid == 0) { userActivities = db.LearningActivity.Where(la => la.Start > dt).ToList(); } else { userActivities = db.LearningActivity.Where(la => la.UserID == userid && la.Start > dt).ToList(); } return(userActivities); } }
//public static List<LADLL.QuerylearningActivity> GetlearningActivityByUserAndDuration(long userId, DateTime startDate, DateTime endDate) //{ // using (var db = new LAActivityEntities()) // { // List<QuerylearningActivity> userActivities = db.QuerylearningActivity.ToList();//获取所有用户所有活动 // if (userId == 0) // { // userActivities = userActivities.Where(ua => ua.开始时间 >= startDate && ua.开始时间<endDate).ToList(); // } // else // { // userActivities = userActivities.Where(ua => ua.UserID == userId && ua.开始时间 >= startDate && ua.开始时间 < endDate).ToList(); // } // return userActivities; // } //} /// <summary> /// 筛选用户的活动,若指定用户ID(userId!=0),则筛选该用户的活动,若指定日期(dateString!=""),则筛选该日的活动 /// </summary> /// <param name="userId">指定用户ID</param> /// <param name="dateString">指定日期</param> /// <returns></returns> public static List <LADLL.QuerylearningActivity> GetLAbyUserIdandDay(long userId, string dateString) { List <QuerylearningActivity> userActivities = GetAllLA(); using (var db = new LAActivityEntities()) { // List<QuerylearningActivity> userActivities = db.QuerylearningActivity.ToList();//获取所有用户所有活动 if (dateString != "")//指定了活动开始日期 { userActivities = userActivities.Where(ua => ua.开始日期 == dateString).ToList(); } if (userId != 0)//指定了用户ID { userActivities = userActivities.Where(ua => ua.UserID == userId).ToList(); } return(userActivities); } }
/// <summary> /// 更新指定ID的活动记录 /// </summary> /// <param name="laid">指定活动ID</param> /// <param name="aTypeId">活动类型ID</param> /// <param name="objectId">学习对象ID</param> /// <param name="locationId">活动地点ID</param> /// <param name="startDateTime">起始时间</param> /// <param name="durings">持续时长</param> /// <param name="worksUrl">作品Url</param> /// <param name="others">活动描述</param> public static void UpdateLearningActivity(long laid, long aTypeId, long objectId, long locationId, DateTime startDateTime, int durings, string worksUrl, string others) { var db = new LAActivityEntities(); var result = from la in db.LearningActivity where la.LearningActivityID == laid select la; var target = result.FirstOrDefault <LADLL.LearningActivity>(); if (target != null) { target.ActivityTypeID = aTypeId; target.LearningObjectID = objectId; target.LocationID = locationId; target.Start = startDateTime; target.During = durings; target.WorksUrl = worksUrl; target.Others = others; target.ModifyDate = DateTime.Now; } db.SaveChanges(); }
/// <summary> /// 获取指定ID的学习对象 /// </summary> /// <param name="loId">学习对象ID</param> /// <returns>生成对象详情表</returns> public static string GetLObjectById(long loId) { string strContent = "<table>"; var db = new LAActivityEntities(); LearningObject lObjects = db.LearningObject.FirstOrDefault(lo => lo.LearningObjectID == loId); if (lObjects != null) { strContent += "<tr>"; strContent += "<td>对象名称:</td><td>" + lObjects.Title + "</td>"; strContent += "</tr><tr>"; strContent += "<td>创建时间:</td><td>" + lObjects.CreatedDate + "</td>"; strContent += "</tr><tr>"; strContent += "<td>对象描述:</td><td>" + lObjects.Description + "</td>"; //strContent += "</tr><tr>"; //strContent += "<td>学习内容:</td><td>" + lObjects.LearningContent + "</td>"; strContent += "</tr>"; } strContent += "</table>"; return(strContent); }
protected void btnSubmit_OnClick(object sender, EventArgs e) { long userId = DAL.UserDAL.GetUserId();//获取当前用户ID if (userId == 0) { DAL.Common.Alert("请先登录网站才能记录活动!"); Response.Redirect("../Authenticate.aspx");//专项登录页面 return; } LADLL.LAActivityEntities vaCtx = new LAActivityEntities(); LADLL.LearningActivity la = new LADLL.LearningActivity(); la.UserID = UserDAL.GetUserId(); la.ActivityTypeID = int.Parse(thisTypeID.Value); la.LearningObjectID = int.Parse(thisObjID.Value); la.LocationID = int.Parse(thisLocaID.Value); la.Others = tbOthers.Value; la.Start = DTStart.SelectedDate; //la.WorksID = WorksDAL.GetWorksId(wName); vaCtx.LearningActivity.Add(la); vaCtx.SaveChanges(); }
/// <summary> /// 新增学习活动记录 /// </summary> /// <param name="aTypeId">类别ID</param> /// <param name="objectId">学习对象ID</param> /// <param name="durings">持续时长</param> /// <param name="startDateTime">开始时间</param> /// <param name="locationId">学习地点</param> /// <param name="worksUrl">作品URL</param> /// <param name="others">其他描述</param> /// <returns></returns> public static long AddAct(long aTypeId, long objectId, int durings, DateTime startDateTime, long locationId, string worksUrl, string others) { var db = new LAActivityEntities(); var la = new LADLL.LearningActivity { UserID = UserDAL.GetUserId(), ActivityTypeID = aTypeId, LearningObjectID = objectId, Start = startDateTime, During = durings, LocationID = locationId, WorksUrl = worksUrl, Others = others, CreatDate = DateTime.Now, Flag = 1 }; db.LearningActivity.Add(la); db.SaveChanges(); return(la.LearningActivityID); }
public static int GetLACountsbyUserIdandDuration(long userId, DateTime startdate, DateTime enddate) { List <QuerylearningActivity> userActivities = GetAllLA(); using (var db = new LAActivityEntities()) { if (string.Format("{0:yyyy-MM-dd}", startdate) != "")//指定了活动的时间段 { //userActivities = db.QuerylearningActivity.Where(ua => Convert.ToDateTime(ua.开始日期) >= Convert.ToDateTime(StartDate)).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => Convert.ToDateTime(ua.开始日期) <= Convert.ToDateTime(EndDate)).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => DateTime.Compare(Convert.ToDateTime(ua.开始日期), Convert.ToDateTime(StartDate)) >=0 ).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => DateTime.Compare(Convert.ToDateTime(ua.开始日期), Convert.ToDateTime(EndDate)) <= 0).ToList(); userActivities = userActivities.Where(ua => ua.开始时间 >= startdate && ua.开始时间 <= enddate).ToList(); } if (userId != 0)//指定了用户ID { userActivities = userActivities.Where(ua => ua.UserID == userId).ToList(); } return(userActivities.Count); } }
public static int GetLACountsbyUserIdandDate(long userId, string dateString) { List <QuerylearningActivity> userActivities = GetAllLA(); using (var db = new LAActivityEntities()) { // List<QuerylearningActivity> userActivities = db.QuerylearningActivity.ToList();//获取所有用户所有活动 if (dateString != "")//指定了活动的时间段 { //userActivities = db.QuerylearningActivity.Where(ua => Convert.ToDateTime(ua.开始日期) >= Convert.ToDateTime(StartDate)).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => Convert.ToDateTime(ua.开始日期) <= Convert.ToDateTime(EndDate)).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => DateTime.Compare(Convert.ToDateTime(ua.开始日期), Convert.ToDateTime(StartDate)) >=0 ).ToList(); //userActivities = db.QuerylearningActivity.Where(ua => DateTime.Compare(Convert.ToDateTime(ua.开始日期), Convert.ToDateTime(EndDate)) <= 0).ToList(); userActivities = userActivities.Where(ua => ua.开始日期 == dateString).ToList(); } if (userId != 0)//指定了用户ID { userActivities = userActivities.Where(ua => ua.UserID == userId).ToList(); } return(userActivities.Count); } }