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