/// <summary>
///
/// </summary>
private void RunWorkingDatabase(string fullPath)
{
//string strSQL = $"SELECT TOP 1 * FROM PTS_HEADER WHERE EndDateTime >= #1/7/2017# ORDER BY EndDateTime DESC";
string strSQL = $"SELECT TOP 1 * FROM PTS_HEADER WHERE EndDateTime >= #{DateTime.Now.Date}# ORDER BY EndDateTime DESC";
OleDbConnection myConn = OpenConnection(fullPath);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "PTS_HEADER");
DataTable dTable = dtSet.Tables[0];
List <Item> items = new List <Item>();
if (dTable.Rows.Count > 0)
{
var item = new Item()
{
BoardNo = dTable.Rows[0]["Serial"].ToString(),
Model = dTable.Rows[0]["Model"].ToString(),
Result = int.Parse(dTable.Rows[0]["Result"].ToString()),
EndDateTime = DateTime.Parse(dTable.Rows[0]["EndDateTime"].ToString())
};
if (item != null)
{
//string currentModel = cboModel.SelectedValue.ToString();
//if (currentModel == "ZSFLD22_REV5")
//{
// currentModel = "ZSFLD22IA";
//}
//if (item.Model == currentModel)
//{
items.Add(item);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = items;
if (item.Result == 1)
{
pass = pass + 1;
lblPASS.Text = pass.ToString();
SuccessMessage("OK", $"Board [{item.BoardNo}] OK!");
}
if (item.Result == 0)
{
ng = ng + 1;
lblNG.Text = ng.ToString();
ErrorMessage("NG", $"Board [{item.BoardNo}] NG!");
}
total = pass + ng;
lblTotal.Text = total.ToString();
lblAdd.Enabled = true;
Ultils.CreateFileLog(item.Model, item.BoardNo, item.Status, stationNo, DateTime.Now.ToString("yyMMddHHmmss"));
//}
//else
//{
// ErrorMessage("NG", $"Sai Model. Vui lòng chọn lại Model cho chính xác." +
// $"\nBoard [{item.BoardNo}] NG!" +
// $"\nModel: {item.Model}");
//}
}
}
else
{
lblStatusMessage.Visible = true;
lblStatusMessage.Text = "Check local format time!";
ErrorMessage("NG", "Check local format time!");
}
CloseConnection(fullPath);
}
