Esempio n. 1
0
        private void procDonSanXuat_ViewGridControl_Click(object sender, EventArgs e)
        {
            chieudai = kichThuocTextEdit.Text.ToUpper().Replace("MM", "");
            // xóa dữ liệu
            Clear();

            // click chọn sẽ tab đến bộ phận của đơn hàng đó
            try
            {
                var db = new MyDBContextDataContext();
                var ll = (from s in db.DonSanXuat_LanhLieu_QuanLyDonHang_SanXuat_Null() where s.SCD == sCDTextEdit.Text select s).Single();
                if (ll.BoPhanSX != null)
                {
                    boPhanTextEdit.Text = ll.BoPhanSX;
                    MessageBox.Show("Đơn hàng đã chuyển đổi bộ phận " + ll.BoPhanSX + " , mọi người xem kỹ khi tính liệu");
                }

                var vatlieu = (from s in db.VatLieu_4C() where s.TenHangHoa == vatLieuTextEdit.Text select s).ToList();
                if (boPhanTextEdit.Text == offset)
                {
                    xtraTabControl1.SelectedTabPage        = tpOffset;
                    QuycachOffset.Properties.DataSource    = vatlieu;//vlCtr.GetData1C(vatLieuTextEdit.Text);
                    QuycachOffset.Properties.DisplayMember = "QuyCach";
                    QuycachOffset.Properties.ValueMember   = "QuyCach";
                    if (ll.LanhLieu == null)
                    {
                        if (tenKhachHangTextEdit.Text == PrintRibbon.AD)
                        {
                            SLSXOffset.Value = soLuongTextEdit.Value;
                        }
                        else
                        {
                            SLSXOffset.Value = soLuongTextEdit.Value * 115 / 100;
                        }
                        if (khoTextEdit.Text == banthanhpham || khoTextEdit.Text == thanhpham)
                        {
                            CatGiayOffset.Text = "1K";
                        }
                    }
                    else
                    {
                        KhoGiayInOffset.Text         = ll.KhoGiayIn;
                        CatGiayOffset.Text           = ll.CatGiay;
                        soLuongDanTrangTextEdit.Text = ll.SoLuongDanTrang.ToString();
                        SLSXOffset.Text        = ll.SoLuongSanXuat.ToString();
                        soTrangInTextEdit.Text = ll.SoTrangIn;
                        buHaoTextEdit.Text     = ll.BuHao.ToString();
                        ctpOffsetTextEdit.Text = ll.CtpOffset.ToString();
                        QuycachOffset.Text     = ll.QuyCach;
                        if (ll.Kho == nguyenvatlieu)
                        {
                            var vl = (from a in db.tbVatLieus
                                      where a.TenHangHoa == ll.VatLieu && a.QuyCach == ll.QuyCach
                                      select a).Single();
                            btnTinhOffset.Text = ll.LanhLieu + " " + ll.DonViTinh + " (" + vatLieuTextEdit.Text +
                                                 ") " +
                                                 " " + ll.QuyCach;
                        }
                        else
                        {
                            btnTinhOffset.Text = ll.LanhLieu + " " + ll.DonViTinh + " " + vatLieuTextEdit.Text;
                        }
                    }
                }
                else if (boPhanTextEdit.Text == temvai)
                {
                    //var vatlieu = (from s in db.VatLieu_4C() where s.TenHangHoa == vatLieuTextEdit.Text select s).ToList();
                    QuyCachTemVaiSearch.Properties.DataSource    = vatlieu;
                    QuyCachTemVaiSearch.Properties.DisplayMember = "QuyCach";
                    QuyCachTemVaiSearch.Properties.ValueMember   = "QuyCach";

                    xtraTabControl1.SelectedTabPage = tpTemVai;
                    var _kichthuoc = chieudai.Split('*');
                    txtChieuDai.Text = _kichthuoc[1];
                    if (ll.LanhLieu == null)
                    {
                        txtSLSXTemVai.Value = soLuongTextEdit.Value;
                        txtChieuDai.Text    = _kichthuoc[1];

                        if (tenKhachHangTextEdit.Text == PrintRibbon.AD)
                        {
                            txtBuHaoTemVai.Value = (decimal)1.06;
                            foreach (var item in vatlieu)
                            {
                                QuyCachTemVaiSearch.Text = item.QuyCach;
                                break;
                            }
                        }
                        else
                        {
                            txtBuHaoTemVai.Value = (decimal)1.06;
                        }
                    }
                    else
                    {
                        if (ll.SoLuongSanXuat != null)
                        {
                            txtSLSXTemVai.Value = ll.SoLuongSanXuat.Value;
                        }
                        txtBuHaoTemVai.Text      = ll.BuHao.ToString();
                        btnTinhTemVai.Text       = ll.LanhLieu.ToString();
                        QuyCachTemVaiSearch.Text = ll.QuyCach;
                    }
                }
                else if (boPhanTextEdit.Text == danhthiep)
                {
                    xtraTabControl1.SelectedTabPage = tpDanhThiep;
                    if (ll.LanhLieu == null)
                    {
                        txtBuHaoDanhThiep.Text = "1.04";
                        txtSLDTDanhThiep.Value = 1;
                    }
                    else
                    {
                        txtSLSX_DanhThiep.Text = ll.SoLuongSanXuat.ToString();
                        txtSLDTDanhThiep.Text  = ll.SoLuongDanTrang.ToString();
                        txtBuHaoDanhThiep.Text = ll.BuHao.ToString();
                        txtCTPDanhThiep.Text   = ll.CtpOffset.ToString();
                        btnTinhDanhThiep.Text  = ll.LanhLieu + " " + ll.DonViTinh;
                    }
                }
                else if (boPhanTextEdit.Text == sticker)
                {
                    //var vatlieu = (from s in db.VatLieu_4C() where s.TenHangHoa == vatLieuTextEdit.Text select s).ToList();
                    QuyCachStickerSearch.Properties.DataSource    = vatlieu;
                    QuyCachStickerSearch.Properties.DisplayMember = "QuyCach";
                    QuyCachStickerSearch.Properties.ValueMember   = "QuyCach";

                    xtraTabControl1.SelectedTabPage = tpSticker;
                    var chon = chieudai.Split('*');
                    if (radioGroup1.SelectedIndex == 0)
                    {
                        _dantrang = Math.Round(Convert.ToDouble(chon[0]), 0);
                        _tinhlieu = Math.Round(Convert.ToDouble(chon[1]), 0);
                    }
                    else
                    {
                        _dantrang = Math.Round(Convert.ToDouble(chon[1]), 0);
                        _tinhlieu = Math.Round(Convert.ToDouble(chon[0]), 0);
                    }
                    if (ll.LanhLieu == null)
                    {
                        txtBuHaoSticker.Text = "1.05";
                        txtSLDTSticker.Text  = "2";
                    }
                    else
                    {
                        txtSLSXSticker.Text       = ll.SoLuongSanXuat.ToString();
                        txtSLDTSticker.Text       = ll.SoLuongDanTrang.ToString();
                        txtBuHaoSticker.Text      = ll.BuHao.ToString();
                        btnTinhSticker.Text       = ll.LanhLieu + " " + ll.DonViTinh;
                        QuyCachStickerSearch.Text = ll.QuyCach;
                    }
                }
                else if (boPhanTextEdit.Text == inchu)
                {
                    //var vatlieu = (from s in db.VatLieu_4C() where s.TenHangHoa == vatLieuTextEdit.Text select s).ToList();
                    QuyCachInChuSearch.Properties.DataSource    = vatlieu;
                    QuyCachInChuSearch.Properties.DisplayMember = "QuyCach";
                    QuyCachInChuSearch.Properties.ValueMember   = "QuyCach";
                    xtraTabControl1.SelectedTabPage             = tpInChuViTinh;
                    var chon = chieudai.Split('*');
                    if (radioGroup2.SelectedIndex == 0)
                    {
                        _dantrang = Math.Round(Convert.ToDouble(chon[0]), 0);
                        _tinhlieu = Math.Round(Convert.ToDouble(chon[1]), 0);
                    }
                    else
                    {
                        _dantrang = Math.Round(Convert.ToDouble(chon[0]), 0);
                        _tinhlieu = Math.Round(Convert.ToDouble(chon[1]), 0);
                    }


                    if (ll.LanhLieu == null)
                    {
                        txtBuHaoInChu.Text = "1.03";
                        if (ll.LoaiSanPham == "TEM GIẤY")
                        {
                            txtSLSXInChu.BackColor  = Color.LightGreen;
                            txtSLDTInChu.BackColor  = Color.LightGreen;
                            txtBuHaoInChu.BackColor = Color.LightGreen;
                            txtSLDTInChu.Text       = "1";
                        }
                        else if (ll.LoaiSanPham == "STICKER")
                        {
                            txtSLSXInChu.BackColor  = Color.LightSalmon;
                            txtSLDTInChu.BackColor  = Color.LightSalmon;
                            txtBuHaoInChu.BackColor = Color.LightSalmon;
                            radioGroup2.BackColor   = Color.LightSalmon;
                            txtSLDTInChu.Text       = "2";
                        }
                    }
                    else
                    {
                        txtSLSXInChu.Text       = ll.SoLuongSanXuat.ToString();
                        txtSLDTInChu.Text       = ll.SoLuongDanTrang.ToString();
                        txtBuHaoInChu.Text      = ll.BuHao.ToString();
                        btnTinhInChu.Text       = ll.LanhLieu + " " + ll.DonViTinh;
                        QuyCachInChuSearch.Text = ll.QuyCach;
                    }
                }
                else if (boPhanTextEdit.Text == sauin)
                {
                    xtraTabControl1.SelectedTabPage = tpSauIn;

                    txtKhoGiayInSauIn.Text = ll.KhoGiayIn;
                    txtCatGiaySauIn.Text   = ll.CatGiay;
                    txtSLDTSauIn.Text      = ll.SoLuongDanTrang.ToString();
                    txtSLSXSauIn.Text      = ll.SoLuongSanXuat.ToString();
                    txtSLTISauIn.Text      = ll.SoTrangIn;
                    txtBuHaoSauIn.Text     = ll.BuHao.ToString();
                    var khoGiayIn = (from a in db.tbKhoGiayIns where a.KhoIn == txtKhoGiayInSauIn.Text && a.CatGiay == txtCatGiaySauIn.Text select a).Single();
                    btnTinhSauIn.Text = ll.LanhLieu + " " + ll.DonViTinh + " (" + ll.VatLieu + ") " + khoGiayIn.GiayLon;
                }
                else if (boPhanTextEdit.Text == kts)
                {
                    xtraTabControl1.SelectedTabPage = tpKyThuatSo;
                    if (ll.LanhLieu == null)
                    {
                        if (soLuongTextEdit.Value < 5000)
                        {
                            txtBuHaoKTS.Text = "3";
                        }
                        else
                        {
                            txtBuHaoKTS.Text = "5";
                        }
                    }
                    else
                    {
                        txtSLSXKyThuatSo.Text  = ll.SoLuongSanXuat.ToString();
                        txtKhoGiayInKTS.Text   = ll.KhoGiayIn;
                        txtBuHaoKTS.Text       = ll.BuHao.ToString();
                        txtSoLuongSizeKTS.Text = ll.SoLuongSize.ToString();
                        txtSLDTKTS.Text        = ll.SoLuongDanTrang.ToString();
                        btnTinhKTS.Text        = ll.LanhLieu + " " + ll.DonViTinh + " " + ll.KhoGiayIn;
                    }
                }
            }
            catch (Exception)
            {
                // ignored
            }
        }