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