/// <summary>
/// 根据权限插入数据
/// </summary>
public void InsertByCodes(string Codes, int RoleID, string NodeID = "")
{
M_UserPurview model = new M_UserPurview();
model.RoleID = RoleID;
DelByCodes(Codes, RoleID);
string[] CodesArr = Codes.Split(',');
for (int i = 0; i < CodesArr.Length; i++)
{
if (CodesArr[i] == "OATop" || CodesArr[i] == "OADel" || CodesArr[i] == "OAEdit")
{
string[] nidArr = NodeID.Split('|');
DelByCodeIn(CodesArr[i], RoleID);
if (CodesArr[i] == "OATop")
{
model.NodeID = nidArr[0];
}
else if (CodesArr[i] == "OADel")
{
model.NodeID = nidArr[1];
}
else if (CodesArr[i] == "OAEdit")
{
model.NodeID = nidArr[2];
}
model.PurviewCode = CodesArr[i];
insert(model);
}
if (!IsExist(CodesArr[i], RoleID))
{
model.PurviewCode = CodesArr[i];
insert(model);
}
}
}
/// <summary>
/// 获取节点id列表
/// </summary>
/// <param name="roleid">角色ID</param>
/// <param name="code">权限代码</param>
/// <returns></returns>
public string GetNodeIDs(int roleid, string code)
{
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("code", code) };
M_UserPurview model = new M_UserPurview();
using (DbDataReader reader = Sql.SelReturnReader(strTableName, "Where RoleID=" + roleid + " And PurviewCode=@code", sp))
{
if (reader.Read())
{
return(model.GetModelFromReader(reader).NodeID);
}
else
{
return("");
}
}
}
/// <summary>
///添加记录
/// </summary>
/// <param name="Sensitivity"></param>
/// <returns></returns>
public int insert(M_UserPurview model)
{
return(DBCenter.Insert(model));
}
/// <summary>
///添加记录
/// </summary>
/// <param name="Sensitivity"></param>
/// <returns></returns>
public int insert(M_UserPurview model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
