/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string username)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_users");
strSql.Append(" where username=@username");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.VarChar, 50)
};
parameters[0].Value = username;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string empid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from r_jshz");
strSql.Append(" where empid=@empid");
SqlParameter[] parameters =
{
new SqlParameter("@empid", SqlDbType.VarChar, 50)
};
parameters[0].Value = empid;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_users");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
return(DbHelperSql.Exists(strSql.ToString(), parameters));
}
