public int GetBill(int id) { if (ConnectionState.Closed == Getcon().State) { Getcon().Open(); } string query = "select * from dbo.Bill where idTable = " + id + " and status = 0"; SqlCommand cmd = new SqlCommand(query, Getcon()); try { SqlDataReader rd = cmd.ExecuteReader(); dt.Load(rd); if (dt.Rows.Count > 0) { BEL_HOADON bill = new BEL_HOADON(dt.Rows[0]); return(bill.MaHD); } return(-1); } catch (Exception err) { throw; } finally { Getcon().Close(); } }
public List <BEL_HOADON> DuLieuHoaDon() { List <BEL_HOADON> listHoaDon = new List <BEL_HOADON>(); DataTable dt = new DataTable(); string truyvan = "select IDHD,IDNV,IDKH,CONVERT(varchar, Ngaylap, 103) as Ngaylap,GioLap,CAST(TongTien as int) as TongTien from HOADON"; dt = this.Read(truyvan); foreach (DataRow item in dt.Rows) { BEL_HOADON nhanvien = new BEL_HOADON(item); listHoaDon.Add(nhanvien); } return(listHoaDon); }
private void btnThanhToan_Click(object sender, EventArgs e) { if (this.listSanPhamDatHang.Count < 1) { MessageBox.Show("Vui lòng chọn sản phẩm", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { BEL_HOADON bel_hd = new BEL_HOADON(); BAL_HOADON bAL_HOADON = new BAL_HOADON(); bel_hd.IDNV = this.bel_nv.IDNV; bel_hd.IDKH = this.bel_kh.IDKH; bel_hd.NGAYLAP = DateTime.Now.ToShortDateString(); bel_hd.GIOLAP = labTime.Text; bel_hd.TONGTIEN = ThanhTien(this.listSanPhamDatHang); bAL_HOADON.ThemHD(bel_hd); bel_hd.IDHD = bAL_HOADON.LayIDHD().ToString(); for (int i = 0; i < this.listSanPhamDatHang.Count; i++) { BEL_CHITIETHOADON bel_cthd = new BEL_CHITIETHOADON(this.listSanPhamDatHang[i]); bel_cthd.IDHD = bel_hd.IDHD; bAL_HOADON.ThemChiTietHoaDon(bel_cthd); } //--- this.listSanPhamDatHang.Clear(); txtTenKH.Text = ""; txtThanhTien.Text = ""; HienThiDatHang(lvBill, this.listSanPhamDatHang); MessageBox.Show("Thanh toán thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool ThemHD(BEL_HOADON hd) { return(dal_hd.ThemHD(hd)); }
public bool ThemHD(BEL_HOADON hd) { string truyvan = "insert into HOADON(IDNV,IDKH,Ngaylap,GioLap,TongTien) values(" + hd.IDNV + "," + hd.IDKH + ",'" + hd.NGAYLAP + "','" + hd.GIOLAP + "'," + hd.TONGTIEN + ")"; return(this.Change(truyvan)); }