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