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