public static bool UpdateRoleLink(string strDelete, string strRoleId) { //构建查询条件 Parameter parameter1 = new Parameter(); parameter1.SqlString = " DELETE FROM PT_RoleLink WHERE RoleId = " + strRoleId + " "; //构建多个查询条件 Parameter parameter2 = new Parameter(); parameter2.SqlString = " INSERT PT_RoleLink VALUES('" + strRoleId + "','01') "; List <Parameter> parmList = new List <Parameter>(); parmList.Add(parameter1); parmList.Add(parameter2); string[] lstr = strDelete.Split(','); foreach (string str in lstr) { //角色关联功能 Parameter parameter = new Parameter(); parameter.SqlString = " INSERT PT_RoleLink VALUES('" + strRoleId + "','" + str + "') "; parmList.Add(parameter); } CommonToolsBLL.ExcuteSqlWithTransaction(parmList); return(true); }
/// <summary> /// add by chr /// 通过用户名将用户的所有信息进行删除 /// </summary> /// <param name="userName"></param> /// <returns></returns> public static void DeleteUser(string userName) { //构建查询条件 Parameter parameter1 = new Parameter(); parameter1.SqlString = " DELETE FROM PT_UserLink WHERE UserName = @UserName"; SqlParameter[] parameters1 = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) { Value = userName }, }; parameter1.Parameters = parameters1; Parameter parameter2 = new Parameter(); parameter2.SqlString = " DELETE FROM PT_USER WHERE UserName= @UserName"; SqlParameter[] parameters2 = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) { Value = userName }, }; parameter2.Parameters = parameters2; List <Parameter> parmList = new List <Parameter>(); parmList.Add(parameter1); parmList.Add(parameter2); CommonToolsBLL.ExcuteSqlWithTransaction(parmList); }
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉ // 说明:以下区域的代码为设计开发人员所编写,主要为扩展该业务逻辑类的功能,而定义的变量、属性及相关业务逻辑处理方法。 // 注意:用户界面层应当只需调用本层便可完成所有操作,本类对关联的数据访问类调用,应当只通过类中的DataAccess属性实现。 //﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍ /// <summary> /// 通过传入的角色id组成的字符串 来删除角色 /// </summary> /// <param name="strDelete"></param> /// <returns></returns> public static bool DeleteRolesByStr(string strDelete) { //构建查询条件 Parameter parameter1 = new Parameter(); parameter1.SqlString = " SELECT * FROM PT_UserLink WHERE RoleId IN(" + strDelete + ") "; //查询数据 DataTable dt = BLL.CommonToolsBLL.GetAllListByParams(parameter1); if (dt.Rows.Count > 0) { return(false); } //构建多个查询条件 Parameter parameter2 = new Parameter(); parameter2.SqlString = " DELETE FROM PT_ROLE WHERE Id IN(" + strDelete + ") "; //角色关联功能 Parameter parameter3 = new Parameter(); parameter3.SqlString = " DELETE FROM PT_RoleLink WHERE RoleId IN(" + strDelete + ") "; //角色关联用户 Parameter parameter4 = new Parameter(); parameter4.SqlString = " DELETE FROM PT_UserLink WHERE RoleId IN(" + strDelete + ") "; List <Parameter> parmList = new List <Parameter>(); parmList.Add(parameter2); parmList.Add(parameter3); parmList.Add(parameter4); CommonToolsBLL.ExcuteSqlWithTransaction(parmList); return(true); }
/// <summary> /// add by chr /// 公共方法: 通过机构的主键Id 删除相关的机构信息(包括其子机构) 将被删除机构下的所有用户一并删除 /// </summary> /// <param name="strId"></param> public static bool DeleteOrgById(string strId) { //构建查询条件 Parameter parameter1 = new Parameter(); parameter1.SqlString = " SELECT Id FROM PT_ORG WHERE Id = @Id OR FatherId= @Id "; SqlParameter[] parameters1 = { new SqlParameter("@Id", SqlDbType.Int, 4) { Value = strId }, }; parameter1.Parameters = parameters1; //查询数据 DataTable dt = BLL.CommonToolsBLL.GetAllListByParams(parameter1); string DelStr = ""; foreach (DataRow dr in dt.Rows) { DelStr += dr["Id"] + ","; } //被删除的机构字符串 DelStr = DelStr.Substring(0, DelStr.Length - 1); //构建多个查询条件 Parameter parameter4 = new Parameter(); parameter4.SqlString = " SELECT * FROM PT_USER WHERE OrgId IN (" + DelStr + ") "; DataTable dt_user = BLL.CommonToolsBLL.GetAllListByParams(parameter4); if (dt_user.Rows.Count > 0) { return(false); } //构建多个查询条件 Parameter parameter2 = new Parameter(); parameter2.SqlString = " DELETE FROM PT_USER WHERE OrgId IN (" + DelStr + ") "; Parameter parameter3 = new Parameter(); parameter3.SqlString = " DELETE FROM PT_ORG WHERE Id = @Id OR FatherId= @Id "; SqlParameter[] parameters3 = { new SqlParameter("@Id", SqlDbType.Int, 4) { Value = strId }, }; parameter3.Parameters = parameters3; List <Parameter> parmList = new List <Parameter>(); parmList.Add(parameter2); parmList.Add(parameter3); CommonToolsBLL.ExcuteSqlWithTransaction(parmList); return(true); }