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";
}
}
