public void showOnDisplay() // Выводим отчет на экран { string nsql = "SELECT ori.`product_ean`'EAN',ori.`manufacturer_code`'PAN',pr.`name_ru-RU` 'Наименование',ori.`product_quantity` 'Количество' FROM `ishp_jshopping_order_item` ori,`ishp_jshopping_products` pr WHERE ori.`product_id`=pr.`product_id` AND ori.`order_id`=@orid"; StatFormClickID sfc = new StatFormClickID(cn, "Результат поиска", dtResult, new string[] { "order_id" }, nsql, "@orid", "order_id", new string[] { }, "Состав заказа"); sfc.ShowDialog(); }
/* * public result searchByTemplate() * { * if (name == "") { dtToTemplateSearch = null; return new result(401, "Не задан шаблон имени для поиска"); } * sql = "SELECT * FROM supplier WHERE name LIKE '" + name + "'"; * dtToTemplateSearch = SQL.ExecuteReader(sql); * return new result(0, "Поиск выполнен"); * } * public DataTable getDtForTemplateSearch() { return dtToTemplateSearch; } * */ public result searchByEAN() { string cond = ""; sql = "SELECT sly.`id`,sly.`date` 'Дата поставки',sers.`name` 'Наименование поставщика' ,sers.`ogrn` 'ОГРН', sel.`quantity` 'Количество товара в поставке' FROM `supply_elements` sel,`supply` sly,`suppliers` sers,`ishp_jshopping_products` pr WHERE sers.`id` = sly.`supplier` AND pr.`product_id` = sel.`product` AND sel.`supply`=sly.`id` AND pr.`product_ean` = @ean"; SQL.clearParam(); SQL.addParam("@ean", EAN); if (withDate) { cond += "AND sly.`date` between @from AND @to"; SQL.addParam("@from", from.ToString("yyyy-MM-dd") + " 00:00:00"); SQL.addParam("@to", to.ToString("yyyy-MM-dd") + " 23:59:59"); } if (OGRN != "") { cond += " AND sers.`ogrn` = @ogrn"; SQL.addParam("@ogrn", OGRN); } if (INN != "") { cond += " AND sers.`inn` = @inn"; SQL.addParam("@inn", INN); } if (cond != "") { sql += cond; } dtSearchResult = SQL.ExecuteReader(sql); if (dtSearchResult.Rows.Count == 0) { return(new result(402, "Поиск не дал результатов")); } //StatForm sf = new StatForm("Поставки", dtSearchResult,new string[]{"id"}); string nsql = "SELECT pr.`product_ean`'EAN',pr.`name_ru-RU`'Наименование',se.`quantity`'Количество' FROM `supply_elements` se,`ishp_jshopping_products` pr WHERE se.`product`=pr.`product_id` AND se.`supply`=@supl"; StatFormClickID sf = new StatFormClickID(cn, "Результат поиска поставок", dtSearchResult, new string[] { "id" }, nsql, "@supl", "id", new string[] { }, "Состав поставки"); sf.ShowDialog(); return(new result(0, "Поиск поставок выполнен")); }
public result searchSupply() { string condSupplier = ""; // Условие поиска поставщика string cond = ""; sql = "SELECT sl.`id`,sp.`ogrn` 'ОГРН',sp.`name` 'Поставщик',sl.`date` 'Дата поставки' FROM supply sl, suppliers sp"; bool and = false; string sAND = " AND "; SQL.clearParam(); if (INN != "") { condSupplier = "sp.`inn`=@inn"; SQL.addParam("@inn", INN); and = true; } if (OGRN != "") { if (and) { condSupplier += sAND; } condSupplier += "sp.`ogrn`=@ogrn"; SQL.addParam("@ogrn", OGRN); and = true; } if (name != "") { if (and) { condSupplier += sAND; } condSupplier += "sp.`name` LIKE '" + name + "'"; and = true; } if (withDate) { if (and) { cond += sAND; } cond += "sl.`date` between @from AND @to"; SQL.addParam("@from", from.ToString("yyyy-MM-dd") + " 00:00:00"); SQL.addParam("@to", to.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " WHERE sl.`supplier`=sp.`id`"; if (condSupplier != "") { sql += " AND "; sql += condSupplier; } if (cond != "") { sql += " AND "; sql += cond; } dtSearchResult = SQL.ExecuteReader(sql); if (dtSearchResult.Rows.Count == 0) { return(new result(402, "Поиск не дал результатов")); } //StatForm sf = new StatForm("Поставки", dtSearchResult,new string[]{"id"}); string nsql = "SELECT pr.`product_ean`'EAN',pr.`name_ru-RU`'Наименование',se.`quantity`'Количество' FROM `supply_elements` se,`ishp_jshopping_products` pr WHERE se.`product`=pr.`product_id` AND se.`supply`=@supl"; StatFormClickID sf = new StatFormClickID(cn, "Результат поиска поставок", dtSearchResult, new string[] { "id" }, nsql, "@supl", "id", new string[] { }, "Состав поставки"); sf.ShowDialog(); return(new result(0, "Поиск поставок выполнен")); }