private void searchBtn_Click(object sender, RoutedEventArgs e) { try { CheckStateDB(); if (string.IsNullOrEmpty(this.searchQuery.Text) || string.IsNullOrWhiteSpace(this.searchQuery.Text) == false) { if (this.searchQuery.Text.Contains('-')) { String[] order = this.searchQuery.Text.Split('-'); String sql_data = "SELECT rowid, customerId, finishDate, recordDate, productId, year, receiveNumber FROM command_card WHERE rowid REGEXP @id AND year REGEXP @year"; cmd = new MySqlCommand(sql_data, conn); cmd.Parameters.AddWithValue("@id", order[1].TrimStart('0')); cmd.Parameters.AddWithValue("@year", order[0]); reader = cmd.ExecuteReader(); CommandList ses = new CommandList(); if (reader.HasRows == false) { MessageBox.Show("ไม่พบข้อมูล Job ที่ค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); terminater = true; } List <String> orderNumber = new List <String>(); List <String> receiveNumber = new List <String>(); List <String> recordDate = new List <String>(); List <String> finishDate = new List <String>(); List <String> customerId = new List <String>(); List <String> productId = new List <String>(); while (reader.Read()) { orderNumber.Add(reader.GetString("year") + "-" + reader.GetString("rowid").PadLeft(4, '0')); receiveNumber.Add(reader.GetString("receiveNumber")); recordDate.Add(reader.GetString("recordDate")); finishDate.Add(reader.GetString("finishDate")); customerId.Add(reader.GetString("customerId")); productId.Add(reader.GetString("productId")); } reader.Close(); for (int i = 0; i < orderNumber.Count(); i++) { ses.commandLst.Items.Add(new { Col1 = orderNumber[i], Col2 = receiveNumber[i], Col3 = recordDate[i], Col4 = finishDate[i], Col5 = ResolveCustomerName(customerId[i]), Col6 = ResolveProductName(productId[i]) }); } if (terminater == false) { this.Close(); ses.Show(); } } else { MessageBox.Show("ไม่พบข้อมูล Job ที่ค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("กรุณากรอกลำดับสั่งในช่องค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } } catch (Exception ex) { ErrorLogCreate(ex); MessageBox.Show("เกิดข้อผิดพลาด ข้อมูล error บันทึกอยู่ในไฟล์ log กรุณาแจ้งข้อมูลดังกล่าวแก่ทีมติดตั้ง" , "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void searchBtn_Click(object sender, RoutedEventArgs e) { try { CheckStateDB(); if (string.IsNullOrEmpty(this.searchQuery.Text) || string.IsNullOrWhiteSpace(this.searchQuery.Text) == false) { if (this.searchQuery.Text.Contains('-')) { String[] order = this.searchQuery.Text.Split('-'); String sql_data = "SELECT rowid, customerId, finishDate, recordDate, productId, year, receiveNumber FROM command_card WHERE rowid REGEXP @id AND year REGEXP @year"; cmd = new MySqlCommand(sql_data, conn); cmd.Parameters.AddWithValue("@id", order[1].TrimStart('0')); cmd.Parameters.AddWithValue("@year", order[0]); reader = cmd.ExecuteReader(); CommandList ses = new CommandList(); if (reader.HasRows == false) { MessageBox.Show("ไม่พบข้อมูล Job ที่ค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); terminater = true; } List<String> orderNumber = new List<String>(); List<String> receiveNumber = new List<String>(); List<String> recordDate = new List<String>(); List<String> finishDate = new List<String>(); List<String> customerId = new List<String>(); List<String> productId = new List<String>(); while (reader.Read()) { orderNumber.Add(reader.GetString("year") + "-" + reader.GetString("rowid").PadLeft(4, '0')); receiveNumber.Add(reader.GetString("receiveNumber")); recordDate.Add(reader.GetString("recordDate")); finishDate.Add(reader.GetString("finishDate")); customerId.Add(reader.GetString("customerId")); productId.Add(reader.GetString("productId")); } reader.Close(); for (int i = 0; i < orderNumber.Count(); i++) { ses.commandLst.Items.Add(new { Col1 = orderNumber[i], Col2 = receiveNumber[i], Col3 = recordDate[i], Col4 = finishDate[i], Col5 = ResolveCustomerName(customerId[i]), Col6 = ResolveProductName(productId[i]) }); } if (terminater == false) { this.Close(); ses.Show(); } } else { MessageBox.Show("ไม่พบข้อมูล Job ที่ค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("กรุณากรอกลำดับสั่งในช่องค้นหา", "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } } catch (Exception ex) { ErrorLogCreate(ex); MessageBox.Show("เกิดข้อผิดพลาด ข้อมูล error บันทึกอยู่ในไฟล์ log กรุณาแจ้งข้อมูลดังกล่าวแก่ทีมติดตั้ง" , "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } }