private void btnDonHang_Click(object sender, EventArgs e) // Lap don hang`
{
try
{
int numberRow = gridView3.RowCount;
if (numberRow == 0)
{
MessageBox.Show("Nhập chị tiết đơn hàng của bạn");
return;
}
for (int i = 0; i < numberRow; i++)
{
string maddh = labelDDH.Text.ToString();
string mavt = gridView3.GetRowCellValue(i, gridView3.Columns[1]).ToString();
string soluong = gridView3.GetRowCellValue(i, gridView3.Columns[3]).ToString();
string maNV = Access.MANV.ToString();
string nhacc = gridView3.GetRowCellValue(i, gridView3.Columns[4]).ToString();
string makho = gridView3.GetRowCellValue(i, gridView3.Columns[5]).ToString();
string[] param = { maddh, mavt, soluong, maNV, makho, nhacc };
DonDH dondh = new DonDH();
int x = dondh.Create_DonHang(param);
if (x == 0 && i == (numberRow - 1)) // vong lap cuoi cung x =0
{
MessageBox.Show("Thêm Đơn đặt hàng " + labelDDH.Text + " thành công");
loadDDH();
loadChiTiet_DDH();
EventHandleFor_btnHUY();
}
}
}
catch
{
MessageBox.Show("Them DDH that bai");
}
}
private void btnThietLapDDH_Click(object sender, EventArgs e) // bat dau lap don dat hang tren kho va tu nha cung cap nao`
{
bool makho = f.CheckNullValueCBox(mAKHOComboBox);
bool tenkho = f.CheckNullValueCBox(tENKHOComboBox);
bool nhacc = f.CheckNullValueCBox(cBoxNhaCC);
if (makho && tenkho && nhacc)
{
tBoxSoluong.Enabled = true;
btnThem.Enabled = true;
cBoxNhaCC.Enabled = false;
mAKHOComboBox.Enabled = false;
tENKHOComboBox.Enabled = false;
btnThietLapDDH.Visible = false;
btnHuy.Visible = true;
gridView3.OptionsBehavior.Editable = true;
DonDH dondh = new DonDH();
maDDH = dondh.getMaDDH();
maDDH.Read();
labelDDH.Text = maDDH["MADDH"].ToString();
maDDH.Close();
}
}
private void loadDDH() // load don dat hang
{
DonDH dondh = new DonDH();
ddh = dondh.getDonDatHang();
sP_DS_DONDATHANGGridControl.DataSource = ddh;
sP_DS_DONDATHANGGridControl.DataMember = ddh.TableName;
}
private void loadKho()
{
DonDH dondh = new DonDH();
kho = dondh.getKho();
sP_LAYKHOGridControl.DataSource = kho;
sP_LAYKHOGridControl.DataMember = kho.TableName;
}
private void btnDonHang_Click(object sender, EventArgs e) // Lap don hang`
{
try
{
int numberRow = gridView3.RowCount;
if (numberRow == 0)
{
MessageBox.Show("Nhập chị tiết đơn hàng của bạn");
return;
}
string maddh = labelDDH.Text.ToString();
string maNV = Access.MANV.ToString();
string strXML = "<Root>";
for (int i = 0; i < numberRow; i++)
{
strXML += "<DonDH MasoDDH = \"" + maddh;
strXML += "\" MAVT = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[1]).ToString();
strXML += "\" SOLUONG = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[3]).ToString();
strXML += "\" DONGIA = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[6]).ToString();
strXML += "\" MANV = \"" + maNV;
strXML += "\" MAKHO = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[5]).ToString();
strXML += "\" NHACC = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[4]).ToString();
strXML += "\" />";
}
strXML += "</Root>";
string[] param = { strXML };
if (strXML == "<Root></Root>")
{
MessageBox.Show("Thiếu dữ liệu", "Thông Báo");
return;
}
else
{
try
{
DonDH dondh = new DonDH();
int x = dondh.Create_DonHang(param);
if (x == 0) // vong lap cuoi cung x =0
{
MessageBox.Show("Thêm Đơn đặt hàng " + labelDDH.Text + " thành công");
loadDDH();
loadChiTiet_DDH();
EventHandleFor_btnHUY();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
catch
{
MessageBox.Show("Them DDH that bai");
}
}
private void load_kho() // load kho
{
DonDH dondh = new DonDH();
kho = dondh.getKho();
foreach (DataRow dr in kho.Rows)
{
ListKho ckho = new ListKho() // dua gia tri datarow vao array cua ckkho
{
MaKho = dr[0].ToString(),
TenKho = dr[1].ToString(),
MaCN = dr[2].ToString(),
};
cnnkho.Add(ckho); // add array vao mang cnnkho
}
}
// ADDD CoLumns vao datatable chitietDDH----------------------------------------------------------------------------------------------------------
// Cac function load khi moi bat dau mo page-----------------------------------------------------------------------------------------------
private void load_nhacungcap()
{
DonDH dondh = new DonDH(); // goi toi model DonDH
nhacungcap = dondh.getNhacungcap(); // goi function trong MODEL DonDH
foreach (DataRow dr in nhacungcap.Rows) //doc tung gia tri vao Datarow
{
ListNhacungcap cnhacungcap = new ListNhacungcap() // dua vao array
{
MaNCC = dr[0].ToString(),
TenNCC = dr[1].ToString(),
Diachi_NCC = dr[2].ToString(),
SDT_NCC = dr[3].ToString(),
};
cnnNhacungcap.Add(cnhacungcap); // add array vao cmd_Nhacungcap
}
}
private void loadChiTiet_DDH() // load Chitiet DDH
{
DataRow row = gridView1.GetFocusedDataRow();
string[] param = { row["MasoDDH"].ToString() };
DonDH dondh = new DonDH();
ddh = dondh.getChiTietDonDatHang(param);
if (ddh == null)
{
sP_DS_CHITIET_DONDATHANGGridControl.DataSource = null;
}
else
{
sP_DS_CHITIET_DONDATHANGGridControl.DataSource = ddh;
sP_DS_CHITIET_DONDATHANGGridControl.DataMember = ddh.TableName;
}
}
private void dgvDonDH_Click(object sender, EventArgs e) //R
{
int vitri = dgvDonDH.CurrentRow.Index;
List <DonDH> list = DonDHClient.HienThiDonDH().ToList();
ddh = list[vitri];
txtHoTenKH.Text = ddh.HoTenKH;
txtDiaChi.Text = ddh.DiaChi;
txtDienThoai.Text = ddh.DienThoai;
txtEmail.Text = ddh.Email;
txtGhiChu.Text = ddh.GhiChu;
cbTinhTrang.SelectedItem = ddh.TinhTrang;
string madondh = dgvDonDH.CurrentRow.Cells[1].Value.ToString();
ctddh.MaDonDH = madondh;
Ds_CtDonDH(ctddh);
}
//R
private void dgvDonDH_Click(object sender, EventArgs e)
{
int vitri = dgvDonDH.CurrentRow.Index;
List<DonDH> list = DonDHClient.HienThiDonDH().ToList();
ddh = list[vitri];
txtHoTenKH.Text = ddh.HoTenKH;
txtDiaChi.Text = ddh.DiaChi;
txtDienThoai.Text = ddh.DienThoai;
txtEmail.Text = ddh.Email;
txtGhiChu.Text = ddh.GhiChu;
cbTinhTrang.SelectedItem = ddh.TinhTrang;
string madondh = dgvDonDH.CurrentRow.Cells[1].Value.ToString();
ctddh.MaDonDH = madondh;
Ds_CtDonDH(ctddh);
}
