C# (CSharp) QLCuaHangXeMay.Business ChiTietPhieuNhap Beispiele

Beispiel #1

 public void CTPhieuNhap_Insert(ChiTietPhieuNhap ctpn)
 {
     _db.table_Command("INSERT INTO ChiTietPhieuNhap VALUES('" + ctpn.MaPhieuNhap + "','" + ctpn.MaXe + "'," + ctpn.SlNhap + "," + ctpn.DonGiaNhap + "," + ctpn.Thue + "," + ctpn.ThanhTien + ")");
 }

Beispiel #2

 public void CTPhieuNhap_Update(ChiTietPhieuNhap ctpn)
 {
     _db.table_Command("UPDATE ChiTietPhieuNhap SET MaXe='" + ctpn.MaXe + "',SLNhap = " + ctpn.SlNhap + ",DonGiaNhap = " + ctpn.DonGiaNhap + ",Thue = " + ctpn.Thue + ",ThanhTien = " + ctpn.ThanhTien + " WHERE MaPhieuNhap = '" + ctpn.MaPhieuNhap + "'");
 }

Beispiel #3

 public void CTPhieuNhap_Delete(ChiTietPhieuNhap ctpn)
 {
     _db.table_Command("DELETE FROM ChiTietPhieuNhap WHERE MaPhieuNhap='" + ctpn.MaPhieuNhap + "'");
 }