private void CreateSupplier(object sender, EventArgs e)
{
var supplier = new Supplier();
supplier.Id = 1;
supplier.Name = txtSupplierName.Text;
supplier.Type = txtSupplierType.Text;
supplier.Address = txtSupplierAddr.Text;
supplier.Category = txtSupplierCategory.Text;
supplier.Phone = txtSupplierPhone.Text;
supplier.Remark = txtSupplierRemark.Text;
supplier.WebSite = txtSupplierWebSite.Text;
supplier.ZipCode = txtSupplierZipCode.Text;
this.Hide();
}
public bool AddORUpdateSupplier(Supplier supplier)
{
var sql = new StringBuilder();
if (supplier.Id != 0)
{
//更新
sql.AppendLine("update supplier set name='" + supplier.Name + "',type='" + supplier.Type + "',category='" + supplier.Category + "'");
sql.AppendLine(",website='" + supplier.WebSite + "',zipcode='" + supplier.ZipCode + "',address='" + supplier.Address + "'");
sql.AppendLine(",remark='" + supplier.Remark + "',phone='" + supplier.Phone + "' where id=" + supplier.Id + "");
}
else
{
//新增
sql.AppendLine("insert into supplier(name,type,category,website,zipcode,address,remark,phone) values (");
sql.AppendLine("'" + supplier.Name + "','" + supplier.Type + "','" + supplier.Category + "','" + supplier.WebSite + "'");
sql.AppendLine(",'" + supplier.ZipCode + "','" + supplier.Address + "','" + supplier.Remark + "','" + supplier.Phone + "')");
}
return false;
}
public List<Supplier> GetAllSupplier()
{
var supplierList = new List<Supplier>();
var supplier = new Supplier();
supplier.Id = 1;
supplier.Name = "供应商测试数据1";
supplier.Type = "测试";
supplier.Phone = "111111111111111";
supplier.WebSite = "http://www.baidu.com";
supplier.Remark = "测试";
supplier.Category = "重要";
supplier.Address = "北京";
supplier.ZipCode = "100000";
supplierList.Add(supplier);
supplier = new Supplier();
supplier.Id = 2;
supplier.Name = "供应商测试数据2";
supplier.Type = "测试";
supplier.Phone = "22222222222222";
supplier.WebSite = "http://www.qq.com";
supplier.Remark = "测试";
supplier.Category = "重要";
supplier.Address = "深圳";
supplier.ZipCode = "200000";
supplierList.Add(supplier);
return supplierList;
}
