private void bwDelete_DoWork(object sender, DoWorkEventArgs e)
{
foreach (OffDayModel offDay in offDayToDeleteList)
{
OffDayController.Delete(offDay.Date.Date);
}
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
offDayList = OffDayController.Select();
foreach (OffDayModel offDay in offDayList)
{
offDayViewList.Add(offDay);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrderController.Select();
supplierList = SupplierController.Select();
componentList = ComponentController.Select();
sizeRunList = SizeRunController.Select();
offDayList = OffDayController.Select();
offDayMapList = OffDayMapController.Select();
}
private void bwRemove_DoWork(object sender, DoWorkEventArgs e)
{
foreach (var removeItem in offDayToRemoveList)
{
// Remove offday
OffDayController.Delete(removeItem.OffDayID);
offDayCurrentList.Remove(removeItem);
// Remove offdaymap by OffDayID
RemoveOffDayMap(removeItem.OffDayID);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
if (modeViewStatistics == "1")
{
this.Title = "Master Schedule - Lead Time Per Section Statistics";
cboSection.SelectedIndex = 0;
}
if (modeViewStatistics == "2" && cutAB == "Cut A")
{
cboSection.Visibility = Visibility.Collapsed;
this.Title = "Master Schedule - Cut A Lead Time Statistics";
cuta = cutAB;
}
if (modeViewStatistics == "2" && cutAB == "Cut B")
{
cboSection.Visibility = Visibility.Collapsed;
this.Title = "Master Schedule - Cut B Lead Time Statistics";
cutb = cutAB;
}
dpDateFrom.SelectedDate = DateTime.Now;
dpDateTo.SelectedDate = DateTime.Now;
offDayList = OffDayController.Select();
}
private void bwSave_DoWork(object sender, DoWorkEventArgs e)
{
if (insertOrUpdate == true)
{
OffDayController.Insert(offDay);
offDayCurrentList.Add(offDay);
foreach (var supp in supplierCurrentList)
{
var offDayMapInsert = new OffDay_Supplier_Mapping()
{
SupplierID = supp.SupplierID,
OffDayID = offDay.OffDayID
};
OffDayMapController.Insert(offDayMapInsert);
}
}
if (insertOrUpdate == false)
{
// Update OffDay
OffDayController.Update(offDayCurrent);
// Delete OffDayMap
RemoveOffDayMap(offDayCurrent.OffDayID);
// Insert OffDayMap
foreach (var supp in supplierCurrentList)
{
var offDayMapInsert = new OffDay_Supplier_Mapping()
{
SupplierID = supp.SupplierID,
OffDayID = offDayCurrent.OffDayID
};
OffDayMapController.Insert(offDayMapInsert);
}
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
try
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
productionMemoList = ProductionMemoController.Select();
offDayList = OffDayController.Select();
privateDefine = PrivateDefineController.GetDefine();
}
catch (Exception ex)
{
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(ex.Message, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
}));
return;
}
_SEW_VS_OTHERS_CUT_A = privateDefine.SewingVsOthersCutTypeA;
_SEW_VS_OTHERS_CUT_B = privateDefine.SewingVsOthersCutTypeB;
//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)
{
CutprepMasterExportViewModel cutprepMasterExportView = new CutprepMasterExportViewModel();
cutprepMasterExportView.Sequence = sewingMaster.Sequence;
cutprepMasterExportView.ProductNo = sewingMaster.ProductNo;
OrdersModel order = orderList.FirstOrDefault(f => f.ProductNo == sewingMaster.ProductNo);
string memoId = "";
if (order != null)
{
cutprepMasterExportView.Country = order.Country;
cutprepMasterExportView.ShoeName = order.ShoeName;
cutprepMasterExportView.ArticleNo = order.ArticleNo;
cutprepMasterExportView.PatternNo = order.PatternNo;
cutprepMasterExportView.Quantity = order.Quantity;
cutprepMasterExportView.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";
}
}
cutprepMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalUpper = MaterialArrival(order.ProductNo, materialIdUpperArray);
cutprepMasterExportView.IsUpperMatsArrivalOk = false;
if (materialArrivalUpper != null)
{
cutprepMasterExportView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalUpper.Date);
cutprepMasterExportView.IsUpperMatsArrivalOk = materialArrivalUpper.IsMaterialArrivalOk;
}
cutprepMasterExportView.SewingLine = sewingMaster.SewingLine;
cutprepMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
cutprepMasterExportView.SewingQuota = sewingMaster.SewingQuota;
cutprepMasterExportView.SewingBalance = sewingMaster.SewingBalance;
cutprepMasterExportView.CutAStartDate = sewingMaster.CutAStartDate;
cutprepMasterExportView.CutAFinishDate = sewingMaster.CutAFinishDate;
cutprepMasterExportView.CutAQuota = sewingMaster.CutAQuota;
cutprepMasterExportView.AutoCut = sewingMaster.AutoCut;
cutprepMasterExportView.LaserCut = sewingMaster.LaserCut;
cutprepMasterExportView.HuasenCut = sewingMaster.HuasenCut;
cutprepMasterExportView.CutABalance = sewingMaster.CutABalance;
cutprepMasterExportView.PrintingBalance = sewingMaster.PrintingBalance;
cutprepMasterExportView.H_FBalance = sewingMaster.H_FBalance;
cutprepMasterExportView.EmbroideryBalance = sewingMaster.EmbroideryBalance;
cutprepMasterExportView.CutBBalance = sewingMaster.CutBBalance;
// Cut type A before sewing 18days
var cutTypeABeforeSewing = sewingMaster.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_A);
var dtCheckOffDateCutTypeAList = CheckOffDay(cutTypeABeforeSewing, sewingMaster.SewingStartDate);
// Cut type B before sewing 10days
var cutTypeBBeforeSewing = sewingMaster.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_B);
var dtCheckOffDateCutTypeBList = CheckOffDay(cutTypeBBeforeSewing, sewingMaster.SewingStartDate);
var firstDateCheckOffCutTypeA = String.Format("{0:M/d}", dtCheckOffDateCutTypeAList.FirstOrDefault());
var firstDateCheckOffCutTypeB = String.Format("{0:M/d}", dtCheckOffDateCutTypeBList.FirstOrDefault());
if (!String.IsNullOrEmpty(sewingMaster.CutBStartDate))
{
cutprepMasterExportView.CutBStartDate = sewingMaster.CutBStartDate;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.CutBStartDate = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.CutBStartDate = "";
}
if (!String.IsNullOrEmpty(sewingMaster.AtomCutA))
{
cutprepMasterExportView.AtomCutA = sewingMaster.AtomCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.AtomCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.AtomCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.AtomCutB))
{
cutprepMasterExportView.AtomCutB = sewingMaster.AtomCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.AtomCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.AtomCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.LaserCutA))
{
cutprepMasterExportView.LaserCutA = sewingMaster.LaserCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.LaserCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.LaserCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.LaserCutB))
{
cutprepMasterExportView.LaserCutB = sewingMaster.LaserCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.LaserCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.LaserCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.HuasenCutA))
{
cutprepMasterExportView.HuasenCutA = sewingMaster.HuasenCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.HuasenCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.HuasenCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.HuasenCutB))
{
cutprepMasterExportView.HuasenCutB = sewingMaster.HuasenCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.HuasenCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.HuasenCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.ComelzCutA))
{
cutprepMasterExportView.ComelzCutA = sewingMaster.ComelzCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.ComelzCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.ComelzCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.ComelzCutB))
{
cutprepMasterExportView.ComelzCutB = sewingMaster.ComelzCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.ComelzCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.ComelzCutB = "";
}
cutprepMasterExportViewList.Add(cutprepMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
offDayList = OffDayController.Select();
}
private void threadLoad_DoWork(object sender, DoWorkEventArgs e)
{
//Get offdate
offDateList = OffDayController.SelectDate();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdAssemblyArray = { 8 };
int[] materialIdOutsoleArray = { 6 };
object[] args = e.Argument as object[];
DateTime dateFrom = (args[0] as DateTime?).Value;
DateTime dateTo = (args[1] as DateTime?).Value;
string sectionId = args[2] as string;
if (orderList.Count <= 0)
{
orderList = OrdersController.Select();
}
if (sectionId == sewing && sewingMasterList.Count <= 0)
{
sewingMasterList = SewingMasterController.Select();
}
if (sectionId == assembly && assemblyMasterList.Count <= 0)
{
assemblyMasterList = AssemblyMasterController.Select();
}
if (sectionId == outsole && outsoleMasterList.Count <= 0)
{
outsoleMasterList = OutsoleMasterController.Select();
}
if (rawMaterialList.Count <= 0)
{
rawMaterialList = RawMaterialController.Select();
}
string[] lineArray = null;
string[] tempArray = null;
if (sectionId == sewing)
{
//lineArray = sewingMasterList.Select(s => s.SewingLine).Distinct().OrderBy(s => s).ToArray();
tempArray = sewingMasterList.Select(s => s.SewingLine).Distinct().ToArray();
SortArray(tempArray);
lineArray = tempArray;
}
if (sectionId == assembly)
{
//lineArray = assemblyMasterList.Select(s => s.AssemblyLine).Distinct().OrderBy(s => s).ToArray();
tempArray = assemblyMasterList.Select(s => s.AssemblyLine).Distinct().ToArray();
SortArray(tempArray);
lineArray = tempArray;
}
if (sectionId == outsole)
{
lineArray = outsoleMasterList.Select(s => s.OutsoleLine).Distinct().OrderBy(s => s).ToArray();
}
foreach (string line in lineArray)
{
DataRow dr = dt.NewRow();
dr["Line"] = line;
if (sectionId == sewing)
{
List <SewingMasterModel> sewingMasterTempList = sewingMasterList.Where(s => s.SewingLine == line && ((dateFrom <= s.SewingStartDate && s.SewingStartDate <= dateTo) || (dateFrom <= s.SewingFinishDate && s.SewingFinishDate <= dateTo))).ToList();
foreach (SewingMasterModel sewingMaster in sewingMasterTempList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
CompareDate(order, dateFrom, dateTo, sewingMaster.SewingStartDate, sewingMaster.SewingFinishDate, ref dr, materialIdUpperArray);
}
}
if (sectionId == assembly)
{
List <AssemblyMasterModel> sewingMasterTempList = assemblyMasterList.Where(s => s.AssemblyLine == line && ((dateFrom <= s.AssemblyStartDate && s.AssemblyStartDate <= dateTo) || (dateFrom <= s.AssemblyFinishDate && s.AssemblyFinishDate <= dateTo))).ToList();
foreach (AssemblyMasterModel sewingMaster in sewingMasterTempList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
CompareDate(order, dateFrom, dateTo, sewingMaster.AssemblyStartDate, sewingMaster.AssemblyFinishDate, ref dr, materialIdAssemblyArray);
}
}
if (sectionId == outsole)
{
List <OutsoleMasterModel> sewingMasterTempList = outsoleMasterList.Where(s => s.OutsoleLine == line && ((dateFrom <= s.OutsoleStartDate && s.OutsoleStartDate <= dateTo) || (dateFrom <= s.OutsoleFinishDate && s.OutsoleFinishDate <= dateTo))).ToList();
foreach (OutsoleMasterModel sewingMaster in sewingMasterTempList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
CompareDate(order, dateFrom, dateTo, sewingMaster.OutsoleStartDate, sewingMaster.OutsoleFinishDate, ref dr, materialIdOutsoleArray);
}
}
dt.Rows.Add(dr);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
sizeRunList = SizeRunController.Select(productNo);
sockliningInputList = SockliningInputController.SelectByPO(productNo);
offDayList = OffDayController.Select();
}
private void BwLoad_DoWork(object sender, DoWorkEventArgs e)
{
try
{
offDayList = OffDayController.Select();
productionMemoList = ProductionMemoController.Select();
sewingMasterViewModelNewList = ReportController.GetSewingSummaryReport();
rawMaterialViewModelNewList = RawMaterialController.Select_1();
}
catch (Exception ex)
{
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(ex.Message, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
}));
return;
}
_SEW_VS_OTHERS_CUT_A = privateDefine.SewingVsOthersCutTypeA;
_SEW_VS_OTHERS_CUT_B = privateDefine.SewingVsOthersCutTypeB;
//int index = 1;
DataTable dt = new SewingSummaryDataset().Tables["SewingSummaryDatatable"];
foreach (var sewNew in sewingMasterViewModelNewList)
{
var memoByPOList = productionMemoList.Where(p => p.ProductionNumbers.Contains(sewNew.ProductNo) == true).Select(s => s.MemoId).ToList();
var sewingMasterView = new SewingMasterViewModel();
// Order Information
sewingMasterView.ProductNoBackground = Brushes.Transparent;
sewingMasterView.ProductNo = sewNew.ProductNo;
sewingMasterView.Country = sewNew.Country;
sewingMasterView.ShoeName = sewNew.ShoeName;
sewingMasterView.ArticleNo = sewNew.ArticleNo;
sewingMasterView.PatternNo = sewNew.PatternNo;
sewingMasterView.Quantity = sewNew.Quantity;
sewingMasterView.ETD = sewNew.ETD;
// Sewing Master Information
sewingMasterView.Sequence = sewNew.Sequence;
sewingMasterView.SewingLine = sewNew.SewingLine;
sewingMasterView.SewingQuota = sewNew.SewingQuota;
sewingMasterView.SewingStartDate = sewNew.SewingStartDate;
sewingMasterView.SewingFinishDate = sewNew.SewingFinishDate;
sewingMasterView.SewingPrep = sewNew.SewingPrep;
sewingMasterView.SewingActualStartDate = sewNew.SewingActualStartDate;
sewingMasterView.SewingActualFinishDate = sewNew.SewingActualFinishDate;
sewingMasterView.SewingActualStartDateAuto = sewNew.SewingActualStartDateAuto;
sewingMasterView.SewingActualFinishDateAuto = sewNew.SewingActualFinishDateAuto;
sewingMasterView.SewingBalance = sewNew.SewingBalance;
sewingMasterView.CutAStartDate = sewNew.CutAStartDate;
sewingMasterView.CutAFinishDate = sewNew.CutAFinishDate;
sewingMasterView.CutAQuota = sewNew.CutAQuota;
sewingMasterView.CutAActualStartDate = sewNew.CutAActualStartDate;
sewingMasterView.CutAActualFinishDate = sewNew.CutAActualFinishDate;
sewingMasterView.PrintingBalance = sewNew.PrintingBalance;
sewingMasterView.H_FBalance = sewNew.H_FBalance;
sewingMasterView.EmbroideryBalance = sewNew.EmbroideryBalance;
sewingMasterView.CutBBalance = sewNew.CutBBalance;
sewingMasterView.AutoCut = sewNew.AutoCut;
sewingMasterView.LaserCut = sewNew.LaserCut;
sewingMasterView.HuasenCut = sewNew.HuasenCut;
sewingMasterView.AssemblyBalance = sewNew.AssemblyBalance;
// Outsole Master Infor
sewingMasterView.OSFinishDate = sewNew.OSFinishDate;
sewingMasterView.OSBalance = sewNew.OSBalance;
sewingMasterView.SewingStartDateForeground = Brushes.Black;
sewingMasterView.SewingFinishDateForeground = Brushes.Black;
sewingMasterView.CutAStartDateForeground = Brushes.Black;
//var bfSew10 = sewNew.SewingStartDate.AddDays(-10);
var bfSew10 = sewNew.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_B);
var bfSew10IncludeHolidayList = CheckOffDay(bfSew10, sewNew.SewingStartDate);
//var bfSew15 = sewNew.SewingStartDate.AddDays(-15);
var bfSew15 = sewNew.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_A);
var bfSew15IncludeHolidayList = CheckOffDay(bfSew15, sewNew.SewingStartDate);
var bf10 = bfSew10IncludeHolidayList.FirstOrDefault();
var bf15 = bfSew15IncludeHolidayList.FirstOrDefault();
if (string.IsNullOrEmpty(sewNew.CutBStartDate) == false)
{
sewingMasterView.CutBStartDate = sewNew.CutBStartDate;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.CutBStartDate = TimeHelper.ConvertDateToView(new DateTime(bf10.Year, bf10.Month, bf10.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.CutBStartDate = "";
}
}
if (string.IsNullOrEmpty(sewNew.AtomCutA) == false)
{
sewingMasterView.AtomCutA = sewNew.AtomCutA;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.AtomCutA = TimeHelper.ConvertDateToView(new DateTime(bf15.Year, bf15.Month, bf15.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.AtomCutA = "";
}
}
if (string.IsNullOrEmpty(sewNew.AtomCutB) == false)
{
sewingMasterView.AtomCutB = sewNew.AtomCutB;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.AtomCutB = TimeHelper.ConvertDateToView(new DateTime(bf10.Year, bf10.Month, bf10.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.AtomCutB = "";
}
}
if (string.IsNullOrEmpty(sewNew.LaserCutA) == false)
{
sewingMasterView.LaserCutA = sewNew.LaserCutA;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.LaserCutA = TimeHelper.ConvertDateToView(new DateTime(bf15.Year, bf15.Month, bf15.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.LaserCutA = "";
}
}
if (string.IsNullOrEmpty(sewNew.LaserCutB) == false)
{
sewingMasterView.LaserCutB = sewNew.LaserCutB;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.LaserCutB = TimeHelper.ConvertDateToView(new DateTime(bf10.Year, bf10.Month, bf10.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.LaserCutB = "";
}
}
if (string.IsNullOrEmpty(sewNew.HuasenCutA) == false)
{
sewingMasterView.HuasenCutA = sewNew.HuasenCutA;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.HuasenCutA = TimeHelper.ConvertDateToView(new DateTime(bf15.Year, bf15.Month, bf15.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.HuasenCutA = "";
}
}
if (string.IsNullOrEmpty(sewNew.HuasenCutB) == false)
{
sewingMasterView.HuasenCutB = sewNew.HuasenCutB;
}
else
{
if (sewNew.SewingStartDate != dtDefault)
{
sewingMasterView.HuasenCutB = TimeHelper.ConvertDateToView(new DateTime(bf10.Year, bf10.Month, bf10.Day).ToString("MM/dd/yyyy"));
}
else
{
sewingMasterView.HuasenCutB = "";
}
}
// UpperMaterial 1, 2, 3, 4, 10
if (sewNew.UpperMaterialFinisedDate != dtDefault)
{
sewingMasterView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.UpperMaterialFinisedDate);
}
else if (sewNew.UpperMaterialETD != dtDefault)
{
sewingMasterView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.UpperMaterialETD);
}
//Sewing Material 5, 7
if (sewNew.SewingMaterialFinisedDate != dtDefault)
{
sewingMasterView.SewingMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.SewingMaterialFinisedDate);
}
else if (sewNew.SewingMaterialETD != dtDefault)
{
sewingMasterView.SewingMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.SewingMaterialETD);
}
// Assembly Material 8, 9
if (sewNew.AssemblyMaterialFinisedDate != dtDefault)
{
sewingMasterView.AssemblyMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.AssemblyMaterialFinisedDate);
}
else if (sewNew.AssemblyMaterialETD != dtDefault)
{
sewingMasterView.AssemblyMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.AssemblyMaterialETD);
}
//// Outsole Material 6
//if (sewNew.OutsoleMaterialFinisedDate != dtDefault)
// sewingMasterView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.OutsoleMaterialFinisedDate);
//else if (sewNew.OutsoleMaterialETD != dtDefault)
// sewingMasterView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", sewNew.OutsoleMaterialETD);
// Base on rawmaterial
sewingMasterView.OSMatsArrival = "";
var osMaterial = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == sewNew.ProductNo);
if (String.IsNullOrEmpty(osMaterial.OUTSOLE_Remarks) &&
!String.IsNullOrEmpty(osMaterial.OUTSOLE_ActualDate))
{
sewingMasterView.OSMatsArrival = osMaterial.OUTSOLE_ActualDate;
}
else if (osMaterial.OUTSOLE_ETD_DATE != dtDefault)
{
sewingMasterView.OSMatsArrival = osMaterial.OUTSOLE_ETD;
}
sewingMasterView.OutsoleStartDate = sewNew.OutsoleStartDate;
sewingMasterView.OutsoleFinishDate = sewNew.OutsoleFinishDate;
sewingMasterView.AssemblyStartDate = sewNew.AssemblyStartDate;
sewingMasterView.AssemblyFinishDate = sewNew.AssemblyFinishDate;
sewingMasterView.OutsoleCode = sewNew.OutsoleCode;
sewingMasterViewList.Add(sewingMasterView);
DataRow dr = dt.NewRow();
dr["MemoId"] = memoByPOList.Count() > 0 ? String.Join("\n", memoByPOList) : "";
dr["ProductNo"] = sewNew.ProductNo;
dr["Country"] = sewNew.Country;
dr["ShoeName"] = sewNew.ShoeName;
dr["ArticleNo"] = sewNew.ArticleNo;
dr["PatternNo"] = sewNew.PatternNo;
dr["Quantity"] = sewNew.Quantity;
dr["ETD"] = sewNew.ETD;
dr["CSD"] = sewNew.ETD.AddDays(10);
dr["UpperMatsArrival"] = sewingMasterView.UpperMatsArrival;
dr["SewingMatsArrival"] = sewingMasterView.SewingMatsArrival;
dr["OutsoleMatsArrival"] = sewingMasterView.OSMatsArrival;
dr["AssemblyMatsArrival"] = sewingMasterView.AssemblyMatsArrival;
dr["SewingLine"] = sewNew.SewingLine;
dr["SewingStartDate"] = sewNew.SewingStartDate;
dr["SewingFinishDate"] = sewNew.SewingFinishDate;
dr["SewingActualStartDate"] = sewNew.SewingActualStartDate;
dr["SewingActualFinishDate"] = sewNew.SewingActualFinishDate;
dr["SewingActualStartDateAuto"] = sewNew.SewingActualStartDateAuto;
dr["SewingActualFinishDateAuto"] = sewNew.SewingActualFinishDateAuto;
dr["SewingBalance"] = sewNew.SewingBalance;
dr["CutAStartDate"] = sewNew.CutAStartDate;
dr["CutAFinishDate"] = sewNew.CutAFinishDate;
dr["CutAQuota"] = sewNew.CutAQuota;
dr["CutAActualStartDate"] = sewNew.CutAActualStartDate;
dr["CutAActualFinishDate"] = sewNew.CutAActualFinishDate;
dr["CutABalance"] = sewNew.CutABalance;
dr["PrintingBalance"] = sewNew.PrintingBalance;
dr["H_FBalance"] = sewNew.H_FBalance;
dr["EmbroideryBalance"] = sewNew.EmbroideryBalance;
dr["AutoCut"] = sewNew.AutoCut;
dr["LaserCut"] = sewNew.LaserCut;
dr["HuasenCut"] = sewNew.HuasenCut;
dr["CutBStartDate"] = sewNew.CutBStartDate;
dr["AtomCutA"] = sewingMasterView.AtomCutA;
dr["AtomCutB"] = sewingMasterView.AtomCutB;
dr["LaserCutA"] = sewingMasterView.LaserCutA;
dr["LaserCutB"] = sewingMasterView.LaserCutB;
dr["HuasenCutA"] = sewingMasterView.HuasenCutA;
dr["HuasenCutB"] = sewingMasterView.HuasenCutB;
dr["OutsoleStartDate"] = sewNew.OutsoleStartDate;
dr["OutsoleFinishDate"] = sewNew.OutsoleFinishDate;
dr["AssemblyStartDate"] = sewNew.AssemblyStartDate;
dr["AssemblyFinishDate"] = sewNew.AssemblyFinishDate;
dr["SewingPrep"] = sewNew.SewingPrep;
dr["StockfitFinishDate"] = sewNew.OutsoleFinishDate;
dr["StockfitBalance"] = sewNew.OSBalance;
dr["CutprepBalance"] = sewNew.H_FBalance;
dr["SewingQuota"] = sewNew.SewingQuota;
dr["OutsoleCode"] = sewNew.OutsoleCode;
dr["AssemblyBalance"] = sewNew.AssemblyBalance;
dt.Rows.Add(dr);
}
sewingMasterViewList = sewingMasterViewList.OrderBy(s => s.SewingLine).ThenBy(s => s.Sequence).ToList();
e.Result = dt;
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
outsoleOutputList = OutsoleOutputController.Select(productNo);
sizeRunList = SizeRunController.Select(productNo);
offDayList = OffDayController.SelectDate();
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
supplierDefaultList = SupplierController.Select();
offDayCurrentList = OffDayController.Select();
}
private void bwInsert_DoWork(object sender, DoWorkEventArgs e)
{
OffDayController.Insert(offDayToInsert);
}
