private bool UpdateMarkDataInfo(MarkDataInfo dataInfo)
{
string sqlCmd = "update ";
sqlCmd += _tableName;
sqlCmd += " set MarkInfo='" + dataInfo.MarksToString() +
"', Time=datetime('now','localtime') where ";
sqlCmd += "Product='" + dataInfo.ProductName + "' ";
sqlCmd += "and Batch='" + dataInfo.BatchName + "' ";
sqlCmd += "and Board='" + dataInfo.BoardName + "' ";
sqlCmd += "and Side='" + dataInfo.SideName + "' ";
sqlCmd += "and Shot='" + dataInfo.ShotName + "' ";
sqlCmd += "and Defect='" + dataInfo.DefectName + "';";
return(SqliteCMD(sqlCmd));
}
private bool InsertMarkDataInfo(MarkDataInfo dataInfo)
{
string sqlCmd = "insert into ";
sqlCmd += _tableName;
sqlCmd += " (Product, Batch, Board, Side, Shot, Defect, MarkInfo)";
sqlCmd += " values(";
sqlCmd += "'" + dataInfo.ProductName + "', ";
sqlCmd += "'" + dataInfo.BatchName + "', ";
sqlCmd += "'" + dataInfo.BoardName + "', ";
sqlCmd += "'" + dataInfo.SideName + "', ";
sqlCmd += "'" + dataInfo.ShotName + "', ";
sqlCmd += "'" + dataInfo.DefectName + "', ";
sqlCmd += "'" + dataInfo.MarksToString() + "'";
sqlCmd += ");";
return(SqliteCMD(sqlCmd));
}