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