public void Load_Data()
{
clsChi_Tiet_Phieu_Nhap_Vat_Tu pn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu();
txtMaPhieuNhap.Text = maphieu;
dtPhieuNhap = pn.GetAll(txtMaPhieuNhap.Text);
gridDanhSachPhieuNhap.DataSource = dtPhieuNhap;
clsGiaoDienChung.initCombobox(cbbPhieuNo, new clsBu_Tru_No_Phieu(), "Ma_phieu_nhap", "ID_phieu_nhap", "Ma_phieu_nhap");
}
private bool initEdit()
{
try
{
clsPhieuNhapKho clsNhap = new clsPhieuNhapKho();
clsNhap.Ma_phieu_nhap = txtMaPhieuNhap.Text;
if (clsNhap.CheckTonTaiSoDK(txtMaPhieuNhap.Text) == true)
{
DataTable tb = clsNhap.GetAllPhieuNo(txtMaPhieuNhap.Text.Trim());
// dtNgayNhap.Text = tb.Rows[0]["Ngay_nhap"].ToString();
dtNgayNhap.CustomFormat = "dd-MM-yyyy";
dtNgayNhap.Value = Convert.ToDateTime(tb.Rows[0]["Ngay_lap"].ToString());
// dtNgayNhap.Text = string.Format("{0:dd/MM/yyyy}", tb.Rows[0]["Ngay_lap"]);
txtLyDo.Text = tb.Rows[0]["Ly_do"].ToString();
// txtXuatTaiKho.Text = tb.Rows[0]["ID_kho"].ToString();
txtCongTrinh.Text = tb.Rows[0]["cong_trinh"].ToString();
cbKhoNhan.Text = tb.Rows[0]["Ten_kho"].ToString();
txtDiaChi.Text = tb.Rows[0]["Dia_chi"].ToString();
// cbLoaiPhieuNhan.SelectedValue = tb.Rows[0]["ID_Loai_Phieu_Nhap"].ToString();
// chbNGD.Checked =bool.Parse( tb.Rows[0]["isGoiDau"].ToString());
cbKhoNgoai.Text = tb.Rows[0]["Ten_kho_muon"].ToString();
rdoKCMuonNo.Checked =bool.Parse( tb.Rows[0]["isKCMN"].ToString());
rdoKCTN.Checked = bool.Parse(tb.Rows[0]["isKCTN"].ToString());
rdoKNMN.Checked = bool.Parse(tb.Rows[0]["isKNMN"].ToString());
rdoKNTN.Checked = bool.Parse(tb.Rows[0]["isKNTN"].ToString());
clsChi_Tiet_Phieu_Nhap_Vat_Tu chitiet = new clsChi_Tiet_Phieu_Nhap_Vat_Tu();
DataTable vChiTiet = (DataTable)chitiet.GetAll(txtMaPhieuNhap.Text);
for (int i = 0; i < vChiTiet.Rows.Count; i++)
{
// dataTable1.Rows[i]["Ma_phieu_nhap"] = vChiTiet.Rows[i]["ma_phieu_nhap"].ToString();
DataRow dr = dataTable1.NewRow();
//dr["Ma_vat_tu"] = vChiTiet.Rows[i]["ma_phieu_nhap"].ToString();
dr["ma_vat_tu"] = vChiTiet.Rows[i]["ma_vat_tu"].ToString();
dr["Ten_vat_tu"] = vChiTiet.Rows[i]["Ten_vat_tu"].ToString();
// dr["don_vi_tinh"] = vChiTiet.Rows[i]["don_vi_tinh"].ToString() ;
dr["chat_luong"] = vChiTiet.Rows[i]["chat_luong"].ToString();
dr["ID_chat_luong"] = vChiTiet.Rows[i]["ID_chat_luong"].ToString();
dr["so_luong_thuc_lanh"] = vChiTiet.Rows[i]["so_luong_thuc_lanh"].ToString();
dr["don_gia"] = vChiTiet.Rows[i]["don_gia"].ToString();
dr["Thanh_tien"] = vChiTiet.Rows[i]["thanh_tien"].ToString();// int.Parse(vChiTiet.Rows[i]["don_gia"].ToString()) * int.Parse(vChiTiet.Rows[i]["so_luong_thuc_lanh"].ToString());
dr["Ten_Don_vi_tinh"] = vChiTiet.Rows[i]["ten_don_vi_tinh"].ToString();
dr["ID_Don_vi_tinh"] = vChiTiet.Rows[i]["ID_don_vi_tinh"].ToString();
dataTable1.Rows.Add(dr);
}
if (clsChi_Tiet_Phieu_Nhap_Vat_Tu.KTVTChuaDuyet(clsNhap.Ma_phieu_nhap) == true)
{
//khong cho sua thong tin tren luoi
disableInputForm();
MessageBox.Show("Phiếu nhập này chứa vật tư đã phân vào kho, không thể chỉnh sữa thông tin.");
return false;
}
//MessageBox.Show("Tồn tại mã phiếu nhập trong csdl");
return true;
}
else
{
//MessageBox.Show("Chưa Tồn tại mã phiếu nhập trong csdl");
}
}
catch (Exception ex)
{
MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex));
}
return false;
}
private void Load_DataNo()
{
clsChi_Tiet_Phieu_Nhap_Vat_Tu pn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu();
dtPhieuNhapNo = pn.GetAll(cbbPhieuNo.GetItemText(this.cbbPhieuNo.SelectedItem));
gridNhapNo.DataSource = dtPhieuNhapNo;
}
