public static bool InsertSequence(AssemblyMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @AssemblyStartDate = new SqlParameter("@AssemblyStartDate", model.AssemblyStartDate); var @AssemblyFinishDate = new SqlParameter("@AssemblyFinishDate", model.AssemblyFinishDate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertAssemblyMasterSequence @ProductNo,@Sequence,@AssemblyStartDate,@AssemblyFinishDate", @ProductNo, @Sequence, @AssemblyStartDate, @AssemblyFinishDate) > 0) { return(true); } return(false); }
public static bool Insert_2(AssemblyMasterModel model) { DateTime dtDefault = new DateTime(2000, 01, 01); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @Sequence = new SqlParameter("@Sequence", model.Sequence); var @AssemblyLine = new SqlParameter("@AssemblyLine", model.AssemblyLine); var @AssemblyStartDate = new SqlParameter("@AssemblyStartDate", model.AssemblyStartDate); var @AssemblyFinishDate = new SqlParameter("@AssemblyFinishDate", model.AssemblyFinishDate); var @AssemblyQuota = new SqlParameter("@AssemblyQuota", model.AssemblyQuota); DateTime assemblyActualStartDateDt = TimeHelper.Convert(model.AssemblyActualStartDate); DateTime assemblyActualFinishDateDt = TimeHelper.Convert(model.AssemblyActualFinishDate); string assemblyActualStartDateString = ""; if (assemblyActualStartDateDt != dtDefault) { assemblyActualStartDateString = String.Format("{0:MM/dd/yyyy}", assemblyActualStartDateDt); } string assemblyActualFinishDateString = ""; if (assemblyActualFinishDateDt != dtDefault) { assemblyActualFinishDateString = String.Format("{0:MM/dd/yyyy}", assemblyActualFinishDateDt); } var @AssemblyActualStartDate = new SqlParameter("@AssemblyActualStartDate", assemblyActualStartDateString); var @AssemblyActualFinishDate = new SqlParameter("@AssemblyActualFinishDate", assemblyActualFinishDateString); var @AssemblyBalance = new SqlParameter("@AssemblyBalance", model.AssemblyBalance); var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate); var @IsAssemblyLineUpdate = new SqlParameter("@IsAssemblyLineUpdate", model.IsAssemblyLineUpdate); var @IsAssemblyStartDateUpdate = new SqlParameter("@IsAssemblyStartDateUpdate", model.IsAssemblyStartDateUpdate); var @IsAssemblyFinishDateUpdate = new SqlParameter("@IsAssemblyFinishDateUpdate", model.IsAssemblyFinishDateUpdate); var @IsAssemblyQuotaUpdate = new SqlParameter("@IsAssemblyQuotaUpdate", model.IsAssemblyQuotaUpdate); var @IsAssemblyActualStartDateUpdate = new SqlParameter("@IsAssemblyActualStartDateUpdate", model.IsAssemblyActualStartDateUpdate); var @IsAssemblyActualFinishDateUpdate = new SqlParameter("@IsAssemblyActualFinishDateUpdate", model.IsAssemblyActualFinishDateUpdate); var @IsAssemblyBalanceUpdate = new SqlParameter("@IsAssemblyBalanceUpdate", model.IsAssemblyBalanceUpdate); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertAssemblyMaster_3 @ProductNo, @Sequence, @AssemblyLine, @AssemblyStartDate, @AssemblyFinishDate, @AssemblyQuota, @AssemblyActualStartDate, @AssemblyActualFinishDate, @AssemblyBalance, @IsSequenceUpdate, @IsAssemblyLineUpdate, @IsAssemblyStartDateUpdate, @IsAssemblyFinishDateUpdate, @IsAssemblyQuotaUpdate, @IsAssemblyActualStartDateUpdate, @IsAssemblyActualFinishDateUpdate, @IsAssemblyBalanceUpdate", @ProductNo, @Sequence, @AssemblyLine, @AssemblyStartDate, @AssemblyFinishDate, @AssemblyQuota, @AssemblyActualStartDate, @AssemblyActualFinishDate, @AssemblyBalance, @IsSequenceUpdate, @IsAssemblyLineUpdate, @IsAssemblyStartDateUpdate, @IsAssemblyFinishDateUpdate, @IsAssemblyQuotaUpdate, @IsAssemblyActualStartDateUpdate, @IsAssemblyActualFinishDateUpdate, @IsAssemblyBalanceUpdate) > 0) { return(true); } return(false); }
public static bool InsertAssembly(AssemblyMasterModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @AssemblyLine = new SqlParameter("@AssemblyLine", model.AssemblyLine); var @AssemblyStartDate = new SqlParameter("@AssemblyStartDate", model.AssemblyStartDate); var @AssemblyFinishDate = new SqlParameter("@AssemblyFinishDate", model.AssemblyFinishDate); var @AssemblyQuota = new SqlParameter("@AssemblyQuota", model.AssemblyQuota); var @AssemblyActualStartDate = new SqlParameter("@AssemblyActualStartDate", model.AssemblyActualStartDate); var @AssemblyActualFinishDate = new SqlParameter("@AssemblyActualFinishDate", model.AssemblyActualFinishDate); var @AssemblyBalance = new SqlParameter("@AssemblyBalance", model.AssemblyBalance); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertAssemblyMasterAssembly @ProductNo,@AssemblyLine,@AssemblyStartDate,@AssemblyFinishDate,@AssemblyQuota,@AssemblyActualStartDate,@AssemblyActualFinishDate,@AssemblyBalance", @ProductNo, @AssemblyLine, @AssemblyStartDate, @AssemblyFinishDate, @AssemblyQuota, @AssemblyActualStartDate, @AssemblyActualFinishDate, @AssemblyBalance) > 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); } }