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 { }
}
