/// <summary> /// 添加吧 /// </summary> /// <returns></returns> public static bool Add(BarModel model) { string sql = @" insert into bar (Name) values (@Name); select @@identity; "; MySqlParameter[] _parameter = { new MySqlParameter("@Name", MySqlDbType.VarChar, 100) { Value = model.Name }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); if (_ds.Tables[0].Rows.Count > 0) { model.ID = long.Parse(_ds.Tables[0].Rows[0][0].ToString()); return(true); } return(false); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static UserBarModel GetModel(string UserID, long BarID) { string sql = @" select * from user_bar where UserID=@UserID and BarID=@BarID limit 1; "; MySqlParameter[] _parameter = { new MySqlParameter("@UserID", MySqlDbType.VarChar, 36) { Value = UserID }, new MySqlParameter("@BarID", MySqlDbType.Int32) { Value = BarID }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); if (_ds.Tables[0].Rows.Count > 0) { return(CollectionHelper.CreateItem <UserBarModel>(_ds.Tables[0].Rows[0])); } return(null); }
/// <summary> /// 获取吧信息 /// </summary> /// <returns></returns> public static List <BarModel> GetList(long[] ids) { string sql = string.Format(@" select * from bar where ID in ({0}); " , string.Join(",", ids)); var _ds = DbHelperMySqlForWeiBar.Query(sql); return(CollectionHelper.ConvertTo <BarModel>(_ds.Tables[0]).ToList()); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <BarMessageModel> GetList(long BarID) { string sql = @" select * from bar_message where BarID=@BarID and Type=1 order by MessageID desc limit 50; "; MySqlParameter[] _parameter = { new MySqlParameter("@BarID", MySqlDbType.Int64) { Value = BarID }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); return(CollectionHelper.ConvertTo <BarMessageModel>(_ds.Tables[0]).ToList()); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <UserBarModel> GetListFollowed(string UserID) { string sql = @" select * from user_bar where UserID=@UserID and IsFollow=1 order by FollowTime desc; "; MySqlParameter[] _parameter = { new MySqlParameter("@UserID", MySqlDbType.VarChar, 36) { Value = UserID }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); return(CollectionHelper.ConvertTo <UserBarModel>(_ds.Tables[0]).ToList()); }
/// <summary> /// 获取吧信息 /// </summary> /// <returns></returns> public static BarModel GetModelByName(string Name) { string sql = @" select * from bar where Name=@Name limit 1; "; MySqlParameter[] _parameter = { new MySqlParameter("@Name", MySqlDbType.VarChar, 100) { Value = Name }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); if (_ds.Tables[0].Rows.Count > 0) { return(CollectionHelper.CreateItem <BarModel>(_ds.Tables[0].Rows[0])); } return(null); }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> public static AuthorizeModel GetModelByAuthID(string AuthID) { string sql = @" select * from `authorize` where `AuthID`=@AuthID limit 1; "; MySqlParameter[] _parameter = { new MySqlParameter("@AuthID", MySqlDbType.VarChar, 100) { Value = AuthID }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); if (_ds.Tables[0].Rows.Count > 0) { return(CollectionHelper.CreateItem <AuthorizeModel>(_ds.Tables[0].Rows[0])); } return(null); }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> public static UserModel GetModelByLoginKey(string loginKey) { string sql = @" select * from user where LoginKey=@loginKey limit 1; "; MySqlParameter[] _parameter = { new MySqlParameter("@loginKey", MySqlDbType.VarChar, 36) { Value = loginKey }, }; var _ds = DbHelperMySqlForWeiBar.Query(sql, _parameter); if (_ds.Tables[0].Rows.Count > 0) { return(CollectionHelper.CreateItem <UserModel>(_ds.Tables[0].Rows[0])); } return(null); }