/// <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>
/// 新增活动类别
/// </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);
}
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>
/// 更新指定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>
/// 新增学习活动记录
/// </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);
}
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>
/// 获取当前用户ID,如果数据库中没有数据，根据活动目录写入数据库中
/// </summary>
/// <returns>mUser.UserID</returns>
public static long GetUserId()
{
string account = GetAccount();
var db = new LAActivityEntities();//定义数据库连接接口
User mUser = db.User.FirstOrDefault(u => u.Account.Equals(account));
if (mUser != null)
{
return(mUser.UserID);
}
else
{
mUser = new User();
mUser.Account = account;
mUser.Created = DateTime.Now;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
DirectoryEntry adUser = ADHelper.GetDirectoryEntryByAccount(account);
if (adUser != null)
{
mUser.Name = adUser.Properties["displayName"][0].ToString();
if (adUser.Properties.Contains("telephoneNumber"))
{
mUser.Telephone = adUser.Properties["telephoneNumber"][0].ToString();
}
if (adUser.Properties.Contains("mail"))
{
mUser.Email = adUser.Properties["mail"][0].ToString();
}
}
});
db.User.Add(mUser);
db.SaveChanges();
return(mUser.UserID);
}
}
