public bool AddNotReturn(Model.torquecheckrecord checkrecord)
{
try
{
string sqldep = string.Format("select * from torquechecktarget where id='{0}'", checkrecord.TorqueCheckTargetID);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
torquechecktarget dep = DataTableToList.GetList <torquechecktarget>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
checkrecord.TorqueCheckTargetID = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO torquecheckrecord(TorqueCheckTargetID_id,TesterID,errorRangeMax,errorRangeMin,analyserValue,torqueTargetValue,checkTime,passedFlag,isEffective,isTurn,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()",
checkrecord.TorqueCheckTargetID, checkrecord.TesterID, checkrecord.errorRangeMax, checkrecord.errorRangeMin, checkrecord.analyserValue, checkrecord.torqueTargetValue, checkrecord.checkTime, checkrecord.passedFlag == true ? 1 : 0, checkrecord.isEffective == true ? 1 : 0, checkrecord.isTurn == true ? 1 : 0, checkrecord.comment, checkrecord.guid
);
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool Del(Model.torquecheckrecord checkrecord)
{
throw new NotImplementedException();
}
public string AddReturnGuid(Model.torquecheckrecord torquecheckrecord)
{
return(ServerHelp.addSingleInfoReturnID <torquecheckrecord>(torquecheckrecord, _webip).ToString());
}
