public bool updata(Model.wrench wrenchtool)
{
string tablename = typeof(wrench).Name;
string contion = string.Format("guid='{0}'", wrenchtool.guid);
string updatestr = string.Format(
"wrenchCode='{0}',wrenchBarCode='{1}',rangeMin='{2}',rangeMax='{3}',factory='{4}',species_id='{5}',status_id='{6}',comment='{7}',targetvalue='{8}',unit='{9}',isallowcheck={10},cycletime={11},createDate='{12}' , targetvalue1='{13}',targetvalue2='{14}' , lastrepair='{15}'", wrenchtool.wrenchCode
, wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.species, wrenchtool.status, wrenchtool.comment, wrenchtool.targetvalue, wrenchtool.unit, wrenchtool.isallowcheck, wrenchtool.cycletime, wrenchtool.createDate, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.lastrepair);
return(ServerHelp.updateByWhere(tablename, _webip, contion, updatestr));
}
public bool add(Model.wrench wrenchtool)
{
try
{
string sqldep = string.Format("select * from wrenchspecies where id='{0}'", wrenchtool.species);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
wrenchtool.species = dep.guid;
}
}
sqldep = string.Format("select * from wrenchstatus where id='{0}'", wrenchtool.status);
dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
wrenchstatus dep = DataTableToList.GetList <wrenchstatus>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
wrenchtool.status = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO wrench(wrenchCode,wrenchBarCode,rangeMin,rangeMax,factory,createDate,IP,port,species_id,status_id,lastrepair,cycletime,isallowcheck,targetvalue,targetvalue1,targetvalue2,unit,comment,guid,offPset) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}') ;select last_insert_rowid()",
wrenchtool.wrenchCode, wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.createDate, wrenchtool.IP, wrenchtool.port, wrenchtool.species, wrenchtool.status, wrenchtool.lastrepair, wrenchtool.cycletime, wrenchtool.isallowcheck == true ? 1 : 0, wrenchtool.targetvalue, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.unit, wrenchtool.comment, wrenchtool.guid, wrenchtool.offPset
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public bool Del(Model.wrench wrenchmodel)
{
try
{
string contation = string.Format("where guid='{0}'", wrenchmodel.guid);
string sql = "delete from wrench " + contation;
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool updata(Model.wrench wrenchtool)
{
try
{
string contation = string.Format("where guid='{0}'", wrenchtool.guid);
string strsql = string.Format(
"wrenchCode='{0}',wrenchBarCode='{1}',rangeMin='{2}',rangeMax='{3}',factory='{4}',species_id='{5}',status_id='{6}',comment='{7}',targetvalue='{8}',unit='{9}',isallowcheck='{10}',cycletime={11},createDate='{12}' , targetvalue1='{13}',targetvalue2='{14}' ,lastrepair='{15}',offPset='{16}' ", wrenchtool.wrenchCode
, wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.species, wrenchtool.status, wrenchtool.comment, wrenchtool.targetvalue, wrenchtool.unit, wrenchtool.isallowcheck == true ? 1 : 0, wrenchtool.cycletime, wrenchtool.createDate, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.lastrepair, wrenchtool.offPset);
string sql = "update wrench set " + strsql + contation;
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool add(Model.wrench wrenchtool)
{
return(ServerHelp.addSingleInfoNotReturnID <wrench>(wrenchtool, _webip));
}
