private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang b = new BUSKhoHang(); DTOKho d = new DTOKho(); d.MaKho = textEdit1.Text; d.TenKho = textEdit2.Text; d.NguoiLienHe = textEdit3.Text; d.DiaChi = textEdit4.Text; d.SODT = textEdit5.Text; d.Mobile = textEdit6.Text; d.Fax = textEdit7.Text; d.Email = textEdit8.Text; d.NguoiQuanLy = textEdit9.Text; d.DienGiai = textEdit10.Text; d.ConQuanLy = checkEdit1.Checked; if (isAddForm) { if (b.insertKho(d)) { MessageBox.Show("Thao tác thành công"); } else { MessageBox.Show("Thao tác không thành công"); } } else { b.updateKho(d); MessageBox.Show("Thao tác hóa thành công"); } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang b = new BUSKhoHang(); DTONhomHang d = new DTONhomHang(); d.MaNH = textEdit1.Text; d.TenNH = textEdit2.Text; d.GhiChu = textEdit3.Text; d.ConQuanLy = checkEdit1.Checked; if (isAddForm) { if (b.insertBangNhomHang(d)) { MessageBox.Show("Thao tác thành công"); } else { MessageBox.Show("Thao tác không thành công"); } } else { b.updateBangNhomHang(d); MessageBox.Show("Thao tác hóa thành công"); } }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang um = new BUSKhoHang(); string a = gridView1.GetFocusedRowCellValue("MaNH").ToString(); um.removeBangNhomHang(a); MessageBox.Show("Xóa thành công"); }
private void gridControl1_Load(object sender, EventArgs e) { BUSKhoHang um = new BUSKhoHang(); DataTable dt = um.getBangNhomHang(); gridColumn1.FieldName = "id"; gridColumn2.FieldName = "MaNH"; gridColumn3.FieldName = "TenNH"; gridColumn4.FieldName = "GhiChu"; gridColumn5.FieldName = "ConQuanLy"; gridControl1.DataSource = dt; }
private void gridControl1_Load(object sender, EventArgs e) { BUSKhoHang um = new BUSKhoHang(); DataTable dt = um.getHangHoa(); gridColumn1.FieldName = "id"; gridColumn2.FieldName = "MaHH"; gridColumn3.FieldName = "TENHH"; gridColumn4.FieldName = "MaDonVi"; gridColumn5.FieldName = "GiaMua"; gridControl1.DataSource = dt; }
private void frmKho_Load(object sender, EventArgs e) { BUSKhoHang um = new BUSKhoHang(); DataTable dt = um.getKho(); gridColumn1.FieldName = "id"; gridColumn2.FieldName = "MaKho"; gridColumn3.FieldName = "TenKho"; gridColumn4.FieldName = "DiaChi"; gridColumn5.FieldName = "NguoiLienHe"; gridColumn6.FieldName = "SODT"; gridColumn7.FieldName = "ConQuanLy"; gridControl1.DataSource = dt; }
private void frmNhomHang_Add_Load(object sender, EventArgs e) { if (!isAddForm) { BUSKhoHang b = new BUSKhoHang(); DTONhomHang dtoHangHoa = b.getBangNhomHangDetail(gotID); textEdit1.Text = dtoHangHoa.MaNH; textEdit2.Text = dtoHangHoa.TenNH; textEdit3.Text = dtoHangHoa.GhiChu; checkEdit1.Checked = dtoHangHoa.ConQuanLy; } else { textEdit1.ReadOnly = false; } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang b = new BUSKhoHang(); DTOHangHoa dtoHangHoa = new DTOHangHoa(); dtoHangHoa.VatTu = radioButton1.Checked; dtoHangHoa.DichVu = radioButton1.Checked; dtoHangHoa.XuatXu = textEdit1.Text; dtoHangHoa.MaHH = textEdit2.Text; dtoHangHoa.MaVachNSX = textEdit3.Text; dtoHangHoa.TENHH = textEdit4.Text; dtoHangHoa.MaKhoHang = comboBoxEdit1.Text; dtoHangHoa.PhanLoai = comboBoxEdit2.Text; dtoHangHoa.MaDonVi = comboBoxEdit3.Text; dtoHangHoa.MaNhaCungCap = comboBoxEdit7.Text; dtoHangHoa.Thue = comboBoxEdit4.Text; dtoHangHoa.TonKhoToiThieu = comboBoxEdit5.Text; dtoHangHoa.TonKhoHienTai = comboBoxEdit6.Text; dtoHangHoa.GiaMua = comboBoxEdit8.Text; dtoHangHoa.GiaSi = comboBoxEdit9.Text; dtoHangHoa.GiaLe = comboBoxEdit10.Text; if (isAddForm) { if (b.insertHangHoa(dtoHangHoa)) { MessageBox.Show("Thao tác thành công"); } else { MessageBox.Show("Thao tác không thành công"); } } else { b.updateHangHoa(dtoHangHoa); MessageBox.Show("Thao tác hóa thành công"); } }
private void frmKho_Add_Load(object sender, EventArgs e) { if (!isAddForm) { BUSKhoHang b = new BUSKhoHang(); DTOKho dtoHangHoa = b.getKhoDetail(gotID); textEdit1.Text = dtoHangHoa.MaKho; textEdit2.Text = dtoHangHoa.TenKho; textEdit3.Text = dtoHangHoa.NguoiLienHe; textEdit4.Text = dtoHangHoa.DiaChi; textEdit5.Text = dtoHangHoa.SODT; textEdit6.Text = dtoHangHoa.Mobile; textEdit7.Text = dtoHangHoa.Fax; textEdit8.Text = dtoHangHoa.Email; textEdit9.Text = dtoHangHoa.NguoiQuanLy; textEdit10.Text = dtoHangHoa.DienGiai; checkEdit1.Checked = dtoHangHoa.ConQuanLy; } else { textEdit1.ReadOnly = false; } }
private void frmHangHoa_Add_Load(object sender, EventArgs e) { DataTable dt2 = new DataTable(); BUSKhoHang bus = new BUSKhoHang(); dt2 = bus.getKho(); if (dt2.Rows.Count > 0) { foreach (DataRow row in dt2.Rows) { comboBoxEdit1.Properties.Items.Add(row["TenKho"]); } } dt2 = new DataTable(); dt2 = bus.getBangNhomHang(); if (dt2.Rows.Count > 0) { foreach (DataRow row in dt2.Rows) { comboBoxEdit2.Properties.Items.Add(row["TenNH"]); } } dt2 = new DataTable(); dt2 = bus.getBangDonVi(); if (dt2.Rows.Count > 0) { foreach (DataRow row in dt2.Rows) { comboBoxEdit3.Properties.Items.Add(row["TenDV"]); } } dt2 = new DataTable(); BUSDoiTac bus2 = new BUSDoiTac(); dt2 = bus2.getNhaPhanPhoi(); if (dt2.Rows.Count > 0) { foreach (DataRow row in dt2.Rows) { comboBoxEdit7.Properties.Items.Add(row["TenNPP"]); } } //////////////////// if (!isAddForm) { BUSKhoHang b = new BUSKhoHang(); DTOHangHoa dtoHangHoa = b.getHangHoaDetail(gotID); radioButton1.Checked = dtoHangHoa.VatTu; radioButton1.Checked = dtoHangHoa.DichVu; textEdit1.Text = dtoHangHoa.XuatXu; textEdit2.Text = dtoHangHoa.MaHH; textEdit3.Text = dtoHangHoa.MaVachNSX; textEdit4.Text = dtoHangHoa.TENHH; comboBoxEdit1.Text = dtoHangHoa.MaKhoHang; comboBoxEdit2.Text = dtoHangHoa.PhanLoai; comboBoxEdit3.Text = dtoHangHoa.MaDonVi; comboBoxEdit7.Text = dtoHangHoa.MaNhaCungCap; comboBoxEdit4.Text = dtoHangHoa.Thue; comboBoxEdit5.Text = dtoHangHoa.TonKhoToiThieu; comboBoxEdit6.Text = dtoHangHoa.TonKhoHienTai; comboBoxEdit8.Text = dtoHangHoa.GiaMua; comboBoxEdit9.Text = dtoHangHoa.GiaSi; comboBoxEdit10.Text = dtoHangHoa.GiaLe; } else { textEdit2.ReadOnly = false; comboBoxEdit6.Text = "0"; } }