private void sıralıYazdırmaToolStripMenuItem_Click(object sender, EventArgs e) { try { using (MB_NEW.Modals.SearchWithBarcodeModal ara = new MB_NEW.Modals.SearchWithBarcodeModal()) { if (ara.ShowDialog() == DialogResult.OK) { ; int len_ = ara.allRecords.Length; if (len_ > 0) { search_text = " ITEMS.LOGICALREF IN ("; for (int i = 0; i < len_; i++) { search_text += "\'" + ara.allRecords[i].item_id.ToString() + "\'"; } string in_text = ""; string in_order = "CASE ITEMS.LOGICALREF "; galyndy_query = "CASE ITEMS.LOGICALREF "; for (int i = 0; i < len_; i++) { if (i != 0) { in_text += ", "; } in_order += "WHEN '" + ara.allRecords[i].item_id + "' THEN " + ara.allRecords[i].order + " "; galyndy_query += "WHEN '" + ara.allRecords[i].item_id + "' THEN " + ara.allRecords[i].galyndy + " "; in_text += "'" + ara.allRecords[i].item_id + "'"; } galyndy_query += " END GALYNDY "; if (in_text != "") { search_text = " AND ITEMS.LOGICALREF IN(" + in_text + ") ORDER BY " + in_order + " END"; } else { search_text = " AND ITEMS.LOGICALREF IN(-1)"; } getData(); } } } } catch (Exception ex) { MB_NEW.Log.set("HATA: BarcodeForm>BarcodeReturn\nEXCEPTION:" + ex.ToString()); MessageBox.Show("Hata oluştu. Programı yeniden başlatin.\n\n", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void sıralıYazdırmaToolStripMenuItem_Click(object sender, EventArgs e) { try { using (MB_NEW.Modals.SearchWithBarcodeModal ara = new MB_NEW.Modals.SearchWithBarcodeModal()) { if (ara.ShowDialog() == DialogResult.OK) { //GET VALUE barcodes = ara.barcodes; int len_ = barcodes.Length; if (len_ > 0) { search_text = ""; string in_text = ""; string in_order = "CASE BARCODE "; for (int i = 0; i < len_; i++) { if (i != 0) { in_text += ", "; } in_order += "WHEN '" + barcodes[i] + "' THEN " + (i + 1).ToString() + " "; in_text += "'" + barcodes[i] + "'"; } sql = "SELECT ITEMREF FROM LG_" + Int32.Parse(SettingsConf.tiger_firma_num).ToString("000") + "_UNITBARCODE WHERE BARCODE IN(" + in_text + ") ORDER BY " + in_order + " END"; // richTextBox1.Text = (sql); SqlConnection bag = new SqlConnection(@"server=" + SettingsConf.server_name + ";Initial Catalog=" + SettingsConf.tiger_firma_database_name + "; User ID=" + SettingsConf.server_user_name + "; Password="******";"); bag.Open(); SqlCommand cmdepo = new SqlCommand(sql, bag); SqlDataReader rs = cmdepo.ExecuteReader(); List <string> log_ref = new List <string>(); while (rs.Read()) { log_ref.Add(rs[0].ToString()); } bag.Close(); // hakyky sql ucin in_text = ""; in_order = "CASE ITEMS.LOGICALREF "; len_ = log_ref.Count(); for (int i = 0; i < len_; i++) { if (i != 0) { in_text += ", "; } in_order += "WHEN '" + log_ref[i] + "' THEN " + (i + 1).ToString() + " "; in_text += "'" + log_ref[i] + "'"; } if (in_text != "") { search_text = " AND ITEMS.LOGICALREF IN(" + in_text + ")"; orderbytext = " ORDER BY " + in_order + " END "; } else { search_text = " AND ITEMS.LOGICALREF IN(-1)"; orderbytext = ""; } getData(); } } } } catch (Exception ex) { Log.set("HATA: PriceForm>BarcodeReturn\nEXCEPTION:" + ex.ToString()); MessageBox.Show("Hata oluştu. Programı yeniden başlatin.\n\n", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); } }