/// <summary>
/// 记录成员在项目中的成绩
/// </summary>
/// <param name="mId"></param>
/// <param name="score"></param>
/// <returns></returns>
public static long UpdateMemberScore(long mId, float score)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId);
pm.Score = score;
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 成员退出
/// </summary>
/// <param name="mId"></param>
/// <param name="outReason"></param>
/// <returns></returns>
public static long SetMemberOut(long mId, string outReason)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId);
pm.OutReason = outReason;
pm.ApplyOutTime = DateTime.Now;
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 用户申请加入项目
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static long InsertMember(Proj_Member dr)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pm = new Proj_Member();
pm.UserID = dr.UserID;
pm.ProjectID = dr.ProjectID;
pm.ApplyInTime = dr.ApplyInTime;
pm.Flag = dr.Flag;
db.Proj_Member.Add(pm);
db.SaveChanges();
return(pm.MemberID);
}
}
/// <summary>
/// 添加成员参加项目信息，表Proj_Member
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static long NewProjectMember(Proj_Member dr)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pr = new Proj_Member();
pr.UserID = dr.UserID;
pr.ProjectID = dr.ProjectID;
pr.ApplyInTime = dr.ApplyInTime;
pr.ApplyOutTime = dr.ApplyOutTime;
pr.OutReason = dr.OutReason;
pr.Score = dr.Score;
pr.Flag = dr.Flag;
db.Proj_Member.Add(pr);
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 申请加入项目数据库添加记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnJoinIn_Click(object sender, EventArgs e)
{
string projName = this.lbProjectName.Text;
SPWeb projWeb = SPContext.Current.Web.Webs[projName];
long currentUserId = ProjectDll.BLL.User.GetUserId(SPContext.Current.Web.CurrentUser);
var dr = new Proj_Member
{
UserID = currentUserId,
ProjectID = ProjectId,
ApplyInTime = DateTime.Now,
Score = 0,
Flag = 1
};
ProjectDll.DAL.ProjectDal.NewProjectMember(dr);
Page.RegisterStartupScript("温馨提示", String.Format("<script language=\"javascript\">alert(\"{0}\");window.location.replace(\"{1}\")</script>", "欢迎加入: “" + projName + "”", "MyProjects.aspx"));
}
