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