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