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 Model_ClassPool DataRowToModel(DataRow row)
{
Model_ClassPool pool = new Model_ClassPool();
if (row != null)
{
if (row["ClassPool_Id"] != null)
{
pool.ClassPool_Id = row["ClassPool_Id"].ToString();
}
if (row["Class_Id"] != null)
{
pool.Class_Id = row["Class_Id"].ToString();
}
if ((row["IsEnabled"] != null) && (row["IsEnabled"].ToString() != ""))
{
pool.IsEnabled = new int?(int.Parse(row["IsEnabled"].ToString()));
}
if ((row["IsUsed"] != null) && (row["IsUsed"].ToString() != ""))
{
pool.IsUsed = new int?(int.Parse(row["IsUsed"].ToString()));
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
pool.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
return(pool);
}
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());
}
}
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 bool Add(Model_ClassPool model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ClassPool(");
builder.Append("ClassPool_Id,Class_Id,IsEnabled,IsUsed,CreateTime)");
builder.Append(" values (");
builder.Append("@ClassPool_Id,@Class_Id,@IsEnabled,@IsUsed,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ClassPool_Id", SqlDbType.Char, 0x24), new SqlParameter("@Class_Id", SqlDbType.VarChar, 10), new SqlParameter("@IsEnabled", SqlDbType.Int, 4), new SqlParameter("@IsUsed", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.ClassPool_Id;
cmdParms[1].Value = model.Class_Id;
cmdParms[2].Value = model.IsEnabled;
cmdParms[3].Value = model.IsUsed;
cmdParms[4].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <Model_ClassPool> DataTableToList(DataTable dt)
{
List <Model_ClassPool> list = new List <Model_ClassPool>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_ClassPool item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Update(Model_ClassPool model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ClassPool set ");
builder.Append("Class_Id=@Class_Id,");
builder.Append("IsEnabled=@IsEnabled,");
builder.Append("IsUsed=@IsUsed,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where ClassPool_Id=@ClassPool_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Class_Id", SqlDbType.VarChar, 10), new SqlParameter("@IsEnabled", SqlDbType.Int, 4), new SqlParameter("@IsUsed", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ClassPool_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Class_Id;
cmdParms[1].Value = model.IsEnabled;
cmdParms[2].Value = model.IsUsed;
cmdParms[3].Value = model.CreateTime;
cmdParms[4].Value = model.ClassPool_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_ClassPool model)
{
return(this.dal.Add(model));
}
public bool Update(Model_ClassPool model)
{
return(this.dal.Update(model));
}
public bool DelGroupUpClassPoolDelMember(string UserGroup_Id, string PUserGroup_Id, Model_ClassPool modelClassPool)
{
return(this.dal.DelGroupUpClassPoolDelMember(UserGroup_Id, PUserGroup_Id, modelClassPool));
}
public bool AddGroupUpClassPoolAddMember(Model_UserGroup model, Model_ClassPool modelClassPool, Model_UserGroup_Member modelUGM)
{
return(this.dal.AddGroupUpClassPoolAddMember(model, modelClassPool, modelUGM));
}
public bool DelGroupUpClassPoolDelMember(string UserGroup_Id, string PUserGroup_Id, Model_ClassPool modelClassPool)
{
Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>();
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(PUserGroup_Id))
{
builder = new StringBuilder();
builder.Append("delete from UserGroup_Member where UserGroup_Id=@PUserGroup_Id and User_Id=@UserGroup_Id ");
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@PUserGroup_Id", SqlDbType.VarChar, 10), new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 0x24) };
parameterArray[0].Value = PUserGroup_Id;
parameterArray[1].Value = UserGroup_Id;
dictionary.Add(builder.ToString(), parameterArray);
}
builder = new StringBuilder();
builder.Append("delete from UserGroup_Member where UserGroup_Id=@UserGroup_Id ");
SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 10) };
parameterArray2[0].Value = UserGroup_Id;
dictionary.Add(builder.ToString(), parameterArray2);
builder = new StringBuilder();
builder.Append("delete from UserGroup where UserGroup_Id=@UserGroup_Id ");
SqlParameter[] parameterArray3 = new SqlParameter[] { new SqlParameter("@UserGroup_Id", SqlDbType.VarChar, 10) };
parameterArray3[0].Value = UserGroup_Id;
dictionary.Add(builder.ToString(), parameterArray3);
builder = new StringBuilder();
builder.Append("update ClassPool set ");
builder.Append("IsUsed=@IsUsed");
builder.Append(" where ClassPool_Id=@ClassPool_Id ");
SqlParameter[] parameterArray4 = new SqlParameter[] { new SqlParameter("@IsUsed", SqlDbType.Int, 4), new SqlParameter("@ClassPool_Id", SqlDbType.Char, 0x24) };
parameterArray4[0].Value = modelClassPool.IsUsed;
parameterArray4[1].Value = modelClassPool.ClassPool_Id;
dictionary.Add(builder.ToString(), parameterArray4);
return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0);
}
