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 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"
}));
}
}