/// <summary>
/// 更新一条数据
/// Author 2015-08-11
/// </summary>
public bool Update(object tran, RoleModuleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RoleModule set ");
strSql.Append("RoleID=@RoleID,");
strSql.Append("ModID=@ModID");
strSql.Append(" where RoleID=@RoleID and ModID=@ModID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@ModID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.ModID;
int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// Author 2015-08-11
/// </summary>
public bool Add(object tran, RoleModuleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RoleModule(");
strSql.Append("RoleID,ModID");
strSql.Append(") values (");
strSql.Append("@RoleID,@ModID");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@ModID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.ModID;
int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// Author 2015-08-11
/// </summary>
public RoleModuleInfo GetModel(object tran, int RoleID, int ModID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RoleID,ModID ");
strSql.Append(" from RoleModule ");
strSql.Append(" where RoleID=@RoleID and ModID=@ModID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@ModID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
parameters[1].Value = ModID;
RoleModuleInfo model = new RoleModuleInfo();
DataSet ds = SQLHelper.GetDataSet((SqlTransaction)tran, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["ModID"].ToString() != "")
{
model.ModID = int.Parse(ds.Tables[0].Rows[0]["ModID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// Author 2015-08-11
/// </summary>
public bool Update(object tran, RoleModuleInfo model)
{
return(dal.Update(tran, model));
}
/// <summary>
/// 增加一条数据
/// Author 2015-08-11
/// </summary>
public bool Add(object tran, RoleModuleInfo model)
{
return(dal.Add(tran, model));
}
/// <summary>
/// 分配菜单和按钮权限
/// pxd 2015-10-19
/// </summary>
/// <param name="roleID"></param>
/// <param name="modID"></param>
/// <param name="mbID"></param>
/// <returns></returns>
public string Allot(int roleID, List <int> modID, List <string> mbID)
{
string strReturn = "";
Transaction transaction = new Transaction();
object tran = transaction.CreatTransaction();
try
{
//判断存在角色菜单权限则先删除
if (new RoleModule().ExistsByRoleID(tran, roleID))
{
if (!new RoleModule().DeleteByRoleID(tran, roleID))
{
throw new Exception("删除角色菜单权限失败！");
}
}
//判断存在角色按钮权限则先删除
if (new RoleModButton().ExistsByRoleID(tran, roleID))
{
if (!new RoleModButton().DeleteByRoleID(tran, roleID))
{
throw new Exception("删除角色菜单权限失败！");
}
}
//添加角色菜单权限
if (modID != null)
{
for (int i = 0; i < modID.Count; i++)
{
RoleModuleInfo model = new RoleModuleInfo()
{
RoleID = roleID,
ModID = modID[i],
};
if (!Add(tran, model))
{
throw new Exception("添加角色菜单权限失败！");
}
}
}
//添加角色按钮权限
if (mbID != null)
{
RoleModButtonInfo model = new RoleModButtonInfo();
model.RoleID = roleID;
for (int i = 0; i < mbID.Count; i++)
{
string [] mbID_Arr = mbID[i].Split(new char[] { ',' });
model.ModID = int.Parse(mbID_Arr[0]);
model.BtnID = int.Parse(mbID_Arr[1]);
if (!new RoleModButton().Add(tran, model))
{
throw new Exception("添加角色按钮权限失败！");
}
}
}
transaction.Commit(tran);
}
catch (Exception ex)
{
transaction.Rollback(tran);
strReturn = new Tools().GetErrorInfo(ex);
}
return(strReturn);
}
