private void QuerybyCondition()
{
try
{
CheckStateDB();
CultureInfo ci = new CultureInfo("en-US");
String start = "", end = "";
String[] dataSet = new String[4];
String runYear = this.runNumberYear.Text, runNo = this.runNumberNo.Text;
if (this.startDate.SelectedDate != null)
{
DateTime startTime = (DateTime)this.startDate.SelectedDate;
start = startTime.ToString("dd/MM/yyyy", ci);
dataSet[0] = start;
}
if (this.finishDate.SelectedDate != null)
{
DateTime finishTime = (DateTime)this.finishDate.SelectedDate;
end = finishTime.ToString("dd/MM/yyyy", ci);
dataSet[1] = end;
}
if ((string.IsNullOrWhiteSpace(runYear) && string.IsNullOrWhiteSpace(runNo)) == false)
{
dataSet[2] = runYear;
dataSet[3] = runNo.TrimStart('0');
}
String sqlGet = "SELECT rowid, year, finishDate, recordDate, customerId, productId FROM command_card WHERE ";
String[] searchSet = { "recordDate=@recordDate", "finishDate=@finishDate", "year=@year", "rowid=@rowid" };
String[] paramList = { "@recordDate", "@finishDate", "@year", "@rowid" };
String[] paramIn = new String[4];
String part = "";
if (dataSet.Length > 0)
{
for (int i = 0; i < dataSet.Length; i++)
{
if (string.IsNullOrWhiteSpace(dataSet[i]) == false)
{
part += searchSet[i];
paramIn[i] = paramList[i];
part += " ";
}
}
part = part.TrimEnd(' ');
part = part.Replace(" ", " AND ");
sqlGet += part;
cmd = new MySqlCommand(sqlGet, conn);
for (int j = 0; j < paramList.Length; j++)
{
if (string.IsNullOrWhiteSpace(paramIn[j]) == false)
{
cmd.Parameters.AddWithValue(paramIn[j], dataSet[j]);
}
}
reader = cmd.ExecuteReader();
String currentDate = DateTime.Now.ToString("dd/MM/yyyy", ci);
String jobNo = "";
String jobProduct = "";
ArrayList product = new ArrayList();
String jobCustomer = "";
ArrayList customer = new ArrayList();
String jobStart = "";
String JobEnd = "";
while (reader.Read())
{
jobNo += reader.GetString("year") +"-" +reader.GetString("rowid").PadLeft(5, '0') + " \n ";
product.Add(reader.GetString("productId"));
customer.Add(reader.GetString("customerId"));
jobStart += reader.GetString("recordDate") + " \n ";
JobEnd += reader.GetString("finishDate") + " \n ";
}
reader.Close();
for (int i = 0; i < product.Count; i++)
{
jobProduct += GetProductName((String)product[i]) + "\n";
jobCustomer += GetCustomerName((String)customer[i]) + "\n";
}
String[] jobData = { jobNo, jobProduct, jobCustomer, jobStart, JobEnd};
Application.Current.Properties["dataTable"] = jobData;
TotalDataPreview ses = new TotalDataPreview();
ses.Show();
}
else
{
throw new Exception("No choice was selected!");
}
}
catch (Exception ee)
{
ErrorLogCreate(ee);
MessageBox.Show("ไม่มีการเลือกคำค้นหา", "ข้อผิดพลาด");
}
}
private void QuerybyCondition()
{
try
{
CheckStateDB();
CultureInfo ci = new CultureInfo("en-US");
String start = "", end = "";
String[] dataSet = new String[4];
String runYear = this.runNumberYear.Text, runNo = this.runNumberNo.Text;
if (this.startDate.SelectedDate != null)
{
DateTime startTime = (DateTime)this.startDate.SelectedDate;
start = startTime.ToString("dd/MM/yyyy", ci);
dataSet[0] = start;
}
if (this.finishDate.SelectedDate != null)
{
DateTime finishTime = (DateTime)this.finishDate.SelectedDate;
end = finishTime.ToString("dd/MM/yyyy", ci);
dataSet[1] = end;
}
if ((string.IsNullOrWhiteSpace(runYear) && string.IsNullOrWhiteSpace(runNo)) == false)
{
dataSet[2] = runYear;
dataSet[3] = runNo.TrimStart('0');
}
String sqlGet = "SELECT rowid, year, finishDate, recordDate, customerId, productId FROM command_card WHERE ";
String[] searchSet = { "recordDate=@recordDate", "finishDate=@finishDate", "year=@year", "rowid=@rowid" };
String[] paramList = { "@recordDate", "@finishDate", "@year", "@rowid" };
String[] paramIn = new String[4];
String part = "";
if (dataSet.Length > 0)
{
for (int i = 0; i < dataSet.Length; i++)
{
if (string.IsNullOrWhiteSpace(dataSet[i]) == false)
{
part += searchSet[i];
paramIn[i] = paramList[i];
part += " ";
}
}
part = part.TrimEnd(' ');
part = part.Replace(" ", " AND ");
sqlGet += part;
cmd = new MySqlCommand(sqlGet, conn);
for (int j = 0; j < paramList.Length; j++)
{
if (string.IsNullOrWhiteSpace(paramIn[j]) == false)
{
cmd.Parameters.AddWithValue(paramIn[j], dataSet[j]);
}
}
reader = cmd.ExecuteReader();
String currentDate = DateTime.Now.ToString("dd/MM/yyyy", ci);
String jobNo = "";
String jobProduct = "";
ArrayList product = new ArrayList();
String jobCustomer = "";
ArrayList customer = new ArrayList();
String jobStart = "";
String JobEnd = "";
while (reader.Read())
{
jobNo += reader.GetString("year") + "-" + reader.GetString("rowid").PadLeft(5, '0') + " \n ";
product.Add(reader.GetString("productId"));
customer.Add(reader.GetString("customerId"));
jobStart += reader.GetString("recordDate") + " \n ";
JobEnd += reader.GetString("finishDate") + " \n ";
}
reader.Close();
for (int i = 0; i < product.Count; i++)
{
jobProduct += GetProductName((String)product[i]) + "\n";
jobCustomer += GetCustomerName((String)customer[i]) + "\n";
}
String[] jobData = { jobNo, jobProduct, jobCustomer, jobStart, JobEnd };
Application.Current.Properties["dataTable"] = jobData;
TotalDataPreview ses = new TotalDataPreview();
ses.Show();
}
else
{
throw new Exception("No choice was selected!");
}
}
catch (Exception ee)
{
ErrorLogCreate(ee);
MessageBox.Show("ไม่มีการเลือกคำค้นหา", "ข้อผิดพลาด");
}
}