public bool update(Model.wrenchstatus wrenchstatusmodel)
{
string tableName = typeof(wrenchstatus).Name;
string contion = string.Format("guid='{0}'", wrenchstatusmodel.guid);
string sql = string.Format("statusName='{0}',statusDM='{1}',comment='{2}'", wrenchstatusmodel.statusName, wrenchstatusmodel.statusDM, wrenchstatusmodel.comment);
return(ServerHelp.updateByWhere(tableName, _webip, contion, sql));
}
public bool Del(Model.wrenchstatus wrenchstatus)
{
try
{
string contation = string.Format("where guid='{0}'", wrenchstatus.guid);
string sql = "delete from wrenchstatus " + contation;
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool update(Model.wrenchstatus wrenchstatusmodel)
{
try
{
string contation = string.Format("where guid='{0}'", wrenchstatusmodel.guid);
string strsql = string.Format("statusName='{0}',statusDM='{1}',comment='{2}'", wrenchstatusmodel.statusName, wrenchstatusmodel.statusDM, wrenchstatusmodel.comment);
string sql = "update wrenchstatus 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.wrenchstatus wrenchstatusmodel)
{
try
{
string sql =
string.Format
(
"INSERT INTO wrenchstatus(statusName,statusDM,comment,guid) VALUES('{0}','{1}','{2}','{3}') ;select last_insert_rowid()",
wrenchstatusmodel.statusName, wrenchstatusmodel.statusDM, wrenchstatusmodel.comment, wrenchstatusmodel.guid
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool add(Model.wrenchstatus wrenchstatusmodel)
{
return(ServerHelp.addSingleInfoNotReturnID <wrenchstatus>(wrenchstatusmodel, _webip));
}