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