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