//更新 //public bool UpdateProducts(int PID,int CategoryID,string Name,string Description) //{ // if (helper.ExcuteCommandInt("update Products set CategoryID=" + CategoryID + ",Name='" + Name + "',Description='" + Description + "' where PID=" + PID + "") > 0) // return true; // else // return false; //} public bool UpdateProducts(Entity.Products product) { if (helper.ExcuteCommandInt("update Products set CategoryID=" +product.getCategoryID()+ ",Name='" +product.getName()+ "',Description='" +product.getDescription()+ "' where PID=" + product.getPID() + "") > 0) return true; else return false; }
//新增 //public bool AddProduct(int CategoryID,string Name,string Description) { // if (helper.ExcuteCommandInt("insert into Products(CategoryID,Name,Description) values("+CategoryID+",'"+Name+"','"+Description+"')") > 0) // return true; // else // return false; //} public bool AddProduct(Entity.Products product) { //int CategoryID, string Name, string Description if (helper.ExcuteCommandInt("insert into Products(CategoryID,Name,Description) values(" + product.getCategoryID() + ",'" + product.getName()+ "','" +product.getDescription() + "')") > 0) return true; else return false; }