private void LoadFgTheKho() { DataTable dt = new DataTable(); if (GlobalVariables.m_Flag == 0) { clsTheKho cls = new clsTheKho(); dt = cls.SelectVatTuWithID_XuatTheKho(int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()), int.Parse(cboKhoXuat.EditValue.ToString())); } else { clsTheKho cls = new clsTheKho(); cls.ID_VatTu = int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()); cls.ID_Kho = m_iID_Kho; dt = cls.Select_TheKho_PX_PhieuNhap_SoLuong(m_iID_PX); } int iSTT = 1; fgChiTietTheKho.Rows.Count = fgChiTietTheKho.Rows.Fixed + 1; fgChiTietTheKho[fgChiTietTheKho.Rows.Count - 1, "ID_TheKho"] = "Tổng"; fgChiTietTheKho.Rows[fgChiTietTheKho.Rows.Count - 1].Style = cs; foreach (DataRow dr in dt.Rows) { Row fgRow = fgChiTietTheKho.Rows.Add(); fgRow["STT"] = iSTT; iSTT++; fgRow["ID_TheKho"] = dr["ID_TheKho"]; fgRow["ID_PhieuNhap"] = dr["ID_PhieuNhap"]; fgRow["So_PhieuNhap"] = dr["So_QuyetDinh"]; fgRow["SoLuongTrongKho"] = dr["SoLuong_HienTai"]; fgRow["Ngay_NhapKho"] = dr["Ngay_QuyetDinh"]; fgRow["SoLuongXuat"] = 0; fgRow["SoLuongKhac"] = 0; if (GlobalVariables.m_Flag != 0) { fgRow["SoLuongXuat"] = dr["SoLuong"]; } fgChiTietTheKho.SetCellStyle(iSTT, 7, cs1); } }
private void fgChiTietTheKho_AfterEdit(object sender, RowColEventArgs e) { int sl = 0; if (fgChiTietTheKho[fgChiTietTheKho.Row, "SoLuongXuat"] != null) { DataRow dr = m_dtTmp.NewRow(); ThemMoiDataTableTmp(dr); m_dtTmp.Rows.Add(dr); UpdateSoLuongDataTableTmp(dr); // update số lượng vật tư trong thẻ kho khi thay đổi số lượng } clsTheKho cls = new clsTheKho(); DataTable dt = cls.SelectVatTuWithID_XuatTheKho(int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()), m_iID_Kho); for (int i = fgChiTietTheKho.Rows.Fixed + 1; i < fgChiTietTheKho.Rows.Count; i++) { if (fgChiTietTheKho[i, "SoLuongXuat"] != null) { sl += int.Parse(fgChiTietTheKho[i, "SoLuongXuat"].ToString()); } } UpdateFgPhieuXuatChiTiet(sl); UpdateFgPhieuXuat(sl); }