/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int sr_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from sr_info");
strSql.Append(" where sr_id=@sr_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@sr_id", MySqlDbType.Int32, 32)
};
parameters[0].Value = sr_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int type_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from material_type");
strSql.Append(" where type_id=@type_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@type_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = type_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int out_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from out_storage");
strSql.Append(" where out_id=@out_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@out_id", MySqlDbType.Int32, 128)
};
parameters[0].Value = out_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from c_stock_code");
strSql.Append(" where ");
strSql.Append(" id = @id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
public bool Exists(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from User");
strSql.Append(" where ");
strSql.Append(" name = @name ");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 255)
};
parameters[0].Value = name;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string key)
{
string sSql = "SELECT COUNT(1) from UserMst WHERE Phone = '" + key + "' OR UserID='" + key + "'";
return(DbHelperMySQL.Exists(sSql));
}
