private void FocusedRowChanged_for_DDH_CHUANHAP()// lấy sự kiện click trong gridViewDDH_CHUANHAP load Data lên gridViewDDH_CHUANHAP
{
DataRow red = gridViewDDH_CHUANHAP.GetFocusedDataRow();
if (red == null)
{
return;
}
else
{
EventHandleForBtnHuy();
NgaylapDateEdit.Text = red["NGAY"].ToString();
string MADDH = red["MasoDDH"].ToString();
string[] param = { MADDH };
MDPhieuNhap phieunhap = new MDPhieuNhap();
pnhap = phieunhap.getChiTietDonDatHangTheoMa(param);
sP_DS_CHITIET_DONDATHANG_THEOMAGridControl.DataSource = pnhap;
sP_DS_CHITIET_DONDATHANG_THEOMAGridControl.DataMember = pnhap.TableName;
if (label1.Text != "")
{
loadMaPN_TuDong();
}
}
}
private void loadDonHang_ChuaNhap()
{
MDPhieuNhap phieunhap = new MDPhieuNhap();
pnhap = phieunhap.getDS_DonDatHang_ChuaNhap();
sP_DS_DONDATHANG_CHUANHAPGridControl.DataSource = pnhap;
sP_DS_DONDATHANG_CHUANHAPGridControl.DataMember = pnhap.TableName;
}
private void load_DS_PhieuNhap()
{
MDPhieuNhap phieunhap = new MDPhieuNhap();
pnhap = phieunhap.getDS_PHIEUNHAP();
sP_DS_PHIEUNHAPGridControl.DataSource = pnhap;
sP_DS_PHIEUNHAPGridControl.DataMember = pnhap.TableName;
}
private void load_CTPN(string ct_pn)
{
string[] param = { ct_pn };
MDPhieuNhap phieunhap = new MDPhieuNhap();
pnhap = phieunhap.getChiTietPhieuNhap(param);
sP_DS_CHITIET_PHIEUNHAPGridControl.DataSource = pnhap;
sP_DS_CHITIET_PHIEUNHAPGridControl.DataMember = pnhap.TableName;
}
private void loadMaPN_TuDong()
{
MDPhieuNhap phieunhap = new MDPhieuNhap();
maphieu = phieunhap.getMaPhieuNhap_TuDong();
maphieu.Read();
label1.Text = maphieu["MAPN"].ToString();
maphieu.Close();
}
private void cboxMaPhieuNhap_SelectedValueChanged(object sender, EventArgs e)
{
DataTable ppnn = new DataTable();
string mapn = cboxMaPhieuNhap.Text.ToString();
string[] param = { mapn };
MDPhieuNhap phieunhap = new MDPhieuNhap();
ppnn = phieunhap.getChiTietPhieuNhap(param);
DS_CT_PNHAP.DataSource = ppnn;
}
private void btnLapPhieuNhap_Click(object sender, EventArgs e)
{
try
{
int numberRow = gridViewChiTietPhieuNhap.RowCount;
if (numberRow == 0)
{
MessageBox.Show("Nhập chị tiết Phiếu Nhập của đơn hàng");
return;
}
string mapn = label1.Text.ToString();
string maNV = Access.MANV.ToString();
string maKho = mKhoTbox.Text.ToString();
string strXML = "<Root>";
for (int i = 0; i < numberRow; i++)
{
strXML += "<PhieuNhap MAPN = \"" + mapn;
strXML += "\" MAKHO =\"" + maKho;
strXML += "\" MADDH =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[0]).ToString();
strXML += "\" MAVT =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[1]).ToString();
strXML += "\" MANV =\"" + maNV;
strXML += "\" SL_NHAP =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[3]).ToString();
strXML += "\" DONGIA_NHAP =\"" + gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[4]).ToString();
strXML += "\" />";
}
strXML += "</Root>";
string[] param = { strXML };
MDPhieuNhap pnhap = new MDPhieuNhap();
int x = pnhap.CreatePhieuNhap(param);
if (x == 0)
{
MessageBox.Show("Thêm Phiếu nhập : " + label1.Text + " thành công");
loadDonHang_ChuaNhap();
load_DS_PhieuNhap();
load_Chitiet_PN();
gridViewDDH_CHUANHAP.FocusedRowHandle = 1;
EventHandleForBtnHuy();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
EventHandleForBtnHuy();
}
private void btnLapPhieuNhap_Click(object sender, EventArgs e)
{
try
{
int numberRow = gridViewChiTietPhieuNhap.RowCount;
if (numberRow == 0)
{
MessageBox.Show("Nhập chị tiết Phiếu Nhập của đơn hàng");
return;
}
for (int i = 0; i < numberRow; i++)
{
string mapn = label1.Text.ToString();
string maddh = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[0]).ToString();
string mavt = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[1]).ToString();
string soluongnhap = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[3]).ToString();
string maNV = Access.MANV.ToString();
string dongia_nhap = gridViewChiTietPhieuNhap.GetRowCellValue(i, gridViewChiTietPhieuNhap.Columns[4]).ToString();
string[] param = { mapn, maddh, mavt, maNV, soluongnhap, dongia_nhap };
MDPhieuNhap pnhap = new MDPhieuNhap();
int x = pnhap.CreatePhieuNhap(param);
if (x == 0 && i == (numberRow - 1))
{
MessageBox.Show("Thêm Phiếu nhập : " + label1.Text + " thành công");
loadDonHang_ChuaNhap();
load_DS_PhieuNhap();
load_Chitiet_PN();
EventHandleForBtnHuy();
}
}
}
catch
{
MessageBox.Show("Them DDH that bai");
}
EventHandleForBtnHuy();
}
