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 List <Model_UserGroup_Member> DataTableToList(DataTable dt) { List <Model_UserGroup_Member> list = new List <Model_UserGroup_Member>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_UserGroup_Member item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
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"); } }
private void InputExcelDataToDB() { string strLog = string.Empty; int exData = 0; try { DataRow[] dr = excelData.Select("ErrorData='正确'"); if (dr.Count() > 0) { if (strQtype == "1") { List <Model_UserGroup> listModelUG = new List <Model_UserGroup>(); List <Model_F_User> listModelFU = new List <Model_F_User>(); List <Model_ClassPool> listModelCP = new List <Model_ClassPool>(); 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(); modelFUser.Password = Rc.Common.StrUtility.DESEncryptLogin.EncryptString("123456"); modelFUser.TrueName = dr[i]["创建人登录账号"].ToString().Trim(); modelFUser.UserIdentity = "T"; modelFUser.CreateTime = DateTime.Now; modelFUser.UserPost = UserPost.年级组长; listModelFU.Add(modelFUser); #endregion } else { userId = modelFUser.UserId; } #endregion string gradeId = pfunction.GetNewUserGroupID(); #region 年级群组 Model_UserGroup modelUG = new Model_UserGroup(); modelUG.UserGroup_Id = gradeId; modelUG.UserGroup_ParentId = userGroupParentId; modelUG.User_ID = userId; modelUG.UserGroup_Name = dr[i]["年级名称"].ToString().Trim(); modelUG.UserGroup_BriefIntroduction = dr[i]["年级简介"].ToString().Trim(); modelUG.CreateTime = DateTime.Now; modelUG.UserGroup_AttrEnum = UserGroup_AttrEnum.Grade.ToString(); modelUG.GradeType = "";//导入年级时,年级类型(学段)默认为空 listModelUG.Add(modelUG); #endregion #region 群组池 Model_ClassPool modelClassPool = new BLL_ClassPool().GetModelByClass_Id(gradeId); modelClassPool.IsUsed = 1; listModelCP.Add(modelClassPool); #endregion #region 群组成员表--年级加入学校 Model_UserGroup_Member modelUGM = new Model_UserGroup_Member(); modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString(); modelUGM.UserGroup_Id = userGroupParentId; modelUGM.User_ID = gradeId; modelUGM.User_ApplicationStatus = "passed"; modelUGM.User_ApplicationTime = DateTime.Now; modelUGM.User_ApplicationReason = "导入年级"; modelUGM.User_ApplicationPassTime = DateTime.Now; modelUGM.UserStatus = 0; modelUGM.MembershipEnum = MembershipEnum.grade.ToString(); modelUGM.CreateUser = loginUser.SysUser_ID; listModelUGM.Add(modelUGM); #endregion #region 群组成员表--年级负责人建立与年级关系 modelUGM = new Model_UserGroup_Member(); modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString(); modelUGM.UserGroup_Id = gradeId; modelUGM.User_ID = userId; modelUGM.User_ApplicationStatus = "passed"; modelUGM.User_ApplicationTime = DateTime.Now; modelUGM.User_ApplicationReason = "年级负责人建立与年级关系"; modelUGM.User_ApplicationPassTime = DateTime.Now; modelUGM.UserStatus = 0; modelUGM.MembershipEnum = MembershipEnum.gradedirector.ToString(); modelUGM.CreateUser = loginUser.SysUser_ID; listModelUGM.Add(modelUGM); #endregion } exData = new BLL_UserGroup().ImportGradeData(listModelFU, listModelUG, listModelCP, listModelUGM); } strLog = "年级导入信息:操作人ID:【" + loginUser.SysUser_ID + "】"; } if (exData > 0) { ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('【" + dr.Count() + "】年级被成功导入',{time:1000,icon:1},function(){historyBack();});})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('操作失败',{time:2000,icon:2});})})</script>"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "handle", "<script type='text/javascript'>$(function(){layer.ready(function(){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(); }
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(); }
private void InputExcelDataToDB() { string strLog = string.Empty; int exData = 0; try { DataRow[] dr = excelData.Select("ErrorData='正确'"); if (dr.Count() > 0) { if (strQtype == "1") { List <Model_UserGroup> listModelUG = new List <Model_UserGroup>(); List <Model_F_User> listModelFU = new List <Model_F_User>(); List <Model_ClassPool> listModelCP = new List <Model_ClassPool>(); List <Model_UserGroup_Member> listModelUGM = new List <Model_UserGroup_Member>(); for (int i = 0; i < dr.Count(); i++) { string gradeId = pfunction.GetNewUserGroupID(); #region 班级群组 Model_UserGroup modelUG = new Model_UserGroup(); modelUG.UserGroup_Id = gradeId; modelUG.UserGroup_ParentId = userGroupParentId; modelUG.User_ID = ""; modelUG.UserGroup_Name = dr[i]["班级名称"].ToString().Trim(); modelUG.UserGroup_BriefIntroduction = dr[i]["班级简介"].ToString().Trim(); modelUG.StartSchoolYear = Convert.ToInt16(dr[i]["入学年份(级)"].ToString()); modelUG.CreateTime = DateTime.Now; modelUG.UserGroup_AttrEnum = UserGroup_AttrEnum.Class.ToString(); listModelUG.Add(modelUG); #endregion #region 群组池 Model_ClassPool modelClassPool = new BLL_ClassPool().GetModelByClass_Id(gradeId); modelClassPool.IsUsed = 1; listModelCP.Add(modelClassPool); #endregion #region 群组成员表 Model_UserGroup_Member modelUGM = new Model_UserGroup_Member(); modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString(); modelUGM.UserGroup_Id = userGroupParentId; modelUGM.User_ID = gradeId; modelUGM.User_ApplicationStatus = "passed"; modelUGM.User_ApplicationTime = DateTime.Now; modelUGM.User_ApplicationReason = "导入班级"; modelUGM.User_ApplicationPassTime = DateTime.Now; modelUGM.UserStatus = 0; modelUGM.MembershipEnum = MembershipEnum.classrc.ToString(); modelUGM.CreateUser = loginUser.SysUser_ID; listModelUGM.Add(modelUGM); #endregion } exData = new BLL_UserGroup().ImportGradeData(listModelFU, listModelUG, listModelCP, listModelUGM); } 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(); }
protected void ButtonOK_Click(object sender, EventArgs e) { try { Model_UserGroup userGroup = new Model_UserGroup(); userGroup.UserGroup_Id = Rc.Cloud.Web.Common.pfunction.GetNewUserGroupID(); if (string.IsNullOrEmpty(userGroup.UserGroup_Id)) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('无可用班级号',{icon:4,time:2000})})</script>"); return; } userGroup.User_ID = FloginUser.UserId; if (pfunction.FilterKeyWords(this.txtClassName.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('班级名称存在敏感词汇,请重新填写',{icon:4,time:2000})})</script>"); return; } else { userGroup.UserGroup_Name = this.txtClassName.Text.Trim(); } //userGroup.Class = Convert.ToInt32(this.txtClass.Text.Trim()); userGroup.GradeType = this.ddlGradeType.SelectedValue; userGroup.Grade = Convert.ToDecimal(this.HidGrade.Value); userGroup.StartSchoolYear = Convert.ToDecimal(this.ddlStartSchoolYear.SelectedValue); userGroup.UserGroupp_Type = "8842F17C-E3F7-4B65-BBF1-FDD950328CB1";//群类型,班 if (pfunction.FilterKeyWords(this.txtClassIntro.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('班级简介存在敏感词汇,请重新填写',{icon:4,time:2000})});</script>"); return; } else { userGroup.UserGroup_BriefIntroduction = this.txtClassIntro.Text.Trim(); } userGroup.CreateTime = DateTime.Now; userGroup.UserGroup_AttrEnum = UserGroup_AttrEnum.Class.ToString(); int intOrder = 1; int.TryParse(txtSort.Text, out intOrder); userGroup.UserGroupOrder = intOrder; Model_ClassPool modelClassPool = new BLL_ClassPool().GetModelByClass_Id(userGroup.UserGroup_Id); modelClassPool.IsUsed = 1; Model_UserGroup_Member modelUGM = new Model_UserGroup_Member(); modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString(); modelUGM.UserGroup_Id = userGroup.UserGroup_Id; modelUGM.User_ID = FloginUser.UserId; modelUGM.User_ApplicationStatus = "passed"; modelUGM.User_ApplicationTime = DateTime.Now; modelUGM.User_ApplicationReason = ""; modelUGM.User_ApplicationPassTime = DateTime.Now; modelUGM.UserStatus = 0; modelUGM.MembershipEnum = MembershipEnum.headmaster.ToString(); modelUGM.CreateUser = FloginUser.UserId; if (new BLL_UserGroup().AddGroupUpClassPoolAddMember(userGroup, modelClassPool, modelUGM)) { new BLL_ClassPool().Update(modelClassPool); ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('创建成功',{icon:1,time:1000},function(){parent.window.location.reload()})})</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('创建失败',{icon:2,time:2000},function(){parent.layer.closeAll()})})</script>"); } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('未知错误',{icon:4,time:2000},function(){parent.layer.closeAll()})})</script>"); } }
public bool AddGroupUpClassPoolAddMember(Model_UserGroup model, Model_ClassPool modelClassPool, Model_UserGroup_Member modelUGM) { return(this.dal.AddGroupUpClassPoolAddMember(model, modelClassPool, modelUGM)); }
public bool Add(Model_UserGroup_Member model) { return(this.dal.Add(model)); }
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); }
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"); } }
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>"); } }
protected void ButtonOK_Click(object sender, EventArgs e) { try { Model_UserGroup userGroup = new Model_UserGroup(); userGroup.UserGroup_Id = Rc.Cloud.Web.Common.pfunction.GetNewUserGroupID(); if (string.IsNullOrEmpty(userGroup.UserGroup_Id)) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('无可用学校号',{icon:4,time:2000,offset:'10px'})})</script>"); return; } userGroup.User_ID = FloginUser.UserId; if (pfunction.FilterKeyWords(this.txtClassName.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('学校名称存在敏感词汇,请重新填写',{icon:4,time:2000,offset:'10px'})})</script>"); return; } else { userGroup.UserGroup_Name = this.txtClassName.Text.Trim(); } userGroup.UserGroupp_Type = "8842F17C-E3F7-4B65-BBF1-FDD950328CB1";//群类型,班 if (pfunction.FilterKeyWords(this.txtClassIntro.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('学校简介存在敏感词汇,请重新填写',{icon:4,time:2000,offset:'10px'})})</script>"); return; } else { userGroup.UserGroup_BriefIntroduction = this.txtClassIntro.Text.Trim(); } userGroup.CreateTime = DateTime.Now; userGroup.UserGroup_AttrEnum = UserGroup_AttrEnum.School.ToString(); Model_ClassPool modelClassPool = new BLL_ClassPool().GetModelByClass_Id(userGroup.UserGroup_Id); modelClassPool.IsUsed = 1; Model_UserGroup_Member modelUGM = new Model_UserGroup_Member(); modelUGM.UserGroup_Member_Id = Guid.NewGuid().ToString(); modelUGM.UserGroup_Id = userGroup.UserGroup_Id; modelUGM.User_ID = FloginUser.UserId; modelUGM.User_ApplicationStatus = "passed"; modelUGM.User_ApplicationTime = DateTime.Now; modelUGM.User_ApplicationReason = ""; modelUGM.User_ApplicationPassTime = DateTime.Now; modelUGM.UserStatus = 0; modelUGM.MembershipEnum = MembershipEnum.principal.ToString(); if (new BLL_UserGroup().AddGroupUpClassPoolAddMember(userGroup, modelClassPool, modelUGM)) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('创建成功',{icon:1,time:1000,offset:'10px'},function(){parent.window.location.reload()})})</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 bool Update(Model_UserGroup_Member model) { return(this.dal.Update(model)); }
public bool TeacherRemoveStudent(Model_UserGroup_Member model, Model_Msg modelMsg) { return(this.dal.TeacherRemoveStudent(model, modelMsg)); }
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>"); } }
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 bool AddGroupUpClassPoolAddMember(Model_UserGroup model, Model_ClassPool modelClassPool, Model_UserGroup_Member modelUGM) { Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>(); StringBuilder builder = new StringBuilder(); builder = new StringBuilder(); builder.Append("insert into UserGroup("); builder.Append("UserGroup_Id,UserGroup_ParentId,User_ID,UserGroup_Name,GradeType,StartSchoolYear,Grade,Class,Subject,UserGroupp_Type,UserGroup_BriefIntroduction,CreateTime,UserGroup_AttrEnum,UserGroupOrder)"); builder.Append(" values ("); builder.Append("@UserGroup_Id,@UserGroup_ParentId,@User_ID,@UserGroup_Name,@GradeType,@StartSchoolYear,@Grade,@Class,@Subject,@UserGroupp_Type,@UserGroup_BriefIntroduction,@CreateTime,@UserGroup_AttrEnum,@UserGroupOrder)"); SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 10), new SqlParameter("@UserGroup_ParentId", SqlDbType.VarChar, 0x24), new SqlParameter("@User_ID", SqlDbType.Char, 0x24), new SqlParameter("@UserGroup_Name", SqlDbType.NVarChar, 250), new SqlParameter("@GradeType", SqlDbType.Char, 0x24), new SqlParameter("@StartSchoolYear", SqlDbType.Decimal, 5), new SqlParameter("@Grade", SqlDbType.Decimal, 5), new SqlParameter("@Class", SqlDbType.Decimal, 5), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@UserGroupp_Type", SqlDbType.Char, 0x24), new SqlParameter("@UserGroup_BriefIntroduction", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UserGroup_AttrEnum", SqlDbType.VarChar, 10), new SqlParameter("@UserGroupOrder", SqlDbType.Int, 4) }; parameterArray[0].Value = model.UserGroup_Id; parameterArray[1].Value = model.UserGroup_ParentId; parameterArray[2].Value = model.User_ID; parameterArray[3].Value = model.UserGroup_Name; parameterArray[4].Value = model.GradeType; parameterArray[5].Value = model.StartSchoolYear; parameterArray[6].Value = model.Grade; parameterArray[7].Value = model.Class; parameterArray[8].Value = model.Subject; parameterArray[9].Value = model.UserGroupp_Type; parameterArray[10].Value = model.UserGroup_BriefIntroduction; parameterArray[11].Value = model.CreateTime; parameterArray[12].Value = model.UserGroup_AttrEnum; parameterArray[13].Value = model.UserGroupOrder; dictionary.Add(builder.ToString(), parameterArray); builder = new StringBuilder(); builder.Append("update ClassPool set "); builder.Append("IsUsed=@IsUsed"); builder.Append(" where ClassPool_Id=@ClassPool_Id "); SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@IsUsed", SqlDbType.Int, 4), new SqlParameter("@ClassPool_Id", SqlDbType.Char, 0x24) }; parameterArray2[0].Value = modelClassPool.IsUsed; parameterArray2[1].Value = modelClassPool.ClassPool_Id; dictionary.Add(builder.ToString(), parameterArray2); if (modelUGM != null) { builder = new StringBuilder(); builder.Append("insert into UserGroup_Member("); builder.Append("UserGroup_Member_Id,UserGroup_Id,User_ID,User_ApplicationStatus,User_ApplicationTime,User_ApplicationReason,User_ApplicationPassTime,UserStatus,MembershipEnum)"); builder.Append(" values ("); builder.Append("@UserGroup_Member_Id,@UserGroup_Id,@User_ID,@User_ApplicationStatus,@User_ApplicationTime,@User_ApplicationReason,@User_ApplicationPassTime,@UserStatus,@MembershipEnum)"); SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@UserGroup_Member_Id", SqlDbType.Char, 0x24), new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 10), new SqlParameter("@User_ID", SqlDbType.Char, 0x24), new SqlParameter("@User_ApplicationStatus", SqlDbType.VarChar, 50), new SqlParameter("@User_ApplicationTime", SqlDbType.DateTime), new SqlParameter("@User_ApplicationReason", SqlDbType.NVarChar, 0x7d0), new SqlParameter("@User_ApplicationPassTime", SqlDbType.DateTime), new SqlParameter("@UserStatus", SqlDbType.Int, 4), new SqlParameter("@MembershipEnum", SqlDbType.VarChar, 20) }; parameterArray3[0].Value = modelUGM.UserGroup_Member_Id; parameterArray3[1].Value = modelUGM.UserGroup_Id; parameterArray3[2].Value = modelUGM.User_ID; parameterArray3[3].Value = modelUGM.User_ApplicationStatus; parameterArray3[4].Value = modelUGM.User_ApplicationTime; parameterArray3[5].Value = modelUGM.User_ApplicationReason; parameterArray3[6].Value = modelUGM.User_ApplicationPassTime; parameterArray3[7].Value = modelUGM.UserStatus; parameterArray3[8].Value = modelUGM.MembershipEnum; dictionary.Add(builder.ToString(), parameterArray3); } return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0); }