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.OffsetNhan == null)
{
lst.OffsetNhan = xn;
}
else
{
lst.OffsetHoanThanh = xn;
}
db.SubmitChanges();
frmOffset_Load(sender, e);
}
private void btnXacNhan1Dong_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var scd = bandedGridView1.GetRowCellValue(bandedGridView1.FocusedRowHandle, "SCD");
var tb = db.tbBaoCaoThietKes.Single(s => s.IDBaoCaoThietKe == scd.ToString());
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.GhiChu = dr["GhiChu"].ToString();
db.SubmitChanges();
frmBaoCaoThietKe_Load(sender, e);
MessageBox.Show(PrintRibbon.capnhat);
}
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
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 lst = (from s in db.tbDonHangTemVaiAveries where s.SO == dr["SO"].ToString() select s).Single();
lst.GhiChu = dr["GhiChu"].ToString();
db.SubmitChanges();
//var donhang = db.GetTable<tbDonHangTemVaiAvery>();
//var lst = (from s in donhang where s.SO == dr["SO"].ToString() select s).Single();
//var query = from s in donhang select s;
}
}
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
for (int i = 0; i <= gridView1.RowCount - 1; i++)
{
var dr = gridView1.GetDataRow(i);
if (dr.RowState == DataRowState.Modified)
{
if (XtraMessageBox.Show("Bạn có muốn cập nhật không", "Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
var db = new MyDBContextDataContext();
var tb = db.tbDonViTinhs.Single(s => s.ID == dr["ID"].ToString());
tb.DIENGIAI = dr["DIENGIAI"].ToString();
tb.GHICHU = dr["GHICHU"].ToString();
tb.TINHTRANG = dr["TINHTRANG"].ToString();
db.SubmitChanges();
//frmDonViTinh_Load(sender, e);
MessageBox.Show(PrintRibbon.capnhat);
}
}
else if (dr.RowState == DataRowState.Added)
{
if (XtraMessageBox.Show("Bạn có muốn thêm không", "Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
var db = new MyDBContextDataContext();
var tb = new tbDonViTinh
{
ID = dr["ID"].ToString(),
DIENGIAI = dr["DIENGIAI"].ToString(),
GHICHU = dr["GHICHU"].ToString(),
TINHTRANG = dr["TINHTRANG"].ToString()
};
db.tbDonViTinhs.InsertOnSubmit(tb);
db.SubmitChanges();
MessageBox.Show(PrintRibbon.themthanhcong);
//frmDonViTinh_Load(sender, e);
}
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
var db = new MyDBContextDataContext();
//var tsl1 = 0;
//var bc = db.tbBarcodeStickers.ToList();
//foreach (var item in bc)
//{
// if (item.Barcode != QuetTxt.Text && item.SCD == sCDTextEdit.Text)
// tsl1 = tsl1 + Convert.ToInt32(item.SoLuongSheet_Goi) * Convert.ToInt32(item.SoLuongPcs_Sheet);
//}
//if (tsl1 + (int)SoLuongQuetTxt.Value * (int)SoLuongPcs_Sheet.Value <= SoLuongCanIn.Value)
//{
var barcode = new tbBarcodeSticker();
barcode.SCD = sCDTextEdit.Text;
barcode.Barcode = txtNhap.Text;
barcode.NhanVien = NvObj.Tennhanvien;
barcode.SoLuongSKU = (int)SoLuongSKU.Value;
barcode.SoLuongCanIn = (int)SoLuongCanIn.Value;
barcode.SoLuongSheet_Goi = (int)SoLuongQuetTxt.Value;
barcode.SoLuongPcs_Sheet = (int)SoLuongPcs_Sheet.Value;
barcode.BarcodeLoi = MaLoiTxt.Text;
barcode.NgayNhap = DateTime.Now;
db.tbBarcodeStickers.InsertOnSubmit(barcode);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
frmQuetBarcodeSticker_Load(sender, e);
MaLoiTxt.Text = string.Empty;
//}
//else
//{
// MessageBox.Show("Đơn hàng sản xuất đúng số lượng , nên không được thêm");
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn xóa không", "Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
var db = new MyDBContextDataContext();
var ID = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colIDKhuon).ToString();
var pdf = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colDuongDan).ToString();
var jpg = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colHinhAnh).ToString();
var lst = (from s in db.tbDanhSachKhuonBes where s.IDKhuon == ID select s).Single();
db.tbDanhSachKhuonBes.DeleteOnSubmit(lst);
db.SubmitChanges();
MessageBox.Show(PrintRibbon.xoathanhcong);
File.Delete(pdf);
//File.Delete(jpg);
frmDanhSachKhuonBe_Load(sender, e);
}
else
{
MessageBox.Show(PrintRibbon.xoathatbai);
}
}
public bool Add(KhoBTP_TPObj khoObj)
{
try
{
var db = new MyDBContextDataContext();
tbKhoBTP_TP kho = new tbKhoBTP_TP()
{
IDKhoBTP_TP = khoObj.IDKhoBTP_TP,
MaPhieu = khoObj.MaPhieu,
Lo = khoObj.Lo,
NhapXuat = khoObj.NhapXuat,
SCD = khoObj.SCD,
Kho = khoObj.Kho,
Ngay = khoObj.Ngay,
LoaiSanPham = khoObj.LoaiSanPham,
MaDonHang = khoObj.MaDonHang,
TenKhachHang = khoObj.TenKhachHang,
TenSanPham = khoObj.TenSanPham,
SoLuongNhapKhachHang = khoObj.SoLuongNhapKhachHang,
SoLuongXuatKhachHang = khoObj.SoLuongXuatKhachHang,
SoLuongNhapCongTy = khoObj.SoLuongNhapCongTy,
SoLuongXuatCongTy = khoObj.SoLuongXuatCongTy,
DonViTinh = khoObj.DonViTinh,
KichThuoc = khoObj.KichThuoc,
KhoGiayIn = khoObj.KhoGiayIn,
BoPhan = khoObj.BoPhan,
GhiChu = khoObj.GhiChu,
NhanVien = khoObj.NhanVien,
XacNhan = khoObj.XacNhan,
};
db.tbKhoBTP_TPs.InsertOnSubmit(kho);
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
var open = new OpenFileDialog();
open.Filter = ".pdf,.doc,.xls,.docx,.xlsx|*.pdf;*.doc;*.xls,*.docx,*.xlsx| All file (*.*)|*.*";
open.FilterIndex = 2;
if (open.ShowDialog() != DialogResult.OK)
{
return;
}
if (!open.CheckFileExists)
{
return;
}
var correctfilename = Path.GetFileName(open.FileName);
var paths = "File\\" + correctfilename;
var db = new MyDBContextDataContext();
try
{
var tb = new tbForm();
File.Copy(open.FileName, paths, true);
tb.URL = paths;
tb.TenForm = correctfilename;
db.tbForms.InsertOnSubmit(tb);
db.SubmitChanges();
MessageBox.Show("Upload " + correctfilename + " thành công");
}
catch
{
//MessageBox.Show("Hình " + correctfilename + " đã tồn tại");
//lst.HinhMatTrai = paths;
//db.SubmitChanges();
//ptbHinhMatTrai.Image = Image.FromFile(paths);
}
frmForm_Load(sender, e);
}
private void simpleButton6_Click(object sender, EventArgs e)
{
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);
dsx.XacNhan = 1;
db.SubmitChanges();
}
}
catch (Exception)
{
//null
}
finally
{
gridView1.EndUpdate();
dateEdit1_EditValueChanged(sender, e);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
for (var i = 0; i <= gridView1.RowCount - 1; i++)
{
var dr = gridView1.GetDataRow(i);
if (dr.RowState != DataRowState.Modified)
{
continue;
}
if (XtraMessageBox.Show("Bạn có muốn cập nhật không", "Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) != DialogResult.Yes)
{
continue;
}
var db = new MyDBContextDataContext();
var tb = db.tbForms.Single(s => s.idForm == (int)dr["idForm"]);
tb.TenForm = dr["TenForm"].ToString();
tb.DienGiai = dr["DienGiai"].ToString();
tb.URL = dr["URL"].ToString();
db.SubmitChanges();
MessageBox.Show(PrintRibbon.capnhat);
frmForm_Load(sender, e);
}
}
private void btnLuuTam_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var lst = db.tbBarcodeSticker_Temps.Single(s => s.STT == 1);
if (lst.ID == false)
{
lst.ID = true;
lst.SCD = sCDTextEdit.Text;
lst.Barcode = txtNhap.Text;
lst.SoLuongCanIn = (int)SoLuongCanIn.Value;
lst.SoLuongSKU = (int)SoLuongSKU.Value;
lst.SoLuongSheet_Goi = (int)SoLuongSheet_Goi.Value;
lst.SoLuongPcs_Sheet = (int)SoLuongPcs_Sheet.Value;
lst.BarcodeLoi = MaLoiTxt.Text;
lst.SoLuongQuet = (int)SoLuongQuetTxt.Value;
db.SubmitChanges();
MessageBox.Show("Lưu vào bộ nhớ tạm thành công");
btnLuuTam.Text = "LẤY DỮ LIỆU";
}
else
{
if (sCDTextEdit.Text == lst.SCD)
{
if (MessageBox.Show(
"Bạn có muốn lấy dữ liệu từ bộ nhớ tạm không, dữ liệu chỉ phục hồi 1 lần duy nhất",
"Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
txtNhap.Text = lst.Barcode;
if (lst.SoLuongCanIn != null)
{
SoLuongCanIn.Value = (int)lst.SoLuongCanIn;
if (lst.SoLuongSKU != null)
{
SoLuongSKU.Value = (int)lst.SoLuongSKU;
}
if (lst.SoLuongSheet_Goi != null)
{
SoLuongSheet_Goi.Value = (int)lst.SoLuongSheet_Goi;
}
if (lst.SoLuongPcs_Sheet != null)
{
SoLuongPcs_Sheet.Value = (int)lst.SoLuongPcs_Sheet;
}
MaLoiTxt.Text = lst.BarcodeLoi;
if (lst.SoLuongQuet != null)
{
SoLuongQuetTxt.Value = (int)lst.SoLuongQuet;
}
lst.ID = false;
lst.SCD = null;
lst.Barcode = null;
}
lst.SoLuongCanIn = null;
lst.SoLuongSKU = null;
lst.SoLuongSheet_Goi = null;
lst.SoLuongPcs_Sheet = null;
lst.BarcodeLoi = null;
lst.SoLuongQuet = null;
db.SubmitChanges();
MessageBox.Show("Lấy dữ liệu thành công");
btnLuuTam.Text = "LƯU DỮ LIỆU";
}
else
{
MessageBox.Show("Không trùng mã SCD, Mã SCD lưu tạm là : " + lst.SCD);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
var dsxObj = new DonSanXuat_AveryObj();
if (XtraMessageBox.Show("Bạn có muốn lưu dữ liệu không", "Cảnh báo", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
var db = new MyDBContextDataContext();
if (flagluu == 1)
{
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var dr = gridView1.GetDataRow(i);
// Nếu dữ liệu trên grid view có thêm mới dữ liệu
if (dr.RowState == DataRowState.Added)
{
dsxObj.No = (int)dr["No"];
dsxObj.Orderdate = DateTime.Parse(dr["OrderDate"].ToString());
dsxObj.Requestdate = DateTime.Parse(dr["RequestDate"].ToString());
dsxObj.So = dr["SO"].ToString();
dsxObj.Rbo = dr["RBO"].ToString();
dsxObj.Customerpo = dr["CustomerPO"].ToString();
dsxObj.Customeritem = dr["CustomerItem"].ToString();
dsxObj.Item = dr["Item"].ToString();
dsxObj.Qty = (int)dr["Qty"];
dsxObj.Material = dr["Material"].ToString();
dsxObj.Length = (float)Convert.ToDouble(dr["Length"]);
dsxObj.Materialqty = (float)Convert.ToDouble(dr["MaterialQty"]);
dsxObj.Sku = (int)dr["SKU"];
dsxObj.Cut = dr["Cut"].ToString();
dsxObj.Fold = dr["Fold"].ToString();
dsxObj.Gopdon = (int)dr["GopDon"];
//dsxObj.dj
dsxObj.NhanVien = nvObj.Tennhanvien;
dsxObj.Danhsach = (int)txtDanhSach.Value;
if (donSanXuatAveryCtr.Kiemtra(dsxObj.So) == 0)
{
donSanXuatAveryCtr.AddData(dsxObj);
}
}
}
}
else if (flagluu == 2)
{
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var dr = gridView1.GetDataRow(i);
if (dr.RowState == DataRowState.Modified)
{
var dsx = (from s in db.tbDonSanXuat_Averies where s.SO == dr["SO"].ToString() select s).Single();
dsx.PO = dr["PO"].ToString();
}
//var so = gridView1.GetRowCellValue(i, colSO).ToString();
//var lst = (from s in db.tbDonSanXuat_Averies where s.SO == so select s).ToList();
//if (lst.Count != 1) continue;
////lst.ForEach(x => { x.PO = gridView1.GetRowCellValue(i, colPO).ToString();});
//foreach (var item in lst)
//{
// item.PO = gridView1.GetRowCellValue(i, colPO).ToString();
// break;
//}
}
}
else if (flagluu == 3)
{
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var dr = gridView1.GetDataRow(i);
if (dr.RowState == DataRowState.Modified)
{
var dsx = (from s in db.tbDonSanXuat_Averies where s.SO == dr["SO"].ToString() select s).Single();
dsx.Note = dr["Note"].ToString();
}
//var so = gridView1.GetRowCellValue(i, colSO).ToString();
//var lst = (from s in db.tbDonSanXuat_Averies where s.SO == so select s).ToList();
//if (lst.Count != 1) continue;
//foreach (var item in lst)
//{
// item.Note = gridView1.GetRowCellValue(i, colNote).ToString();
// break;
//}
}
}
db.SubmitChanges();
}
catch (Exception exception)
{
MessageBox.Show("lỗi " + exception);
//Console.WriteLine(exception);
//throw;
}
//try
//{
// if (XtraMessageBox.Show("Bạn có muốn lưu dữ liệu không", "Cảnh báo", MessageBoxButtons.YesNo,
// MessageBoxIcon.Question) != DialogResult.Yes) return;
// var db = new MyDBContextDataContext();
// var dem = 0;
// if (flagluu == 1)
// {
// for (var i = 0; i < gridView1.RowCount - 1; i++)
// {
// var so = gridView1.GetRowCellValue(i, colSO).ToString();
// var lst = (from s in db.tbDonSanXuat_Averies where s.SO == so select s).ToList();
// if (lst.Count == 0)
// {
// var dsxAvery = new tbDonSanXuat_Avery();
// dsxAvery.SO = gridView1.GetRowCellValue(i, colSO).ToString();
// dsxAvery.OrderDate =
// Convert.ToDateTime(gridView1.GetRowCellValue(i, colOrderDate).ToString());
// dsxAvery.RequestDate =
// Convert.ToDateTime(gridView1.GetRowCellValue(i, colRequestDate).ToString());
// dsxAvery.No = Convert.ToInt32(gridView1.GetRowCellValue(i, colNo).ToString());
// dsxAvery.RBO = gridView1.GetRowCellValue(i, colRBO).ToString();
// dsxAvery.CustomerPO = gridView1.GetRowCellValue(i, colCustomerPO).ToString();
// dsxAvery.CustomerItem = gridView1.GetRowCellValue(i, colCustomerItem).ToString();
// dsxAvery.Item = gridView1.GetRowCellValue(i, colItem).ToString();
// dsxAvery.Qty = Convert.ToInt32(gridView1.GetRowCellValue(i, colQty).ToString());
// dsxAvery.Material = gridView1.GetRowCellValue(i, colMaterial).ToString();
// dsxAvery.Length = Convert.ToDouble(gridView1.GetRowCellValue(i, colLength).ToString());
// dsxAvery.MaterialQty =
// Convert.ToDouble(gridView1.GetRowCellValue(i, colMaterialQty).ToString());
// dsxAvery.SKU = Convert.ToInt32(gridView1.GetRowCellValue(i, colSKU).ToString());
// dsxAvery.Cut = gridView1.GetRowCellValue(i, colCut).ToString();
// dsxAvery.Fold = gridView1.GetRowCellValue(i, colFold).ToString();
// dsxAvery.GopDon = Convert.ToInt32(gridView1.GetRowCellValue(i, colGopDon).ToString());
// dsxAvery.NhanVien = gridView1.GetRowCellValue(i, colNhanVien).ToString();
// dsxAvery.DanhSach =
// Convert.ToInt32(gridView1.GetRowCellValue(i, colDanhSach).ToString());
// db.tbDonSanXuat_Averies.InsertOnSubmit(dsxAvery);
// }
// else
// {
// MessageBox.Show("SO: {0} đã tồn tại , vui lòng xem lại", so);
// dem = dem + 1;
// }
// if (dem == 3)
// {
// MessageBox.Show("Đã có 3 SO trùng nên hệ thống sẽ dừng lại");
// break;
// }
// }
// }
// else if (flagluu == 2)
// {
// for (var i = 0; i < gridView1.RowCount - 1; i++)
// {
// var so = gridView1.GetRowCellValue(i, colSO).ToString();
// var lst = (from s in db.tbDonSanXuat_Averies where s.SO == so select s).ToList();
// if (lst.Count != 1) continue;
// //lst.ForEach(x => { x.PO = gridView1.GetRowCellValue(i, colPO).ToString();});
// foreach (var item in lst)
// {
// item.PO = gridView1.GetRowCellValue(i, colPO).ToString();
// break;
// }
// //var dsxAvery = db.tbDonSanXuat_Averies.ToList().Exists(s => s.SO == so);
// //if(dsxAvery == false)
// // foreach (var VARIABLE in dsxAvery)
// // {
// // }
// }
// }
// else if (flagluu == 3)
// {
// //DataSet ds = new DataSet();
// //DataTable dt = ds.Tables["tbDonSanXuat_Avery"];
// for (var i = 0; i < gridView1.RowCount - 1; i++)
// {
// var so = gridView1.GetRowCellValue(i, colSO).ToString();
// var lst = (from s in db.tbDonSanXuat_Averies where s.SO == so select s).ToList();
// if (lst.Count != 1) continue;
// foreach (var item in lst)
// {
// item.Note = gridView1.GetRowCellValue(i, colNote).ToString();
// break;
// }
// }
// }
// db.SubmitChanges();
//}
//catch (Exception exception)
//{
// MessageBox.Show("lỗi " + exception);
// //Console.WriteLine(exception);
// //throw;
//}
}
private void btnThem_Click(object sender, EventArgs e)
{
var open = new OpenFileDialog();
open.Filter = "Format files ( *.pdf,*.jpg, *.jpeg, *.jpe, *.jfif, *.png)| *.pdf;*.jpg; *.jpeg; *.jpe; *.jfif; *.png|All files (*.*)|*.*";;
open.FilterIndex = 1;
open.Multiselect = true;
if (open.ShowDialog() != DialogResult.OK)
{
return;
}
if (!open.CheckFileExists)
{
return;
}
string pathPdf = null, pathJpg = null;
var db = new MyDBContextDataContext();
try
{
if (Path.GetExtension(open.SafeFileNames[0]) == ".pdf")
{
pathPdf = "Khuon\\" + Path.GetFileName(open.FileNames[0]);
File.Copy(open.FileNames[0], pathPdf, true);
}
if (Path.GetExtension(open.SafeFileNames[1]) == ".jpg")
{
pathJpg = "Khuon\\Hinh\\" + Path.GetFileName(open.FileNames[1]);
File.Copy(open.FileNames[1], pathJpg, true);
}
}
catch { }
try
{
if (Path.GetExtension(open.SafeFileNames[1]) == ".pdf")
{
pathPdf = "Khuon\\" + Path.GetFileName(open.FileNames[1]);
File.Copy(open.FileNames[1], pathPdf, true);
}
if (Path.GetExtension(open.SafeFileNames[0]) == ".jpg")
{
pathJpg = "Khuon\\Hinh\\" + Path.GetFileName(open.FileNames[0]);
File.Copy(open.FileNames[0], pathJpg, true);
}
}
catch { }
var tb = new tbDanhSachKhuonBe();
DataTable dt;
var dskbCtr = new DanhSachKhuonBeCtr();
dt = dskbCtr.GetData_KhuonBe_IDKhuon("KB");
tb.IDKhuon = "KB" + dskbCtr.SinhMaTuDong(dt);
tb.DuongDan = pathPdf;
tb.HinhAnh = pathJpg;
tb.TenKhuon = Path.GetFileNameWithoutExtension(open.FileName);
db.tbDanhSachKhuonBes.InsertOnSubmit(tb);
db.SubmitChanges();
MessageBox.Show("Thêm " + Path.GetFileNameWithoutExtension(open.FileName) + " thành công");
frmDanhSachKhuonBe_Load(sender, e);
//var open = new OpenFileDialog();
//open.Filter = ".pdf,.JPG |*.pdf;*.JPG | All file (*.*)|*.*";
//open.FilterIndex = 2;
////open.Multiselect = true;
//if (open.ShowDialog() != DialogResult.OK) return;
////if (!open.CheckFileExists) return;
//var db = new MyDBContextDataContext();
//try
//{
// if (Path.GetExtension(open.FileName) == ".pdf")
// {
// var path = "Khuon\\" + Path.GetFileName(open.FileName);
// File.Copy(open.FileName, path, true);
// var tb = new tbDanhSachKhuonBe();
// DataTable dt;
// var dskbCtr = new DanhSachKhuonBeCtr();
// dt = dskbCtr.GetData_KhuonBe_IDKhuon("KB");
// tb.IDKhuon = "KB" + dskbCtr.SinhMaTuDong(dt);
// tb.DuongDan = path;
// tb.TenKhuon = Path.GetFileNameWithoutExtension(open.FileName);
// db.tbDanhSachKhuonBes.InsertOnSubmit(tb);
// db.SubmitChanges();
// MessageBox.Show("Thêm " + Path.GetFileNameWithoutExtension(open.FileName) + " thành công");
// }
// if (Path.GetExtension(open.FileName) == ".jpg")
// {
// var path = "Khuon\\Hinh\\" + Path.GetFileName(open.FileName);
// File.Copy(open.FileName, path, true);
// var id = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, colIDKhuon);
// var tb = (from s in db.tbDanhSachKhuonBes where s.IDKhuon == id.ToString() select s).Single();
// if (string.IsNullOrEmpty(tb.HinhAnh))
// {
// tb.HinhAnh = path;
// db.SubmitChanges();
// MessageBox.Show("Upload " + Path.GetFileNameWithoutExtension(open.FileName) + " thành công");
// }
// else
// {
// MessageBox.Show("Hình ảnh đã upload rồi ");
// }
// }
//}
//catch { }
//frmDanhSachKhuonBe_Load(sender, e);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int tong = 0;
var dbc = new MyDBContextDataContext();
for (int i = 0; i < gvBang.RowCount; i++)
{
var soluong = Convert.ToInt32(gvBang.GetRowCellValue(i, colSoLuong));
var size = gvBang.GetRowCellValue(i, colSize).ToString();
if (Convert.ToInt32(soluong) < 1)
{
continue;
}
var _solanin = Math.Ceiling((double)soluong / 500);
var _sodu = soluong - soluong / 500 * 500;
for (int j = 1; j <= _solanin; j++)
{
tbTemDanAd tb = new tbTemDanAd();
tb.IDTemDanAD = SCD;
tb.SO = so;
tb.Size = size;
tb.OrderDate = orderdate;
if (j == (int)_solanin && _sodu > 0 || soluong < 500 && _sodu == 0)
{
tb.QTY = _sodu.ToString();
}
else
{
tb.QTY = "500";
}
dbc.tbTemDanAds.InsertOnSubmit(tb);
tong = tong + Convert.ToInt32(tb.QTY);
}
//MessageBox.Show(tong.ToString());
}
if (tong == Convert.ToInt32(qty))
{
dbc.SubmitChanges();
MessageBox.Show(PrintRibbon.themthanhcong);
var tb = dbc.tbBaoCaoThietKes.Single(s => s.IDBaoCaoThietKe == SCD);
var nghiepvu = dbc.tbBaoCaoNghiepVus.Single(s => s.IDBaoCaoNghiepVu == SCD);
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;
var dsxAvery = (from s in dbc.tbDonSanXuat_Averies where s.SO == so select s).Single();
dsxAvery.XacNhan = 2;
dbc.SubmitChanges();
dateEdit1_EditValueChanged(sender, e);
}
else if (tong == 0)
{
MessageBox.Show("Đơn hàng không tồn tại");
}
else
{
MessageBox.Show("Số lượng không đúng , vui lòng xem lại");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
// Create an empty list.
var rows = new ArrayList();
// Add the selected rows to the list.
for (var i = 0; i < gridView1.SelectedRowsCount; i++)
{
if (gridView1.GetSelectedRows()[i] >= 0)
{
rows.Add(gridView1.GetDataRow(gridView1.GetSelectedRows()[i]));
}
}
if ((Convert.ToInt32(rows.Count) <= 0))
{
return;
}
try
{
gridView1.BeginUpdate();
foreach (var t in rows)
{
var xn = nvObj.Tennhanvien + " " + DateTime.Now;
// Change the field value.
if (!(t is DataRow row))
{
continue;
}
var scd = row["SCD"].ToString();
//var gopdon = row["LoaiChi"].ToString();
//var so = row["SO"].ToString();
var db = new MyDBContextDataContext();
var donhang = (from s in db.tbDonHangTemVaiAveries where s.IDDonHangTemVaiAvery == scd select s).Single();
if (string.IsNullOrEmpty(donhang.XacNhan))
{
donhang.XacNhan = xn;
db.SubmitChanges();
//var a = so.Split('-');
//var filename = "LAYOUT " + a[0].Trim() + ".pdf"; ;
//var PathSource = txtDuongDan.Text + "\\" + gopdon;
//var PathDest = txtDuongDan.Text + "\\" + "DataThietKe";
//var FileSource = Path.Combine(PathSource, filename);
//var FileDest = Path.Combine(PathDest, filename);
//var URL = txtDuongDan.Text + "\\" + gopdon + "\\" + filename;
//var thumucmoi = txtDuongDan.Text + "\\" + "DataThietKe";
//if (!Directory.Exists(thumucmoi))
//{
// Directory.CreateDirectory(thumucmoi);
//}
//File.Copy(FileSource, FileDest, true);
}
else
{
MessageBox.Show("Mã SO " + donhang.SO + " đã được xác nhận bởi " + donhang.XacNhan);
}
}
}
catch
{
// ignored
}
finally
{
gridView1.EndUpdate();
MessageBox.Show(PrintRibbon.capnhat);
Ngayxuongdontxt_EditValueChanged(sender, e);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
var db = new MyDBContextDataContext();
var kiemtra = (from s in db.tbKhoBTP_TPs where s.MaPhieu == MaPhieutxt.Text select s).ToList();
//if (kiemtra.Count > 0 && _MaPhieu == "mới" && _flagluu == 1)
//{
// MessageBox.Show("Mã phiếu đã có, hệ thống tự động thay đổi Mã phiếu mới");
// var maphieu = "PXK" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "/";
// dt = kbtpCtr.GetData_MaPhieu(maphieu);
// MaPhieutxt.Text = maphieu + kbtpCtr.SinhMaTuDong_MaPhieu(dt);
//}
var gioihan = DateTime.Today - NgayNhaptxt.DateTime;
if (!string.IsNullOrEmpty(KhoCongTytxt.Text))
{
if (!string.IsNullOrEmpty(txtBoPhan.Text))
{
if ((int)gioihan.TotalDays <= 100 && gioihan.TotalDays >= 0)
{
if (kiemtra.Count == 0 && _MaPhieu == "mới" && _flagluu == 1 || kiemtra.Count > 0 && _MaPhieu != "mới" && _flagluu == 2)
{
if (_flagluu == 2)
{
kbtpCtr.DelData("MaPhieu", _MaPhieu);
}
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var IDKho = "/" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "X";
dt = kbtpCtr.GetData_IDKhoBTP(IDKho);
var dr = gridView1.GetDataRow(i);
var lst = (from s in db.tbKhoBTP_TPs
where s.SCD == dr["SCD"].ToString() && s.NhapXuat == "Nhập"
select s).ToList();
if (lst.Count == 1)
{
foreach (var item in lst)
{
var kbtp = new tbKhoBTP_TP();
kbtp.IDKhoBTP_TP = kbtpCtr.SinhMaTuDong(dt) + IDKho;;
kbtp.MaPhieu = MaPhieutxt.Text;
kbtp.SCD = dr["SCD"].ToString();
kbtp.Lo = txtlo.Text;
kbtp.NhapXuat = "Xuất";
kbtp.Kho = KhoCongTytxt.Text;
kbtp.Ngay = NgayNhaptxt.DateTime;
kbtp.LoaiSanPham = item.LoaiSanPham;
kbtp.MaDonHang = item.MaDonHang;
kbtp.TenKhachHang = item.TenKhachHang;
kbtp.TenSanPham = dr["TenSanPham"].ToString();
if (Convert.ToInt32(dr["SoLuongXuatKhachHang"].ToString()) > 0)
{
kbtp.SoLuongXuatKhachHang = (int)dr["SoLuongXuatKhachHang"];
}
if (!string.IsNullOrEmpty(dr["SoLuongXuatCongTy"].ToString()))
{
kbtp.SoLuongXuatCongTy =
Convert.ToInt32(dr["SoLuongXuatCongTy"].ToString());
}
kbtp.DonViTinh = dr["DonViTinh"].ToString();
kbtp.KichThuoc = item.KichThuoc;
kbtp.KhoGiayIn = item.KhoGiayIn;
kbtp.BoPhan = txtBoPhan.Text;
kbtp.GhiChu = dr["GhiChu"].ToString();
kbtp.NhanVien = nvObj.Tennhanvien;
db.tbKhoBTP_TPs.InsertOnSubmit(kbtp);
var tbkho = (from s in db.tbKhoBTP_TPs
where s.SCD == dr["SCD"].ToString()
select s).Single();
tbkho.XacNhan = 1;
db.SubmitChanges();
}
}
}
switch (_flagluu)
{
case 1:
MessageBox.Show("Thêm Thành Công");
break;
case 2:
MessageBox.Show("Cập nhật thành công");
break;
}
//frmPhieuNhapKhoNVL_Load(sender, e);
}
else
{
MessageBox.Show("Mã phiếu đã tồn tại , vui lòng tạo mã phiếu mới");
}
}
else
{
MessageBox.Show("Dữ liệu đã vượt quá thời gian cho phép Lưu kho");
}
}
else
{
MessageBox.Show("Vui lòng nhập bộ phận");
}
}
else
{
MessageBox.Show("Vui lòng nhập kho công ty");
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Lỗi");
//null
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
var db = new MyDBContextDataContext();
var qldh = (from s in db.tbQuanLyDonHangs where s.IDQuanLyDonHang == sCDTextEdit.Text select s).Single();
var dsx = (from s in db.tbDonSanXuats where s.SCD == sCDTextEdit.Text select s).Single();
var ll = (from s in db.tbLanhLieus where s.IDLanhLieu == sCDTextEdit.Text select s).Single();
var sanxuat = (from s in db.tbSanXuats where s.IDSanXuat == sCDTextEdit.Text select s).Single();
if (qldh.HoanThanh == null)
{
if (!string.IsNullOrEmpty(sanxuat.BoPhanSX))
{
dsx.BoPhan = sanxuat.BoPhanSX;
dsx.PhuongPhapIn = sanxuat.PhuongPhapInSX;
}
if (!string.IsNullOrEmpty(sanxuat.VatLieuSX))
{
dsx.VatLieu = sanxuat.VatLieuSX;
dsx.Kho = sanxuat.KhoSX;
}
if (dsx.BoPhan == offset)
{
var vatlieu = (from s in db.tbVatLieus
where dsx.VatLieu == s.TenHangHoa && QuycachOffset.Text == s.QuyCach
select s).ToList();
//if (vatlieu.Count == 1)
//{
ll.KhoGiayIn = KhoGiayInOffset.Text;
ll.CatGiay = CatGiayOffset.Text;
ll.SoLuongDanTrang = (int)soLuongDanTrangTextEdit.Value;
ll.SoLuongSanXuat = (int)SLSXOffset.Value;
ll.BuHao = (int)buHaoTextEdit.Value;
ll.CtpOffset = (int)ctpOffsetTextEdit.Value;
ll.SoTrangIn = soTrangInTextEdit.Text;
ll.LanhLieu = TinhOffset;
ll.DonViTinh = "TẤM";
ll.QuyCach = QuycachOffset.Text;
MessageBox.Show(themthanhcong);
//}
//else
//{
// MessageBox.Show("Quy cách " + QuycachOffset.Text + " không đúng, không thêm đơn hàng");
//}
//var kgi = (from s in db.tbKhoGiayIns
// where s.KhoIn == ll.KhoGiayIn && s.CatGiay == ll.CatGiay
// select s).Single();
//ll.QuyCach = kgi.GiayLon;
}
else if (dsx.BoPhan == danhthiep)
{
ll.SoLuongSanXuat = (int)txtSLSX_DanhThiep.Value;
ll.SoLuongDanTrang = (int)txtSLDTDanhThiep.Value;
ll.BuHao = (double)(txtBuHaoDanhThiep.Value);
ll.CtpOffset = (int)txtCTPDanhThiep.Value;
ll.LanhLieu = TinhDanhThiep;
ll.DonViTinh = "TẤM";
MessageBox.Show(themthanhcong);
}
else if (dsx.BoPhan == temvai)
{
ll.SoLuongSanXuat = (int)txtSLSXTemVai.Value;
ll.BuHao = (double)txtBuHaoTemVai.Value;
ll.LanhLieu = Convert.ToInt32(btnTinhTemVai.Text);
ll.QuyCach = QuyCachTemVaiSearch.Text;
if (dsx.TenKhachHang == AD)
{
ll.DonViTinh = "YARD";
}
else
{
ll.DonViTinh = "MÉT";
}
MessageBox.Show(themthanhcong);
}
else if (dsx.BoPhan == kts)
{
ll.SoLuongSanXuat = (int)txtSLSXKyThuatSo.Value;
ll.SoLuongDanTrang = Convert.ToInt32(txtSLDTKTS.Value);
ll.BuHao = Convert.ToDouble(txtBuHaoKTS.Value);
ll.KhoGiayIn = txtKhoGiayInKTS.Text;
ll.SoLuongSize = Convert.ToInt32(txtSoLuongSizeKTS.Value);
ll.LanhLieu = TinhKyThuatSo;
ll.DonViTinh = "TẤM";
MessageBox.Show(themthanhcong);
}
else if (dsx.BoPhan == sticker)
{
ll.SoLuongSanXuat = (int)txtSLSXSticker.Value;
ll.SoLuongDanTrang = int.Parse(txtSLDTSticker.Text);
ll.BuHao = Convert.ToDouble(txtBuHaoSticker.Value);
ll.LanhLieu = TinhSticker;
ll.DonViTinh = "MÉT";
ll.QuyCach = QuyCachStickerSearch.Text;
MessageBox.Show(themthanhcong);
}
else if (dsx.BoPhan == inchu)
{
ll.SoLuongDanTrang = (int)txtSLDTInChu.Value;
ll.SoLuongSanXuat = (int)txtSLSXInChu.Value;
ll.BuHao = Convert.ToDouble(txtBuHaoInChu.Value);
ll.LanhLieu = TinhInChu;
if (dsx.LoaiSanPham == "TEM GIẤY")
{
ll.DonViTinh = "TẤM";
}
else if (dsx.LoaiSanPham == "STICKER")
{
ll.DonViTinh = "MÉT";
ll.QuyCach = QuyCachInChuSearch.Text;
}
MessageBox.Show(themthanhcong);
}
if (dsx.BoPhan == sauin)
{
ll.KhoGiayIn = txtKhoGiayInSauIn.Text;
ll.CatGiay = txtCatGiaySauIn.Text;
ll.SoLuongDanTrang = (int)txtSLDTSauIn.Value;
ll.SoLuongSanXuat = (int)txtSLSXSauIn.Value;
ll.BuHao = (int)txtBuHaoSauIn.Value;
ll.SoTrangIn = txtSLTISauIn.Text;
ll.LanhLieu = TinhSauIn;
ll.DonViTinh = "TẤM";
MessageBox.Show(themthanhcong);
}
ll.NhanVienSanXuat = nvObj.Tennhanvien;
db.SubmitChanges();
frmLanhLieu_Load_1(sender, e);
}
else
{
MessageBox.Show("Đơn hàng đã hoàn thành ko thể chỉnh sửa");
}
}
catch
{
MessageBox.Show("Có lỗi, liên hệ admin");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
var gioihan = DateTime.Today - NgayNhaptxt.DateTime;
if (!string.IsNullOrEmpty(NhaCungCaptxt.Text))
{
if (!string.IsNullOrEmpty(KhoCongTytxt.Text))
{
if ((int)gioihan.TotalDays <= 100 && gioihan.TotalDays >= 0)
{
DataRow dr;
var db = new MyDBContextDataContext();
if (_flagluu == 2)
{
knvlCtr.DelData("MaPhieu", _MaPhieu);
}
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var IDKho = "/" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "N";
dt = knvlCtr.GetData_IDKho(IDKho);
dr = gridView1.GetDataRow(i);
var lst = db.tbVatLieus.Single(s => s.MaHang == dr["MaHang"].ToString());
var knvl = new tbKhoNLV();
knvl.IDKhoNVL = knvlCtr.SinhMaTuDong_IDkho(dt) + IDKho;
knvl.MaPhieu = MaPhieutxt.Text;
knvl.Lo = txtlo.Text;
if (!string.IsNullOrEmpty(dr["HanSuDung"].ToString()))
{
knvl.HanSuDung = (DateTime)dr["HanSuDung"];
}
knvl.NhapXuat = "Nhập";
knvl.Kho = KhoCongTytxt.Text;
knvl.Ngay = NgayNhaptxt.DateTime;
knvl.TenHangHoa = lst.TenHangHoa;
knvl.DonViTinh = lst.DonViTinh;
knvl.QuyCach = lst.QuyCach;
knvl.MaHang = lst.MaHang;
knvl.MaAD = lst.MaAvery;
knvl.LoaiHang = lst.IDMaHang;
knvl.SoLuongNhap = (double)dr["SoLuongNhap"];
knvl.NhaCungCap = NhaCungCaptxt.Text;
knvl.GhiChu = dr["GhiChu"].ToString();
knvl.NguoiQuanKho = nvObj.Tennhanvien;
db.tbKhoNLVs.InsertOnSubmit(knvl);
db.SubmitChanges();
}
switch (_flagluu)
{
case 1:
MessageBox.Show("Thêm Thành Công");
break;
case 2:
MessageBox.Show("Cập nhật thành công");
break;
}
//frmPhieuNhapKhoNVL_Load(sender, e);
}
else
{
MessageBox.Show("Dữ liệu đã vượt quá thời gian cho phép Lưu kho");
}
}
else
{
MessageBox.Show("Vui lòng nhập kho công ty");
}
}
else
{
MessageBox.Show("Vui lòng nhập Nhà Cung Cấp");
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Lỗi");
//null
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var procqldh = (from a in db.DonSanXuat_QuanLyDonhang_View() where a.SCD == sCDTextEdit.Text select a).Single();
if (procqldh.HoanThanh == null)
{
var tb = (from s in db.tbDonSanXuats where s.SCD == sCDTextEdit.Text select s).Single();
tb.MaDonHang = maDonHangTextEdit.Text;
tb.PhienBan = txtPhienBan.Text;
tb.TenKhachHang = txtKhachHang.Text;
tb.NgayXuongDon = ngayXuongDonDateEdit.DateTime;
tb.NgayGiaoHang = ngayGiaoHangDateEdit.DateTime;
tb.TenSanPham = tenSanPhamComboBox.Text;
tb.LoaiSanPham = txtLoaiSanPham.Text;
tb.PhuongPhapIn = txtPhuongPhapIn.Text;
tb.KichThuoc = kichThuocTextEdit.Text;
tb.SoLuong = int.Parse(soLuongSpinEdit.Text);
tb.VatLieu = vatLieuComboBox.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.DucLo = ducLoTextEdit.Text;
tb.LoaiChi = loaiChiTextEdit.Text;
tb.ChuY = chuYTextEdit.Text;
tb.BoPhan = txtBoPhan.Text;
tb.ChamCatDapHop = chamCatDapHopTextEdit.Text;
tb.DoDai = doDaiTextEdit.Text;
tb.GiaCongSau = giaCongSauTextEdit.Text;
tb.InChu_MaVach = inChu_MaVachTextEdit.Text;
tb.SKU = (int)txtSKU.Value;
tb.Kho = txtKho.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.ThoiGianXuongDon = DateTime.Now;
tb.NhanVienNghiepVu = nvObj.Tennhanvien;
if (procqldh.NghiepVu_XuongDon != null)
{
tb.ChinhSua = "1";
}
var tiente = (from s in db.tbQuanLyTienTes where s.IDTienTe == sCDTextEdit.Text select s).Single();
if (tiente.QuanLy == null)
{
tiente.IDTienTe = sCDTextEdit.Text;
tiente.DonGiaSanPham = Convert.ToDouble(donGiaSanPhamSpinEdit.Value);
tiente.DonGiaKhuon = Convert.ToDouble(donGiaKhuonSpinEdit.Value);
tiente.DonGiaMau = Convert.ToDouble(donGiaMauSpinEdit.Value);
tiente.DonGiaVanChuyen = Convert.ToDouble(donGiaVanChuyenSpinEdit.Value);
tiente.TongTien = Convert.ToDouble(tongTienSpinEdit.Value);
tiente.NgoaiTe = ngoaiTeComboBox.Text;
tiente.GiaTienUSD = (int)txtGiaTienUSD.Value;
if (CheckVAT.Checked)
{
tiente.VAT = 1.1;
}
else if (CheckVAT.CheckState == CheckState.Unchecked || tongTienSpinEdit.Text == null)
{
tiente.VAT = 1;
}
if (nvObj.Chucvu == "Quản Lý")
{
tiente.QuanLy = "1";
}
}
else if (nvObj.Chucvu == "Quản Lý" && tiente.QuanLy == "1" && tiente.KetChuyen == null)
{
tiente.IDTienTe = sCDTextEdit.Text;
tiente.DonGiaSanPham = Convert.ToDouble(donGiaSanPhamSpinEdit.Value);
tiente.DonGiaKhuon = Convert.ToDouble(donGiaKhuonSpinEdit.Value);
tiente.DonGiaMau = Convert.ToDouble(donGiaMauSpinEdit.Value);
tiente.DonGiaVanChuyen = Convert.ToDouble(donGiaVanChuyenSpinEdit.Value);
tiente.TongTien = Convert.ToDouble(tongTienSpinEdit.Value);
tiente.NgoaiTe = ngoaiTeComboBox.Text;
if (CheckVAT.Checked)
{
tiente.VAT = 1.1;
}
else if (CheckVAT.CheckState == CheckState.Unchecked || tongTienSpinEdit.Text == null)
{
tiente.VAT = 1;
}
}
var baocao = (from s in db.tbBaoCaoThietKes where s.IDBaoCaoThietKe == sCDTextEdit.Text select s).Single();
baocao.Size = khacTextEdit.Text;
baocao.SpSize = soLuongSpinEdit.Text;
db.SubmitChanges();
MessageBox.Show(PrintRibbon.capnhat);
frmDonSanXuat_CapNhat_Load(sender, e);
}
else
{
MessageBox.Show("Đơn hàng đã hoàn thành, không thể cập nhật");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
if (flagluu == 1)
{
var tb = new tbNhanVien();
{
tb.MaNhanVien = maNhanVienTextEdit.Text;
tb.TenNhanVien = tenNhanVienTextEdit.Text;
tb.TaiKhoan = taiKhoanTextEdit.Text;
tb.MatKhau = Md5(matKhauTextEdit.Text);
tb.BoPhan = BoPhantxt.Text;
tb.NgaySinh = ngaySinhTextEdit.Text;
if (gioiTinhTextEdit.SelectedIndex == 1)
{
tb.GioiTinh = "Nam";
}
else
{
tb.GioiTinh = "Nữ";
}
tb.DiaChi = diaChiTextEdit.Text;
tb.DienThoai = dienThoaiTextEdit.Text;
tb.ChucVu = chucVuTextEdit.Text;
tb.TinhTrang = tinhTrangTextEdit.Text;
tb.GhiChu = ghiChuTextEdit.Text;
}
db.tbNhanViens.InsertOnSubmit(tb);
db.SubmitChanges();
MessageBox.Show(PrintRibbon.themthanhcong);
var phanquyen = new tbPhanQuyen();
phanquyen.MaNhanVien = maNhanVienTextEdit.Text;
phanquyen.NghiepVu = "False";
phanquyen.ThietKe = "False";
phanquyen.CTP = "False";
phanquyen.CTF = "False";
phanquyen.Offset = "False";
phanquyen.TemVai = "False";
phanquyen.SauIn = "False";
phanquyen.KiemPham = "False";
phanquyen.KhoBTP = "False";
phanquyen.KhoNVL = "False";
phanquyen.QuanLyChatLuong = "False";
phanquyen.QuanLySanXuat = "False";
phanquyen.DanhThiep = "False";
phanquyen.KyThuatSo = "False";
phanquyen.Sticker = "False";
phanquyen.InChuViTinh = "False";
db.tbPhanQuyens.InsertOnSubmit(phanquyen);
db.SubmitChanges();
flagluu = 0;
frmTaoTaiKhoan_Load(sender, e);
}
else if (flagluu == 2)
{
var tb = db.tbNhanViens.Single(s => s.MaNhanVien == maNhanVienTextEdit.Text);
tb.TenNhanVien = tenNhanVienTextEdit.Text;
tb.TaiKhoan = taiKhoanTextEdit.Text;
tb.MatKhau = Md5(matKhauTextEdit.Text);
tb.BoPhan = BoPhantxt.Text;
tb.NgaySinh = ngaySinhTextEdit.Text;
tb.GioiTinh = gioiTinhTextEdit.Text;
tb.DiaChi = diaChiTextEdit.Text;
tb.DienThoai = dienThoaiTextEdit.Text;
tb.ChucVu = chucVuTextEdit.Text;
tb.TinhTrang = tinhTrangTextEdit.Text;
tb.GhiChu = ghiChuTextEdit.Text;
db.SubmitChanges();
MessageBox.Show(PrintRibbon.capnhat);
flagluu = 0;
frmTaoTaiKhoan_Load(sender, e);
}
}
private void btnTinh_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var _OrderDate = new DateTime();
try
{
var Soluongtong = 0;
gridView1.BeginUpdate();
string _SO = null;
string Madonhang = null, SCD = null, SIZE = null, Soluongchitiet = null;
string SoXacnhan = null;
for (var i = 0; i < gridView1.SelectedRowsCount; i++)
{
string xacnhan = null, _Size = null;
try{ xacnhan = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colXacNhan).ToString(); }catch { }
_SO = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colso).ToString();
_OrderDate =
Convert.ToDateTime(gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colOrderDate));
var _IDTemDanAD = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colIDTemDanAD)
.ToString();
try { _Size = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colSize).ToString(); } catch { }
var _Qty = gridView1.GetRowCellValue(gridView1.GetSelectedRows()[i], colQTY).ToString();
if (!string.IsNullOrEmpty(xacnhan))
{
SoXacnhan = SoXacnhan + _SO + " , ";
}
var dsx = (from s in db.tbDonSanXuats where s.SCD == _IDTemDanAD select s).ToList();
foreach (var dsxItem in dsx)
{
SCD = SCD + dsxItem.SCD + " , " + Environment.NewLine;
Madonhang = Madonhang + dsxItem.MaDonHang + " , " + Environment.NewLine;
}
if (string.IsNullOrEmpty(_Size))
{
SIZE = SIZE + _SO + " , " + Environment.NewLine;
Soluongchitiet = Soluongchitiet + _SO + " ( " + _Qty + " pcs ) " + " , " +
Environment.NewLine;
var lst1 = (from s in db.tbTemDanAds where s.SO == _SO select s).ToList();
foreach (var item in lst1)
{
item.XacNhan = "1";
}
}
else
{
SIZE = SIZE + _SO + "_" + _Size + " , " + Environment.NewLine;
Soluongchitiet = Soluongchitiet + _SO + "_" + _Size + " ( " + _Qty +
" pcs )" + " , " + Environment.NewLine;
var lst2 = (from s in db.tbTemDanAds
where s.SO == _SO && s.Size == _Size
select s).ToList();
foreach (var item in lst2)
{
item.XacNhan = "1";
}
}
Soluongtong = Soluongtong + Convert.ToInt32(_Qty);
}
if (SoXacnhan == null)
{
var thongtin = new tbThongTinGopDonAD();
if (_SO != null)
{
thongtin.SO = _SO.Split('-')[0];
}
thongtin.NgayXuongDon = _OrderDate;
thongtin.DonGop = SIZE;
thongtin.SoLuongDonGop = Soluongchitiet;
thongtin.TongSoLuong = Soluongtong;
thongtin.SCD = SCD;
thongtin.MaDonHang = Madonhang;
db.tbThongTinGopDonADs.InsertOnSubmit(thongtin);
db.SubmitChanges();
}
else
{
MessageBox.Show("Mã SO: " + SoXacnhan + " đã xác nhận rồi , nên không gộp đơn được");
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi" + ex);
// ignored
}
finally
{
gridView1.EndUpdate();
MessageBox.Show(PrintRibbon.capnhat);
SearchSO_EditValueChanged(sender, e);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
var db = new MyDBContextDataContext();
var procqldh = (from a in db.DonSanXuat_QuanLyDonhang_View() where a.SCD == sCDTextEdit.Text select a).Single();
if (procqldh.HoanThanh == null)
{
var tb = (from s in db.tbDonSanXuats where s.SCD == sCDTextEdit.Text select s).Single();
tb.MaDonHang = maDonHangTextEdit.Text;
tb.PhienBan = txtPhienBan.Text;
tb.TenKhachHang = txtKhachHang.Text;
tb.NgayXuongDon = ngayXuongDonDateEdit.DateTime;
tb.NgayGiaoHang = ngayGiaoHangDateEdit.DateTime;
tb.TenSanPham = txtTenSanPham.Text;
tb.LoaiSanPham = txtLoaiSanPham.Text;
tb.PhuongPhapIn = txtPhuongPhapIn.Text;
tb.KichThuoc = kichThuocTextEdit.Text;
tb.SoLuong = int.Parse(soLuongSpinEdit.Text);
tb.VatLieu = vatLieuComboBox.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.DucLo = ducLoTextEdit.Text;
tb.LoaiChi = loaiChiTextEdit.Text;
tb.ChuY = chuYTextEdit.Text;
tb.BoPhan = txtBoPhan.Text;
tb.ChamCatDapHop = chamCatDapHopTextEdit.Text;
tb.DoDai = doDaiTextEdit.Text;
tb.GiaCongSau = giaCongSauTextEdit.Text;
tb.InChu_MaVach = inChu_MaVachTextEdit.Text;
tb.Kho = txtKho.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.ThoiGianXuongDon = DateTime.Now;
tb.Khac = khacTextEdit.Text;
tb.SKU = (int)txtSKU.Value;
if (procqldh.NghiepVu_XuongDon != null)
{
tb.ChinhSua = "1";
}
var tiente = (from s in db.tbQuanLyTienTes where s.IDTienTe == sCDTextEdit.Text select s).Single();
tiente.IDTienTe = sCDTextEdit.Text;
tiente.DonGiaSanPham = Convert.ToDouble(donGiaSanPhamSpinEdit.Value);
tiente.DonGiaKhuon = Convert.ToDouble(donGiaKhuonSpinEdit.Value);
tiente.DonGiaMau = Convert.ToDouble(donGiaMauSpinEdit.Value);
tiente.DonGiaVanChuyen = Convert.ToDouble(donGiaVanChuyenSpinEdit.Value);
tiente.TongTien = Convert.ToDouble(tongTienSpinEdit.Value);
tiente.NgoaiTe = ngoaiTeComboBox.Text;
if (CheckVAT.Checked)
{
tiente.VAT = 1.1;
}
else
{
tiente.VAT = 1;
}
db.SubmitChanges();
MessageBox.Show(capnhat);
var soluong = tb.SoLuong;
double scrap = 0;
var dsx = db.tbDonSanXuat_Averies.ToList();
var ll = (from s in db.tbLanhLieus where s.IDLanhLieu == sCDTextEdit.Text select s).Single();
foreach (var item in dsx)
{
if (item.SO != txtTenSanPham.Text)
{
continue;
}
if (soluong / item.SKU > 1000)
{
scrap = 0.02;
}
else if (soluong / item.SKU > 500)
{
scrap = 0.04;
}
else if (soluong / item.SKU > 300)
{
scrap = 0.06;
}
else if (soluong / item.SKU > 200)
{
scrap = 0.08;
}
else if (soluong / item.SKU > 100)
{
scrap = 0.12;
}
else if (soluong / item.SKU <= 100)
{
scrap = 0.21;
}
ll.LanhLieu = (int)((1 + scrap) *
(soluong * 1.1 + item.SKU * 5 + Math.Round((double)item.Qty / 500, 0) * 6 +
15 + 15) * ((item.Length / 1000) + (item.SKU - 1) * 2 + 6) / 0.9144);
ll.SoLuongSanXuat = soluong;
ll.BuHao = 1.1;
ll.DonViTinh = "YARD";
db.SubmitChanges();
}
frmDonSanXuat_Avery_CapNhat_Load(sender, e);
}
else
{
MessageBox.Show("Đơn hàng đã hoàn thành, không thể cập nhật");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
var db = new MyDBContextDataContext();
var kiemtra = (from s in db.tbKhoNLVs where s.MaPhieu == MaPhieutxt.Text select s).ToList();
if (kiemtra.Count > 0 && _MaPhieu == "mới" && _flagluu == 1)
{
MessageBox.Show("Mã phiếu đã có, hệ thống tự động thay đổi Mã phiếu mới");
var maphieu = "PXK" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "/";
dt = knvlCtr.GetData_MaPhieu(maphieu);
MaPhieutxt.Text = maphieu + knvlCtr.SinhMaTuDong_MaPhieu(dt);
}
if (!string.IsNullOrEmpty(KhoCongTytxt.Text))
{
if (!string.IsNullOrEmpty(BoPhantxt.Text))
{
var gioihan = DateTime.Today - NgayNhaptxt.DateTime;
if ((int)gioihan.TotalDays <= 30 && gioihan.TotalDays >= 0)
{
DataRow dr;
if (_flagluu == 2)
{
knvlCtr.DelData("MaPhieu", _MaPhieu);
}
for (var i = 0; i < gridView1.RowCount - 1; i++)
{
var IDKho = "/" + DateTime.Now.ToString("ddMMyyHHmmss").Substring(2, 4) + "X";
dt = knvlCtr.GetData_IDKho(IDKho);
dr = gridView1.GetDataRow(i);
var lst = db.tbVatLieus.Single(s => s.MaHang == dr["MaHang"].ToString());
var knvl = new tbKhoNLV();
knvl.IDKhoNVL = knvlCtr.SinhMaTuDong_IDkho(dt) + IDKho;
knvl.MaPhieu = MaPhieutxt.Text;
knvl.SCD = dr["SCD"].ToString();
knvl.Lo = dr["Lo"].ToString();
if (!string.IsNullOrEmpty(dr["HanSuDung"].ToString()))
{
knvl.HanSuDung = (DateTime)dr["HanSuDung"];
}
knvl.NhapXuat = "Xuất";
knvl.Kho = KhoCongTytxt.Text;
knvl.Ngay = NgayNhaptxt.DateTime;
knvl.TenHangHoa = lst.TenHangHoa;
knvl.DonViTinh = lst.DonViTinh;
knvl.QuyCach = lst.QuyCach;
knvl.MaHang = lst.MaHang;
knvl.MaAD = lst.MaAvery;
knvl.LoaiHang = lst.IDMaHang;
knvl.SoLuongXuat = (double)dr["SoLuongXuat"];
knvl.BoPhan = BoPhantxt.Text;
knvl.GhiChu = dr["GhiChu"].ToString();
knvl.NguoiQuanKho = nvObj.Tennhanvien;
db.tbKhoNLVs.InsertOnSubmit(knvl);
db.SubmitChanges();
if (!string.IsNullOrEmpty(knvl.SCD))
{
var count = 0;
var tb = db.tbLanhLieus.ToList();
foreach (var xacnhan in tb)
{
if (xacnhan.IDLanhLieu != knvl.SCD)
{
continue;
}
xacnhan.XacNhanLanhLieu = 1;
db.SubmitChanges();
count = 1;
break;
}
if (count == 0)
{
MessageBox.Show("Mã SCD : " + knvl.SCD + " không đúng , vui lòng xem lại");
}
}
}
switch (_flagluu)
{
case 1:
MessageBox.Show("Thêm Thành Công");
break;
case 2:
MessageBox.Show("Cập nhật thành công");
break;
}
//frmPhieuXuatKhoNVL_Load(sender, e);
btnLuu.Text = "Cập Nhật";
_flagluu = 2;
_MaPhieu = MaPhieutxt.Text;
}
else
{
MessageBox.Show("Dữ liệu đã vượt quá thời gian cho phép Lưu kho");
}
}
else
{
MessageBox.Show("Vui lòng nhập bộ phận");
}
}
else
{
MessageBox.Show("Vui lòng nhập Kho Công Ty");
}
}
catch (Exception)
{
//null
}
}
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");
}
}
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 btnTinh_Click(object sender, EventArgs e)
{
try
{
var db = new MyDBContextDataContext();
//if (radioGroup1.SelectedIndex == 0)
//{
var lst = (from s in db.DonSanXuat_LanhLieu_View()
where s.NgayXuongDon == Ngayxuongdontxt.DateTime && s.TenKhachHang == PrintRibbon.AD && s.BoPhan == PrintRibbon.temvai && s.PhuongPhapIn == "Máy in Tem Vải (In Mềm)" && s.DanhSach == txtDanhSach.Value // && s.Khac == "SKU 1"
select s).ToList();
foreach (var dsx in lst)
{
var tbLanhLieu = (from s in db.tbLanhLieus where s.LanhLieu == null select s).ToList();
foreach (var tb in tbLanhLieu)
{
if (tb.IDLanhLieu != dsx.SCD)
{
continue;
}
var kichthuoc = dsx.KichThuoc.Split('*');
//var sku = dsx.Khac.Split(' ');
tb.SoLuongSanXuat = dsx.SoLuong;
tb.BuHao = (double)txtBuHao.Value;
tb.NhanVienSanXuat = nvObj.Tennhanvien;
tb.DonViTinh = "YARD";
var tinh = ((tb.SoLuongSanXuat * tb.BuHao) * Convert.ToDouble(kichthuoc[1]) * 1.09 / 1000) + (int)txtChoThem.Value * Convert.ToInt32(dsx.SKU);
if (tinh != null)
{
tb.LanhLieu = (int)tinh;
}
//if (tinh != null)
//{
// if (dsx.SoLuong < 500)
// tb.LanhLieu = (int)tinh + 5;
// else
// tb.LanhLieu = (int)tinh;
//}
var vatlieu = db.tbVatLieus.Single(s => s.TenHangHoa == dsx.VatLieu && tb.DonViTinh == "YARD");
tb.QuyCach = vatlieu.QuyCach;
db.SubmitChanges();
}
}
//}
//else
//{
// var donsanxuat = (from s in db.DonSanXuat_LanhLieu_View()
// where s.NgayXuongDon == Ngayxuongdontxt.DateTime && s.TenKhachHang == PrintRibbon.AD && s.BoPhan == PrintRibbon.temvai && s.PhuongPhapIn == "Máy in Tem Vải (In Mềm)" && s.Khac != "SKU 1" && s.Khac != null
// select s).ToList();
// foreach (var dsx in donsanxuat)
// {
// var lanhlieu = (from s in db.tbLanhLieus where s.IDLanhLieu == dsx.SCD select s).Single();
// var kichthuoc = dsx.KichThuoc.Split('*');
// var _Size = db.TemDanAD_GroupBy_Size(dsx.SCD).ToList();
// double tong = 0;
// foreach (var size in _Size)
// {
// double tong1;
// double tong2 = 0;
// var TongSize = (from s in db.TemDanAD_Size(dsx.SCD) select s).ToList();
// foreach (var item2 in TongSize)
// {
// if (size.Size != item2.Size) continue;
// if (item2.QTY == "500 + 5")
// {
// var a = item2.QTY.Split('+');
// tong2 = tong2 + Convert.ToInt32(a[0]);
// }
// else
// tong2 = tong2 + Convert.ToInt32(item2.QTY);
// }
// if (tong2 < 500)
// tong1 = (double)(tong2 * lanhlieu.BuHao * Convert.ToInt32(kichthuoc[1]) * 1.09 / 1000 + 5);
// else
// tong1 = (double)(tong2 * lanhlieu.BuHao * Convert.ToInt32(kichthuoc[1]) * 1.09 / 1000);
// tong = tong + tong1;
// }
// //MessageBox.Show(item.SCD + " - tong - " + Math.Ceiling(tong));
// lanhlieu.SoLuongSanXuat = dsx.SoLuong;
// lanhlieu.BuHao = (double)txtBuHao.Value;
// lanhlieu.NhanVienSanXuat = nvObj.Tennhanvien;
// lanhlieu.DonViTinh = "YARD";
// lanhlieu.LanhLieu = (int)Math.Ceiling(tong);
// var vatlieu = db.tbVatLieus.Single(s => s.TenHangHoa == dsx.VatLieu && dsx.DonViTinh == "YARD");
// lanhlieu.QuyCach = vatlieu.QuyCach;
// db.SubmitChanges();
// }
//}
MessageBox.Show(PrintRibbon.themthanhcong);
}
catch (Exception)
{
//MessageBox.Show("Lỗi " + exception);
//throw;
}
Ngayxuongdontxt_EditValueChanged(sender, e);
}
