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);
}
}
