private void LoadData()
{
DataTable dt = new BLL_UserGroup().GetClassListByUserIdMembershipEnum(FloginUser.UserId, MembershipEnum.classrc.ToString(), UserGroup_AttrEnum.Class.ToString()).Tables[0];
if (string.IsNullOrEmpty(ugroupId) && dt.Rows.Count > 0)
{
ugroupId = dt.Rows[0]["UserGroup_Id"].ToString();
}
rptClass.DataSource = dt;
rptClass.DataBind();
Model_UserGroup model = bll.GetModel(ugroupId);
if (model != null)
{
txtUserGroup_Name.Text = model.UserGroup_Name;
txtUserGroup_Id.Text = model.UserGroup_Id;
this.ddlGradeType.SelectedValue = model.GradeType;
this.ddlStartSchoolYear.SelectedValue = model.StartSchoolYear.ToString();
if (string.IsNullOrEmpty(model.Grade.ToString()))
{
this.HidGrade.Value = "-1";
}
else
{
this.HidGrade.Value = model.Grade.ToString();
}
txtUserGroup_BriefIntroduction.Text = model.UserGroup_BriefIntroduction;
txtSort.Text = model.UserGroupOrder.ToString();
if (model.User_ID != FloginUser.UserId)//判断登录用户是否为群组创建者，不是不让编辑
{
ButtonOK.Visible = false;
}
}
}
public bool Add(Model_UserGroup model)
{
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[] cmdParms = 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) };
cmdParms[0].Value = model.UserGroup_Id;
cmdParms[1].Value = model.UserGroup_ParentId;
cmdParms[2].Value = model.User_ID;
cmdParms[3].Value = model.UserGroup_Name;
cmdParms[4].Value = model.GradeType;
cmdParms[5].Value = model.StartSchoolYear;
cmdParms[6].Value = model.Grade;
cmdParms[7].Value = model.Class;
cmdParms[8].Value = model.Subject;
cmdParms[9].Value = model.UserGroupp_Type;
cmdParms[10].Value = model.UserGroup_BriefIntroduction;
cmdParms[11].Value = model.CreateTime;
cmdParms[12].Value = model.UserGroup_AttrEnum;
cmdParms[13].Value = model.UserGroupOrder;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
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);
}
public List <Model_UserGroup> DataTableToList(DataTable dt)
{
List <Model_UserGroup> list = new List <Model_UserGroup>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_UserGroup item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
try
{
Model_UserGroup userGroup = bll.GetModel(ugroupId);
if (pfunction.FilterKeyWords(this.txtUserGroup_Name.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('年级名称存在敏感词汇，请重新填写。',{icon:2,time:2000});</script>");
return;
}
else
{
userGroup.UserGroup_Name = this.txtUserGroup_Name.Text.Trim();
}
if (pfunction.FilterKeyWords(this.txtUserGroup_BriefIntroduction.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('年级简介存在敏感词汇，请重新填写。',{icon:2,time:2000});</script>");
return;
}
else
{
userGroup.UserGroup_BriefIntroduction = this.txtUserGroup_BriefIntroduction.Text.Trim();
}
userGroup.GradeType = this.ddlGradeType.SelectedValue;
userGroup.Grade = Convert.ToDecimal(this.HidGrade.Value);
userGroup.StartSchoolYear = Convert.ToDecimal(this.ddlStartSchoolYear.SelectedValue);
int intOrder = 1;
int.TryParse(txtSort.Text, out intOrder);
userGroup.UserGroupOrder = intOrder;
if (bll.Update(userGroup))
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('1','修改成功')</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('2','修改失败')</script>");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('2','修改失败err')</script>");
}
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
try
{
Model_UserGroup userGroup = bll.GetModel(ugroupId);
if (pfunction.FilterKeyWords(this.txtUserGroup_Name.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('学校名称存在敏感词汇，请重新填写。',{icon:2,time:2000});</script>");
return;
}
else
{
userGroup.UserGroup_Name = this.txtUserGroup_Name.Text.Trim();
}
if (pfunction.FilterKeyWords(this.txtUserGroup_BriefIntroduction.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('学校简介存在敏感词汇，请重新填写。',{icon:2,time:2000});</script>");
return;
}
else
{
userGroup.UserGroup_BriefIntroduction = this.txtUserGroup_BriefIntroduction.Text.Trim();
}
if (bll.Update(userGroup))
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('1','修改成功')</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('2','修改失败')</script>");
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'> Handel('2','修改失败err')</script>");
}
}
public bool Update(Model_UserGroup model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update UserGroup set ");
builder.Append("UserGroup_ParentId=@UserGroup_ParentId,");
builder.Append("User_ID=@User_ID,");
builder.Append("UserGroup_Name=@UserGroup_Name,");
builder.Append("GradeType=@GradeType,");
builder.Append("StartSchoolYear=@StartSchoolYear,");
builder.Append("Grade=@Grade,");
builder.Append("Class=@Class,");
builder.Append("Subject=@Subject,");
builder.Append("UserGroupp_Type=@UserGroupp_Type,");
builder.Append("UserGroup_BriefIntroduction=@UserGroup_BriefIntroduction,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("UserGroup_AttrEnum=@UserGroup_AttrEnum,");
builder.Append("UserGroupOrder=@UserGroupOrder");
builder.Append(" where UserGroup_Id=@UserGroup_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { 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), new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 10) };
cmdParms[0].Value = model.UserGroup_ParentId;
cmdParms[1].Value = model.User_ID;
cmdParms[2].Value = model.UserGroup_Name;
cmdParms[3].Value = model.GradeType;
cmdParms[4].Value = model.StartSchoolYear;
cmdParms[5].Value = model.Grade;
cmdParms[6].Value = model.Class;
cmdParms[7].Value = model.Subject;
cmdParms[8].Value = model.UserGroupp_Type;
cmdParms[9].Value = model.UserGroup_BriefIntroduction;
cmdParms[10].Value = model.CreateTime;
cmdParms[11].Value = model.UserGroup_AttrEnum;
cmdParms[12].Value = model.UserGroupOrder;
cmdParms[13].Value = model.UserGroup_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
private void LoadData()
{
DataTable dt = new BLL_UserGroup().GetList("UserGroup_AttrEnum='" + UserGroup_AttrEnum.School.ToString() + "' and User_Id='" + FloginUser.UserId + "' order by CreateTime desc").Tables[0];
if (string.IsNullOrEmpty(ugroupId) && dt.Rows.Count > 0)
{
ugroupId = dt.Rows[0]["UserGroup_Id"].ToString();
}
rptClass.DataSource = dt;
rptClass.DataBind();
Model_UserGroup model = bll.GetModel(ugroupId);
if (model != null)
{
txtUserGroup_Name.Text = model.UserGroup_Name;
txtUserGroup_Id.Text = model.UserGroup_Id;
txtUserGroup_BriefIntroduction.Text = model.UserGroup_BriefIntroduction;
if (model.User_ID != FloginUser.UserId)//判断登录用户是否为群组创建者，不是不让编辑
{
ButtonOK.Visible = false;
}
}
}
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 Update(Model_UserGroup model)
{
return(this.dal.Update(model));
}
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 Model_UserGroup DataRowToModel(DataRow row)
{
Model_UserGroup group = new Model_UserGroup();
if (row != null)
{
if (row["UserGroup_Id"] != null)
{
group.UserGroup_Id = row["UserGroup_Id"].ToString();
}
if (row["UserGroup_ParentId"] != null)
{
group.UserGroup_ParentId = row["UserGroup_ParentId"].ToString();
}
if (row["User_ID"] != null)
{
group.User_ID = row["User_ID"].ToString();
}
if (row["UserGroup_Name"] != null)
{
group.UserGroup_Name = row["UserGroup_Name"].ToString();
}
if (row["GradeType"] != null)
{
group.GradeType = row["GradeType"].ToString();
}
if ((row["StartSchoolYear"] != null) && (row["StartSchoolYear"].ToString() != ""))
{
group.StartSchoolYear = new decimal?(decimal.Parse(row["StartSchoolYear"].ToString()));
}
if ((row["Grade"] != null) && (row["Grade"].ToString() != ""))
{
group.Grade = new decimal?(decimal.Parse(row["Grade"].ToString()));
}
if ((row["Class"] != null) && (row["Class"].ToString() != ""))
{
group.Class = new decimal?(decimal.Parse(row["Class"].ToString()));
}
if (row["Subject"] != null)
{
group.Subject = row["Subject"].ToString();
}
if (row["UserGroupp_Type"] != null)
{
group.UserGroupp_Type = row["UserGroupp_Type"].ToString();
}
if (row["UserGroup_BriefIntroduction"] != null)
{
group.UserGroup_BriefIntroduction = row["UserGroup_BriefIntroduction"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
group.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["UserGroup_AttrEnum"] != null)
{
group.UserGroup_AttrEnum = row["UserGroup_AttrEnum"].ToString();
}
if ((row["UserGroupOrder"] != null) && (row["UserGroupOrder"].ToString() != ""))
{
group.UserGroupOrder = new int?(int.Parse(row["UserGroupOrder"].ToString()));
}
}
return(group);
}
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 bool Add(Model_UserGroup model)
{
return(this.dal.Add(model));
}
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();
}
public int ImportClassMemberData(List <Model_F_User> listModelFU, List <Model_UserGroup_Member> listModelUGM, Model_UserGroup modelUG)
{
return(this.dal.ImportClassMemberData(listModelFU, listModelUGM, modelUG));
}
