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