public string AddReturnGuid(Model.torquechecktarget torquechecktarget)
{
try
{
string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
torquechecktarget.wrenchID = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()",
torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
return(ds.ToString());
}
catch
{
return("-1");
}
}
public bool Update(Model.torquechecktarget torquechecktarget)
{
string tableName = typeof(torquechecktarget).Name;
string contion = string.Format("guid='{0}'", torquechecktarget.guid);
string sql = string.Format("wrenchID_id='{0}',checkDate='{1}',qaID='{2}',operatorID='{3}',torqueTargetValue='{4}',errorRangeMax='{5}',is_good='{6}',comment='{7}',errorRangeMin='{8}'", torquechecktarget.wrenchID, Convert.ToDateTime(torquechecktarget.checkDate), torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.is_good?1:0, torquechecktarget.comment, torquechecktarget.errorRangeMin);
return(ServerHelp.updateByWhere(tableName, _webip, contion, sql));
}
public bool Update(Model.torquechecktarget torquechecktarget)
{
try
{
string contion = string.Format("where guid='{0}'", torquechecktarget.guid);
string strsql = string.Format("wrenchID_id='{0}',checkDate='{1}',qaID='{2}',operatorID='{3}',torqueTargetValue='{4}',errorRangeMax='{5}',is_good='{6}',comment='{7}',errorRangeMin='{8}'", torquechecktarget.wrenchID, Convert.ToDateTime(torquechecktarget.checkDate), torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.is_good ? 1 : 0, torquechecktarget.comment, torquechecktarget.errorRangeMin);
string sql = "update torquechecktarget set " + strsql + contion;
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch { return(false); }
}
public bool Del(Model.torquechecktarget torquechecktarget)
{
throw new NotImplementedException();
}
