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