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