/// <summary>
/// 判断用户名是否存在
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public userinfo isHaveThisUserName(string UserName)
{
MySqlParameter[] mySqlParameter = { new MySqlParameter("@username", UserName) };
string sql = @"SELECT username,id,nicheng,zhuceshijian,xiugaishijian,touxiangurl FROM boke.userinfo where username=@username and isdel=0";
DataTable dt = MySqlHelpers.ExecuteQuery(sql, mySqlParameter);
if (dt.Rows.Count == 1)
{
return(DataToEnity <userinfo> .DataRowToEntity(dt.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 查询数据
/// </summary>
/// <param name="sql"></param>
/// <param name="mySqlParameters"></param>
/// <returns></returns>
public DataTable testlogin(string sql, MySqlParameter[] mySqlParameters)
{
return(MySqlHelpers.ExecuteQuery(sql, mySqlParameters));
}