public static string ClassDisband(string ClassId, string SchoolId)
{
try
{
//if (new BLL_UserGroup_Member().GetRecordCount("UserGroup_Id='" + ClassId + "' and MembershipEnum!='" + MembershipEnum.gradedirector.ToString() + "' ") > 0)
//{
// return "2";//已有成员
//}
//else
//{
Model_ClassPool modelClassPool = new Model_ClassPool();
modelClassPool = new BLL_ClassPool().GetModelByClass_Id(ClassId);
modelClassPool.IsUsed = 0;
if (new BLL_UserGroup().DelGroupUpClassPoolDelMember(ClassId, SchoolId, modelClassPool))
{
return("1");
}
else
{
return("0");
}
//}
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
public static string ClassDisband(string ClassId)
{
try
{
//if (new BLL_UserGroup_Member().GetRecordCount("UserGroup_Id='" + ClassId + "' and MembershipEnum!='" + MembershipEnum.principal.ToString() + "' ") > 0)
//{
// return "2";//已有成员
//}
//else
//{
//BLL_ClassPool bllCP = new BLL_ClassPool();
//Model_ClassPool modelCP = new Model_ClassPool();
//modelCP = bllCP.GetModelByClass_Id(ClassId);
//modelCP.IsUsed = 0;
//if (new BLL_UserGroup().Delete(ClassId) && bllCP.Update(modelCP))
Model_ClassPool modelClassPool = new Model_ClassPool();
modelClassPool = new BLL_ClassPool().GetModelByClass_Id(ClassId);
modelClassPool.IsUsed = 0;
if (new BLL_UserGroup().DelGroupUpClassPoolDelMember(ClassId, "", modelClassPool))
{
return("1");
}
else
{
return("0");
}
//}
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
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")
{
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>");
}
}
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>");
}
}
