/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int gid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_purchase_goods");
strSql.Append(" where gid=@gid ");
MySqlParameter[] parameters =
{
new MySqlParameter("@gid", MySqlDbType.Int32, 8)
};
parameters[0].Value = gid;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int shipping_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_shipping");
strSql.Append(" where shipping_id=@shipping_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@shipping_id", MySqlDbType.Int32, 3)
};
parameters[0].Value = shipping_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_progress_payments");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int invoice_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_invoices2");
strSql.Append(" where invoice_id=@invoice_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@invoice_id", MySqlDbType.Int16, 8)
};
parameters[0].Value = invoice_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_reg_extend_info");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32, 10)
};
parameters[0].Value = Id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ordergood_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_points_order_goods");
strSql.Append(" where ordergood_id=@ordergood_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ordergood_id", MySqlDbType.Int16, 8)
};
parameters[0].Value = ordergood_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int address_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_user_address");
strSql.Append(" where address_id=@address_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@address_id", MySqlDbType.Int32, 8)
};
parameters[0].Value = address_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int level_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_member_level");
strSql.Append(" where level_id=@level_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@level_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = level_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string type_no, string code_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from shop_base_code");
strSql.Append(" where type_no=@type_no and code_id=@code_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@type_no", MySqlDbType.VarChar, 2),
new MySqlParameter("@code_id", MySqlDbType.VarChar, 30)
};
parameters[0].Value = type_no;
parameters[1].Value = code_id;
return(Shop_DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
