private void load_dshd_nam() { HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.NAM = Nam; dg_dshd.DataSource = hd_old_bul.load_hd_year(hd_old_public); }
private void load_dshd_ngay() { HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.NGAY = Ngay; dg_dshd.DataSource = hd_old_bul.load_hd_day(hd_old_public); }
private void load_dshd_thang() { HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.THANG = Thang; dg_dshd.DataSource = hd_old_bul.load_hd_month(hd_old_public); }
private void TONGDOANHTHU_Load(object sender, EventArgs e) { txttongtien.ReadOnly = true; groupBox2.Text = "Tổng doanh thu(VNĐ)"; if (Bngay == true) { trangthai = "Ngày"; load_dshd_ngay(); dinhdangluoi(); groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Ngày: " + Ngay.ToString(); tinhtongtien(5); } else if (Bthang == true) { trangthai = "Tháng"; load_dshd_thang(); dinhdangluoi(); groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Tháng: " + Thang.ToString(); tinhtongtien(5); } else if (Bnam == true) { trangthai = "Năm"; load_dshd_nam(); dinhdangluoi(); groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Năm: " + Nam.ToString(); tinhtongtien(5); } else if (Timcheck == true) { trangthai = Tenban; HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.Soban = Tenban; dg_dshd.DataSource = hd_old_bul.load_timhd_old(hd_old_public); dinhdangluoi_hd_ban(); groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo " + Tenban; tinhtongtien(5); } else if (Checkten == true) { trangthai = Tenban; HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC(); hd_old_public.TENNV = Tenban; dg_dshd.DataSource = hd_old_bul.load_timhd_old_TENNV(hd_old_public); dinhdangluoi_hd_ban(); groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn của nhân viên: " + Tenban; tinhtongtien(5); } else { trangthai = "Tất cả các hóa đơn"; dg_dshd.DataSource = hd_old_bul.load_hoadon_old_NOTID(); dinhdangluoi(); groupBoxTONGDOANHTHU.Text = "Danh sách tất cả các hóa đơn"; tinhtongtien(5); } }
public DataTable load_hd_day(HOADON_OLD_PUBLIC hd_old) { int parameter = 1; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@NGAY"; values[0] = hd_old.NGAY; string sql = "LOAD_HD_DAY"; return(ketnoi.LoadDataWithParameter(sql, name, values, parameter)); }
public DataTable load_timhd_old_TENNV(HOADON_OLD_PUBLIC hd_old) { int paramater = 1; string[] name = new string[paramater]; object[] values = new object[paramater]; name[0] = "@TENNV"; values[0] = hd_old.TENNV; string sql = "TIM_HOADON_OLD_tennv"; return(ketnoi.LoadDataWithParameter(sql, name, values, paramater)); }
public int delete_hoadon_old(HOADON_OLD_PUBLIC hd_old) { int parameter = 1; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@IDHD_OLD"; values[0] = hd_old.IDHOADON; string sql = "DELETE_HOADON_OLD"; return(ketnoi.Excute_Data(sql, name, values, parameter)); }
public DataTable load_hd_month(HOADON_OLD_PUBLIC hd_old) { int parameter = 1; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@THANG"; values[0] = hd_old.THANG; string sql = "LOAD_HD_MONTH"; return(ketnoi.LoadDataWithParameter(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(); }
private void bttimnhanvien_Click(object sender, EventArgs e) { checktimtennv = true; HOADON_OLD_PUBLIC hd_old_publuc = new HOADON_OLD_PUBLIC(); hd_old_publuc.TENNV = txttennhanvien.Text; dg_hoadon.DataSource = hoadon_old_bul.load_timhd_old_TENNV(hd_old_publuc); cbngay.DropDownStyle = ComboBoxStyle.DropDownList; cbngay.Enabled = false; cbthang.DropDownStyle = ComboBoxStyle.DropDownList; cbthang.Enabled = false; cbnam.DropDownStyle = ComboBoxStyle.DropDownList; cbnam.Enabled = false; rdNgay.Checked = false; rdThang.Checked = false; rdNam.Checked = false; cbngay.SelectedIndex = -1; cbthang.SelectedIndex = -1; cbnam.SelectedIndex = -1; }
private void bttim_Click(object sender, EventArgs e) { checktim = true; HOADON_OLD_PUBLIC hd_old_publuc = new HOADON_OLD_PUBLIC(); hd_old_publuc.Soban = "Bàn số: " + Soban.Value.ToString(); dg_hoadon.DataSource = hoadon_old_bul.load_timhd_old(hd_old_publuc); cbngay.DropDownStyle = ComboBoxStyle.DropDownList; cbngay.Enabled = false; cbthang.DropDownStyle = ComboBoxStyle.DropDownList; cbthang.Enabled = false; cbnam.DropDownStyle = ComboBoxStyle.DropDownList; cbnam.Enabled = false; rdNgay.Checked = false; rdThang.Checked = false; rdNam.Checked = false; cbngay.SelectedIndex = -1; cbthang.SelectedIndex = -1; cbnam.SelectedIndex = -1; }
public int insert_hoadon_old(HOADON_OLD_PUBLIC hd_old) { int parameter = 6; string[] name = new string[parameter]; object[] values = new object[parameter]; name[0] = "@IDHOADON"; name[1] = "@IDBAN"; name[2] = "@IDNV"; name[3] = "@NGAYLAP"; name[4] = "@TRANGTHAI"; name[5] = "@TONGTIEN"; values[0] = hd_old.IDHOADON; values[1] = hd_old.IDBAN; values[2] = hd_old.IDNV; values[3] = hd_old.NGAYLAP; values[4] = hd_old.TRANGTHAI; values[5] = hd_old.TONGTIEN; string sql = "INSERT_HOADON_OLD"; return(ketnoi.Excute_Data(sql, name, values, parameter)); }
public DataTable load_timhd_old_TENNV(HOADON_OLD_PUBLIC hd_old) { return(hd_dal_old.load_timhd_old_TENNV(hd_old)); }
public DataTable load_hd_year(HOADON_OLD_PUBLIC hd_old) { return(hd_dal_old.load_hd_year(hd_old)); }
public int delete_hoadon_old(HOADON_OLD_PUBLIC hd_old) { return(hd_dal_old.delete_hoadon_old(hd_old)); }
public int insert_hoadon_old(HOADON_OLD_PUBLIC hd_old) { return(hd_dal_old.insert_hoadon_old(hd_old)); }