public static bool Insert_2(OutsoleMasterModel model) { DateTime dtDefault = new DateTime(2000, 01, 01); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @OutsoleLine = new SqlParameter("@OutsoleLine", model.OutsoleLine); var @OutsoleStartDate = new SqlParameter("@OutsoleStartDate", model.OutsoleStartDate); var @OutsoleFinishDate = new SqlParameter("@OutsoleFinishDate", model.OutsoleFinishDate); var @OutsoleQuota = new SqlParameter("@OutsoleQuota", model.OutsoleQuota); var @OutsoleActualStartDate = new SqlParameter("@OutsoleActualStartDate", model.OutsoleActualStartDate); var @OutsoleActualFinishDate = new SqlParameter("@OutsoleActualFinishDate", model.OutsoleActualFinishDate); DateTime outsoleActualStartDateAutoDt = TimeHelper.Convert(model.OutsoleActualStartDateAuto); DateTime outsoleActualFinishDateAutoDt = TimeHelper.Convert(model.OutsoleActualFinishDateAuto); string outsoleActualStartDateAutoString = ""; if (outsoleActualStartDateAutoDt != dtDefault) { outsoleActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualStartDateAutoDt); } string outsoleActualFinishDateAutoString = ""; if (outsoleActualFinishDateAutoDt != dtDefault) { outsoleActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualFinishDateAutoDt); } var @OutsoleActualStartDateAuto = new SqlParameter("@OutsoleActualStartDateAuto", outsoleActualStartDateAutoString); var @OutsoleActualFinishDateAuto = new SqlParameter("@OutsoleActualFinishDateAuto", outsoleActualFinishDateAutoString); var @OutsoleBalance = new SqlParameter("@OutsoleBalance", model.OutsoleBalance); var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate); var @IsOutsoleLineUpdate = new SqlParameter("@IsOutsoleLineUpdate", model.IsOutsoleLineUpdate); var @IsOutsoleStartDateUpdate = new SqlParameter("@IsOutsoleStartDateUpdate", model.IsOutsoleStartDateUpdate); var @IsOutsoleFinishDateUpdate = new SqlParameter("@IsOutsoleFinishDateUpdate", model.IsOutsoleFinishDateUpdate); var @IsOutsoleQuotaUpdate = new SqlParameter("@IsOutsoleQuotaUpdate", model.IsOutsoleQuotaUpdate); var @IsOutsoleActualStartDateUpdate = new SqlParameter("@IsOutsoleActualStartDateUpdate", model.IsOutsoleActualStartDateUpdate); var @IsOutsoleActualFinishDateUpdate = new SqlParameter("@IsOutsoleActualFinishDateUpdate", model.IsOutsoleActualFinishDateUpdate); var @IsOutsoleActualStartDateAutoUpdate = new SqlParameter("@IsOutsoleActualStartDateAutoUpdate", model.IsOutsoleActualStartDateAutoUpdate); var @IsOutsoleActualFinishDateAutoUpdate = new SqlParameter("@IsOutsoleActualFinishDateAutoUpdate", model.IsOutsoleActualFinishDateAutoUpdate); var @IsOutsoleBalanceUpdate = new SqlParameter("@IsOutsoleBalanceUpdate", model.IsOutsoleBalanceUpdate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand(@"EXEC spm_InsertOutsoleMaster_3 @ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate", @ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate) > 0) { return(true); } return(false); }
public static bool InsertSequence(OutsoleMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @OutsoleStartDate = new SqlParameter("@OutsoleStartDate", model.OutsoleStartDate); var @OutsoleFinishDate = new SqlParameter("@OutsoleFinishDate", model.OutsoleFinishDate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMasterSequence @ProductNo,@Sequence,@OutsoleStartDate,@OutsoleFinishDate", @ProductNo, @Sequence, @OutsoleStartDate, @OutsoleFinishDate) > 0) { return(true); } return(false); }
public static bool InsertOutsole(OutsoleMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @OutsoleLine = new SqlParameter("@OutsoleLine", model.OutsoleLine); var @OutsoleStartDate = new SqlParameter("@OutsoleStartDate", model.OutsoleStartDate); var @OutsoleFinishDate = new SqlParameter("@OutsoleFinishDate", model.OutsoleFinishDate); var @OutsoleQuota = new SqlParameter("@OutsoleQuota", model.OutsoleQuota); var @OutsoleActualStartDate = new SqlParameter("@OutsoleActualStartDate", model.OutsoleActualStartDate); var @OutsoleActualFinishDate = new SqlParameter("@OutsoleActualFinishDate", model.OutsoleActualFinishDate); var @OutsoleBalance = new SqlParameter("@OutsoleBalance", model.OutsoleBalance); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMasterOutsole @ProductNo,@OutsoleLine,@OutsoleStartDate,@OutsoleFinishDate,@OutsoleQuota,@OutsoleActualStartDate,@OutsoleActualFinishDate,@OutsoleBalance", @ProductNo, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleBalance) > 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(); productionMemoList = ProductionMemoController.Select(); outsoleRawMaterialList = OutsoleRawMaterialController.Select(); rawMaterialViewModelNewList = RawMaterialController.Select_1(); //sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing); sewingMasterList = sewingMasterList.OrderBy(s => s.Sequence).ToList(); int[] materialIdUpperArray = { 1, 2, 3, 4, 10 }; int[] materialIdSewingArray = { 5, 7 }; int[] materialIdOutsoleArray = { 6 }; foreach (SewingMasterModel sewingMaster in sewingMasterList) { SewingMasterExportViewModel sewingMasterExportView = new SewingMasterExportViewModel(); sewingMasterExportView.Sequence = sewingMaster.Sequence; sewingMasterExportView.ProductNo = sewingMaster.ProductNo; OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault(); string memoId = ""; if (order != null) { sewingMasterExportView.Country = order.Country; sewingMasterExportView.ShoeName = order.ShoeName; sewingMasterExportView.ArticleNo = order.ArticleNo; sewingMasterExportView.PatternNo = order.PatternNo; sewingMasterExportView.Quantity = order.Quantity; sewingMasterExportView.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"; } } sewingMasterExportView.MemoId = memoId; } MaterialArrivalViewModel materialArrivalUpper = MaterialArrival(order.ProductNo, materialIdUpperArray); sewingMasterExportView.IsUpperMatsArrivalOk = false; if (materialArrivalUpper != null) { sewingMasterExportView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalUpper.Date); sewingMasterExportView.IsUpperMatsArrivalOk = materialArrivalUpper.IsMaterialArrivalOk; } MaterialArrivalViewModel materialArrivalSewing = MaterialArrival(order.ProductNo, materialIdSewingArray); sewingMasterExportView.IsSewingMatsArrivalOk = false; if (materialArrivalSewing != null) { sewingMasterExportView.SewingMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalSewing.Date); sewingMasterExportView.IsSewingMatsArrivalOk = materialArrivalSewing.IsMaterialArrivalOk; } //MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray); //sewingMasterExportView.IsOSMatsArrivalOk = false; //if (materialArrivalOutsole != null) //{ // sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date); // sewingMasterExportView.IsOSMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk; //} // For Outsole Material //var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList(); //var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList(); //sewingMasterExportView.IsOSMatsArrivalOk = false; //if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false) //{ // sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max()); // sewingMasterExportView.IsOSMatsArrivalOk = true; //} //else //{ // var etdDateList = osRawMaterial.Select(s => s.ETD).ToList(); // if (etdDateList.Count() > 0) // { // sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max()); // } //} var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo); sewingMasterExportView.IsOSMatsArrivalOk = false; if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) && !String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate)) { sewingMasterExportView.OSMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate; sewingMasterExportView.IsOSMatsArrivalOk = true; } else { sewingMasterExportView.OSMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD; } sewingMasterExportView.SewingLine = sewingMaster.SewingLine; sewingMasterExportView.CutAStartDate = sewingMaster.CutAStartDate; sewingMasterExportView.SewingStartDate = sewingMaster.SewingStartDate; sewingMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate; sewingMasterExportView.SewingQuota = sewingMaster.SewingQuota; sewingMasterExportView.SewingBalance = sewingMaster.SewingBalance; sewingMasterExportView.CutABalance = sewingMaster.CutABalance; sewingMasterExportView.CutBBalance = sewingMaster.CutBBalance; OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault(); if (outsoleMaster != null) { sewingMasterExportView.OSBalance = outsoleMaster.OutsoleBalance; } else { sewingMasterExportView.OSBalance = ""; } sewingMasterExportViewList.Add(sewingMasterExportView); } }
public static bool Insert_2(OutsoleMasterModel model, AccountModel account) { DateTime dtDefault = new DateTime(2000, 01, 01); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo != null ? model.ProductNo : ""); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @OutsoleLine = new SqlParameter("@OutsoleLine", model.OutsoleLine != null ? model.OutsoleLine : ""); var @OutsoleStartDate = new SqlParameter("@OutsoleStartDate", model.OutsoleStartDate != null ? model.OutsoleStartDate : dtDefault); var @OutsoleFinishDate = new SqlParameter("@OutsoleFinishDate", model.OutsoleFinishDate != null ? model.OutsoleFinishDate : dtDefault); var @OutsoleQuota = new SqlParameter("@OutsoleQuota", model.OutsoleQuota); var @OutsoleActualStartDate = new SqlParameter("@OutsoleActualStartDate", model.OutsoleActualStartDate != null ? model.OutsoleActualStartDate : ""); var @OutsoleActualFinishDate = new SqlParameter("@OutsoleActualFinishDate", model.OutsoleActualFinishDate != null ? model.OutsoleActualFinishDate : ""); var @Remarks = new SqlParameter("@Remarks", model.Remarks != null ? model.Remarks : ""); DateTime outsoleActualStartDateAutoDt = TimeHelper.Convert(model.OutsoleActualStartDateAuto); DateTime outsoleActualFinishDateAutoDt = TimeHelper.Convert(model.OutsoleActualFinishDateAuto); string outsoleActualStartDateAutoString = ""; if (outsoleActualStartDateAutoDt != dtDefault) { outsoleActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualStartDateAutoDt); } string outsoleActualFinishDateAutoString = ""; if (outsoleActualFinishDateAutoDt != dtDefault) { outsoleActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualFinishDateAutoDt); } var @OutsoleActualStartDateAuto = new SqlParameter("@OutsoleActualStartDateAuto", outsoleActualStartDateAutoString); var @OutsoleActualFinishDateAuto = new SqlParameter("@OutsoleActualFinishDateAuto", outsoleActualFinishDateAutoString); var outsoleBalanceInsert = model.OutsoleBalance; if (model.OutsoleBalance_Date != dtDefault) { outsoleBalanceInsert = String.Format("{0:MM/dd/yyyy}", model.OutsoleBalance_Date); } var @OutsoleBalance = new SqlParameter("@OutsoleBalance", outsoleBalanceInsert); var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate); var @IsOutsoleLineUpdate = new SqlParameter("@IsOutsoleLineUpdate", model.IsOutsoleLineUpdate); var @IsOutsoleStartDateUpdate = new SqlParameter("@IsOutsoleStartDateUpdate", model.IsOutsoleStartDateUpdate); var @IsOutsoleFinishDateUpdate = new SqlParameter("@IsOutsoleFinishDateUpdate", model.IsOutsoleFinishDateUpdate); var @IsOutsoleQuotaUpdate = new SqlParameter("@IsOutsoleQuotaUpdate", model.IsOutsoleQuotaUpdate); var @IsOutsoleActualStartDateUpdate = new SqlParameter("@IsOutsoleActualStartDateUpdate", model.IsOutsoleActualStartDateUpdate); var @IsOutsoleActualFinishDateUpdate = new SqlParameter("@IsOutsoleActualFinishDateUpdate", model.IsOutsoleActualFinishDateUpdate); var @IsOutsoleActualStartDateAutoUpdate = new SqlParameter("@IsOutsoleActualStartDateAutoUpdate", model.IsOutsoleActualStartDateAutoUpdate); var @IsOutsoleActualFinishDateAutoUpdate = new SqlParameter("@IsOutsoleActualFinishDateAutoUpdate", model.IsOutsoleActualFinishDateAutoUpdate); var @IsOutsoleBalanceUpdate = new SqlParameter("@IsOutsoleBalanceUpdate", model.IsOutsoleBalanceUpdate); var @IsRemarksUpdate = new SqlParameter("@IsRemarksUpdate", model.IsRemarksUpdate); var @OutsoleActualStartDate_Date = new SqlParameter("@OutsoleActualStartDate_Date", model.OutsoleActualStartDate_Date); var @OutsoleActualFinishDate_Date = new SqlParameter("@OutsoleActualFinishDate_Date", model.OutsoleActualFinishDate_Date); var @Reviser = new SqlParameter("@Reviser", account.FullName); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand(@"EXEC spm_InsertOutsoleMaster_8 @ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @Remarks, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate, @IsRemarksUpdate, @OutsoleActualStartDate_Date, @OutsoleActualFinishDate_Date, @Reviser", @ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @Remarks, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate, @IsRemarksUpdate, @OutsoleActualStartDate_Date, @OutsoleActualFinishDate_Date, @Reviser) > 0) { return(true); } return(false); }