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 save()
{
// if (!filterdata()) return false ;
try
{
if (_zuser == null || _zuser.user == null)
{
_zuser = new userinfo();
_zuser.user = new users();
_zuser.user.cardID = "空";
}
GetSplit(Checkdatashow, ref success, ref fail);
torquechecktarget tqct = new torquechecktarget()
{
wrenchID = _wrench.id.ToString(), checkDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), qaID = _zuser.user.cardID, operatorID = _juser.cardID, torqueTargetValue = _wrench.targetvalue, errorRangeMax = (_errorrangmax / 100).ToString("f0"), errorRangeMin = (_errorrangmin / 100).ToString("f0"), is_good = _wrenchisgood, guid = Guid.NewGuid().ToString(), count = _systemset.count ?? 0, arry = _systemset.arry ?? 0
};
string ttid = CheckTarget.AddReturnGuid(tqct);
List <torquecheckrecord> tc = getresult(ttid);
return(CheckTargetRecord.AddMany(tc));
}
catch {
new Exception("保存时出现异常");
return(false);
}
}
private void Button_Click_20(object sender, RoutedEventArgs e)
{
try
{
torquechecktarget t = CheckTarget.SelectByGuid("e54bd7d0-7b66-40cf-96ad-76b7cec237f3");
t.torqueTargetValue = Convert.ToDecimal(this.content.Text.Trim());
CheckTarget.Update(t);
}
catch { }
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
torquechecktarget t = new torquechecktarget()
{
wrenchID = "1",
checkDate = DateTime.Now,
qaID = "1", operatorID = "1",
torqueTargetValue = Convert.ToDecimal(32.99),
//errorRangeMax =(decimal)0.5,
//errorRangeMin =0,
is_good = true,
guid = Guid.NewGuid().ToString()
};
MessageBox.Show(CheckTarget.AddReturnGuid(t));
}
public bool Del(torquechecktarget torquechecktarget)
{
string contion = string.Format("id='{0}'", torquechecktarget.id);
return(ServerHelp.deleteDataByWhere <torquechecktarget>(_webip, contion));
}
public string AddReturnGuid(torquechecktarget checktarget)
{
return(ServerHelp.addSingleInfoReturnID <torquechecktarget>(checktarget, _webip).ToString());
}
