public static string ClearClassMember(string UserGroup_Id)
{
try
{
string strSql = string.Empty;
int inum = 0;
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
inum = bll.ClearUserGroupMember(UserGroup_Id.Filter());
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作成功：清除“" + inum + "”条",
err = "null"
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
msg = "操作成功：清除“" + inum + "”条",
err = "0"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作失败:" + ex.Message.ToString(),
err = "error",
}));
}
}
public static string GetClassMember(string UserGroup_Id, int PageIndex, int PageSize)
{
try
{
UserGroup_Id = UserGroup_Id.Filter();
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
string strSqlCount = string.Empty;
string strWhere = string.Format("User_ApplicationStatus='passed' and UserGroup_Id='{0}'", UserGroup_Id);
string orderBy = string.Format("charindex(MembershipEnum,'{0},{1},{2}'),TrueName,UserStatus,User_ApplicationPassTime desc",
MembershipEnum.headmaster, MembershipEnum.teacher, MembershipEnum.student);
dt = new BLL_UserGroup_Member().GetClassMemberListByPageEX(strWhere, orderBy, ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = new BLL_UserGroup_Member().GetRecordCount(strWhere);
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
Row = dt.Rows[i]["Row"],
UserGroup_Member_Id = dt.Rows[i]["UserGroup_Member_Id"],
UserName = dt.Rows[i]["UserName"],
TrueName = string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["UserName"] : dt.Rows[i]["TrueName"],
User_ApplicationPassTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["User_ApplicationPassTime"].ToString()),
UserStatus = dt.Rows[i]["UserStatus"],
Email = dt.Rows[i]["Email"].ToString(),
MembershipEnum = dt.Rows[i]["MembershipEnum"],
MembershipEnumName = (dt.Rows[i]["MembershipEnum"].ToString() == MembershipEnum.teacher.ToString()) ? dt.Rows[i]["SubjectName"].ToString() + "老师" : Rc.Common.EnumService.GetDescription <MembershipEnum>(dt.Rows[i]["MembershipEnum"].ToString()),
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string GetClassNotice(string UserGroup_Id, int PageIndex, int PageSize)
{
try
{
UserGroup_Id = UserGroup_Id.Filter();
Model_F_User FloginUser = (Model_F_User)HttpContext.Current.Session["FLoginUser"];
bool bool_IsGroupOwner = pfunction.CheckUserIsGroupOwner(UserGroup_Id, FloginUser.UserId);
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
string strSqlCount = string.Empty;
string strWhere = string.Format("User_ApplicationStatus='applied' and UserGroup_Id='{0}'", UserGroup_Id);
dt = new BLL_UserGroup_Member().GetGradeMemberListByPageEX(strWhere, "User_ApplicationTime desc", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = new BLL_UserGroup_Member().GetRecordCount(strWhere);
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
inum = (i + 1),
UserGroup_Member_Id = dt.Rows[i]["UserGroup_Member_Id"],
UserGroup_Id = dt.Rows[i]["User_Id"].ToString(),
UserGroup_Name = dt.Rows[i]["UserGroup_Name"].ToString(),
User_ApplicationReason = dt.Rows[i]["User_ApplicationReason"],
User_ApplicationTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["User_ApplicationTime"].ToString()),
User_ApplicationStatus = dt.Rows[i]["User_ApplicationStatus"],
IType = dt.Rows[i]["IType"],
PostName = dt.Rows[i]["PostName"],
IsGroupOwner = bool_IsGroupOwner
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string GetTeacherList(string UserName, string UserIdentity)
{
try
{
UserName = UserName.Filter();
UserIdentity = UserIdentity.Filter();
string strWhere = string.Format("User_ApplicationStatus='passed' and UserStatus=0 and UserGroup_Id='{0}' ", ugroupId);
if (!string.IsNullOrEmpty(UserName))
{
strWhere += string.Format(" and (UserName like '%{0}%' or TrueName like '%{0}%') ", UserName);
}
if (!string.IsNullOrEmpty(UserIdentity))
{
strWhere += string.Format(" and MembershipEnum = '{0}' ", UserIdentity);
}
List <object> listReturn = new List <object>();
string orderBy = string.Format("charindex(MembershipEnum,'{0},{1},{2}'),UserStatus,User_ApplicationPassTime desc",
MembershipEnum.headmaster, MembershipEnum.teacher, MembershipEnum.student);
DataTable dt = new BLL_UserGroup_Member().GetClassMemberList(strWhere, orderBy).Tables[0];
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
UserGroup_Id = dt.Rows[i]["UserGroup_Id"],
UserName = string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["UserName"].ToString() : dt.Rows[i]["TrueName"].ToString(),
LoginName = dt.Rows[i]["UserName"].ToString(),
MembershipEnumText = Rc.Common.EnumService.GetDescription <MembershipEnum>(dt.Rows[i]["MembershipEnum"].ToString()),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
User_ApplicationPassTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["User_ApplicationPassTime"].ToString())
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string DeleteClass(string UserGroup_Id)
{
try
{
string strSql = string.Empty;
int inum = 0;
BLL_UserGroup_Member bllUGM = new BLL_UserGroup_Member();
BLL_UserGroup bllUG = new BLL_UserGroup();
//string strWhere = string.Empty;
//strWhere += string.Format(" where UserGroup_Id='{0}'", UserGroup_Id.Filter());
//inum = bllUGM.ClearUserGroupMember(strWhere);//暂时没使用事物
//strWhere = string.Format(" where User_Id='{0}'", UserGroup_Id.Filter());
//bllUGM.ClearUserGroupMember(strWhere);//暂时没使用事物
if (new BLL_UserGroup_Member().GetRecordCount("UserGroup_Id='" + UserGroup_Id + "'") > 0)
{
return(JsonConvert.SerializeObject(new
{
msg = "存在下级数据，不允许删除",
err = "error"
}));
}
else
{
if (new BLL_UserGroup_Member().ClearUserGroup(UserGroup_Id.Filter()) > 0)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作成功",
err = "null"
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
msg = "操作失败",
err = "0"
}));
}
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作失败:" + ex.Message.ToString(),
err = "error",
}));
}
}
public static string ClearSchoolMember(string UserGroup_Id)
{
UserGroup_Id = UserGroup_Id.Filter();
try
{
string strSql = string.Empty;
strSql = "select count(1) from UserGroup_Member where UserGroup_Id in(select USER_ID from UserGroup_Member where UserGroup_Id='" + UserGroup_Id + "' and MembershipEnum='grade')";
if (Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSql).ToString() != "0")
{
return(JsonConvert.SerializeObject(new
{
msg = "操作失败：年级下存在数据，清空失败",
err = "error"
}));
}
else
{
int inum = 0;
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
inum = bll.ClearUserGroupMember(UserGroup_Id.Filter());
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作成功：清除“" + inum + "”条",
err = "null"
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
msg = "操作成功：清除“" + inum + "”条",
err = "0"
}));
}
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
msg = "操作失败:" + ex.Message.ToString(),
err = "error"
}));
}
}
public static string DelClassMember(string UserGroup_Member_Id, string UserId, string UserGroup_Id)
{
try
{
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
if (new BLL_Student_HomeWork().GetRecordCount("Student_Id='" + UserId + "' and HomeWork_Id in(select HomeWork_Id from HomeWork where UserGroup_Id='" + UserGroup_Id + "')") > 0)
{
return("2");//成员已布置作业
}
else
{
Model_F_User modelFUser = (Model_F_User)HttpContext.Current.Session["FLoginUser"];
string userId = modelFUser.UserId;
Model_UserGroup_Member model = bll.GetModel(UserGroup_Member_Id);
model.UserStatus = 1;
Model_Msg modelMsg = new Model_Msg();
modelMsg.MsgId = Guid.NewGuid().ToString();
modelMsg.MsgEnum = MsgEnum.QuitClass.ToString();
modelMsg.MsgTypeEnum = MsgTypeEumn.Private.ToString();
modelMsg.ResourceDataId = model.UserGroup_Id;
modelMsg.MsgTitle = string.Format("您被退班{0}", model.UserGroup_Id);
modelMsg.MsgContent = string.Format("您被退班{0}", model.UserGroup_Id);
modelMsg.MsgStatus = MsgStatus.Unread.ToString();
modelMsg.MsgSender = userId;
modelMsg.MsgAccepter = model.User_ID;
modelMsg.CreateTime = DateTime.Now;
modelMsg.CreateUser = userId;
if (bll.TeacherRemoveStudent(model, modelMsg))
{
return("1");
}
else
{
return("0");
}
}
}
catch (Exception)
{
return("0");
}
}
public static string GetGroupMember(string GroupId)
{
try
{
GroupId = GroupId.Filter();
List <object> listReturn = new List <object>();
string strWhere = string.Empty;
strWhere += string.Format(" UserStatus='0' and User_ApplicationStatus='passed' and MembershipEnum='{0}' and UserGroup_Id='{1}' ", Rc.Model.Resources.MembershipEnum.student, GroupId);
int inum = 0;
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
DataTable dt = bll.GetClassMemberListByPageEX(strWhere, "TrueName,UserName", 1, 200).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
UserId = dt.Rows[i]["User_Id"],
UserName = string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["UserName"].ToString() : dt.Rows[i]["TrueName"].ToString()
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string DelClassMember(string UserGroup_Member_Id, string UserId)
{
try
{
Model_F_User modelFUser = (Model_F_User)HttpContext.Current.Session["FLoginUser"];
string userId = modelFUser.UserId;
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
Model_UserGroup_Member model = bll.GetModel(UserGroup_Member_Id);
model.UserStatus = 1;
Model_Msg modelMsg = new Model_Msg();
modelMsg.MsgId = Guid.NewGuid().ToString();
modelMsg.MsgEnum = MsgEnum.QuitSchool.ToString();
modelMsg.MsgTypeEnum = MsgTypeEumn.Private.ToString();
modelMsg.ResourceDataId = model.UserGroup_Id;
modelMsg.MsgTitle = string.Format("您被移除学校{0}", model.UserGroup_Id);
modelMsg.MsgContent = string.Format("您被移除学校{0}", model.UserGroup_Id);
modelMsg.MsgStatus = MsgStatus.Unread.ToString();
modelMsg.MsgSender = userId;
modelMsg.MsgAccepter = model.CreateUser;
modelMsg.CreateTime = DateTime.Now;
modelMsg.CreateUser = userId;
if (bll.TeacherRemoveStudent(model, modelMsg))
{
return("1");
}
else
{
return("0");
}
}
catch (Exception)
{
return("0");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Model_UserGroup_Member model = new Model_UserGroup_Member();
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
string userGroupId = txtUserGroup_Id.Text.Trim().Filter();
if (new BLL_UserGroup().GetRecordCount("UserGroup_Id='" + userGroupId + "' and UserGroup_AttrEnum='" + UserGroup_AttrEnum.School.ToString() + "' ") == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('学校号" + userGroupId + "不存在',{icon:2,time:2000});", true);
return;
}
List <Model_UserGroup_Member> listModelUGM = bll.GetModelList(string.Format("User_ID='{0}' and UserGroup_Id='{1}'", FloginUser.UserId, userGroupId));
bool isExistData = false;//是否已存在成员数据
if (listModelUGM.Count != 0)
{
isExistData = true;
model = listModelUGM[0];
if (model.User_ApplicationStatus == "applied")
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('已经申请加入学校" + userGroupId + "，正在等待审核',{icon:2,time:2000});", true);
return;
}
if (model.User_ApplicationStatus == "passed" && model.UserStatus == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('已经加入学校" + userGroupId + "，请更换学校号重新操作',{icon:2,time:2000});", true);
return;
}
else if (model.User_ApplicationStatus == "passed" && model.UserStatus == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('不可加入此学校(退出)，请联系您的校长',{icon:2,time:2000});", true);
return;
}
}
if (!isExistData)
{
model.UserGroup_Member_Id = Guid.NewGuid().ToString();
}
model.UserGroup_Id = userGroupId;
model.User_ID = FloginUser.UserId;
model.User_ApplicationStatus = "applied";
model.User_ApplicationTime = DateTime.Now;
model.User_ApplicationReason = txtUser_ApplicationReason.Text.Trim().Filter();
string strMembershipEnum = string.Empty;
switch (FloginUser.UserPost)
{
case "32514c70-d669-4c9f-b487-f19fea569ff0":
strMembershipEnum = MembershipEnum.principal.ToString();
break;
case "d022a507-bea8-4cfe-9d8d-80e7fcea88b9":
strMembershipEnum = MembershipEnum.vice_principal.ToString();
break;
case "a96fc2c4-09fc-4b5e-ac10-b22c925aa45e":
strMembershipEnum = MembershipEnum.Dean.ToString();
break;
case "851D680A-930A-47DB-85DD-76D6AEEAB5AA":
strMembershipEnum = MembershipEnum.TeachingLeader.ToString();
break;
}
model.MembershipEnum = strMembershipEnum;
model.CreateUser = FloginUser.UserId;
bool flag = false;
if (isExistData)
{
flag = bll.Update(model);
}
else
{
flag = bll.Add(model);
}
if (flag)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('申请成功',{icon:1,time:1000},function(){parent.loadData();parent.layer.closeAll();})</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('申请失败',{icon:2,time:2000})</script>");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('操作失败',{icon:2,time:2000})</script>");
}
}
public static string GetGradeList(string ClassName)
{
try
{
ClassName = ClassName.Filter();
string strWhere = string.Format("User_ApplicationStatus='passed' and UserStatus=0 and UserGroup_Id='{0}' ", ugroupId);
if (!string.IsNullOrEmpty(ClassName))
{
strWhere += string.Format(" and UserGroup_Name like '%{0}%' ", ClassName);
}
string orderBy = string.Format("charindex(MembershipEnum,'{0},{1},{2}'),UserStatus,UserGroupOrder,User_ApplicationPassTime desc"
, MembershipEnum.gradedirector, MembershipEnum.GroupLeader, MembershipEnum.classrc);
List <object> listReturn = new List <object>();
DataTable dt = new BLL_UserGroup_Member().GetGradeMemberListByPageEX(strWhere, orderBy, 1, 60).Tables[0];
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
string strTeacherCount = dt.Rows[i]["TeacherCount"].ToString();
string strStudentCount = dt.Rows[i]["StudentCount"].ToString();
if (strTeacherCount == "0")
{
strTeacherCount = "-";
}
if (strStudentCount == "0")
{
strStudentCount = "-";
}
listReturn.Add(new
{
Row = dt.Rows[i]["Row"],
UserGroup_Id = dt.Rows[i]["User_Id"],
UserGroup_Name = dt.Rows[i]["UserGroup_Name"],
PostName = dt.Rows[i]["PostName"],
MembershipEnum = dt.Rows[i]["MembershipEnum"],
TeacherCount = strTeacherCount,
StudentCount = strStudentCount
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Model_UserGroup_Member model = new Model_UserGroup_Member();
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
string userGroupId = txtUserGroup_Id.Text.Trim().Filter();
if (new BLL_UserGroup().GetRecordCount("UserGroup_Id='" + userGroupId + "' and UserGroup_AttrEnum='" + UserGroup_AttrEnum.School.ToString() + "' ") == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.ready(function(){layer.msg('学校号不存在',{icon:2,time:2000,offset:'10px'})});", true);
return;
}
List <Model_UserGroup_Member> listModelUGM = bll.GetModelList(string.Format("User_ID='{0}' and UserGroup_Id='{1}'", reqGroupId, userGroupId));
bool isExistData = false;//是否已存在成员数据
if (listModelUGM.Count != 0)
{
isExistData = true;
model = listModelUGM[0];
if (model.User_ApplicationStatus == "applied")
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.ready(function(){layer.msg('您已申请加入此学校，请等待审核',{icon:2,time:2000,offset:'10px'})});", true);
return;
}
if (model.User_ApplicationStatus == "passed" && model.UserStatus == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.ready(function(){layer.msg('您已加入此学校，请更换学校号重新操作',{icon:2,time:2000,offset:'10px'})});", true);
return;
}
else if (model.User_ApplicationStatus == "passed" && model.UserStatus == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.ready(function(){layer.msg('不可加入此学校(退出)，请联系您的老师',{icon:2,time:2000,offset:'10px'})});", true);
return;
}
}
if (!isExistData)
{
model.UserGroup_Member_Id = Guid.NewGuid().ToString();
}
model.UserGroup_Id = userGroupId;
model.User_ID = reqGroupId;
model.User_ApplicationStatus = "applied";
model.User_ApplicationTime = DateTime.Now;
model.User_ApplicationReason = txtUser_ApplicationReason.Text.Trim().Filter();
model.MembershipEnum = MembershipEnum.grade.ToString();
model.CreateUser = FloginUser.UserId;
bool flag = false;
if (isExistData)
{
flag = bll.Update(model);
}
else
{
flag = bll.Add(model);
}
if (flag)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('申请成功',{icon:1,time:1000,offset:'10px'},function(){parent.location.reload();parent.layer.closeAll();})})</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('申请失败',{icon:2,time:2000,offset:'10px'})})</script>");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('操作失败',{icon:2,time:2000,offset:'10px'})})</script>");
}
}
public static string GetDataList(string UserGroup_ParentId, string GradeId, string GroupName, int PageSize, int PageIndex)
{
try
{
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
UserGroup_ParentId = UserGroup_ParentId.Filter();
GradeId = GradeId.Filter();
GroupName = GroupName.Filter();
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
string strWhere = " User_ApplicationStatus='passed' ";
if (!string.IsNullOrEmpty(UserGroup_ParentId))
{
strWhere += " and UserGroup_Id='" + UserGroup_ParentId + "' ";
}
if (!string.IsNullOrEmpty(GradeId))
{
strWhere += " and UserGroup_Id='" + GradeId + "' ";
}
if (!string.IsNullOrEmpty(GroupName))
{
strWhere += " and ClassName like '%" + GroupName + "%' ";
}
string orderBy = string.Format("charindex(MembershipEnum,'{0},{1},{2}'),ClassName,UserStatus,User_ApplicationPassTime desc"
, MembershipEnum.gradedirector, MembershipEnum.GroupLeader, MembershipEnum.classrc);
dt = bll.GetGradeMemberListByPageForSys(strWhere, orderBy, ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = bll.GetGradeMemberRecordCountForSys(strWhere);
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
string userName = dt.Rows[i]["ClassName"].ToString();
if (string.IsNullOrEmpty(userName))
{
userName = dt.Rows[i]["UserName"].ToString();
}
if (dt.Rows[i]["MembershipEnum"].ToString() != MembershipEnum.classrc.ToString())
{
userName += "(" + dt.Rows[i]["UserName"].ToString() + ")";
}
inum++;
string strMemberCount = dt.Rows[i]["MemberCount"].ToString();
if (strMemberCount == "0")
{
strMemberCount = "-";
}
listReturn.Add(new
{
inum = (i + 1),
ParentUserGroup_Name = dt.Rows[i]["ParentUserGroup_Name"].ToString(),
UserGroup_Id = dt.Rows[i]["User_Id"].ToString(),
UserGroup_Name = userName,
ClassUser = dt.Rows[i]["ClassUser"].ToString(),
UserGroup_BriefIntroduction = dt.Rows[i]["UserGroup_BriefIntroduction"].ToString(),
ClassCreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["ClassCreateTime"].ToString()),
GroupMemberCount = strMemberCount,
MembershipEnum = dt.Rows[i]["MembershipEnum"],
PostName = dt.Rows[i]["PostName"]
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string AuditApplyData(string UserGroup_Member_Id, string AType)
{
try
{
Model_F_User modelFUser = (Model_F_User)HttpContext.Current.Session["FLoginUser"];
string userId = modelFUser.UserId;
bool flag = false;
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
string[] strArrMember = UserGroup_Member_Id.Split(',');
List <Model_UserGroup_Member> listMember = new List <Model_UserGroup_Member>();
List <Model_Msg> listMsg = new List <Model_Msg>();
for (int i = 0; i < strArrMember.Length; i++)
{
string strTips = "被拒绝";
Model_UserGroup_Member model = bll.GetModel(strArrMember[i]);
if (AType == "1")//通过
{
strTips = "已通过";
#region 成员表
model.User_ApplicationStatus = "passed";
model.User_ApplicationPassTime = DateTime.Now;
model.UserStatus = 0;
listMember.Add(model);
#endregion
}
#region 消息表
Model_Msg modelMsg = new Model_Msg();
modelMsg.MsgId = Guid.NewGuid().ToString();
modelMsg.MsgEnum = MsgEnum.ApplyToClass.ToString();
modelMsg.MsgTypeEnum = MsgTypeEumn.Private.ToString();
modelMsg.ResourceDataId = model.UserGroup_Id;
modelMsg.MsgTitle = string.Format("申请加入年级{0}{1}", model.UserGroup_Id, strTips);
modelMsg.MsgContent = string.Format("申请加入年级{0}{1}", model.UserGroup_Id, strTips);
modelMsg.MsgStatus = MsgStatus.Unread.ToString();
modelMsg.MsgSender = userId;
modelMsg.MsgAccepter = model.User_ID;
if (model.MembershipEnum == MembershipEnum.classrc.ToString())
{
modelMsg.MsgAccepter = model.CreateUser;
}
modelMsg.CreateTime = DateTime.Now;
modelMsg.CreateUser = userId;
listMsg.Add(modelMsg);
#endregion
}
if (AType == "1")
{
flag = bll.AgreeMemberJoinGroup(listMember, listMsg);
}
else
{
UserGroup_Member_Id = "'" + UserGroup_Member_Id.Replace(",", "','") + "'";
flag = bll.RefuseMemberJoinGroup(UserGroup_Member_Id, listMsg);
}
if (flag)
{
return("1");
}
else
{
return("0");
}
}
catch (Exception)
{
return("0");
}
}
public static string loginIndex(string UserId, string UserPost, string Subject, string ClassId, string type)
{
string strJson = string.Empty;
string iurl = string.Empty;
try
{
HttpContext.Current.Session["UserPublicUrl"] = null;
UserId = UserId.Filter();
UserPost = UserPost.Filter();
Subject = Subject.Filter();
ClassId = ClassId.Filter();
type = type.Filter();
Model_F_User model = new BLL_F_User().GetModel(UserId);
bool flag = true;
if (model != null)
{
model.UserIdentity = type;
if (!string.IsNullOrEmpty(UserPost) && UserPost != "-1")
{
model.UserPost = UserPost;
}
if (!string.IsNullOrEmpty(Subject) && Subject != "-1")
{
model.Subject = Subject;
}
flag = new BLL_F_User().Update(model);
if (flag == false)
{
strJson = JsonConvert.SerializeObject(new
{
err = "操作失败请重试",
iurl = ""
});
return(strJson);
}
if (type == "T") //年级主任，年级组长
{
if (!string.IsNullOrEmpty(ClassId) && ClassId != "-1" && !string.IsNullOrEmpty(Subject) && Subject != "-1") //加入年级
{
#region 加入班级
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
List <Model_UserGroup_Member> listModelUGM = bll.GetModelList(string.Format("User_ID='{0}' and UserGroup_Id='{1}'", UserId, ClassId));
bool isExistDataClass = false;//是否已存在成员数据
if (listModelUGM.Count != 0)
{
isExistDataClass = true;
}
Model_UserGroup_Member UserGroup_Member_Class = new Model_UserGroup_Member();
UserGroup_Member_Class.UserGroup_Member_Id = Guid.NewGuid().ToString();
UserGroup_Member_Class.UserGroup_Id = ClassId;
UserGroup_Member_Class.User_ID = UserId;
UserGroup_Member_Class.User_ApplicationStatus = "passed";
UserGroup_Member_Class.UserStatus = 0;
UserGroup_Member_Class.User_ApplicationTime = DateTime.Now;
UserGroup_Member_Class.User_ApplicationReason = "完善信息-加入班级";
UserGroup_Member_Class.MembershipEnum = MembershipEnum.teacher.ToString();
UserGroup_Member_Class.CreateUser = UserId;
UserGroup_Member_Class.User_ApplicationPassTime = DateTime.Now;
if (isExistDataClass == false)
{
flag = bll.Add(UserGroup_Member_Class);
if (flag == false)
{
strJson = JsonConvert.SerializeObject(new
{
err = "操作失败请重试",
iurl = ""
});
return(strJson);
}
}
#endregion
}
}
else
{
if (!string.IsNullOrEmpty(ClassId) && ClassId != "-1")
{
#region 加入班级
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
List <Model_UserGroup_Member> listModelUGM = bll.GetModelList(string.Format("User_ID='{0}' and UserGroup_Id='{1}'", UserId, ClassId));
bool isExistDataClass = false;//是否已存在成员数据
if (listModelUGM.Count != 0)
{
isExistDataClass = true;
}
Model_UserGroup_Member UserGroup_Member_Class = new Model_UserGroup_Member();
UserGroup_Member_Class.UserGroup_Member_Id = Guid.NewGuid().ToString();
UserGroup_Member_Class.UserGroup_Id = ClassId;
UserGroup_Member_Class.User_ID = UserId;
UserGroup_Member_Class.User_ApplicationStatus = "passed";
UserGroup_Member_Class.UserStatus = 0;
UserGroup_Member_Class.User_ApplicationTime = DateTime.Now;
UserGroup_Member_Class.User_ApplicationReason = "完善信息-加入班级";
UserGroup_Member_Class.MembershipEnum = MembershipEnum.student.ToString();
UserGroup_Member_Class.CreateUser = UserId;
UserGroup_Member_Class.User_ApplicationPassTime = DateTime.Now;
if (isExistDataClass == false)
{
flag = bll.Add(UserGroup_Member_Class);
if (flag == false)
{
strJson = JsonConvert.SerializeObject(new
{
err = "操作失败请重试",
iurl = ""
});
return(strJson);
}
}
#endregion
}
}
#region 登录
HttpContext.Current.Session["FLoginUser"] = model;
if (type == "T")
{
//是否带班
int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
{
iurl = "/teacher/cTeachPlan.aspx";
}
else
{
iurl = "/teacher/basicSetting.aspx";
}
}
else if (type == "S")
{
iurl = "/student/oHomework.aspx";
}
#endregion
string local_url = string.Empty; // 局域网地址
#region 学校配置URL
DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(UserId).Tables[0];
if (dtUrl.Rows.Count > 0)
{
HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
}
#endregion
string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
, HttpContext.Current.Server.UrlEncode(iurl)
, HttpContext.Current.Server.UrlEncode(local_url));
if (dtUrl.Rows.Count > 0) // 有局域网配置数据，验证是否局域网
{
iurl = rurl;
}
strJson = JsonConvert.SerializeObject(new
{
err = "null",
iurl = iurl
});
}
else
{
HttpContext.Current.Session.Clear();
strJson = JsonConvert.SerializeObject(new
{
err = "用户密码错误，请重新登录。",
iurl = ""
});
}
}
catch (Exception)
{
strJson = JsonConvert.SerializeObject(new
{
err = "null",
iurl = "/ErrorPageF.aspx?errorType=6"
});
}
return(strJson);
}
protected void Page_Load(object sender, EventArgs e)
{
string strTemp = string.Empty;
string strS = string.Empty;
if (!String.IsNullOrEmpty(Request["s"]))
{
strS = Request["s"].ToString();
}
strTemp += "";
//if (Request["psdTips"].Filter() == "1")
//{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.confirm('密码过于简单，请修改密码！', {icon:4}, function () { window.location.href = '/teacher/safeSetting.aspx'; });});</script>");
//}
Model_F_User modelFUser = (Model_F_User)Session["FLoginUser"];
if (modelFUser != null)
{
BLL_UserGroup_Member bllUGM = new BLL_UserGroup_Member();
string strUserName = string.IsNullOrEmpty(modelFUser.TrueName) ? modelFUser.UserName : modelFUser.TrueName;
//int classMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where User_ApplicationStatus='passed' and UserStatus='0' and User_Id='" + modelFUser.UserId + "')");
int classMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Class
+ "' and User_Id='" + modelFUser.UserId + "')");
//是否有学科
bool HasSubject = (!string.IsNullOrEmpty(modelFUser.Subject.Trim()) && modelFUser.Subject.Trim() != "-1");
//是否带班
int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + modelFUser.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
if (pfunction.GetWebMdlIsShow("FAQ"))
{
ahelp.Visible = true;
}
switch (modelFUser.UserPost)
{
#region 校长/副校长/教务主任
case UserPost.校长: //"我是校长：" +
int SchoolMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.School
+ "' and User_Id='" + modelFUser.UserId + "')");
int GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
int MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (classCount > 0)
{
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
}
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += "<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>学校管理 <span class='caret'></span></a>";
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href=\"/teacher/SchoolList.aspx\">学校{0}</a></li>"
, (SchoolMesCount > 0) ? "<span class='badge'>" + SchoolMesCount + "</span>" : "");
listLi += string.Format("<li><a href=\"/teacher/GradeList.aspx\">年级{0}</a></li>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
case UserPost.副校长: //"我是副校长：" +
SchoolMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.School
+ "' and User_Id='" + modelFUser.UserId + "')");
GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (classCount > 0)
{
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
}
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += "<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>学校管理 <span class='caret'></span></a>";
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href=\"/teacher/SchoolList.aspx\">学校{0}</a></li>"
, (SchoolMesCount > 0) ? "<span class='badge'>" + SchoolMesCount + "</span>" : "");
listLi += string.Format("<li><a href=\"/teacher/GradeList.aspx\">年级{0}</a></li>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
case UserPost.教务主任: //"我是教务主任：" +
SchoolMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.School
+ "' and User_Id='" + modelFUser.UserId + "')");
GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (classCount > 0)
{
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
}
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += "<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>学校管理 <span class='caret'></span></a>";
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href=\"/teacher/SchoolList.aspx\">学校{0}</a></li>"
, (SchoolMesCount > 0) ? "<span class='badge'>" + SchoolMesCount + "</span>" : "");
listLi += string.Format("<li><a href=\"/teacher/GradeList.aspx\">年级{0}</a></li>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
case UserPost.教研组长: //"我是教研组长：" +
SchoolMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.School
+ "' and User_Id='" + modelFUser.UserId + "')");
GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (classCount > 0)
{
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
}
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += string.Format("<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>学校管理 <span class='caret'></span>{0}</a>"
, (SchoolMesCount > 0) ? "<span class='badge'>" + SchoolMesCount + "</span>" : "");
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href=\"/teacher/GradeList.aspx\">学校{0}</a></li>"
, (SchoolMesCount > 0) ? "<span class='badge'>" + SchoolMesCount + "</span>" : "");
listLi += string.Format("<li><a href=\"/teacher/GradeList.aspx\">年级{0}</a></li>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
#endregion
#region 年级组长/备课组长
case UserPost.年级组长: //"我是年级组长：" +
GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (classCount > 0)
{
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
}
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += "<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>年级管理 <span class='caret'></span></a>";
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href='/teacher/GradeList.aspx'>年级{0}</a>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
case UserPost.备课组长: //"我是备课组长：" +
GradeMesCount = new BLL_UserGroup_Member().GetRecordCount("User_ApplicationStatus='applied' and UserGroup_Id in(select UserGroup_Id from UserGroup where UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade
+ "' and User_Id='" + modelFUser.UserId + "')");
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Principal/AnalysisGradeList.aspx\">数据分析</a></li>";
if (HasSubject && classCount > 0)
{
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
}
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += "<li class='dropdown'><a href='javascript:;' data-toggle='dropdown'>年级管理 <span class='caret'></span></a>";
listLi += "<ul class='dropdown-menu'>";
listLi += string.Format("<li><a href='/teacher/GradeList.aspx'>年级{0}</a>"
, (GradeMesCount > 0) ? "<span class='badge'>" + GradeMesCount + "</span>" : "");
if (HasSubject || classCount > 0)
{
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
}
listLi += "</ul>";
listLi += "</li>";
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
#endregion
#region 普通老师
case UserPost.普通老师: //"我是普通老师：" +
MesCount = new BLL_Msg().GetRecordCount("MsgStatus='Unread' and MsgAccepter='" + modelFUser.UserId + "'");
ltlUserPost.Text = "<a href='javascript:;' data-toggle='dropdown'><i class='material-icons'></i> " + strUserName + " 老师</a>";
if (pfunction.GetWebMdlIsShow("cTeachPlan"))
{
listLi += "<li><a href=\"/teacher/cTeachPlan.aspx\">我的教案</a></li>";
}
listLi += "<li><a href=\"/teacher/cHomework.aspx\">布置作业</a></li>";
listLi += "<li><a href=\"/teacher/cCorrectHomework.aspx\">批改作业</a></li>";
if (pfunction.GetWebMdlIsShow("CollectiveLessonPreparation"))
{
listLi += "<li><a href=\"/teacher/CollectiveLessonPreparation.aspx\">集体备课</a></li>";
}
listLi += "<li><a href=\"/Evaluation/EachHWAnalysis.aspx\">数据分析</a></li>";
listLi += "<li><a href=\"/teacher/Comment.aspx\">讲评</a></li>";
listLi += "<li><a href=\"/teacher/allTeachingPlan.aspx\">购买教案/习题</a></li>";
listLi += string.Format("<li><a href=\"/teacher/classList.aspx\">班级管理{0}</a></li>"
, (classMesCount > 0) ? "<span class='badge'>" + classMesCount + "</span>" : "");
listLi += string.Format("<li><a href=\"/teacher/Message.aspx\">消息{0}</a></li>"
, (MesCount > 0) ? "<span class='badge'>" + MesCount + "</span>" : "");
//if (pfunction.GetWebMdlIsShow("FAQ")) listLi += " <li><a href=\"../Help/FAQ.aspx\" target=\"_blank\">帮助</a></li>";
break;
#endregion
}
}
}
public static string GetMember(string UserGroup_Id, int PageSize, int PageIndex)
{
try
{
UserGroup_Id = UserGroup_Id.Filter();
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
string strSqlCount = string.Empty;
string strWhere = string.Format("User_ApplicationStatus='passed' and UserGroup_Id='{0}'", UserGroup_Id);
string orderBy = string.Format("charindex(MembershipEnum,'{0},{1},{2},{3},{4}'),UserStatus,UserGroupOrder,User_ApplicationPassTime desc"
, MembershipEnum.principal, MembershipEnum.vice_principal
, MembershipEnum.Dean, MembershipEnum.TeachingLeader, MembershipEnum.grade);
dt = new BLL_UserGroup_Member().GetSchoolMemberListByPageEX(strWhere, orderBy, ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = new BLL_UserGroup_Member().GetRecordCount(strWhere);
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
Row = dt.Rows[i]["Row"],
UserGroup_Id = dt.Rows[i]["User_Id"],
UserGroup_Name = dt.Rows[i]["UserGroup_Name"],
MembershipEnum = dt.Rows[i]["MembershipEnum"],
UserGroup_Member_Id = dt.Rows[i]["UserGroup_Member_Id"],
User_ApplicationPassTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["User_ApplicationPassTime"].ToString()),
UserStatus = dt.Rows[i]["UserStatus"].ToString(),
ClassCount = dt.Rows[i]["MembershipEnum"].ToString() == MembershipEnum.grade.ToString() ? dt.Rows[i]["ClassCount"].ToString() : "-",
TeacherCount = dt.Rows[i]["MembershipEnum"].ToString() == MembershipEnum.grade.ToString() ? dt.Rows[i]["TeacherCount"].ToString() : "-",
StudentCount = dt.Rows[i]["MembershipEnum"].ToString() == MembershipEnum.grade.ToString() ? dt.Rows[i]["StudentCount"].ToString() : "-",
IType = dt.Rows[i]["IType"],
PostName = dt.Rows[i]["PostName"],
IsGroupOwner = bool_IsGroupOwner,
UserName = dt.Rows[i]["UserName"]
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Model_UserGroup_Member model = new Model_UserGroup_Member();
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
string userGroupId = txtUserGroup_Id.Text.Trim().Filter();
if (new BLL_UserGroup().GetRecordCount("UserGroup_Id='" + userGroupId + "' and UserGroup_AttrEnum='" + UserGroup_AttrEnum.Grade.ToString() + "' ") == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('年级号" + userGroupId + "不存在',{icon:2,time:2000});", true);
return;
}
List <Model_UserGroup_Member> listModelUGM = bll.GetModelList(string.Format("User_ID='{0}' and UserGroup_Id='{1}'", FloginUser.UserId, userGroupId));
bool isExistData = false;//是否已存在成员数据
if (listModelUGM.Count != 0)
{
isExistData = true;
model = listModelUGM[0];
if (model.User_ApplicationStatus == "applied")
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('已经申请加入年级" + userGroupId + "，正在等待审核',{icon:2,time:2000});", true);
return;
}
if (model.User_ApplicationStatus == "passed" && model.UserStatus == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('已经加入年级" + userGroupId + "，请更换年级号重新操作',{icon:2,time:2000});", true);
return;
}
else if (model.User_ApplicationStatus == "passed" && model.UserStatus == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "layer.msg('不可加入此年级(退出)，请联系您的年级组长',{icon:2,time:2000});", true);
return;
}
}
if (!isExistData)
{
model.UserGroup_Member_Id = Guid.NewGuid().ToString();
}
model.UserGroup_Id = userGroupId;
model.User_ID = FloginUser.UserId;
model.User_ApplicationStatus = "applied";
model.User_ApplicationTime = DateTime.Now;
model.User_ApplicationReason = txtUser_ApplicationReason.Text.Trim().Filter();
string strMembershipEnum = string.Empty;
switch (FloginUser.UserPost)
{
case "b159d237-197d-49ea-ac7b-c4df817a1d5b":
strMembershipEnum = MembershipEnum.gradedirector.ToString();
break;
case "adbd4fc0-24d0-418c-aade-e988f8aeabdd":
strMembershipEnum = MembershipEnum.GroupLeader.ToString();
break;
}
model.MembershipEnum = strMembershipEnum;
model.CreateUser = FloginUser.UserId;
bool flag = false;
if (isExistData)
{
flag = bll.Update(model);
}
else
{
flag = bll.Add(model);
}
if (flag)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('申请成功',{icon:1,time:1000},function(){parent.loadData();parent.layer.closeAll();})</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('申请失败',{icon:2,time:2000})</script>");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.msg('操作失败',{icon:2,time:2000})</script>");
}
}
private void InputExcelDataToDB()
{
string strLog = string.Empty;
int exData = 0;
try
{
DataRow[] dr = excelData.Select("ErrorData='正确'");
if (dr.Count() > 0)
{
if (strQtype == "1")
{
Model_UserGroup modelUG = new Model_UserGroup();
List <Model_F_User> listModelFU = new List <Model_F_User>();
List <Model_UserGroup_Member> listModelUGM = new List <Model_UserGroup_Member>();
for (int i = 0; i < dr.Count(); i++)
{
string userId = string.Empty;
#region 用户
Model_F_User modelFUser = new BLL_F_User().GetModelByUserName(dr[i]["登录账号"].ToString().Trim().Filter());
if (modelFUser == null)
{
modelFUser = new Model_F_User();
#region 新增用户
userId = Guid.NewGuid().ToString();
modelFUser.UserId = userId;
modelFUser.UserName = dr[i]["登录账号"].ToString().Trim();
string pass = dr[i]["密码"].ToString().Trim();
if (string.IsNullOrEmpty(pass))
{
pass = "******";
}
modelFUser.Password = Rc.Common.StrUtility.DESEncryptLogin.EncryptString(pass);
modelFUser.TrueName = dr[i]["姓名"].ToString().Trim();
modelFUser.CreateTime = DateTime.Now;
if (dr[i]["身份"].ToString().Trim() == "学生")
{
modelFUser.UserIdentity = "S";
}
else
{
modelFUser.UserIdentity = "T";
modelFUser.UserPost = UserPost.普通老师;
modelFUser.Subject = pfunction.GetCommon_DictId("7", dr[i]["学科"].ToString().Trim());
}
listModelFU.Add(modelFUser);
#endregion
}
else
{
userId = modelFUser.UserId;
}
#endregion
#region 更新群组User_Id
if (dr[i]["身份"].ToString().Trim() == "班主任")
{
modelUG = new BLL_UserGroup().GetModel(userGroupParentId);
modelUG.User_ID = userId;
}
#endregion
#region 群组成员表
Model_UserGroup_Member modelUGM = new Model_UserGroup_Member();
modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString();
modelUGM.UserGroup_Id = userGroupParentId;
modelUGM.User_ID = userId;
modelUGM.User_ApplicationStatus = "passed";
modelUGM.User_ApplicationTime = DateTime.Now;
modelUGM.User_ApplicationReason = "导入用户";
modelUGM.User_ApplicationPassTime = DateTime.Now;
modelUGM.UserStatus = 0;
if (dr[i]["身份"].ToString().Trim() == "学生")
{
modelUGM.MembershipEnum = MembershipEnum.student.ToString();
}
else if (dr[i]["身份"].ToString().Trim() == "班主任")
{
modelUGM.MembershipEnum = MembershipEnum.headmaster.ToString();
}
else if (dr[i]["身份"].ToString().Trim() == "代课老师")
{
modelUGM.MembershipEnum = MembershipEnum.teacher.ToString();
}
modelUGM.CreateUser = loginUser.SysUser_ID;
listModelUGM.Add(modelUGM);
#endregion
}
exData = new BLL_UserGroup_Member().ImportClassMemberData(listModelFU, listModelUGM, modelUG);
}
strLog = "班级成员导入信息 ： 操作人ID：【" + loginUser.SysUser_ID + "】";
}
if (exData > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>layer.msg('【" + dr.Count() + "】班级成员被成功导入',{time:1000,icon:1},function(){historyBack();});</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>layer.msg('操作失败',{time:2000,icon:2});</script>");
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>layer.msg('操作失败',{time:2000,icon:2});</script>");
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("导入班级成员失败：", string.Format("类：{0}，方法{1},错误信息：{2}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message));
}
excelData.Clear();
}
public static string GetDataList(string UserGroup_ParentId, string GroupName, int PageSize, int PageIndex)
{
try
{
BLL_UserGroup_Member bll = new BLL_UserGroup_Member();
UserGroup_ParentId = UserGroup_ParentId.Filter();
GroupName = GroupName.Filter();
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
string strWhere = "User_ApplicationStatus='passed' and UserGroup_Id='" + UserGroup_ParentId + "' ";
if (!string.IsNullOrEmpty(GroupName))
{
strWhere += " and (UserName like '%" + GroupName + "%' or TrueName like '%" + GroupName + "%') ";
}
string orderBy = string.Format("UserStatus,charindex(MembershipEnum,'{0},{1},{2}'),TrueName,User_ApplicationPassTime desc",
MembershipEnum.headmaster, MembershipEnum.teacher, MembershipEnum.student);
dt = bll.GetClassMemberListByPageEX(strWhere, orderBy, ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = bll.GetRecordCount(strWhere);
int inum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
string userName = dt.Rows[i]["TrueName"].ToString();
if (string.IsNullOrEmpty(userName))
{
userName = dt.Rows[i]["UserName"].ToString();
}
userName += "(" + dt.Rows[i]["UserName"].ToString() + ")";
inum++;
listReturn.Add(new
{
inum = (i + 1),
Row = dt.Rows[i]["Row"],
User_Id = dt.Rows[i]["User_Id"],
UserGroup_Member_Id = dt.Rows[i]["UserGroup_Member_Id"],
UserName = userName,
User_ApplicationPassTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["User_ApplicationPassTime"].ToString()),
UserStatus = dt.Rows[i]["UserStatus"].ToString(),
Email = dt.Rows[i]["Email"].ToString(),
MembershipEnum = dt.Rows[i]["MembershipEnum"],
ClassName = dt.Rows[i]["ClassName"],
MembershipEnumName = (dt.Rows[i]["MembershipEnum"].ToString() == MembershipEnum.teacher.ToString()) ? dt.Rows[i]["SubjectName"].ToString() + "老师" : Rc.Common.EnumService.GetDescription <MembershipEnum>(dt.Rows[i]["MembershipEnum"].ToString())
});
}
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
