public int InsertNewProduct(
string ID,
string ModelName,
DateTime Time,
string SN,
string RunningMode,
string VIResult
)
{
Table.Result resultTbl = new Table.Result();
string cmd = string.Format("INSERT INTO {0} ({1}) values({2});",
resultTbl.TableName,
// --------------
resultTbl.ID + "," +
resultTbl.ModelName + "," +
resultTbl.LoadTime + "," +
resultTbl.SN + "," +
resultTbl.RunningMode + "," +
resultTbl.VIResult,
//--------------
"\'" + ID + "\'," +
"\'" + ModelName + "\'," +
"\'" + Time.ToString("yyyy-MM-dd HH:mm:ss") + "\'," +
"\'" + SN + "\'," +
"\'" + RunningMode + "\'," +
"\'" + VIResult + "\'"
);
return(mCtl.ExecuteCmd(mConn, cmd));
}
public void InitResultTbl()
{
Table.Result resultTbl = new Table.Result();
string cmd = string.Format("CREATE TABLE IF NOT EXISTS {0} ({1});",
resultTbl.TableName,
resultTbl.ID + " TEXT PRIMARY KEY," +
resultTbl.ModelName + " TEXT," +
resultTbl.LoadTime + " TEXT," +
resultTbl.SN + " TEXT," +
resultTbl.RunningMode + " TEXT," +
resultTbl.VIResult + " TEXT"
);
mCtl.ExecuteCmd(mConn, cmd);
}
public int CountFail(string ModelName, DateTime StartTime, DateTime EndTime)
{
Table.Result resultTbl = new Table.Result();
string stTime = StartTime.ToString("yyyy-MM-dd HH:mm:ss");
string endTime = EndTime.ToString("yyyy-MM-dd HH:mm:ss");
string cmd = string.Format("Select count({0}) from {1} where {2} and {3} and {4} and {5};",
resultTbl.ID,
resultTbl.TableName,
resultTbl.ModelName + "=\'" + ModelName + "\'",
resultTbl.LoadTime + ">\'" + stTime + "\'",
resultTbl.LoadTime + "<=\'" + endTime + "\'",
resultTbl.VIResult + "=\'FAIL\'"
);
object count = mCtl.ExecuteScalarCmd(mConn, cmd);
return(Convert.ToInt32(count));
}
public string[] GetModelName()
{
List <string> modelNames = new List <string>();
Table.Result resultTbl = new Table.Result();
string cmd = string.Format("SELECT {0} from {1};",
resultTbl.ModelName,
resultTbl.TableName);
var reader = mCtl.ExecuteReader(mConn, cmd);
for (int i = 0; i < reader.Count; i++)
{
Dictionary <string, object> item = (Dictionary <string, object>)reader[i];
string modelName = (string)item[resultTbl.ModelName];
if (!modelNames.Contains(modelName))
{
modelNames.Add(modelName);
}
}
return(modelNames.ToArray());
}
