/// <summary>
/// 删
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public bool DeleteRoleusers(RoleusersModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from Roleusers where 1=1 ");
sb.Append("and RUID=@RUID ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@RUID", model.RUID));
int res = Base.MySQLHelper.MySQLNonQuery(sb.ToString(), pms);
return(res > 0);
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public RoleusersModel GetRoleusersInfo(RoleusersModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from Roleusers where 1=1 ");
sb.Append("and RUID=@RUID ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@RUID", model.RUID));
DataTable dt = Base.MySQLHelper.MySQLQueryTab(sb.ToString(), pms);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
return(new RoleusersModel(dt.Rows[0]));
}
/// <summary>
/// 增
/// </summary>
/// <param name="model">new model</param>
/// <returns></returns>
public bool AddRoleusers(RoleusersModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into Roleusers ( ");
sb.Append("RUID,RoleID,UserID");
sb.Append(") values ( ");
sb.Append("@RUID,@RoleID,@UserID");
sb.Append(") ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@RUID", model.RUID));
pms.Add(new MySqlParameter("@RoleID", model.RoleID));
pms.Add(new MySqlParameter("@UserID", model.UserID));
int res = Base.MySQLHelper.MySQLNonQuery(sb.ToString(), pms);
return(res > 0);
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public static RoleusersModel GetRoleusersInfo(RoleusersModel model)
{
return(Common.Instance._Roleusers.GetRoleusersInfo(model));
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool DeleteRoleusers(RoleusersModel model)
{
return(Common.Instance._Roleusers.DeleteRoleusers(model));
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddRoleusers(RoleusersModel model)
{
return(Common.Instance._Roleusers.AddRoleusers(model));
}
