public List <Supplier> GetSupplier(string fieldName, string fieldValue) { List <Supplier> results = new List <Supplier>(); DataTable dt = new DataTable(); if (string.IsNullOrEmpty(fieldName) && string.IsNullOrEmpty(fieldValue)) { dt = SqlHepler.GetDataTable(new Supplier().TableName); } else if (fieldName == "Name") { dt = SqlHepler.GetDataTable1(new Supplier(), fieldName, fieldValue); } else { dt = SqlHepler.GetDataTable(new Supplier(), fieldName, fieldValue); } foreach (DataRow dr in dt.Rows) { results.Add( new Supplier( dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString() )); } return(results); }
public void Add(ModelBase model) { if (model is Inventory) { if (((Inventory)model).ID == 0) { SqlHepler.Execute(SqlHepler.InsertSQL(model)); if (this.ModelAdded != null) { this.ModelAdded(this, new ModelAddedEventArgs(model)); } } else { SqlHepler.Execute(SqlHepler.UpdateSQL(model)); } } else if (model is Sale) { if (((Sale)model).ID == 0) { SqlHepler.Execute(SqlHepler.InsertSQL(model)); if (this.ModelAdded != null) { this.ModelAdded(this, new ModelAddedEventArgs(model)); } } else { SqlHepler.Execute(SqlHepler.UpdateSQL(model)); //更新商品库存 } } else { if (AlreadyExisting(model)) { SqlHepler.Execute(SqlHepler.UpdateSQL(model)); } else { SqlHepler.Execute(SqlHepler.InsertSQL(model)); if (model is Employee) { User user = new User(); user.EmployeeID = ((Employee)model).ID; user.Password = "******"; user.IsAdmin = "0"; SqlHepler.Execute(SqlHepler.InsertSQL(user)); } if (this.ModelAdded != null) { this.ModelAdded(this, new ModelAddedEventArgs(model)); } } } }