private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSDoiTac b = new BUSDoiTac();
DTOKhuVuc d = new DTOKhuVuc();
d.MaKhuVuc = textEdit1.Text;
d.TenKhuVuc = textEdit2.Text;
d.GhiChu = textEdit3.Text;
d.ConQuanLy = checkEdit1.Checked;
if (isAddForm)
{
if (b.insertKhuVuc(d))
{
MessageBox.Show("Thao tác thành công");
}
else
{
MessageBox.Show("Thao tác không thành công");
}
}
else
{
b.updateKhuVuc(d);
MessageBox.Show("Thao tác hóa thành công");
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSDoiTac um = new BUSDoiTac();
string a = gridView1.GetFocusedRowCellValue("MaNPP").ToString();
um.deleteNhaPhanPhoi(a);
MessageBox.Show("Xóa thành công");
}
private void frmKhuVuc_Load(object sender, EventArgs e)
{
BUSDoiTac um = new BUSDoiTac();
DataTable dt = um.getKhuVuc();
gridColumn1.FieldName = "MaKhuVuc";
gridColumn2.FieldName = "TenKhuVuc";
gridColumn3.FieldName = "GhiChu";
gridColumn4.FieldName = "ConQuanLy";
gridControl1.DataSource = dt;
}
private void frmNhaPhanPhoi_Load(object sender, EventArgs e)
{
BUSDoiTac um = new BUSDoiTac();
DataTable dt = um.getNhaPhanPhoi();
gridColumn1.FieldName = "id";
gridColumn2.FieldName = "MaNPP";
gridColumn3.FieldName = "TenNPP";
gridColumn4.FieldName = "MaKhuVuc";
gridColumn5.FieldName = "DiaChi";
gridColumn6.FieldName = "SODT";
gridColumn7.FieldName = "Fax";
gridColumn8.FieldName = "Email";
gridControl1.DataSource = dt;
}
private void gridControl1_Load(object sender, EventArgs e)
{
BUSDoiTac um = new BUSDoiTac();
DataTable dt = um.getKhachHang();
gridColumn1.FieldName = "MaKhuVuc";
gridColumn2.FieldName = "MAKH";
gridColumn3.FieldName = "HOTEN";
gridColumn4.FieldName = "DiaChi";
gridColumn5.FieldName = "SODT";
gridColumn6.FieldName = "Email";
gridColumn7.FieldName = "SODT";
gridColumn8.FieldName = "ConQuanLy";
gridControl1.DataSource = dt;
}
private void frmKhuVuc_Add_Load(object sender, EventArgs e)
{
if (!isAddForm)
{
BUSDoiTac b = new BUSDoiTac();
DTOKhuVuc dtoHangHoa = b.getKhuVucDetail(gotID);
textEdit1.Text = dtoHangHoa.MaKhuVuc;
textEdit2.Text = dtoHangHoa.TenKhuVuc;
textEdit3.Text = dtoHangHoa.GhiChu;
checkEdit1.Checked = dtoHangHoa.ConQuanLy;
}
else
{
textEdit1.ReadOnly = false;
}
}
private void frmKhachHang_Add_Load(object sender, EventArgs e)
{
DataTable dt2 = new DataTable();
BUSDoiTac bus = new BUSDoiTac();
dt2 = bus.getKhuVuc();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
comboBoxEdit1.Properties.Items.Add(row["MaKhuVuc"]);
}
}
if (!isAddForm)
{
BUSDoiTac b = new BUSDoiTac();
DTOKhachHang dtoHangHoa = b.getKhachHangDetail(gotID);
textEdit1.Text = dtoHangHoa.MAKH;
textEdit2.Text = dtoHangHoa.HOTEN;
textEdit3.Text = dtoHangHoa.DiaChi;
textEdit4.Text = dtoHangHoa.MaSoThue;
textEdit5.Text = dtoHangHoa.Fax;
textEdit6.Text = dtoHangHoa.SODT;
textEdit7.Text = dtoHangHoa.Mobile;
textEdit8.Text = dtoHangHoa.Email;
textEdit9.Text = dtoHangHoa.Website;
textEdit10.Text = dtoHangHoa.TaiKhoan;
textEdit11.Text = dtoHangHoa.NganHang;
textEdit12.Text = dtoHangHoa.NickYahoo;
textEdit13.Text = dtoHangHoa.NguoiLienHe;
textEdit14.Text = dtoHangHoa.NickSkype;
comboBoxEdit1.Text = dtoHangHoa.MaKhuVuc;
comboBoxEdit2.Text = dtoHangHoa.GioiHanNo;
comboBoxEdit3.Text = dtoHangHoa.NoHienTai;
comboBoxEdit4.Text = dtoHangHoa.ChietKhau;
radioButton1.Checked = dtoHangHoa.DaiLy;
radioButton2.Checked = dtoHangHoa.KhachLe;
checkEdit1.Checked = dtoHangHoa.ConQuanLy;
}
else
{
textEdit1.ReadOnly = false;
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSDoiTac b = new BUSDoiTac();
DTOKhachHang d = new DTOKhachHang();
d.MAKH = textEdit1.Text;
d.HOTEN = textEdit2.Text;
d.DiaChi = textEdit3.Text;
d.MaSoThue = textEdit4.Text;
d.Fax = textEdit5.Text;
d.SODT = textEdit6.Text;
d.Mobile = textEdit7.Text;
d.Email = textEdit8.Text;
d.Website = textEdit9.Text;
d.TaiKhoan = textEdit10.Text;
d.NganHang = textEdit11.Text;
d.NickYahoo = textEdit12.Text;
d.NguoiLienHe = textEdit13.Text;
d.NickSkype = textEdit14.Text;
d.MaKhuVuc = comboBoxEdit1.Text;
d.GioiHanNo = comboBoxEdit2.Text;
d.NoHienTai = comboBoxEdit3.Text;
d.ChietKhau = comboBoxEdit4.Text;
d.ConQuanLy = checkEdit1.Checked;
d.DaiLy = radioButton1.Checked;
d.KhachLe = radioButton2.Checked;
if (isAddForm)
{
if (b.insertKhachHang(d))
{
MessageBox.Show("Thao tác thành công");
}
else
{
MessageBox.Show("Thao tác không thành công");
}
}
else
{
b.updateKhachHang(d);
MessageBox.Show("Thao tác hóa thành công");
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSDoiTac b = new BUSDoiTac();
DTONhaPhanPhoi d = new DTONhaPhanPhoi();
d.MaNPP = textEdit1.Text;
d.TenNPP = textEdit2.Text;
d.DiaChi = textEdit3.Text;
d.MaSoThue = textEdit4.Text;
d.Fax = textEdit5.Text;
d.SODT = textEdit6.Text;
d.Mobile = textEdit7.Text;
d.Email = textEdit8.Text;
d.Website = textEdit9.Text;
d.TaiKhoan = textEdit10.Text;
d.NganHang = textEdit11.Text;
d.NguoiLienHe = textEdit12.Text;
d.ChucVu = textEdit13.Text;
d.MaKhuVuc = comboBoxEdit1.Text;
d.GioiHanNo = comboBoxEdit2.Text;
d.NoHienTai = comboBoxEdit3.Text;
d.ChietKhau = comboBoxEdit4.Text;
d.ConQuanLy = checkEdit1.Checked;
if (isAddForm)
{
if (b.insertNhaPhanPhoi(d))
{
MessageBox.Show("Thao tác thành công");
}
else
{
MessageBox.Show("Thao tác không thành công");
}
}
else
{
b.updateNhaPhanPhoi(d);
MessageBox.Show("Thao tác hóa thành công");
}
}
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";
}
}
