private void hiendonhang_CheckedChanged(object sender, EventArgs e) { if (hiendonhang.Checked == true) { btnXacNhan.Enabled = false; var db = new MyDBContextDataContext(); var lst = (from s in db.DonSanXuat_QuanLyDonhang_View() where s.BoPhan == danhthiep select s).ToList(); foreach (var item in lst) { if (item.NghiepVu_XuongDon != null) { item.NghiepVu_XuongDon = "True"; _nghiepvuCheck.ValueChecked = "True"; } if (item.CtpNhan != null) { item.CtpNhan = "True"; CtpNhanCheck.ValueChecked = "True"; } if (item.CtpHoanThanh != null) { item.CtpHoanThanh = "True"; CtpHoanthanhCheck.ValueChecked = "True"; } if (item.DanhThiepNhan != null) { item.DanhThiepNhan = "True"; DanhthiepNhanCheck.ValueChecked = "True"; } if (item.DanhThiepHoanThanh != null) { item.DanhThiepHoanThanh = "True"; DanhthiepHoanthanhCheck.ValueChecked = "True"; } if (item.SauInNhan != null) { item.SauInNhan = "True"; SauinNhanCheck.ValueChecked = "True"; } if (item.SauInHoanThanh != null) { item.SauInHoanThanh = "True"; SauinHoanthanhCheck.ValueChecked = "True"; } if (item.HoanThanh != null) { item.HoanThanh = "True"; SanxuatHoanThanhCheck.ValueChecked = "True"; } } procQuanLyDonhang_ViewGridControl.DataSource = lst; } else { frmDanhThiep_Load(sender, e); btnXacNhan.Enabled = true; } }
private void dateEdit1_EditValueChanged(object sender, EventArgs e) { var db = new MyDBContextDataContext(); IQueryable <tbDonSanXuat_Avery> lst = null; if (nvObj.Bophan == PrintRibbon.nghiepvu) { tbl = donSanXuatAveryCtr.DonSanXuatAD_NhanVien_XacNhanNull(nvObj.Tennhanvien); lst = from s in db.tbDonSanXuat_Averies where s.OrderDate == dateEdit1.DateTime && s.DanhSach == txtDanhSach.Value && s.NhanVien == nvObj.Tennhanvien orderby s.No select s; } if (nvObj.Bophan == PrintRibbon.khobtp) { tbl = donSanXuatAveryCtr.DonSanXuatAD_NhanVien_XacNhan2(dateEdit1.DateTime.ToString("yyyy-MM-dd"), txtDanhSach.Text); lst = from s in db.tbDonSanXuat_Averies where s.XacNhan == 2 orderby s.No select s; } GridControl1.DataSource = tbl; //dateEdit1.DateTime = DateTime.Today; }
private void frmKhoBTP_TPXuat_Load(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var lst = from s in db.tbKhoBTP_TPs where s.NhapXuat == "Xuất" select s; tbKhoBTP_TPGridControl.DataSource = lst; }
private void btnLuu_Click(object sender, EventArgs e) { if (flagluu != 1) { if (flagluu != 2) { return; } var db = new MyDBContextDataContext(); var tb = (from s in db.tbDanhSachSanPhams where s.MaSanPham == maSanPhamTextEdit.Text select s) .Single(); tb.TenKhachHang = txtKhachHang.Text; tb.TenSanPham = TENSANPHAMTextEdit.Text; tb.LoaiSanPham = txtLoaiSanPham.Text; tb.PhuongPhapIn = txtPhuongPhapIn.Text; tb.KichThuoc = KICHTHUOCTextEdit.Text; tb.DonViTinh = txtDonViTinh.Text; tb.GiaCongMatPhai = GIACONGMATPHAITextEdit.Text; tb.GiaCongMatTrai = GIACONGMATTRAITextEdit.Text; tb.MauMatPhai = MAUMATPHAITextEdit.Text; tb.MauMatTrai = MAUMATTRAITextEdit.Text; tb.PhuongPhapCat = PHUONGPHAPCATTextEdit.Text; tb.BoGoc = BOGOCTextEdit.Text; tb.Lo = LOTextEdit.Text; tb.XoChi = XOCHITextEdit.Text; tb.TinhTrang = TINHTRANGTextEdit.Text; tb.GhiChu = GHICHUTextEdit.Text; db.SubmitChanges(); MessageBox.Show("Cập nhật Thành Công"); frmDanhSachSanPham_Load(sender, e); } else { var db = new MyDBContextDataContext(); var tb = new tbDanhSachSanPham(); dt = con.GetData("select MaSanPham from tbDanhSachSanPham order by (MaSanPham) asc"); tb.MaSanPham = SinhMaTuDong(dt); tb.TenKhachHang = txtKhachHang.Text; tb.TenSanPham = TENSANPHAMTextEdit.Text; tb.LoaiSanPham = txtLoaiSanPham.Text; tb.PhuongPhapIn = txtPhuongPhapIn.Text; tb.KichThuoc = KICHTHUOCTextEdit.Text; tb.DonViTinh = txtDonViTinh.Text; tb.GiaCongMatPhai = GIACONGMATPHAITextEdit.Text; tb.GiaCongMatTrai = GIACONGMATTRAITextEdit.Text; tb.MauMatPhai = MAUMATPHAITextEdit.Text; tb.MauMatTrai = MAUMATTRAITextEdit.Text; tb.PhuongPhapCat = PHUONGPHAPCATTextEdit.Text; tb.BoGoc = BOGOCTextEdit.Text; tb.Lo = LOTextEdit.Text; tb.XoChi = XOCHITextEdit.Text; tb.TinhTrang = TINHTRANGTextEdit.Text; tb.GhiChu = GHICHUTextEdit.Text; db.tbDanhSachSanPhams.InsertOnSubmit(tb); db.SubmitChanges(); MessageBox.Show("Thêm Sản Phẩm Thành Công"); frmDanhSachSanPham_Load(sender, e); } }
public static int Them(this int tong, string soluong, string scd, string so, string size, int solanin, DateTime orderdate, string soluong2, int _tong) { if (_tong == 0) { db = new MyDBContextDataContext(); } for (int i = 0; i < solanin; i++) { tbTemDanAd tb = new tbTemDanAd { IDTemDanAD = scd, SO = so, Size = size, QTY = soluong, OrderDate = orderdate }; db.tbTemDanAds.InsertOnSubmit(tb); } tong = _tong + Convert.ToInt32(soluong) * solanin; if (tong == Convert.ToInt32(soluong2)) { db.SubmitChanges(); } return(tong); }
private void frmXem_Load(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var lst = (from s in db.tbTemDanAds where s.IDTemDanAD == scd select s).ToList(); gridControl1.DataSource = lst; }
private void btnCapNhat_Click(object sender, EventArgs e) { try { for (var i = 0; i <= gridView1.RowCount - 1; i++) { var dr = gridView1.GetDataRow(i); var db = new MyDBContextDataContext(); var tb = (from s in db.tbPhanQuyens where s.MaNhanVien == dr["MaNhanVien"].ToString() select s).Single(); tb.NghiepVu = dr["NghiepVu"].ToString(); tb.ThietKe = dr["ThietKe"].ToString(); tb.CTP = dr["CTP"].ToString(); tb.CTF = dr["CTF"].ToString(); tb.Offset = dr["Offset"].ToString(); tb.TemVai = dr["TemVai"].ToString(); tb.SauIn = dr["SauIn"].ToString(); tb.KiemPham = dr["KiemPham"].ToString(); tb.KhoNVL = dr["KhoNVL"].ToString(); tb.KhoBTP = dr["KhoBTP"].ToString(); tb.QuanLyChatLuong = dr["QuanLyChatLuong"].ToString(); tb.QuanLySanXuat = dr["QuanLySanXuat"].ToString(); tb.DanhThiep = dr["DanhThiep"].ToString(); tb.KyThuatSo = dr["KyThuatSo"].ToString(); tb.InChuViTinh = dr["InChuViTinh"].ToString(); tb.Sticker = dr["Sticker"].ToString(); db.SubmitChanges(); } frmPhanQuyen_Load(sender, e); MessageBox.Show(PrintRibbon.capnhat); } catch { } }
private void hiendonhang_CheckedChanged(object sender, EventArgs e) { if (hiendonhang.Checked == true) { btnThuHoiDon.Enabled = true; btnXacNhan.Enabled = false; var db = new MyDBContextDataContext(); var lst = db.LoadData_DonSanXuat_QuanLyDonHang_NghiepVu().ToList(); foreach (var item in lst) { if (item.NghiepVu_XuongDon != null) { item.NghiepVu_XuongDon = "True"; } if (item.ThietKeNhan != null) { item.ThietKeNhan = "True"; } if (item.ThietKeHoanThanh != null) { item.ThietKeHoanThanh = "True"; } if (item.HoanThanh != null) { item.HoanThanh = "True"; } } procQuanLyDonhang_ViewGridControl.DataSource = lst; } else { frmNghiepVu_Load(sender, e); btnXacNhan.Enabled = true; } }
private void btnXacNhan_Click(object sender, EventArgs e) { var xn = nvObj.Tennhanvien + " " + DateTime.Now; var db = new MyDBContextDataContext(); var lst = (from s in db.tbQuanLyDonHangs where s.IDQuanLyDonHang == sCDTextEdit.Text select s).Single(); if (lst.NghiepVu_XuongDon != null) { return; } var tb = db.tbBaoCaoNghiepVus.Single(s => s.IDBaoCaoNghiepVu == sCDTextEdit.Text); tb.SpSize = "O"; tb.DanhGia = "Đạt"; var lst2 = (from s in db.tbDonSanXuats where s.SCD == sCDTextEdit.Text select s).Single(); if (lst2.TenKhachHang != PrintRibbon.AD || lst2.BoPhan != "TEM VẢI") { var frm = new frmSKU(); frm.MySKU = new frmSKU.GetString(GetValue); frm.ShowDialog(); tb.Size = sku; } lst.NghiepVu_XuongDon = xn; db.SubmitChanges(); frmNghiepVu_Load(sender, e); }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { gridView1.GetFocusedValue(); var mahang = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colMaHang).ToString(); var db = new MyDBContextDataContext(); var lst = db.tbVatLieus.Single(s => s.MaHang == mahang); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "DonViTinh", lst.DonViTinh); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "QuyCach", lst.QuyCach); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "TenHangHoa", lst.TenHangHoa); gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "MaAD", lst.MaAvery); //var mahang = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colMaHang).ToString(); var lo = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colLo).ToString(); //var db = new MyDBContextDataContext(); var lst2 = db.LoadData_TonKhoNVL_Lot_View(tungay, denngay).ToList(); foreach (var item in lst2) { if (item.mahang == mahang && item.Lo == lo) { gridView1.SetRowCellValue(gridView1.FocusedRowHandle, colHanSuDung, item.HanSuDung); } } } catch (Exception) { //MessageBox.Show("Lỗi: " + ex.Message, "Lỗi"); //null } }
private void simpleButton1_Click(object sender, EventArgs e) { var data = ClipboardData.Split('\n'); if (data.Length < 1) { return; } foreach (string row in data) { AddRow(row); } var db = new MyDBContextDataContext(); var lst = db.tbMyDungTemVais.ToList(); foreach (var item in lst) { for (int i = 0; i < gridView2.RowCount; i++) { var dr = gridView2.GetDataRow(i); if (dr["ItemCode"].ToString() != item.ItemCode) { continue; } dr["DuongDan"] = item.DuongDan; } } }
private void SearchSO_EditValueChanged(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var SO = SearchSO.Text; var lst = from AD in ( (from tb in db.tbTemDanAds group tb by new { tb.IDTemDanAD, tb.SO, tb.Size, tb.OrderDate, tb.XacNhan } into g select new { g.Key.IDTemDanAD, g.Key.SO, g.Key.Size, g.Key.OrderDate, QTY = (int?)g.Sum(p => Convert.ToInt32(p.QTY)), g.Key.XacNhan })) where AD.OrderDate == Ngayxuongdontxt.DateTime && AD.SO.StartsWith(SO) select AD; gridControl1.DataSource = lst;//TdCtr.GetData_NgayXuongDon_SO(Ngayxuongdontxt.Text, SO); gridView1.BestFitColumns(); var lst2 = (from s in db.tbThongTinGopDonADs where s.SO.StartsWith(SO) select s).ToList(); gridControl2.DataSource = lst2; }
private void simpleButton1_Click(object sender, EventArgs e) { for (int i = 0; i < 60; i++) { int tong = 0; var db = new MyDBContextDataContext(); var soluong = Convert.ToInt32(gridView1.GetRowCellValue(i, colSoLuong)); // sl = 2300 //2000 //300 var solanin = Convert.ToInt32(gridView1.GetRowCellValue(i, colSoLanIn)); var size = gridView1.GetRowCellValue(i, colSize).ToString(); var _solanin = Math.Ceiling((double)soluong / 500); // 5 // 4 //1 var _sodu = soluong - (soluong / 500) * 500; // 300 // 0 // 0 for (int j = 1; j <= _solanin; j++) { tbTemDanAd tb = new tbTemDanAd(); tb.IDTemDanAD = scd; tb.SO = so; tb.Size = size; if (i == _solanin && _sodu > 0 || soluong < 500 && _sodu == 0) { tb.QTY = _sodu.ToString(); } else { tb.QTY = "500"; } tb.OrderDate = orderdate; db.tbTemDanAds.InsertOnSubmit(tb); } tong = tong + Convert.ToInt32(soluong) * solanin; if (tong == Convert.ToInt32(qty)) { db.SubmitChanges(); } } }
private void gridControl2_Click(object sender, EventArgs e) { try { //ClearSoLanIn(); //ClearSoLuong(); var db = new MyDBContextDataContext(); scd = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colSCD1).ToString(); so = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colSO).ToString(); sku = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colSKU).ToString(); qty = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colQty).ToString(); orderdate = Convert.ToDateTime(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colOrderDate).ToString()); var tdAD = (from s in db.tbTemDanAds where s.IDTemDanAD == SCD && s.SO == so select s).ToList(); if (tdAD.Count == 0) { btnTinh.Enabled = true; } else { btnTinh.Enabled = false; } } catch { // ignored } }
private void lblSCD_TextChanged(object sender, EventArgs e) { try { var db = new MyDBContextDataContext(); var danhsach = (from s in db.tbDonSanXuat_Averies where s.scd == lblSCD.Text select s).ToList(); foreach (var item in danhsach) { switch (item.DanhSach) { case 1: xrDanhSach.Image = Image.FromFile("Images\\1.png"); break; case 2: xrDanhSach.Image = Image.FromFile("Images\\2.png"); break; case 3: xrDanhSach.Image = Image.FromFile("Images\\3.png"); break; case 4: xrDanhSach.Image = Image.FromFile("Images\\4.png"); break; } break; } } catch (Exception) { // ignored } }
//where s.SauInHoanThanh == null && s.BoPhan == "SAU IN" || s.BoPhan == "OFFSET" || s.BoPhan == "KỸ THUẬT SỐ" public void check() { var db = new MyDBContextDataContext(); var lst = (from s in db.LoadData_DonSanXuat_QuanLyDonHang_NghiepVu() where s.NghiepVu_XuongDon == null select s).ToList(); foreach (var item in lst) { if (item.NghiepVu_XuongDon != null) { item.NghiepVu_XuongDon = "True"; } if (item.ThietKeNhan != null) { item.ThietKeNhan = "True"; } if (item.ThietKeHoanThanh != null) { item.ThietKeHoanThanh = "True"; } if (item.HoanThanh != null) { item.HoanThanh = "True"; } } procQuanLyDonhang_ViewGridControl.DataSource = lst; //procQuanLyDonhang_ViewGridControl.DataSource = dsxCtr.LoadData_DonSanXuat_QuanLyDonHang_NghiepVu(); }
private void simpleButton1_Click(object sender, EventArgs e) { var data = ClipboardData.Split('\n'); if (data.Length < 1) { return; } foreach (string row in data) { AddRow(row); } var db = new MyDBContextDataContext(); var lst = db.tbMyDungStickers.ToList(); foreach (var item in lst) { for (int i = 0; i < gridView1.RowCount; i++) { var dr = gridView1.GetDataRow(i); var itemcode = dr["ItemCode"].ToString() + " " + dr["ItemCode2"].ToString(); if (itemcode != item.ItemCode) { continue; } dr["JanCode"] = item.JanCode; dr["ItemName"] = item.ItemName; dr["Tana"] = item.Tana; dr["Location"] = item.Location; dr["Irisu"] = item.Irisu; } } }
private void hiendonhang_CheckedChanged(object sender, EventArgs e) { if (hiendonhang.Checked == true) { btnXacNhan.Enabled = false; var db = new MyDBContextDataContext(); var lst = (from s in db.DonSanXuat_QuanLyDonhang_View() where s.BoPhan == temvai && s.NghiepVu_XuongDon != null select s).ToList(); foreach (var item in lst) { if (item.NghiepVu_XuongDon != null) { item.NghiepVu_XuongDon = "True"; NghiepvuCheck.ValueChecked = "True"; } if (item.CtfNhan != null) { item.CtfNhan = "True"; CtfNhanCheck.ValueChecked = "True"; } if (item.CtfHoanThanh != null) { item.CtfHoanThanh = "True"; CtfHoanThanhCheck.ValueChecked = "True"; } if (item.TemVaiNhan != null) { item.TemVaiNhan = "True"; TemvaiNhanCheck.ValueChecked = "True"; } if (item.TemVaiHoanThanh != null) { item.TemVaiHoanThanh = "True"; TemvaiHoanthanhCheck.ValueChecked = "True"; } if (item.KhoBTPNhan != null) { item.KhoBTPNhan = "True"; KhoNhanCheck.ValueChecked = "True"; } if (item.KhoBTPHoanThanh != null) { item.KhoBTPHoanThanh = "True"; KhoHoanthanhCheck.ValueChecked = "True"; } if (item.HoanThanh != null) { item.HoanThanh = "True"; SanxuatHoanThanhCheck.ValueChecked = "True"; } } procQuanLyDonhang_ViewGridControl.DataSource = lst; } else { frmTemVai_Load(sender, e); btnXacNhan.Enabled = true; } }
private void simpleButton1_Click(object sender, EventArgs e) { try { if (XtraMessageBox.Show("Bạn có muốn cập nhật không", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { for (var i = 0; i <= gridView1.RowCount - 1; i++) { var dr = gridView1.GetDataRow(i); if (dr.RowState != DataRowState.Modified) { continue; } var db = new MyDBContextDataContext(); var tb = db.tbDanhSachKhuonBes.Single(s => s.IDKhuon == dr["IDKhuon"].ToString()); tb.TenKhuon = dr["TenKhuon"].ToString(); tb.KhachHang = dr["KhachHang"].ToString(); tb.LoaiKhuon = dr["LoaiKhuon"].ToString(); tb.KichThuoc = dr["KichThuoc"].ToString(); tb.SoLuongDanTrang = dr["SoLuongDanTrang"].ToString(); tb.DanTrang = dr["DanTrang"].ToString(); tb.HinhAnh = dr["HinhAnh"].ToString(); tb.GhiChu = dr["GhiChu"].ToString(); db.SubmitChanges(); } } } catch { frmDanhSachKhuonBe_Load(sender, e); MessageBox.Show(PrintRibbon.capnhat); } }
private void btnLuu_Click(object sender, EventArgs e) { if (flagluu == 1) { for (var i = 0; i < gridView1.RowCount - 1; i++) { var dr = gridView1.GetDataRow(i); if (dr.RowState != DataRowState.Added) { continue; } var db = new MyDBContextDataContext(); var tb = new tbVatLieu { IDMaHang = dr["IDMaHang"].ToString(), MaHang = dr["MaHang"].ToString(), MaAvery = dr["MaAvery"].ToString(), TenHangHoa = dr["TenHangHoa"].ToString(), DonViTinh = dr["DonViTinh"].ToString(), QuyCach = dr["QuyCach"].ToString(), GhiChu = dr["GhiChu"].ToString(), }; db.tbVatLieus.InsertOnSubmit(tb); db.SubmitChanges(); MessageBox.Show(PrintRibbon.themthanhcong); frmVatLieu_Load(sender, e); } } else if (flagluu == 2) { try { for (var i = 0; i < gridView1.RowCount - 1; i++) { var db = new MyDBContextDataContext(); var dr = gridView1.GetDataRow(i); if (dr.RowState != DataRowState.Modified) { continue; } var mahang = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colMaHang).ToString(); var vatlieu = db.tbVatLieus.Single(s => s.MaHang == mahang); vatlieu.IDMaHang = dr["IDMaHang"].ToString(); //vatlieu.MaHang = MaHangtxt.Text; vatlieu.MaAvery = dr["MaAvery"].ToString(); vatlieu.TenHangHoa = dr["TenHangHoa"].ToString(); vatlieu.DonViTinh = dr["DonViTinh"].ToString(); vatlieu.QuyCach = dr["QuyCach"].ToString(); vatlieu.GhiChu = dr["GhiChu"].ToString(); db.SubmitChanges(); MessageBox.Show(PrintRibbon.capnhat); frmVatLieu_Load(sender, e); } } catch (Exception) { // ignored } } }
//private void toolTipController1_GetActiveObjectInfo(object sender, DevExpress.Utils.ToolTipControllerGetActiveObjectInfoEventArgs e) //{ // //if (e.Info == null && object.ReferenceEquals(e.SelectedControl, gcDonSanXuat)) // //{ // // GridView view = gcDonSanXuat.FocusedView as GridView; // // GridHitInfo info = view.CalcHitInfo(e.ControlMousePosition); // // if (view == null) // // { // // return; // // } // // if (info.InRowCell) // // { // // if (info.Column.FieldName == "SCD" || info.Column.FieldName == "MaDonHang") // // { // // string text = ""; // // string scd = view.GetRowCellValue(info.RowHandle,view.Columns["ChuY"]).ToString(); // // string mdh = view.GetRowCellValue(info.RowHandle, view.Columns["MaDonHang"]).ToString(); // // text += scd + mdh; // // string cellKey = info.RowHandle.ToString() + " - " + info.Column.ToString(); // // e.Info = new DevExpress.Utils.ToolTipControlInfo(cellKey, text); // // } // // } // //} //} private void gcDonSanXuat_Click(object sender, EventArgs e) { try { var db = new MyDBContextDataContext(); var lst = (from s in db.tbDonSanXuats where s.SCD == sCDLabel1.Text select s).ToList(); foreach (var itemTbDonSanXuat in lst) { ptbHinhMatPhai.Image = null; ptbHinhMatTrai.Image = null; ptbHinhKhuon.Image = null; if (itemTbDonSanXuat.HinhMatPhai != null) { ptbHinhMatPhai.Image = Image.FromFile(itemTbDonSanXuat.HinhMatPhai); } if (itemTbDonSanXuat.HinhMatTrai != null) { ptbHinhMatTrai.Image = Image.FromFile(itemTbDonSanXuat.HinhMatTrai); } if (itemTbDonSanXuat.HinhKhuon != null) { ptbHinhKhuon.Image = Image.FromFile(itemTbDonSanXuat.HinhKhuon); } } } catch { // ignored } }
private void simpleButton1_Click(object sender, EventArgs e) { var MQ = 0; var XB = 1; var tong = 0; var Sheet = SoLuongTxt.Value / SoLuongDanTrangTxt.Value; if (Sheet <= 500) { MQ = 3; } else if (Sheet > 500 && Sheet <= 2000) { MQ = 7; } else if (Sheet > 2000 && Sheet <= 5000) { MQ = 20; } else { MQ = 20; } var db = new MyDBContextDataContext(); var lst = (from s in db.tbBuHaos where s.MauSac == MauSacSearch.Text select s).Single(); var TotalImpress = Convert.ToInt32(lst.MauSac.Substring(8, 1).ToString()) * Sheet; var QualityCheck = TotalImpress / 300; var CleanRoller = (TotalImpress - 2000) / 2000 * 5; tong = (int)lst.BuHaoOffsetAvery.Value + ((int)SoLuongSizeTxt.Value - 1) * (int)lst.LotScrap + (int)QualityCheck + (int)CleanRoller; MessageBox.Show(tong.ToString()); Tongtxt.Text = (tong + MQ + XB).ToString(); }
private void tbDanhSachSanPhamGridControl_Click_1(object sender, EventArgs e) { var db = new MyDBContextDataContext(); try { var lst = (from s in db.tbDanhSachSanPhams where s.MaSanPham == maSanPhamTextEdit.Text select s).Single(); if (!string.IsNullOrEmpty(lst.HinhMatPhai)) { ptbHinhMatPhai.Image = Image.FromFile(lst.HinhMatPhai); } if (!string.IsNullOrEmpty(lst.HinhMatTrai)) { ptbHinhMatPhai.Image = Image.FromFile(lst.HinhMatTrai); } if (!string.IsNullOrEmpty(lst.HinhKhuon)) { ptbHinhMatPhai.Image = Image.FromFile(lst.HinhKhuon); } } catch { // ignored } }
private void btnIn_Click(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var lst = db.tbKhoNLVs.ToList(); var tong = 0; foreach (var tbKhoNlv in lst) { if (tbKhoNlv.MaPhieu != MaPhieutxt.Text) { continue; } tong = 1; var rp = new rpPhieuNhapKhoNVL(); rp.DataSource = knvlCtr.GetData("MaPhieu", MaPhieutxt.Text); rp.databing(); rp.ShowRibbonPreviewDialog(); break; } if (tong == 0) { MessageBox.Show("Vui lòng Lưu kho mã phiếu " + MaPhieutxt.Text + " này trước khi in"); } }
private void btnXoa_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Bạn có chắc muốn xóa không", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { gridView1.BeginUpdate(); for (var i = 0; i < gridView1.SelectedRowsCount; i++) { var so = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colSO).ToString(); var db = new MyDBContextDataContext(); var dsx = db.tbDonSanXuat_Averies.Single(s => s.SO == so); db.tbDonSanXuat_Averies.DeleteOnSubmit(dsx); db.SubmitChanges(); } } catch (Exception) { //null } finally { gridView1.EndUpdate(); MessageBox.Show(PrintRibbon.xoathanhcong); dateEdit1_EditValueChanged(sender, e); } } else { MessageBox.Show(PrintRibbon.xoathatbai); } }
public void MaPhieu() { if (_MaPhieu == "mới") { var knvl_DemoCtr = new KhoNVLCtr_Demo(); gridControl1.DataSource = knvl_DemoCtr.LoadData(); var maphieu = "PNK" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "/"; dt = knvlCtr.GetData_MaPhieu(maphieu); MaPhieutxt.Text = maphieu + knvlCtr.SinhMaTuDong_MaPhieu(dt); NgayNhaptxt.DateTime = DateTime.Today; KhoCongTytxt.Text = "NGUYÊN VẬT LIỆU"; } else { MaPhieutxt.Text = _MaPhieu; var db = new MyDBContextDataContext(); var lst = (from s in db.tbKhoNLVs where s.MaPhieu == _MaPhieu select s).ToList(); foreach (var tbkhonvl in lst) { KhoCongTytxt.Text = tbkhonvl.Kho; NhaCungCaptxt.Text = tbkhonvl.NhaCungCap; txtlo.Text = tbkhonvl.Lo; if (tbkhonvl.Ngay != null) { NgayNhaptxt.DateTime = tbkhonvl.Ngay.Value; } break; } gridControl1.DataSource = knvlCtr.GetData("MaPhieu", _MaPhieu); btnLuu.Text = "Cập Nhật"; } }
private void btnPhieuXuatKho_Click(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var lst = db.tbKhoBTP_TPs.ToList(); var _MaPhieu = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colMaPhieu).ToString(); var tong = 0; foreach (var tbKhoNlv in lst) { if (tbKhoNlv.MaPhieu != _MaPhieu) { continue; } tong = 1; var rp = new rpPhieuXuatKhoBTP(); rp.DataSource = kbtpCtr.GetData("MaPhieu", _MaPhieu); rp.databing(); rp.ShowRibbonPreviewDialog(); break; } if (tong == 0) { MessageBox.Show("Vui lòng Xuất kho mã phiếu " + _MaPhieu + " này trước khi in"); } }
private void khoGiayInTextEdit_EditValueChanged(object sender, EventArgs e) { var db = new MyDBContextDataContext(); var lst = (from s in db.tbKhoGiayIns select s).ToList(); var vatlieu = db.tbVatLieus.ToList(); foreach (var kgi in lst) { if (khoTextEdit.Text == nguyenvatlieu & kgi.KhoIn == KhoGiayInOffset.Text) { CatGiayOffset.Text = kgi.CatGiay; //QuycachOffset.Text = kgi.GiayLon; // var tong = 0; // foreach (var vl in vatlieu) // { // if (tenSanPhamTextEdit.Text == vl.TenHangHoa && QuycachOffset.Text == vl.QuyCach) // { // tong = 1; // break; // } // } // if(tong == 0) // MessageBox.Show("Quy cách " + QuycachOffset.Text + " không đúng, vui lòng xem lại"); } } }
private void btnXacNhan_Click(object sender, EventArgs e) { var xn = nvObj.Tennhanvien + " " + DateTime.Now; var db = new MyDBContextDataContext(); var lst = (from s in db.tbQuanLyDonHangs where s.IDQuanLyDonHang == sCDTextEdit.Text select s).Single(); if (lst.ThietKeNhan == null) { lst.ThietKeNhan = xn; db.SubmitChanges(); frmThietKe_Load(sender, e); } else { lst.ThietKeHoanThanh = xn; var tb = db.tbBaoCaoThietKes.Single(s => s.IDBaoCaoThietKe == sCDTextEdit.Text); var nghiepvu = db.tbBaoCaoNghiepVus.Single(s => s.IDBaoCaoNghiepVu == sCDTextEdit.Text); tb.BanIn = "Đạt"; tb.SanPham = "Đạt"; tb.Layout = "Đạt"; tb.NetChu = "Đạt"; tb.CoChu = "Đạt"; tb.VitriCatGap = "Đạt"; tb.KyHieu = "Đạt"; tb.DanhGia = "Đạt"; tb.Size = nghiepvu.Size; db.SubmitChanges(); frmThietKe_Load(sender, e); } }
public void MaPhieu() { if (_MaPhieu == "mới") { var kbtp_DemoCtr = new KhoBTPCtr_Demo(); gridControl1.DataSource = kbtp_DemoCtr.LoadData(); var maphieu = "PXK" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "/"; dt = kbtpCtr.GetData_MaPhieu(maphieu); MaPhieutxt.Text = maphieu + kbtpCtr.SinhMaTuDong_MaPhieu(dt); NgayNhaptxt.DateTime = DateTime.Today; //KhoCongTytxt.Text = "NGUYÊN VẬT LIỆU"; } else { MaPhieutxt.Text = _MaPhieu; var db = new MyDBContextDataContext(); var lst = (from s in db.tbKhoBTP_TPs where s.MaPhieu == _MaPhieu select s).ToList(); foreach (var btp in lst) { //KhoCongTytxt.Text = btp.Kho; txtlo.Text = btp.Lo; txtBoPhan.Text = btp.BoPhan; KhoCongTytxt.Text = btp.Kho; if (btp.Ngay != null) { NgayNhaptxt.DateTime = btp.Ngay.Value; } break; } gridControl1.DataSource = kbtpCtr.GetData("MaPhieu", _MaPhieu); btnLuu.Text = "Cập Nhật"; } }