public void truyendulieu() { try { if (rows == null) { return; } KhoCongTytxt.Text = "NGUYÊN VẬT LIỆU"; foreach (var t in rows) { if (!(t is DataRow row)) { continue; } var SCD = row["SCD"]; row.ItemArray = new object[4]; gridView1.AddNewRow(); gridView1.OptionsNavigation.AutoFocusNewRow = true; gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colSCD, SCD); var db = new MyDBContextDataContext(); var dulieu = (from s in db.DonSanXuat_LanhLieu_QuanLyDonHang_SanXuat_Null_PhieuXuatKho() where s.SCD == SCD.ToString() select s).Single(); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colSoLuongXuat, dulieu.LanhLieu); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colTenHangHoa, dulieu.VatLieu); BoPhantxt.Text = dulieu.BoPhan; if (dulieu.BoPhan == "SAU IN" || dulieu.BoPhan == "OFFSET" && dulieu.TenKhachHang != PrintRibbon.AD) { var khogiayin = (from s in db.tbKhoGiayIns where s.KhoIn == dulieu.KhoGiayIn && s.CatGiay == s.CatGiay && s.GiayLon == dulieu.QuyCach select s).Single(); var lst = (from a in db.tbVatLieus where a.TenHangHoa == dulieu.VatLieu && a.QuyCach == khogiayin.GiayLon select a).Single(); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colDonViTinh, lst.DonViTinh); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colQuyCach, lst.QuyCach); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaHang, lst.MaHang); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaAD, lst.MaAvery); } else if (dulieu.BoPhan == "STICKER" || dulieu.BoPhan == "IN CHỮ VI TÍNH" && dulieu.PhuongPhapIn == "Máy in Sticker (In Chữ)") { var lst = (from a in db.tbVatLieus where a.TenHangHoa == dulieu.VatLieu && a.QuyCach == dulieu.QuyCach select a).Single(); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colDonViTinh, lst.DonViTinh); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colQuyCach, lst.QuyCach); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaHang, lst.MaHang); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaAD, lst.MaAvery); } else if (dulieu.BoPhan == "TEM VẢI" && dulieu.TenKhachHang != PrintRibbon.AD) { var kichthuoc = dulieu.KichThuoc.Split('*'); var lst = (from a in db.tbVatLieus where a.TenHangHoa == dulieu.VatLieu select a).ToList(); foreach (var item in lst) { var quycach = item.QuyCach.Split('*'); if (kichthuoc[0] != quycach[0]) { continue; } gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colDonViTinh, item.DonViTinh); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colQuyCach, item.QuyCach); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaHang, item.MaHang); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaAD, item.MaAvery); } } else { var lst = (from a in db.tbVatLieus where a.TenHangHoa == dulieu.VatLieu select a).Single(); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colDonViTinh, lst.DonViTinh); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colQuyCach, lst.QuyCach); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaHang, lst.MaHang); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colMaAD, lst.MaAvery); } } } catch { } }