public static bool Insert(SewingMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine); var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota); var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate); var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate); var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance); var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota); var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", model.CutAActualStartDate); var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", model.CutAActualFinishDate); var @CutABalance = new SqlParameter("@CutABalance", model.CutABalance); var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance); var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance); var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance); var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance); var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMaster @ProductNo,@Sequence,@SewingLine,@SewingQuota,@SewingActualStartDate,@SewingActualFinishDate,@SewingBalance,@CutAQuota,@CutAActualStartDate,@CutAActualFinishDate,@CutABalance,@PrintingBalance,@H_FBalance,@EmbroideryBalance,@CutBBalance,@AutoCut", @ProductNo, @Sequence, @SewingLine, @SewingQuota, @SewingActualStartDate, @SewingActualFinishDate, @SewingBalance, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBBalance, @AutoCut) > 0) { return(true); } return(false); }
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 static bool InsertSequence(SewingMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate); var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMasterSequence @ProductNo,@Sequence,@SewingStartDate,@SewingFinishDate", @ProductNo, @Sequence, @SewingStartDate, @SewingFinishDate) > 0) { return(true); } return(false); }
private void bwLoad_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { DataTable dt = new AssemblyScheduleDelayDataSet().Tables["AssemblyScheduleDelayTable"]; //sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing); assemblyMasterList = assemblyMasterList.OrderBy(s => s.Sequence).ToList(); foreach (AssemblyMasterModel assemblyMaster in assemblyMasterList) { OrdersModel order = orderList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault(); int qtyBalance = 0; if (order != null && assemblyMaster.AssemblyFinishDate > order.ETD && (String.IsNullOrEmpty(assemblyMaster.AssemblyBalance) == true || int.TryParse(assemblyMaster.AssemblyBalance, out qtyBalance) == true)) { DataRow dr = dt.NewRow(); dr["ProductNo"] = order.ProductNo; dr["Country"] = order.Country; dr["ShoeName"] = order.ShoeName; dr["ArticleNo"] = order.ArticleNo; dr["ETD"] = order.ETD; dr["Quantity"] = order.Quantity; dr["AssemblyLine"] = assemblyMaster.AssemblyLine; dr["AssemblyBalance"] = assemblyMaster.AssemblyBalance; SewingMasterModel sewingMaster = sewingMasterList.Where(s => s.ProductNo == order.ProductNo).FirstOrDefault(); if (sewingMaster != null) { dr["SewingFinishDate"] = sewingMaster.SewingFinishDate; } dr["AssemblyFinishDate"] = assemblyMaster.AssemblyFinishDate; dt.Rows.Add(dr); } } ReportDataSource rds = new ReportDataSource(); rds.Name = "AssemblyScheduleDelay"; rds.Value = dt; //reportViewer.LocalReport.ReportPath = @"C:\Users\IT02\Documents\Visual Studio 2010\Projects\Saoviet Master Schedule Solution\MasterSchedule\Reports\AssemblyScheduleDelayReport.rdlc"; reportViewer.LocalReport.ReportPath = @"Reports\AssemblyScheduleDelayReport.rdlc"; reportViewer.LocalReport.DataSources.Add(rds); reportViewer.RefreshReport(); this.Cursor = null; }
// Not Use public static bool InsertSewing(SewingMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine); var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate); var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate); var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota); var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate); var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate); var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance); using (var db = new SaovietMasterScheduleEntities()) { if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMasterSewing @ProductNo,@SewingLine,@SewingStartDate,@SewingFinishDate,@SewingQuota,@SewingActualStartDate,@SewingActualFinishDate,@SewingBalance", @ProductNo, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingActualStartDate, @SewingActualFinishDate, @SewingBalance) > 0) { return(true); } return(false); } }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); sockliningMasterList = SockliningMasterController.Select(); sewingMasterList = SewingMasterController.Select(); outsoleMasterList = OutsoleMasterController.Select(); assemblyMasterList = AssemblyMasterController.Select(); //sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing); sockliningMasterList = sockliningMasterList.OrderBy(s => s.Sequence).ToList(); int[] materialIdUpperArray = { 1, 2, 3, 4, 10 }; int[] materialIdSewingArray = { 5, 7 }; int[] materialIdOutsoleArray = { 6 }; int[] materialIdAssemblyArray = { 8 }; int[] materialIdSockliningArray = { 9 }; foreach (SockliningMasterModel sockliningMaster in sockliningMasterList) { SockliningMasterExportViewModel sockliningMasterExportView = new SockliningMasterExportViewModel(); sockliningMasterExportView.Sequence = sockliningMaster.Sequence; sockliningMasterExportView.ProductNo = sockliningMaster.ProductNo; OrdersModel order = orderList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault(); if (order != null) { sockliningMasterExportView.Country = order.Country; sockliningMasterExportView.ShoeName = order.ShoeName; sockliningMasterExportView.ArticleNo = order.ArticleNo; sockliningMasterExportView.PatternNo = order.PatternNo; sockliningMasterExportView.Quantity = order.Quantity; sockliningMasterExportView.ETD = order.ETD; } MaterialArrivalViewModel materialArrivalSocklining = MaterialArrival(order.ProductNo, materialIdSockliningArray); sockliningMasterExportView.IsSockliningMatsArrivalOk = false; if (materialArrivalSocklining != null) { sockliningMasterExportView.SockliningMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalSocklining.Date); sockliningMasterExportView.IsSockliningMatsArrivalOk = materialArrivalSocklining.IsMaterialArrivalOk; } sockliningMasterExportView.SockliningLine = sockliningMaster.SockliningLine; sockliningMasterExportView.SockliningQuota = sockliningMaster.SockliningQuota; sockliningMasterExportView.SockliningStartDate = sockliningMaster.SockliningStartDate; sockliningMasterExportView.SockliningFinishDate = sockliningMaster.SockliningFinishDate; sockliningMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance; sockliningMasterExportView.InsockBalance = sockliningMaster.InsockBalance; SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault(); if (sewingMaster != null) { sockliningMasterExportView.SewingStartDate = sewingMaster.SewingStartDate; sockliningMasterExportView.SewingBalance = sewingMaster.SewingBalance; } else { sockliningMasterExportView.SewingStartDate = dtDefault; sockliningMasterExportView.SewingBalance = ""; } OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault(); if (outsoleMaster != null) { sockliningMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate; sockliningMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance; } else { sockliningMasterExportView.OutsoleStartDate = dtDefault; sockliningMasterExportView.OutsoleBalance = ""; } AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault(); if (assemblyMaster != null) { sockliningMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate; } else { sockliningMasterExportView.AssemblyStartDate = dtDefault; } sockliningMasterExportViewList.Add(sockliningMasterExportView); } }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); sewingMasterList = SewingMasterController.Select(); outsoleMasterList = OutsoleMasterController.Select(); sockliningMasterList = SockliningMasterController.Select(); assemblyMasterList = AssemblyMasterController.Select(); productionMemoList = ProductionMemoController.Select(); outsoleRawMaterialList = OutsoleRawMaterialController.Select(); rawMaterialViewModelNewList = RawMaterialController.Select_1(); //sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing); assemblyMasterList = assemblyMasterList.OrderBy(s => s.Sequence).ToList(); int[] materialIdUpperArray = { 1, 2, 3, 4, 10 }; int[] materialIdSewingArray = { 5, 7 }; int[] materialIdOutsoleArray = { 6 }; int[] materialIdAssemblyArray = { 8, 9 }; int[] materialIdCartonArray = { 11 }; foreach (AssemblyMasterModel assemblyMaster in assemblyMasterList) { AssemblyMasterExportViewModel assemblyMasterExportView = new AssemblyMasterExportViewModel(); assemblyMasterExportView.Sequence = assemblyMaster.Sequence; assemblyMasterExportView.ProductNo = assemblyMaster.ProductNo; OrdersModel order = orderList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault(); string memoId = ""; if (order != null) { assemblyMasterExportView.Country = order.Country; assemblyMasterExportView.ShoeName = order.ShoeName; assemblyMasterExportView.ArticleNo = order.ArticleNo; assemblyMasterExportView.LastCode = order.LastCode; assemblyMasterExportView.Quantity = order.Quantity; assemblyMasterExportView.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"; } } assemblyMasterExportView.MemoId = memoId; } //MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray); //assemblyMasterExportView.IsOutsoleMatsArrivalOk = false; //if (materialArrivalOutsole != null) //{ // assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date); // assemblyMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk; //} //// follow OutsoleRawMaterial //var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList(); //var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList(); //assemblyMasterExportView.IsOutsoleMatsArrivalOk = false; //if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false) //{ // assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max()); // assemblyMasterExportView.IsOutsoleMatsArrivalOk = true; //} //else //{ // var etdDateList = osRawMaterial.Select(s => s.ETD).ToList(); // if (etdDateList.Count() > 0) // { // assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max()); // } //} assemblyMasterExportView.IsOutsoleMatsArrivalOk = false; var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo); if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) && !String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate)) { assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate; assemblyMasterExportView.IsOutsoleMatsArrivalOk = true; } else { assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD; } MaterialArrivalViewModel materialArrivalAssembly = MaterialArrival(order.ProductNo, materialIdAssemblyArray); assemblyMasterExportView.IsAssemblyMatsArrivalOk = false; if (materialArrivalAssembly != null) { assemblyMasterExportView.AssemblyMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalAssembly.Date); assemblyMasterExportView.IsAssemblyMatsArrivalOk = materialArrivalAssembly.IsMaterialArrivalOk; } MaterialArrivalViewModel materialArrivalCarton = MaterialArrival(order.ProductNo, materialIdCartonArray); if (materialArrivalCarton != null) { assemblyMasterExportView.CartonMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalCarton.Date); } assemblyMasterExportView.AssemblyLine = assemblyMaster.AssemblyLine; assemblyMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate; assemblyMasterExportView.AssemblyFinishDate = assemblyMaster.AssemblyFinishDate; assemblyMasterExportView.AssemblyQuota = assemblyMaster.AssemblyQuota; assemblyMasterExportView.AssemblyBalance = assemblyMaster.AssemblyBalance; SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault(); if (sewingMaster != null) { assemblyMasterExportView.SewingStartDate = sewingMaster.SewingStartDate; assemblyMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate; assemblyMasterExportView.SewingBalance = sewingMaster.SewingBalance; } else { assemblyMasterExportView.SewingStartDate = dtDefault; assemblyMasterExportView.SewingFinishDate = dtDefault; assemblyMasterExportView.SewingBalance = ""; } OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault(); if (outsoleMaster != null) { assemblyMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance; } else { assemblyMasterExportView.OutsoleBalance = ""; } SockliningMasterModel sockliningMaster = sockliningMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault(); if (sockliningMaster != null) { assemblyMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance; assemblyMasterExportView.InsockBalance = sockliningMaster.InsockBalance; } else { assemblyMasterExportView.InsoleBalance = ""; assemblyMasterExportView.InsockBalance = ""; } assemblyMasterExportViewList.Add(assemblyMasterExportView); } }
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); } }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { orderList = OrdersController.Select(); rawMaterialList = RawMaterialController.Select(); sewingMasterList = SewingMasterController.Select(); outsoleMasterList = OutsoleMasterController.Select(); outsoleRawMaterialList = OutsoleRawMaterialController.Select(); outsoleReleaseMaterialList = OutsoleReleaseMaterialController.SelectByOutsoleMaster(); productionMemoList = ProductionMemoController.Select(); outsoleMaterialList = OutsoleMaterialController.Select(); rawMaterialViewModelNewList = RawMaterialController.Select_1(); //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.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo); string memoId = ""; if (order != null) { outsoleMasterExportView.Country = order.Country; outsoleMasterExportView.ShoeName = order.ShoeName; outsoleMasterExportView.ArticleNo = order.ArticleNo; outsoleMasterExportView.OutsoleCode = order.OutsoleCode; outsoleMasterExportView.PatternNo = order.PatternNo; 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; //} // Update follow OutsoleRawMaterial //var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList(); //var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList(); //outsoleMasterExportView.IsOutsoleMatsArrivalOk = false; //if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false) //{ // outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max()); // outsoleMasterExportView.IsOutsoleMatsArrivalOk = true; //} //else //{ // var etdDateList = osRawMaterial.Select(s => s.ETD).ToList(); // if (etdDateList.Count() > 0) // { // outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max()); // } //} outsoleMasterExportView.IsOutsoleMatsArrivalOk = false; var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo); if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) && !String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate)) { outsoleMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate; outsoleMasterExportView.IsOutsoleMatsArrivalOk = true; } else { outsoleMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD; } outsoleMasterExportView.OutsoleLine = outsoleMaster.OutsoleLine; outsoleMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate; outsoleMasterExportView.OutsoleFinishDate = outsoleMaster.OutsoleFinishDate; outsoleMasterExportView.OutsoleQuota = outsoleMaster.OutsoleQuota; outsoleMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance; //RawMaterialModel outsoleRawMaterial = rawMaterialList.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo && materialIdOutsoleArray.Contains(f.MaterialTypeId)); //if (outsoleRawMaterial != null) //{ // outsoleMasterExportView.OutsoleWHBalance = outsoleRawMaterial.Remarks; //} //else //{ // outsoleMasterExportView.OutsoleWHBalance = ""; //} // Load Outsole_Remarks from OutsoleMaterial var outsoleMaterial_PO = outsoleMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList(); var osMaterialSumBySupplier = outsoleMaterial_PO.GroupBy( g => g.OutsoleSupplierId) .Select(s => new { PO = order.ProductNo, Supplier = s.Key, ActualDelivery = outsoleMaterial_PO.Where(w => w.OutsoleSupplierId == s.Key) .Sum(su => su.Quantity - su.QuantityReject) }).ToList(); // if pot no one delivery. not show the balance quantity. if (osMaterialSumBySupplier.Count > 0 && order.Quantity - osMaterialSumBySupplier.Min(m => m.ActualDelivery) > 0) { // show the balance outsoleMasterExportView.OutsoleWHBalance = (order.Quantity - osMaterialSumBySupplier.Min(m => m.ActualDelivery)).ToString(); // if no one delivery, show blank if (outsoleMaterial_PO.Sum(s => s.Quantity) == 0) { outsoleMasterExportView.OutsoleWHBalance = ""; } } SewingMasterModel sewingMaster = sewingMasterList.FirstOrDefault(f => f.ProductNo == outsoleMaster.ProductNo); 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); } }
public static bool Insert_2(SewingMasterModel model) { DateTime dtDefault = new DateTime(2000, 01, 01); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine); var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate); var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate); var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota); var @SewingPrep = new SqlParameter("@SewingPrep", model.SewingPrep); var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate); var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate); DateTime sewingActualStartDateAutoDt = TimeHelper.Convert(model.SewingActualStartDateAuto); DateTime sewingActualFinishDateAutoDt = TimeHelper.Convert(model.SewingActualFinishDateAuto); string sewingActualStartDateAutoString = ""; if (sewingActualStartDateAutoDt != dtDefault) { sewingActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualStartDateAutoDt); } string sewingActualFinishDateAutoString = ""; if (sewingActualFinishDateAutoDt != dtDefault) { sewingActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualFinishDateAutoDt); } var @SewingActualStartDateAuto = new SqlParameter("@SewingActualStartDateAuto", sewingActualStartDateAutoString); var @SewingActualFinishDateAuto = new SqlParameter("@SewingActualFinishDateAuto", sewingActualFinishDateAutoString); var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance); var @CutAStartDate = new SqlParameter("@CutAStartDate", model.CutAStartDate); var @CutAFinishDate = new SqlParameter("@CutAFinishDate", model.CutAFinishDate); var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota); DateTime cutAActualStartDateDt = TimeHelper.Convert(model.CutAActualStartDate); DateTime cutAActualFinishDateDt = TimeHelper.Convert(model.CutAActualFinishDate); string cutAActualStartDateString = ""; if (cutAActualStartDateDt != dtDefault) { cutAActualStartDateString = String.Format("{0:MM/dd/yyyy}", cutAActualStartDateDt); } string cutAActualFinishDateString = ""; if (cutAActualFinishDateDt != dtDefault) { cutAActualFinishDateString = String.Format("{0:MM/dd/yyyy}", cutAActualFinishDateDt); } var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", cutAActualStartDateString); var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", cutAActualFinishDateString); var @CutABalance = new SqlParameter("@CutABalance", model.CutABalance); var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance); var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance); var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance); DateTime cutBActualStartDateDt = TimeHelper.Convert(model.CutBActualStartDate); string cutBActualStartDateString = ""; if (cutBActualStartDateDt != dtDefault) { cutBActualStartDateString = String.Format("{0:MM/dd/yyyy}", cutBActualStartDateDt); } var @CutBActualStartDate = new SqlParameter("@CutBActualStartDate", cutBActualStartDateString); var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance); var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut); var @LaserCut = new SqlParameter("@LaserCut", model.LaserCut); var @HuasenCut = new SqlParameter("@HuasenCut", model.HuasenCut); var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate); var @IsSewingLineUpdate = new SqlParameter("@IsSewingLineUpdate", model.IsSewingLineUpdate); var @IsSewingStartDateUpdate = new SqlParameter("@IsSewingStartDateUpdate", model.IsSewingStartDateUpdate); var @IsSewingFinishDateUpdate = new SqlParameter("@IsSewingFinishDateUpdate", model.IsSewingFinishDateUpdate); var @IsSewingQuotaUpdate = new SqlParameter("@IsSewingQuotaUpdate", model.IsSewingQuotaUpdate); var @IsSewingPrepUpdate = new SqlParameter("@IsSewingPrepUpdate", model.IsSewingPrepUpdate); var @IsSewingActualStartDateUpdate = new SqlParameter("@IsSewingActualStartDateUpdate", model.IsSewingActualStartDateUpdate); var @IsSewingActualFinishDateUpdate = new SqlParameter("@IsSewingActualFinishDateUpdate", model.IsSewingActualFinishDateUpdate); var @IsSewingActualStartDateAutoUpdate = new SqlParameter("@IsSewingActualStartDateAutoUpdate", model.IsSewingActualStartDateAutoUpdate); var @IsSewingActualFinishDateAutoUpdate = new SqlParameter("@IsSewingActualFinishDateAutoUpdate", model.IsSewingActualFinishDateAutoUpdate); var @IsSewingBalanceUpdate = new SqlParameter("@IsSewingBalanceUpdate", model.IsSewingBalanceUpdate); var @IsCutAStartDateUpdate = new SqlParameter("@IsCutAStartDateUpdate", model.IsCutAStartDateUpdate); var @IsCutAFinishDateUpdate = new SqlParameter("@IsCutAFinishDateUpdate", model.IsCutAFinishDateUpdate); var @IsCutAQuotaUpdate = new SqlParameter("@IsCutAQuotaUpdate", model.IsCutAQuotaUpdate); var @IsCutAActualStartDateUpdate = new SqlParameter("@IsCutAActualStartDateUpdate", model.IsCutAActualStartDateUpdate); var @IsCutAActualFinishDateUpdate = new SqlParameter("@IsCutAActualFinishDateUpdate", model.IsCutAActualFinishDateUpdate); var @IsCutABalanceUpdate = new SqlParameter("@IsCutABalanceUpdate", model.IsCutABalanceUpdate); var @IsPrintingBalanceUpdate = new SqlParameter("@IsPrintingBalanceUpdate", model.IsPrintingBalanceUpdate); var @IsH_FBalanceUpdate = new SqlParameter("@IsH_FBalanceUpdate", model.IsH_FBalanceUpdate); var @IsEmbroideryBalanceUpdate = new SqlParameter("@IsEmbroideryBalanceUpdate", model.IsEmbroideryBalanceUpdate); var @IsCutBActualStartDateUpdate = new SqlParameter("@IsCutBActualStartDateUpdate", model.IsCutBActualStartDateUpdate); var @IsCutBBalanceUpdate = new SqlParameter("@IsCutBBalanceUpdate", model.IsCutBBalanceUpdate); var @IsAutoCutUpdate = new SqlParameter("@IsAutoCutUpdate", model.IsAutoCutUpdate); var @IsLaserCutUpdate = new SqlParameter("@IsLaserCutUpdate", model.IsLaserCutUpdate); var @IsHuasenCutUpdate = new SqlParameter("@IsHuasenCutUpdate", model.IsHuasenCutUpdate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMaster_5 @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate", @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate) > 0) { return(true); } return(false); }
public static bool Insert_2(SewingMasterModel model, AccountModel account) { DateTime dtDefault = new DateTime(2000, 01, 01); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine); var @SewingStartDate = new SqlParameter("@SewingStartDate", model.SewingStartDate); var @SewingFinishDate = new SqlParameter("@SewingFinishDate", model.SewingFinishDate); var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota); var @SewingPrep = new SqlParameter("@SewingPrep", model.SewingPrep); var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate); var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate); DateTime sewingActualStartDateAutoDt = TimeHelper.Convert(model.SewingActualStartDateAuto); DateTime sewingActualFinishDateAutoDt = TimeHelper.Convert(model.SewingActualFinishDateAuto); string sewingActualStartDateAutoString = ""; if (sewingActualStartDateAutoDt != dtDefault) { sewingActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualStartDateAutoDt); } string sewingActualFinishDateAutoString = ""; if (sewingActualFinishDateAutoDt != dtDefault) { sewingActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", sewingActualFinishDateAutoDt); } var @SewingActualStartDateAuto = new SqlParameter("@SewingActualStartDateAuto", sewingActualStartDateAutoString); var @SewingActualFinishDateAuto = new SqlParameter("@SewingActualFinishDateAuto", sewingActualFinishDateAutoString); //var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance); var sewingBalanceInsert = model.SewingBalance; if (model.SewingBalance_Date != dtDefault) { sewingBalanceInsert = model.SewingBalance_Date.ToShortDateString(); } var @SewingBalance = new SqlParameter("@SewingBalance", sewingBalanceInsert); var @CutAStartDate = new SqlParameter("@CutAStartDate", model.CutAStartDate); var @CutAFinishDate = new SqlParameter("@CutAFinishDate", model.CutAFinishDate); var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota); var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", model.CutAActualStartDate); var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", model.CutAActualFinishDate); var cutABalanceInsert = model.CutABalance; if (model.CutABalance_Date != dtDefault) { cutABalanceInsert = model.CutABalance_Date.ToShortDateString(); } var @CutABalance = new SqlParameter("@CutABalance", cutABalanceInsert); var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance); var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance); var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance); var @CutBActualStartDate = new SqlParameter("@CutBActualStartDate", model.CutBActualStartDate); var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance); var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut); var @LaserCut = new SqlParameter("@LaserCut", model.LaserCut); var @HuasenCut = new SqlParameter("@HuasenCut", model.HuasenCut); var @CutBStartDate = new SqlParameter("@CutBStartDate", model.CutBStartDate); var @AtomCutA = new SqlParameter("@AtomCutA", model.AtomCutA); var @AtomCutB = new SqlParameter("@AtomCutB", model.AtomCutB); var @LaserCutA = new SqlParameter("@LaserCutA", model.LaserCutA); var @LaserCutB = new SqlParameter("@LaserCutB", model.LaserCutB); var @HuasenCutA = new SqlParameter("@HuasenCutA", model.HuasenCutA); var @HuasenCutB = new SqlParameter("@HuasenCutB", model.HuasenCutB); var @ComelzCutA = new SqlParameter("@ComelzCutA", model.ComelzCutA); var @ComelzCutB = new SqlParameter("@ComelzCutB", model.ComelzCutB); var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate); var @IsSewingLineUpdate = new SqlParameter("@IsSewingLineUpdate", model.IsSewingLineUpdate); var @IsSewingStartDateUpdate = new SqlParameter("@IsSewingStartDateUpdate", model.IsSewingStartDateUpdate); var @IsSewingFinishDateUpdate = new SqlParameter("@IsSewingFinishDateUpdate", model.IsSewingFinishDateUpdate); var @IsSewingQuotaUpdate = new SqlParameter("@IsSewingQuotaUpdate", model.IsSewingQuotaUpdate); var @IsSewingPrepUpdate = new SqlParameter("@IsSewingPrepUpdate", model.IsSewingPrepUpdate); var @IsSewingActualStartDateUpdate = new SqlParameter("@IsSewingActualStartDateUpdate", model.IsSewingActualStartDateUpdate); var @IsSewingActualFinishDateUpdate = new SqlParameter("@IsSewingActualFinishDateUpdate", model.IsSewingActualFinishDateUpdate); var @IsSewingActualStartDateAutoUpdate = new SqlParameter("@IsSewingActualStartDateAutoUpdate", model.IsSewingActualStartDateAutoUpdate); var @IsSewingActualFinishDateAutoUpdate = new SqlParameter("@IsSewingActualFinishDateAutoUpdate", model.IsSewingActualFinishDateAutoUpdate); var @IsSewingBalanceUpdate = new SqlParameter("@IsSewingBalanceUpdate", model.IsSewingBalanceUpdate); var @IsCutAStartDateUpdate = new SqlParameter("@IsCutAStartDateUpdate", model.IsCutAStartDateUpdate); var @IsCutAFinishDateUpdate = new SqlParameter("@IsCutAFinishDateUpdate", model.IsCutAFinishDateUpdate); var @IsCutAQuotaUpdate = new SqlParameter("@IsCutAQuotaUpdate", model.IsCutAQuotaUpdate); var @IsCutAActualStartDateUpdate = new SqlParameter("@IsCutAActualStartDateUpdate", model.IsCutAActualStartDateUpdate); var @IsCutAActualFinishDateUpdate = new SqlParameter("@IsCutAActualFinishDateUpdate", model.IsCutAActualFinishDateUpdate); var @IsCutABalanceUpdate = new SqlParameter("@IsCutABalanceUpdate", model.IsCutABalanceUpdate); var @IsPrintingBalanceUpdate = new SqlParameter("@IsPrintingBalanceUpdate", model.IsPrintingBalanceUpdate); var @IsH_FBalanceUpdate = new SqlParameter("@IsH_FBalanceUpdate", model.IsH_FBalanceUpdate); var @IsEmbroideryBalanceUpdate = new SqlParameter("@IsEmbroideryBalanceUpdate", model.IsEmbroideryBalanceUpdate); var @IsCutBActualStartDateUpdate = new SqlParameter("@IsCutBActualStartDateUpdate", model.IsCutBActualStartDateUpdate); var @IsCutBBalanceUpdate = new SqlParameter("@IsCutBBalanceUpdate", model.IsCutBBalanceUpdate); var @IsAutoCutUpdate = new SqlParameter("@IsAutoCutUpdate", model.IsAutoCutUpdate); var @IsLaserCutUpdate = new SqlParameter("@IsLaserCutUpdate", model.IsLaserCutUpdate); var @IsHuasenCutUpdate = new SqlParameter("@IsHuasenCutUpdate", model.IsHuasenCutUpdate); var @IsCutBStartDateUpdate = new SqlParameter("@IsCutBStartDateUpdate", model.IsUpdateCutBStartDate); var @IsAtomCutAUpdate = new SqlParameter("@IsAtomCutAUpdate", model.IsUpdateAtomCutA); var @IsAtomCutBUpdate = new SqlParameter("@IsAtomCutBUpdate", model.IsUpdateAtomCutB); var @IsLaserCutAUpdate = new SqlParameter("@IsLaserCutAUpdate", model.IsUpdateLaserCutA); var @IsLaserCutBUpdate = new SqlParameter("@IsLaserCutBUpdate", model.IsUpdateLaserCutB); var @IsHuasenCutAUpdate = new SqlParameter("@IsHuasenCutAUpdate", model.IsUpdateHuasenCutA); var @IsHuasenCutBUpdate = new SqlParameter("@IsHuasenCutBUpdate", model.IsUpdateHuasenCutB); var @IsComelzCutAUpdate = new SqlParameter("@IsComelzCutAUpdate", model.IsUpdateComelzCutA); var @IsComelzCutBUpdate = new SqlParameter("@IsComelzCutBUpdate", model.IsUpdateComelzCutB); var @Reviser = new SqlParameter("@Reviser", account.FullName); var @SewingActualStartDate_Date = new SqlParameter("@SewingActualStartDate_Date", model.SewingActualStartDate_Date); var @SewingActualFinishDate_Date = new SqlParameter("@SewingActualFinishDate_Date", model.SewingActualFinishDate_Date); var @CutAActualStartDate_Date = new SqlParameter("@CutAActualStartDate_Date", model.CutAActualStartDate_Date); var @CutAActualFinishDate_Date = new SqlParameter("@CutAActualFinishDate_Date", model.CutAActualFinishDate_Date); using (var db = new SaovietMasterScheduleEntities()) { db.CommandTimeout = 120; if (db.ExecuteStoreCommand(@"EXEC spm_InsertSewingMaster_10 @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @CutBStartDate, @AtomCutA, @AtomCutB, @LaserCutA, @LaserCutB, @HuasenCutA, @HuasenCutB, @ComelzCutA, @ComelzCutB, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate, @IsCutBStartDateUpdate, @IsAtomCutAUpdate, @IsAtomCutBUpdate, @IsLaserCutAUpdate, @IsLaserCutBUpdate, @IsHuasenCutAUpdate, @IsHuasenCutBUpdate, @IsComelzCutAUpdate, @IsComelzCutBUpdate, @Reviser, @SewingActualStartDate_Date, @SewingActualFinishDate_Date, @CutAActualStartDate_Date, @CutAActualFinishDate_Date", @ProductNo, @Sequence, @SewingLine, @SewingStartDate, @SewingFinishDate, @SewingQuota, @SewingPrep, @SewingActualStartDate, @SewingActualFinishDate, @SewingActualStartDateAuto, @SewingActualFinishDateAuto, @SewingBalance, @CutAStartDate, @CutAFinishDate, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBActualStartDate, @CutBBalance, @AutoCut, @LaserCut, @HuasenCut, @CutBStartDate, @AtomCutA, @AtomCutB, @LaserCutA, @LaserCutB, @HuasenCutA, @HuasenCutB, @ComelzCutA, @ComelzCutB, @IsSequenceUpdate, @IsSewingLineUpdate, @IsSewingStartDateUpdate, @IsSewingFinishDateUpdate, @IsSewingQuotaUpdate, @IsSewingPrepUpdate, @IsSewingActualStartDateUpdate, @IsSewingActualFinishDateUpdate, @IsSewingActualStartDateAutoUpdate, @IsSewingActualFinishDateAutoUpdate, @IsSewingBalanceUpdate, @IsCutAStartDateUpdate, @IsCutAFinishDateUpdate, @IsCutAQuotaUpdate, @IsCutAActualStartDateUpdate, @IsCutAActualFinishDateUpdate, @IsCutABalanceUpdate, @IsPrintingBalanceUpdate, @IsH_FBalanceUpdate, @IsEmbroideryBalanceUpdate, @IsCutBActualStartDateUpdate, @IsCutBBalanceUpdate, @IsAutoCutUpdate, @IsLaserCutUpdate, @IsHuasenCutUpdate, @IsCutBStartDateUpdate, @IsAtomCutAUpdate, @IsAtomCutBUpdate, @IsLaserCutAUpdate, @IsLaserCutBUpdate, @IsHuasenCutAUpdate, @IsHuasenCutBUpdate, @IsComelzCutAUpdate, @IsComelzCutBUpdate, @Reviser, @SewingActualStartDate_Date, @SewingActualFinishDate_Date, @CutAActualStartDate_Date, @CutAActualFinishDate_Date) > 0) { return(true); } return(false); } }