private void bwLoadData_DoWork(object sender, DoWorkEventArgs e) { materialTypeList = MaterialTypeController.Select().Where(w => w.MaterialGroup.Contains("UPPER")).ToList(); orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); sewingMasterList = SewingMasterController.SelectByProductNo(); DataTable dt = new DelayDataSet().Tables["DelayTable"]; List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList(); var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList(); foreach (string productNo in productNoList) { OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault(); List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList(); // get assemblyline from productNo //AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault(); // get sewingLing from productNo SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault(); //materialTypeIdList.Remove(6); //materialTypeIdList.Remove(11); //materialTypeIdList.Remove(12); //materialTypeIdList.Remove(13); //materialTypeIdList.Remove(14); foreach (int materialTypeId in materialTypeIdList) { RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault(); if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date < DateTime.Now.Date && rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1)) { DataRow dr = dt.NewRow(); // binding data to reportviewer dr["SewingLine"] = sewingMaster.SewingLine; dr["ProductNo"] = productNo; if (order != null) { dr["ArticleNo"] = order.ArticleNo; dr["ShoeName"] = order.ShoeName; dr["Quantity"] = order.Quantity; dr["ETD"] = order.ETD; } dr["SupplierETD"] = rawMaterial.ETD; dr["Remarks"] = rawMaterial.Remarks; MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault(); if (materialType != null) { dr["Supplier"] = materialType.Name; } dt.Rows.Add(dr); } } } e.Result = dt; }
public ActionResult RawMaterial(RawMaterialModel rawMaterialModel) { if (!ModelState.IsValid) { string errorString = this.ValidationRawMaterial(rawMaterialModel); if (!string.IsNullOrEmpty(errorString)) { ViewBag.Validate = errorString; return(View(rawMaterialModel)); } } if (rawMaterialModel.Id > 0) { var result = _iRawMaterialService.UpdateRawMaterial(rawMaterialModel); if (result == -1) { ModelState.AddModelError("RawMaterialName", "Raw Material already exists"); return(View(rawMaterialModel)); } ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss"); } else { var result = _iRawMaterialService.InsertRawMaterial(rawMaterialModel); if (result == -1) { ModelState.AddModelError("RawMaterialName", "Raw Material already exists"); return(View(rawMaterialModel)); } ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess"); } return(RedirectToAction("Index", "RawMaterial")); }
public int UpdateRawMaterial(RawMaterialModel rawMaterialModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); result = commonRepository.GetValidateUnique("RawMaterial", "RawMaterialName", rawMaterialModel.RawMaterialName, rawMaterialModel.Id.ToString()); if (result > 0) { return(-1); } con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "UPDATE RawMaterial SET RawMaterialName =@RawMaterialName," + "Notes = @Notes, " + "IsActive = @IsActive, " + "UserIdUpdated = " + LoginInfo.Userid + ",DateUpdated = GetUtcDate() " + "WHERE Id = @Id;"; result = con.Execute(query, rawMaterialModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("RawMaterial"); } else { sqltrans.Rollback(); } } return(result); }
public OutsoleRawMaterialWindow(string productNo) { InitializeComponent(); this.productNo = productNo; bwLoadData = new BackgroundWorker(); bwLoadData.WorkerSupportsCancellation = true; bwLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork); bwLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted); outsoleSupplierList = new List <OutsoleSuppliersModel>(); outsoleRawMaterialList = new List <OutsoleRawMaterialModel>(); outsoleRawMaterialViewList = new List <OutsoleRawMaterialViewModel>(); dtNothing = new DateTime(1999, 12, 31); dtDefault = new DateTime(2000, 1, 1); bwInsert = new BackgroundWorker(); bwInsert.DoWork += new DoWorkEventHandler(bwInsert_DoWork); bwInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwInsert_RunWorkerCompleted); outsoleRawMaterialViewToInsertList = new List <OutsoleRawMaterialViewModel>(); outsoleRawMaterialViewToDeleteList = new List <OutsoleRawMaterialViewModel>(); rawMaterial = new RawMaterialModel { ProductNo = productNo, MaterialTypeId = 6, ETD = dtDefault, ActualDate = dtDefault, Remarks = "", IsETDUpdate = false, IsActualDateUpdate = false, IsRemarksUpdate = false, }; }
void threadLoad_DoWork(object sender, DoWorkEventArgs e) { materialTypeList = MaterialTypeController.Select(); orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList(); foreach (string productNo in productNoList) { OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault(); List <Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList(); //Red! materialTypeIdList.Remove(6); materialTypeIdList.Remove(11); materialTypeIdList.Remove(12); materialTypeIdList.Remove(13); foreach (int materialTypeId in materialTypeIdList) { RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault(); if (rawMaterial != null && rawMaterial.ETD.Date != dtDefault //&& rawMaterial.ActualDate.Date == dtDefault ) { DeliveryStatusViewModel deliveryStatusView = new DeliveryStatusViewModel(); deliveryStatusView.ProductNo = productNo; if (order != null) { deliveryStatusView.Country = order.Country; deliveryStatusView.ArticleNo = order.ArticleNo; deliveryStatusView.ShoeName = order.ShoeName; deliveryStatusView.Quantity = order.Quantity; deliveryStatusView.ETD = order.ETD; } MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault(); if (materialType != null) { deliveryStatusView.Supplier = materialType.Name; } deliveryStatusView.SupplierETD = rawMaterial.ETD; if (rawMaterial.ActualDate != dtDefault) { deliveryStatusView.Actual = string.Format("{0:MM/dd/yyyy}", rawMaterial.ActualDate); deliveryStatusView.IsFinished = true; } else { deliveryStatusView.Actual = rawMaterial.Remarks; deliveryStatusView.IsFinished = false; } deliveryStatusViewList.Add(deliveryStatusView); } } } }
private string ValidationRawMaterial(RawMaterialModel rawMaterialModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(rawMaterialModel.RawMaterialName)) { ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName"); return(ErrorString); } return(ErrorString); }
public static bool Insert(RawMaterialModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @MaterialTypeId = new SqlParameter("@MaterialTypeId", model.MaterialTypeId); var @ETD = new SqlParameter("@ETD", model.ETD); var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate); var @Remarks = new SqlParameter("@Remarks", model.Remarks); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertRawMaterial @ProductNo,@MaterialTypeId,@ETD,@ActualDate,@Remarks", @ProductNo, @MaterialTypeId, @ETD, @ActualDate, @Remarks) > 0) { return(true); } return(false); }
public static bool InsertFromExcel(RawMaterialModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @MaterialTypeId = new SqlParameter("@MaterialTypeId", model.MaterialTypeId); var @ETD = new SqlParameter("@ETD", model.ETD); var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate); using (var db = new SaovietMasterScheduleEntities()) { if (db.ExecuteStoreCommand("EXEC spm_InsertRawMaterialFromExcel @ProductNo, @MaterialTypeId, @ETD, @ActualDate", @ProductNo, @MaterialTypeId, @ETD, @ActualDate) > 0) { return(true); } return(false); } }
private void bwReport_DoWork(object sender, DoWorkEventArgs e) { DataTable dt = new DeliveryDataSet().Tables["DeliveryTable"]; List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList(); var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList(); foreach (string productNo in productNoList) { OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault(); //List<Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList(); List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList(); //Red! //materialTypeIdList.Remove(11); //materialTypeIdList.Remove(6); //materialTypeIdList.Remove(12); //materialTypeIdList.Remove(13); //materialTypeIdList.Remove(14); foreach (int materialTypeId in materialTypeIdList) { RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault(); if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date == dateSearch.Date && rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1)) { DataRow dr = dt.NewRow(); dr["ProductNo"] = productNo; if (order != null) { dr["ArticleNo"] = order.ArticleNo; dr["ShoeName"] = order.ShoeName; dr["Quantity"] = order.Quantity; dr["ETD"] = order.ETD; } dr["SupplierETD"] = rawMaterial.ETD; dr["Remarks"] = rawMaterial.Remarks; MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault(); if (materialType != null) { dr["Supplier"] = materialType.Name; } dt.Rows.Add(dr); } } } e.Result = dt; }
public ActionResult RawMaterial(int?id) { RawMaterialModel rawMaterialModel = new RawMaterialModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true) { if (id > 0) { rawMaterialModel = _iRawMaterialService.GetRawMaterialById(Convert.ToInt32(id)); } return(View(rawMaterialModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public OutsoleInputMaterialWindow(string productNo, AccountModel account) { InitializeComponent(); this.productNo = productNo; this.account = account; threadLoadData = new BackgroundWorker(); threadLoadData.WorkerSupportsCancellation = true; threadLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork); threadLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted); outsoleSupplierList = new List <OutsoleSuppliersModel>(); sizeRunList = new List <SizeRunModel>(); dt = new DataTable(); outsoleMaterialToInsertList = new List <OutsoleMaterialModel>(); threadInsert = new BackgroundWorker(); threadInsert.DoWork += new DoWorkEventHandler(bwInsert_DoWork); threadInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwInsert_RunWorkerCompleted); outsoleMaterialList = new List <OutsoleMaterialModel>(); dtDefault = new DateTime(2000, 1, 1); dtNothing = new DateTime(1999, 12, 31); rawMaterial = new RawMaterialModel { ProductNo = productNo, MaterialTypeId = 6, ETD = dtNothing, ActualDate = dtNothing, Remarks = "", }; outsoleRawMaterialList = new List <OutsoleRawMaterialModel>(); outsoleSupplierModifiedList = new List <OutsoleSuppliersModel>(); outsoleRawMaterialToInsertList = new List <OutsoleRawMaterialModel>(); outsoleMaterialRackPositionList = new List <OutsoleMaterialRackPositionModel>(); outsoleMaterialRackPositionToInsertList = new List <OutsoleMaterialRackPositionModel>(); outsoleMaterialRackPositionToDeleteList = new List <OutsoleMaterialRackPositionModel>(); threadUpdateRawMaterial = new BackgroundWorker(); threadUpdateRawMaterial.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadUpdateRawMaterial_RunWorkerCompleted); threadUpdateRawMaterial.DoWork += new DoWorkEventHandler(threadUpdateRawMaterial_DoWork); }
public UpperComponentInputMaterialWindow(string productNo) { this.productNo = productNo; sizeRunList = new List <SizeRunModel>(); upperComponentList = new List <UpperComponentModel>(); upperComponentModifiedList = new List <UpperComponentModel>(); upperComponentMaterialList = new List <UpperComponentMaterialModel>(); upperComponentRawMaterialList = new List <UpperComponentRawMaterialModel>(); upperComponentRawMaterialToInsertList = new List <UpperComponentRawMaterialModel>(); upperComponentMaterialToInsertList = new List <UpperComponentMaterialModel>(); threadLoadData = new BackgroundWorker(); threadLoadData.WorkerSupportsCancellation = true; threadLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork); threadLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted); threadInsert = new BackgroundWorker(); threadInsert.DoWork += new DoWorkEventHandler(threadInsert_DoWork); threadInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadInsert_RunWorkerCompleted); threadUpdateRawMaterial = new BackgroundWorker(); threadUpdateRawMaterial.DoWork += new DoWorkEventHandler(threadUpdateRawMaterial_DoWork); threadUpdateRawMaterial.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadUpdateRawMaterial_RunWorkerCompleted); dt = new DataTable(); dtDefault = new DateTime(2000, 1, 1); dtNothing = new DateTime(1999, 12, 31); rawMaterial = new RawMaterialModel { ProductNo = productNo, MaterialTypeId = 12, ETD = dtNothing, ActualDate = dtNothing, Remarks = "", }; InitializeComponent(); }
public int InsertRawMaterial(RawMaterialModel rawMaterialModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); result = commonRepository.GetValidateUnique("RawMaterial", "RawMaterialName", rawMaterialModel.RawMaterialName, rawMaterialModel.Id.ToString()); if (result > 0) { return(-1); } int MaxId = commonRepository.GetMaxId("RawMaterial"); con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO RawMaterial (Id,RawMaterialName," + "Notes, " + "IsActive,UserIdInserted,DateInserted,IsDeleted)" + "VALUES (" + MaxId + ",@RawMaterialName," + "@Notes," + "@IsActive," + LoginInfo.Userid + ",GetUtcDate(),0); SELECT CAST(SCOPE_IDENTITY() as INT);"; result = con.Execute(query, rawMaterialModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("RawMaterial"); } else { sqltrans.Rollback(); } return(result); } }
public int UpdateRawMaterial(RawMaterialModel rawMaterialModel) { return(_iRawMaterialRepository.UpdateRawMaterial(rawMaterialModel)); }
public int InsertRawMaterial(RawMaterialModel rawMaterialModel) { return(_iRawMaterialRepository.InsertRawMaterial(rawMaterialModel)); }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { materialTypeList = MaterialTypeController.Select(); Excel.Application excelApplication = new Excel.Application(); Excel.Workbook excelWorkbook = excelApplication.Workbooks.Open(filePath); //excelApplication.Visible = true; Excel.Worksheet excelWorksheet; Excel.Range excelRange; try { excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1]; excelRange = excelWorksheet.UsedRange; progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = excelRange.Rows.Count)); for (int i = 3; i <= excelRange.Rows.Count; i++) { var productNoValue = (excelRange.Cells[i, 1] as Excel.Range).Value2; if (productNoValue != null) { // column 2,3 = TAIWAN (10) var taiwanMaterial = new RawMaterialModel(); taiwanMaterial.ProductNo = productNoValue.ToString(); taiwanMaterial.MaterialTypeId = 10; taiwanMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 10) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 10).Name : ""; taiwanMaterial.ETD = dtDefault; taiwanMaterial.ActualDate = dtDefault; var efdTaiwan = (excelRange.Cells[i, 2] as Excel.Range).Value2; if (efdTaiwan != null) { double efd = 0; Double.TryParse(efdTaiwan.ToString(), out efd); taiwanMaterial.ETD = DateTime.FromOADate(efd); } var actualTaiwan = (excelRange.Cells[i, 3] as Excel.Range).Value2; if (actualTaiwan != null) { double actual = 0; Double.TryParse(actualTaiwan.ToString(), out actual); taiwanMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdTaiwan != null || actualTaiwan != null) { upperMaterialFromExcelList.Add(taiwanMaterial); } // Column 4,5 = LAMINATION (1) var laminationMaterial = new RawMaterialModel(); laminationMaterial.ProductNo = productNoValue.ToString(); laminationMaterial.MaterialTypeId = 1; laminationMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 1) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 1).Name : ""; laminationMaterial.ETD = dtDefault; laminationMaterial.ActualDate = dtDefault; var efdLamination = (excelRange.Cells[i, 4] as Excel.Range).Value2; if (efdLamination != null) { double efd = 0; Double.TryParse(efdLamination.ToString(), out efd); laminationMaterial.ETD = DateTime.FromOADate(efd); } var actualLamination = (excelRange.Cells[i, 5] as Excel.Range).Value2; if (actualLamination != null) { double actual = 0; Double.TryParse(actualLamination.ToString(), out actual); laminationMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdLamination != null || actualLamination != null) { upperMaterialFromExcelList.Add(laminationMaterial); } // Column 6,7 = CUTTING (1) var cuttingMaterial = new RawMaterialModel(); cuttingMaterial.ProductNo = productNoValue.ToString(); cuttingMaterial.MaterialTypeId = 2; cuttingMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 2) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 2).Name : ""; cuttingMaterial.ETD = dtDefault; cuttingMaterial.ActualDate = dtDefault; var efdCutting = (excelRange.Cells[i, 6] as Excel.Range).Value2; if (efdCutting != null) { double efd = 0; Double.TryParse(efdCutting.ToString(), out efd); cuttingMaterial.ETD = DateTime.FromOADate(efd); } var actualCutting = (excelRange.Cells[i, 7] as Excel.Range).Value2; if (actualCutting != null) { double actual = 0; Double.TryParse(actualCutting.ToString(), out actual); cuttingMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdCutting != null || actualCutting != null) { upperMaterialFromExcelList.Add(cuttingMaterial); } // Column 8,9 = LEATHER (1) var leatherMaterial = new RawMaterialModel(); leatherMaterial.ProductNo = productNoValue.ToString(); leatherMaterial.MaterialTypeId = 3; leatherMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 3) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 3).Name : ""; leatherMaterial.ETD = dtDefault; leatherMaterial.ActualDate = dtDefault; var efdLeather = (excelRange.Cells[i, 8] as Excel.Range).Value2; if (efdLeather != null) { double efd = 0; Double.TryParse(efdLeather.ToString(), out efd); leatherMaterial.ETD = DateTime.FromOADate(efd); } var actualLeather = (excelRange.Cells[i, 9] as Excel.Range).Value2; if (actualLeather != null) { double actual = 0; Double.TryParse(actualLeather.ToString(), out actual); leatherMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdLeather != null || actualLeather != null) { upperMaterialFromExcelList.Add(leatherMaterial); } // Column 10, 11 = SEMIPROCESS (1) var semiprocessMaterial = new RawMaterialModel(); semiprocessMaterial.ProductNo = productNoValue.ToString(); semiprocessMaterial.MaterialTypeId = 4; semiprocessMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 4) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 4).Name : ""; semiprocessMaterial.ETD = dtDefault; semiprocessMaterial.ActualDate = dtDefault; var efdSemiprocess = (excelRange.Cells[i, 10] as Excel.Range).Value2; if (efdSemiprocess != null) { double efd = 0; Double.TryParse(efdSemiprocess.ToString(), out efd); semiprocessMaterial.ETD = DateTime.FromOADate(efd); } var actualSemiprocess = (excelRange.Cells[i, 11] as Excel.Range).Value2; if (actualSemiprocess != null) { double actual = 0; Double.TryParse(actualSemiprocess.ToString(), out actual); semiprocessMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdSemiprocess != null || actualSemiprocess != null) { upperMaterialFromExcelList.Add(semiprocessMaterial); } // Column 12, 13 = SEWING (1) var sewingMaterial = new RawMaterialModel(); sewingMaterial.ProductNo = productNoValue.ToString(); sewingMaterial.MaterialTypeId = 5; sewingMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 5) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 5).Name : ""; sewingMaterial.ETD = dtDefault; sewingMaterial.ActualDate = dtDefault; var efdSewing = (excelRange.Cells[i, 12] as Excel.Range).Value2; if (efdSewing != null) { double efd = 0; Double.TryParse(efdSewing.ToString(), out efd); sewingMaterial.ETD = DateTime.FromOADate(efd); } var actualSewing = (excelRange.Cells[i, 13] as Excel.Range).Value2; if (actualSewing != null) { double actual = 0; Double.TryParse(actualSewing.ToString(), out actual); sewingMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdSewing != null || actualSewing != null) { upperMaterialFromExcelList.Add(sewingMaterial); } // Column 14,15 = SECURITY LABEL (1) var securitylabelMaterial = new RawMaterialModel(); securitylabelMaterial.ProductNo = productNoValue.ToString(); securitylabelMaterial.MaterialTypeId = 7; securitylabelMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 7) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 7).Name : ""; securitylabelMaterial.ETD = dtDefault; securitylabelMaterial.ActualDate = dtDefault; var efdSecuritylabel = (excelRange.Cells[i, 14] as Excel.Range).Value2; if (efdSecuritylabel != null) { double efd = 0; Double.TryParse(efdSecuritylabel.ToString(), out efd); securitylabelMaterial.ETD = DateTime.FromOADate(efd); } var actualSecuritylabel = (excelRange.Cells[i, 15] as Excel.Range).Value2; if (actualSecuritylabel != null) { double actual = 0; Double.TryParse(actualSecuritylabel.ToString(), out actual); securitylabelMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdSecuritylabel != null || actualSecuritylabel != null) { upperMaterialFromExcelList.Add(securitylabelMaterial); } // Column 16,17 = ASSEMBLY (1) var assemblyMaterial = new RawMaterialModel(); assemblyMaterial.ProductNo = productNoValue.ToString(); assemblyMaterial.MaterialTypeId = 8; assemblyMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 8) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 8).Name : ""; assemblyMaterial.ETD = dtDefault; assemblyMaterial.ActualDate = dtDefault; var efdAssembly = (excelRange.Cells[i, 16] as Excel.Range).Value2; if (efdAssembly != null) { double efd = 0; Double.TryParse(efdAssembly.ToString(), out efd); assemblyMaterial.ETD = DateTime.FromOADate(efd); } var actualAssembly = (excelRange.Cells[i, 17] as Excel.Range).Value2; if (actualAssembly != null) { double actual = 0; Double.TryParse(actualAssembly.ToString(), out actual); assemblyMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdAssembly != null || actualAssembly != null) { upperMaterialFromExcelList.Add(assemblyMaterial); } // Column 18,19 = SOCKLINING (1) var sockliningMaterial = new RawMaterialModel(); sockliningMaterial.ProductNo = productNoValue.ToString(); sockliningMaterial.MaterialTypeId = 9; sockliningMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 9) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 9).Name : ""; sockliningMaterial.ETD = dtDefault; sockliningMaterial.ActualDate = dtDefault; var efdSocklining = (excelRange.Cells[i, 18] as Excel.Range).Value2; if (efdSocklining != null) { double efd = 0; Double.TryParse(efdSocklining.ToString(), out efd); sockliningMaterial.ETD = DateTime.FromOADate(efd); } var actualSocklining = (excelRange.Cells[i, 19] as Excel.Range).Value2; if (actualSocklining != null) { double actual = 0; Double.TryParse(actualSocklining.ToString(), out actual); sockliningMaterial.ActualDate = DateTime.FromOADate(actual); } if (efdSocklining != null || actualSocklining != null) { upperMaterialFromExcelList.Add(sockliningMaterial); } //upperMaterialFromExcelList.Add(taiwanMaterial); //upperMaterialFromExcelList.Add(laminationMaterial); //upperMaterialFromExcelList.Add(cuttingMaterial); //upperMaterialFromExcelList.Add(leatherMaterial); //upperMaterialFromExcelList.Add(semiprocessMaterial); //upperMaterialFromExcelList.Add(sewingMaterial); //upperMaterialFromExcelList.Add(securitylabelMaterial); //upperMaterialFromExcelList.Add(assemblyMaterial); //upperMaterialFromExcelList.Add(sockliningMaterial); progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = i - 2)); } } } catch { upperMaterialFromExcelList.Clear(); } finally { excelWorkbook.Close(false, Missing.Value, Missing.Value); excelApplication.Quit(); } }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); sewingMasterList = SewingMasterController.Select(); outsoleMasterList = OutsoleMasterController.Select(); outsoleReleaseMaterialList = OutsoleReleaseMaterialController.SelectByOutsoleMaster(); productionMemoList = ProductionMemoController.Select(); //sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing); outsoleMasterList = outsoleMasterList.OrderBy(s => s.Sequence).ToList(); int[] materialIdUpperArray = { 1, 2, 3, 4, 10 }; int[] materialIdSewingArray = { 5, 7 }; int[] materialIdOutsoleArray = { 6 }; foreach (OutsoleMasterModel outsoleMaster in outsoleMasterList) { OutsoleMasterExportViewModel outsoleMasterExportView = new OutsoleMasterExportViewModel(); outsoleMasterExportView.Sequence = outsoleMaster.Sequence; outsoleMasterExportView.ProductNo = outsoleMaster.ProductNo; OrdersModel order = orderList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault(); string memoId = ""; if (order != null) { outsoleMasterExportView.Country = order.Country; outsoleMasterExportView.ShoeName = order.ShoeName; outsoleMasterExportView.ArticleNo = order.ArticleNo; outsoleMasterExportView.OutsoleCode = order.OutsoleCode; outsoleMasterExportView.Quantity = order.Quantity; outsoleMasterExportView.ETD = order.ETD; List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList(); for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++) { ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p]; memoId += productionMemo.MemoId; if (p < productionMemoByProductionNumberList.Count - 1) { memoId += "\n"; } } outsoleMasterExportView.MemoId = memoId; } MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray); outsoleMasterExportView.IsOutsoleMatsArrivalOk = false; if (materialArrivalOutsole != null) { outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date); outsoleMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk; } outsoleMasterExportView.OutsoleLine = outsoleMaster.OutsoleLine; outsoleMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate; outsoleMasterExportView.OutsoleFinishDate = outsoleMaster.OutsoleFinishDate; outsoleMasterExportView.OutsoleQuota = outsoleMaster.OutsoleQuota; outsoleMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance; RawMaterialModel outsoleRawMaterial = rawMaterialList.Where(r => r.ProductNo == outsoleMaster.ProductNo && materialIdOutsoleArray.Contains(r.MaterialTypeId)).FirstOrDefault(); if (outsoleRawMaterial != null) { outsoleMasterExportView.OutsoleWHBalance = outsoleRawMaterial.Remarks; } else { outsoleMasterExportView.OutsoleWHBalance = ""; } SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault(); if (sewingMaster != null) { outsoleMasterExportView.SewingStartDate = sewingMaster.SewingStartDate; outsoleMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate; outsoleMasterExportView.SewingQuota = sewingMaster.SewingQuota; outsoleMasterExportView.SewingBalance = sewingMaster.SewingBalance; } else { outsoleMasterExportView.SewingStartDate = dtDefault; outsoleMasterExportView.SewingFinishDate = dtDefault; outsoleMasterExportView.SewingQuota = 0; outsoleMasterExportView.SewingBalance = ""; } List <OutsoleReleaseMaterialModel> outsoleReleaseMaterialList_D1 = outsoleReleaseMaterialList.Where(o => o.ProductNo == outsoleMaster.ProductNo).ToList(); int qtyReleased = outsoleReleaseMaterialList_D1.Sum(o => o.Quantity); outsoleMasterExportView.ReleasedQuantity = qtyReleased.ToString(); if (qtyReleased <= 0) { outsoleMasterExportView.ReleasedQuantity = ""; } if (qtyReleased >= outsoleMasterExportView.Quantity && outsoleReleaseMaterialList_D1.Count > 0) { DateTime releasedDate = outsoleReleaseMaterialList_D1.FirstOrDefault().ModifiedTime; outsoleMasterExportView.ReleasedQuantity = string.Format("{0:M/d}", releasedDate); } outsoleMasterExportViewList.Add(outsoleMasterExportView); } }