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