private void Import_Temp(DataTable datatable) { int intRow = datatable.Rows.Count; if (datatable.Columns.Contains("Mã hàng hóa") && datatable.Columns.Contains("Tồn thực tế") && datatable.Columns.Contains("Lý do kiểm kê")) { if (intRow != 0) { for (int i = 0; i <= intRow - 1; i++) { DataRow dr = datatable.Rows[i]; string MaHang = dr["Mã hàng hóa"].ToString().Trim(); if (MaHang != "") { int tblHangHoa_Count = DBDataProvider.DB.hhHangHoas.Where(x => x.MaHang == MaHang && x.DaXoa == 0).Count(); if (tblHangHoa_Count > 0) { var tblHangHoa = DBDataProvider.DB.hhHangHoas.Where(x => x.MaHang == MaHang && x.DaXoa == 0 && x.LoaiHHID == 1).FirstOrDefault(); var exitProdInList = listReceiptProducts.SingleOrDefault(r => r.MaHang == MaHang); if (exitProdInList == null) { int TonKhoThucTe = Convert.ToInt32(dr["Tồn thực tế"] == "" ? "0" : dr["Tồn thực tế"].ToString().Trim()); string DienGiai = dr["Lý do kiểm kê"] == "" ? "" : dr["Lý do kiểm kê"].ToString(); oImportProduct_ChiTietKiemKe newKiemKe = new oImportProduct_ChiTietKiemKe( tblHangHoa.IDHangHoa, tblHangHoa.MaHang, tblHangHoa.TenHangHoa, Convert.ToInt32(tblHangHoa.hhTonKhos.Where(s => s.ChiNhanhID == Convert.ToInt32(Formats.IDChiNhanh())).FirstOrDefault().SoLuong), TonKhoThucTe, TonKhoThucTe - Convert.ToInt32(tblHangHoa.hhTonKhos.Where(s => s.ChiNhanhID == Convert.ToInt32(Formats.IDChiNhanh())).FirstOrDefault().SoLuong), 1, DienGiai ); listReceiptProducts.Add(newKiemKe); } } } } } } else { throw new Exception("File excel không đúng. Vui lòng kiểm tra lại!!"); } }
public void Insert_Hang(int ID) { int tblHangHoa_Count = DBDataProvider.DB.hhHangHoas.Where(x => x.IDHangHoa == ID && x.DaXoa == 0 && x.LoaiHHID == 1).Count(); if (tblHangHoa_Count > 0) { var tblHangHoa = DBDataProvider.DB.hhHangHoas.Where(x => x.IDHangHoa == ID && x.DaXoa == 0).FirstOrDefault(); var exitProdInList = listReceiptProducts.SingleOrDefault(r => r.IDHangHoa == ID); if (exitProdInList == null) { oImportProduct_ChiTietKiemKe newKiemKe = new oImportProduct_ChiTietKiemKe( tblHangHoa.IDHangHoa, tblHangHoa.MaHang, tblHangHoa.TenHangHoa, Convert.ToInt32(tblHangHoa.hhTonKhos.Where(s => s.ChiNhanhID == Convert.ToInt32(Formats.IDChiNhanh())).FirstOrDefault().SoLuong), 0, -Convert.ToInt32(tblHangHoa.hhTonKhos.Where(s => s.ChiNhanhID == Convert.ToInt32(Formats.IDChiNhanh())).FirstOrDefault().SoLuong), 0, "" ); listReceiptProducts.Add(newKiemKe); } else { exitProdInList.TonKhoThucTe += 1; exitProdInList.ChenhLech = exitProdInList.TonKhoThucTe - exitProdInList.TonKhoHeThong; } UpdateSTT(); } else { ccbBarcode.Value = ""; ccbBarcode.Text = ""; ccbBarcode.Focus(); throw new Exception("Mã hàng không tồn tại!!"); } }