/// <summary>
/// 判断好友存在
/// </summary>
/// <param name="u_id"></param>
/// <param name="f_id"></param>
/// <returns></returns>
public bool ExistFriend(int u_id, int f_id)
{
string text = "select count(1) as num from friend where u_id =:u_id and f_id=:f_id";
Model.User user = new service.Model.User();
OracleParameter[] pars = new OracleParameter[]
{
new OracleParameter("u_id", u_id),
new OracleParameter("f_id", f_id)
};
OracleDataReader odr = OracleHelper.QueryMore(text, pars);
if (odr.HasRows)
{
while (odr.Read())
{
if (int.Parse(odr["num"].ToString()) == 1)
{
odr.Close();
return(true);
}
}
}
odr.Close();
return(false);
}
/// <summary>
/// 判断用户存在
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public bool ExistUser(string name)
{
string text = "select count(1) as num from tb_user where u_name =:name";
Model.User user = new service.Model.User();
OracleParameter[] pars = new OracleParameter[]
{
new OracleParameter("name", name)
};
OracleDataReader odr = OracleHelper.QueryMore(text, pars);
if (odr.HasRows)
{
while (odr.Read())
{
if (int.Parse(odr["num"].ToString()) == 1)
{
odr.Close();
return(true);
}
}
}
odr.Close();
return(false);
}
/// <summary>
/// 添加用户 1成功 0失败
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public int AddUser(service.Model.User u)
{
return(user.AddUser(u));
}