private void CTHD_OLD_Load(object sender, EventArgs e) { groupBox1.Text = "Chi tiết của mã hóa đơn: " + mahoadon_old.ToString(); CTHD_OLD_PUBLIC cthd_old_public = new CTHD_OLD_PUBLIC(); cthd_old_public.IDHOADON_OLD = mahoadon_old; dg_chtd_old.DataSource = cthd_old_bul.load_cthd_old_printer(cthd_old_public); dinhdangluoi(); rttongtien.ReadOnly = true; tinhtongtien(); }
public int delete_cthd_old(CTHD_OLD_PUBLIC cthd_old) { int parameter = 2; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@IDHD_OLD"; values[0] = cthd_old.IDHOADON_OLD; string sql = "DELETE_CTHD_OLD"; return(ketnoi.Excute_Data(sql, name, values, parameter)); }
public DataTable load_cthd_old_printer(CTHD_OLD_PUBLIC cthd_old) { int parameter = 1; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@IDHD_OLD"; values[0] = cthd_old.IDHOADON_OLD; string sql = "LOAD_CTHD_OLD_PRINTER"; return(ketnoi.LoadDataWithParameter(sql, name, values, parameter)); }
public int insert_cthd_old(CTHD_OLD_PUBLIC cthd_old) { int parameter = 3; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@IDHD_OLD"; name[1] = "@IDDOUONG"; name[2] = "@SOLUONG"; values[0] = cthd_old.IDHOADON_OLD; values[1] = cthd_old.IDDOUONG; values[2] = cthd_old.SOLUONG; string sql = "INSERT_CTHD_OLD"; return(ketnoi.Excute_Data(sql, name, values, parameter)); }
private void btthanhtoan_Click(object sender, EventArgs e) { HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.IDHOADON = idhoadon; hd_old_public.IDBAN = Idban; hd_old_public.IDNV = Idnv; hd_old_public.NGAYLAP = DateTime.Now; hd_old_public.TRANGTHAI = "Rồi"; hd_old_public.TONGTIEN = double.Parse(txttongtien.Text); hd_old_bul.insert_hoadon_old(hd_old_public); CTHD_OLD_PUBLIC cthd_old_public = new CTHD_OLD_PUBLIC(); for (int i = 0; i < dg_monan_ofban.Rows.Count - 1; i++) { cthd_old_public.IDHOADON_OLD = idhoadon; cthd_old_public.IDDOUONG = int.Parse(dg_monan_ofban[0, i].Value.ToString()); cthd_old_public.SOLUONG = int.Parse(dg_monan_ofban[2, i].Value.ToString()); cthd_old_bul.insert_cthd_old(cthd_old_public); } // delete CTHD CTHD_PUBLIC cthd_public = new CTHD_PUBLIC(); for (int j = 0; j < dg_monan_ofban.Rows.Count - 1; j++) { cthd_public.IDHOADON = idhoadon; cthd_public.IDDOUONG = int.Parse(dg_monan_ofban[0, j].Value.ToString()); cthd_bul.delete_cthd(cthd_public); } HOADON_PUBLIC hd_public = new HOADON_PUBLIC(); hd_public.IDHOADON = idhoadon; hd_bul.delete_hoadon(hd_public); // update trạng thái bàn BAN_PUBLIC ban_public = new BAN_PUBLIC(); ban_public.IDBAN = idban; ban_public.TRANGTHAI = "Trống"; ban_bul.update_trangthaiban(ban_public); inhoadon(); this.Close(); }
public int delete_cthd_old(CTHD_OLD_PUBLIC cthd_old) { return(cthd_old_dal.delete_cthd_old(cthd_old)); }
public int insert_cthd_old(CTHD_OLD_PUBLIC cthd_old) { return(cthd_old_dal.insert_cthd_old(cthd_old)); }
public DataTable load_cthd_old_printer(CTHD_OLD_PUBLIC cthd_old) { return(cthd_old_dal.load_cthd_old_printer(cthd_old)); }