public int Update(KB.Models.Factory factory) { string sql = "update factory set FactoryName='{0}',FactoryIndex={1} where FactoryID={2}"; return(db.ExecuteCommand(string.Format(sql, factory.FactoryName, factory.FactoryIndex, factory.FactoryID))); }
public int Delete(KB.Models.Factory factory) { string sql = "delete from factory where FactoryID={0}"; return(db.ExecuteCommand(string.Format(sql, factory.FactoryID))); }
public int Add(KB.Models.Factory facotry) { string sql = "insert into Factory(FactoryName,FactoryIndex) values('{0}',{1});"; return(db.Add(string.Format(sql, facotry.FactoryName, facotry.FactoryIndex))); }