private void btnDanhSachDonHang_Click(object sender, EventArgs e) { try { overlay.StartLoading(groupControl2); var db = new MyDBContextDataContext(); var dsdonhang = (from s in db.tbDonSanXuat_Averies where s.XacNhan == null && s.NhanVien == nvObj.Tennhanvien && s.No == s.GopDon orderby s.GopDon, s.No ascending select s).ToList(); var tongsl = 0; var tongdh = 0; foreach (var ds in dsdonhang) { tenSanPhamTextEdit.Text = ds.SO; Taoscd: sCDTextEdit.Text = sscd.TaoSCD(); var tong = (from s in db.tbDonSanXuats where s.SCD == sCDTextEdit.Text select s).ToList(); if (tong.Count > 0) { goto Taoscd; } //var donSanXuats = (from s in db.tbDonSanXuats select s).ToList(); //foreach (var itemDonSanXuat in donSanXuats) //{ // if (sCDTextEdit.Text == itemDonSanXuat.SCD) // goto scd; //} if (sCDTextEdit.Text.Length > 14 && !string.IsNullOrEmpty(sCDTextEdit.Text)) { if (maDonHangTextEdit.Text.Length > 8) { var dsx = (from a in db.tbDonSanXuat_Averies where a.SO == tenSanPhamTextEdit.Text select a).Single(); var soluong = Convert.ToInt32(soLuongSpinEdit.Value); var tb = new tbDonSanXuat(); tb.SCD = sCDTextEdit.Text; tb.MaDonHang = maDonHangTextEdit.Text; tb.PhienBan = txtPhienBan.Text; tb.TenKhachHang = txtKhachHang.Text; tb.NgayXuongDon = ngayXuongDonDateEdit.DateTime; tb.NgayGiaoHang = ngayGiaoHangDateEdit.DateTime; var gopdon = (from s in db.GopDon_Avery(nvObj.Tennhanvien) where s.gopdon == dsx.GopDon select s).Single(); if (gopdon.CountNo == 1) { tb.TenSanPham = dsx.SO + " - " + dsx.Item; // } else { tb.TenSanPham = dsx.Item; //dsx.SO + " - " + } tb.LoaiSanPham = txtLoaiSanPham.Text; tb.PhuongPhapIn = txtPhuongPhapIn.Text; tb.KichThuoc = kichThuocTextEdit.Text; tb.SoLuong = soluong; tb.VatLieu = vatLieuComboBox.Text; tb.GiaCongMatPhai = giaCongMatPhaiTextEdit.Text; tb.GiaCongMatTrai = giaCongMatTraiTextEdit.Text; //var lst = (from s in db.tbDanhSachSanPhams select s).ToList(); //foreach (var dssPham in lst) //{ // if (dssPham.TenSanPham != tenSanPhamTextEdit.Text) continue; // tb.HinhMatPhai = dssPham.HinhMatPhai; // tb.HinhMatTrai = dssPham.HinhMatTrai; // tb.HinhKhuon = dssPham.HinhKhuon; //} tb.MauMatPhai = mauMatPhaiTextEdit.Text; tb.MauMatTrai = mauMatTraiTextEdit.Text; tb.PhuongPhapCat = phuongPhapCatTextEdit.Text; tb.BoGoc = boGocTextEdit.Text; tb.DucLo = ducLoTextEdit.Text; tb.LoaiChi = loaiChiTextEdit.Text; tb.BTPSoLuongTonKho = Convert.ToInt32(bTPSoLuongTonKhoSpinEdit.Value); tb.TPSoLuongTonKho = Convert.ToInt32(tPSoLuongTonKhoSpinEdit.Value); tb.BTPTonKhoCongTy = Convert.ToInt32(bTPTonKhoCongtySpinEdit.Value); tb.TPTonKhoCongTy = Convert.ToInt32(TPTonKhoCongtySpinEdit.Value); tb.BoPhan = txtBoPhan.Text; tb.ChamCatDapHop = chamCatDapHopTextEdit.Text; tb.Khac = khacTextEdit.Text; tb.DoDai = doDaiTextEdit.Text; tb.InChu_MaVach = inChu_MaVachTextEdit.Text; tb.GiaCongSau = giaCongSauTextEdit.Text; tb.Kho = txtKho.Text; tb.SKU = (int)txtSKU.Value; tb.STT = dsx.No; var so = Empty; var tbDonSanXuatAveries = (from s in db.tbDonSanXuat_Averies where s.XacNhan == null select s).ToList(); foreach (var item in tbDonSanXuatAveries) { if (item.GopDon != dsx.GopDon) { continue; } item.scd = sCDTextEdit.Text; item.XacNhan = 1; //db.SubmitChanges(); if (gopdon.CountNo > 1) { so = so + item.SO + " , "; } } if (gopdon.CountNo > 1) { tb.ChuY = chuYTextEdit.Text + Environment.NewLine + so + " dùng chung layout"; } else { tb.ChuY = chuYTextEdit.Text; } tb.NhanVienNghiepVu = nvObj.Tennhanvien; tb.ThoiGianXuongDon = DateTime.Now; db.tbDonSanXuats.InsertOnSubmit(tb); db.SubmitChanges(); var qldh = new tbQuanLyDonHang { IDQuanLyDonHang = sCDTextEdit.Text }; db.tbQuanLyDonHangs.InsertOnSubmit(qldh); var ll = new tbLanhLieu { IDLanhLieu = sCDTextEdit.Text }; db.tbLanhLieus.InsertOnSubmit(ll); db.SubmitChanges(); var thietke = new tbBaoCaoThietKe { IDBaoCaoThietKe = sCDTextEdit.Text, Size = khacTextEdit.Text, SpSize = soLuongSpinEdit.Text }; db.tbBaoCaoThietKes.InsertOnSubmit(thietke); db.SubmitChanges(); var nghiepvu = new tbBaoCaoNghiepVu() { IDBaoCaoNghiepVu = sCDTextEdit.Text, Size = khacTextEdit.Text }; db.tbBaoCaoNghiepVus.InsertOnSubmit(nghiepvu); db.SubmitChanges(); var tb4 = new tbQuanLyTienTe { IDTienTe = sCDTextEdit.Text, DonGiaSanPham = Convert.ToDouble(donGiaSanPhamSpinEdit.Value), DonGiaKhuon = Convert.ToDouble(donGiaKhuonSpinEdit.Value), DonGiaMau = Convert.ToDouble(donGiaMauSpinEdit.Value), DonGiaVanChuyen = Convert.ToDouble(donGiaVanChuyenSpinEdit.Value), TongTien = Convert.ToDouble(tongTienSpinEdit.Value), NgoaiTe = ngoaiTeComboBox.Text, GiaTienUSD = (int)txtGiaTienUSD.Value, VAT = vat }; db.tbQuanLyTienTes.InsertOnSubmit(tb4); db.SubmitChanges(); var tb6 = new tbSanXuat { IDSanXuat = sCDTextEdit.Text }; db.tbSanXuats.InsertOnSubmit(tb6); db.SubmitChanges(); var donhang = new tbDonHangTemVaiAvery(); donhang.IDDonHangTemVaiAvery = sCDTextEdit.Text; donhang.Item = dsx.Item; donhang.SO = gopdon.CountNo != 1 ? so : dsx.SO; donhang.DanhSach = dsx.DanhSach; db.tbDonHangTemVaiAveries.InsertOnSubmit(donhang); db.SubmitChanges(); //frmDonSanXuat_Avery_Them_Load(sender,e); tongsl = tongsl + soluong; tongdh = tongdh + 1; } else { MessageBox.Show("Bạn chưa nhập mã đơn hàng"); } } else { MessageBox.Show("Bạn chưa nhập mã SCD, hoặc mã SCD bị trùng"); } } overlay.EndLoading(); MessageBox.Show("Tổng số đơn hàng thêm vào: " + tongdh + Environment.NewLine + "Tổng số lượng là : " + tongsl); } catch (Exception exception) { overlay.EndLoading(); MessageBox.Show(exception.ToString()); // ignored } }
private void simpleButton1_Click(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var donSanXuats = (from s in db.tbDonSanXuats select s).ToList(); var tong = 0; foreach (var itemDonSanXuat in donSanXuats) { if (sCDTextEdit.Text == itemDonSanXuat.SCD) { tong = tong + 1; } } if (sCDTextEdit.Text.Length > 14 & tong == 0) { if (maDonHangTextEdit.Text.Length > 8) { try { var tb = new tbDonSanXuat(); tb.SCD = sCDTextEdit.Text; tb.MaDonHang = maDonHangTextEdit.Text; tb.PhienBan = txtPhienBan.Text; tb.TenKhachHang = txtKhachHang.Text; tb.NgayXuongDon = ngayXuongDonDateEdit.DateTime; tb.NgayGiaoHang = ngayGiaoHangDateEdit.DateTime; tb.TenSanPham = tenSanPhamTextEdit.Text; tb.LoaiSanPham = txtLoaiSanPham.Text; tb.PhuongPhapIn = txtPhuongPhapIn.Text; tb.KichThuoc = kichThuocTextEdit.Text; tb.SoLuong = Convert.ToInt32(soLuongSpinEdit.Value); tb.VatLieu = vatLieuComboBox.Text; tb.GiaCongMatPhai = giaCongMatPhaiTextEdit.Text; tb.GiaCongMatTrai = giaCongMatTraiTextEdit.Text; var lst = (from s in db.tbDanhSachSanPhams select s).ToList(); foreach (var itemTbDanhSachSanPham in lst) { if (itemTbDanhSachSanPham.TenSanPham != tenSanPhamTextEdit.Text) { continue; } tb.HinhMatPhai = itemTbDanhSachSanPham.HinhMatPhai; tb.HinhMatTrai = itemTbDanhSachSanPham.HinhMatTrai; tb.HinhKhuon = itemTbDanhSachSanPham.HinhKhuon; } tb.MauMatPhai = mauMatPhaiTextEdit.Text; tb.MauMatTrai = mauMatTraiTextEdit.Text; tb.PhuongPhapCat = phuongPhapCatTextEdit.Text; tb.BoGoc = boGocTextEdit.Text; tb.DucLo = ducLoTextEdit.Text; tb.LoaiChi = loaiChiTextEdit.Text; tb.BTPSoLuongTonKho = Convert.ToInt32(bTPSoLuongTonKhoSpinEdit.Value); tb.TPSoLuongTonKho = Convert.ToInt32(tPSoLuongTonKhoSpinEdit.Value); tb.BTPTonKhoCongTy = Convert.ToInt32(bTPTonKhoCongtySpinEdit.Value); tb.TPTonKhoCongTy = Convert.ToInt32(TPTonKhoCongtySpinEdit.Value); tb.BoPhan = txtBoPhan.Text; tb.ChamCatDapHop = chamCatDapHopTextEdit.Text; tb.Khac = khacTextEdit.Text; tb.DoDai = doDaiTextEdit.Text; tb.InChu_MaVach = inChu_MaVachTextEdit.Text; tb.GiaCongSau = giaCongSauTextEdit.Text; tb.Kho = txtKho.Text; tb.ChuY = chuYTextEdit.Text; tb.SKU = (int)txtSKU.Value; tb.NhanVienNghiepVu = nvObj.Tennhanvien; tb.ThoiGianXuongDon = DateTime.Now; db.tbDonSanXuats.InsertOnSubmit(tb); var tb2 = new tbQuanLyDonHang { IDQuanLyDonHang = sCDTextEdit.Text }; db.tbQuanLyDonHangs.InsertOnSubmit(tb2); var tb3 = new tbLanhLieu { IDLanhLieu = sCDTextEdit.Text }; db.tbLanhLieus.InsertOnSubmit(tb3); if (CheckVAT.CheckState == CheckState.Unchecked || tongTienSpinEdit.Text == null) { vat = 1; } var tb4 = new tbQuanLyTienTe { IDTienTe = sCDTextEdit.Text, DonGiaSanPham = Convert.ToDouble(donGiaSanPhamSpinEdit.Value), DonGiaKhuon = Convert.ToDouble(donGiaKhuonSpinEdit.Value), DonGiaMau = Convert.ToDouble(donGiaMauSpinEdit.Value), DonGiaVanChuyen = Convert.ToDouble(donGiaVanChuyenSpinEdit.Value), TongTien = Convert.ToDouble(tongTienSpinEdit.Value), NgoaiTe = ngoaiTeComboBox.Text, VAT = vat }; db.tbQuanLyTienTes.InsertOnSubmit(tb4); var sanxuat = new tbSanXuat { IDSanXuat = sCDTextEdit.Text }; db.tbSanXuats.InsertOnSubmit(sanxuat); var thietke = new tbBaoCaoThietKe { IDBaoCaoThietKe = sCDTextEdit.Text, SpSize = soLuongSpinEdit.Text }; db.tbBaoCaoThietKes.InsertOnSubmit(thietke); var _nghiepvu = new tbBaoCaoNghiepVu() { IDBaoCaoNghiepVu = sCDTextEdit.Text, }; db.tbBaoCaoNghiepVus.InsertOnSubmit(_nghiepvu); var donhangtemvai = new tbDonHangTemVaiAvery { IDDonHangTemVaiAvery = sCDTextEdit.Text, }; db.tbDonHangTemVaiAveries.InsertOnSubmit(donhangtemvai); db.SubmitChanges(); MessageBox.Show(PrintRibbon.themthanhcong); var xn = nvObj.Tennhanvien + " " + DateTime.Now; if (nvObj.Bophan == "QUẢN LÝ SẢN XUẤT") { var qldh = (from s in db.tbQuanLyDonHangs where s.IDQuanLyDonHang == sCDTextEdit.Text select s).Single(); qldh.NghiepVu_XuongDon = xn; db.SubmitChanges(); } } catch { // ignored } } else { MessageBox.Show("Bạn chưa nhập mã đơn hàng"); } } else { MessageBox.Show("Bạn chưa nhập mã SCD, hoặc mã SCD bị trùng"); } }