private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
insockSupplierList = InsockSuppliersController.Select();
insockMaterialList = InsockMaterialController.Select(productNo);
sizeRunList = SizeRunController.Select(productNo);
insockRawMaterialList = InsockRawMaterialController.SelectPerPO(productNo);
}
private void bwInsert_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (InsockRawMaterialController.IsFull(sizeRunList, insockRawMaterialList, insockMaterialToInsertList) == true)
{
if (insockRawMaterialToInsertList.Count() > 0)
{
rawMaterial.ActualDate = insockRawMaterialToInsertList.Select(o => o.ActualDate).Max();
}
else
{
rawMaterial.ActualDate = insockRawMaterialList.Select(o => o.ActualDate).Max();
}
int balance = sizeRunList.Sum(s => s.Quantity) - sizeRunList.Select(s => insockMaterialToInsertList.Where(o => o.SizeNo == s.SizeNo).Min(o => (o.Quantity - o.QuantityReject))).Sum();
if (balance > 0)
{
rawMaterial.ActualDate = dtDefault;
rawMaterial.Remarks = balance.ToString();
}
}
else
{
rawMaterial.ActualDate = dtDefault;
rawMaterial.Remarks = (sizeRunList.Sum(s => s.Quantity) - sizeRunList.Select(s => insockMaterialToInsertList.Where(o => o.SizeNo == s.SizeNo).Min(o => (o.Quantity - o.QuantityReject))).Sum()).ToString();
}
if (threadUpdateRawMaterial.IsBusy == false)
{
threadUpdateRawMaterial.RunWorkerAsync();
}
}
private void bwInsert_DoWork(object sender, DoWorkEventArgs e)
{
foreach (InsockRawMaterialModel model in insockRawMaterialToInsertList)
{
InsockRawMaterialController.UpdateActualDate(model);
}
foreach (InsockMaterialModel model in insockMaterialToInsertList)
{
InsockMaterialModel insockMaterialDB = InsockMaterialController.Select(model.ProductNo).Where(w => w.SizeNo == model.SizeNo && w.InsockSupplierId == model.InsockSupplierId).FirstOrDefault();
// Insert
if (insockMaterialDB == null)
{
InsockMaterialController.Insert(model);
}
// Update
else
{
// Update quantity
if (insockMaterialDB.Quantity != model.Quantity)
{
InsockMaterialController.Update(model, false, true);
}
// Update Reject
if (insockMaterialDB.QuantityReject != model.QuantityReject)
{
InsockMaterialController.Update(model, true, false);
}
}
}
}
private void bwImport_DoWork(object sender, DoWorkEventArgs e)
{
insockRawMaterialImportList = dgInsockRawMaterial.Items.OfType <InsockRawMaterialModel>().ToList();
progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = insockRawMaterialImportList.Count));
int index = 0;
foreach (var insockImport in insockRawMaterialImportList)
{
index++;
InsockRawMaterialController.Insert(insockImport);
dgInsockRawMaterial.Dispatcher.Invoke((Action)(() =>
{
dgInsockRawMaterial.SelectedItem = insockImport;
dgInsockRawMaterial.ScrollIntoView(insockImport);
}));
progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = index));
}
}
private void bwInsert_DoWork(object sender, DoWorkEventArgs e)
{
rawMaterial.ETD = dtDefault;
rawMaterial.IsETDUpdate = true;
foreach (var insockRawMaterial in insockRawMaterialViewToDeleteList)
{
int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId;
InsockRawMaterialController.Delete(productNo, insockSupplierId);
}
if (insockRawMaterialViewToInsertList.Count > 0)
{
rawMaterial.ETD = insockRawMaterialViewToInsertList.Max(m => m.ETDReal);
}
foreach (var insockRawMaterial in insockRawMaterialViewToInsertList)
{
int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId;
DateTime etd = TimeHelper.Convert(insockRawMaterial.ETD);
if (etd != dtDefault && etd != dtNothing)
{
var insertModel = new InsockRawMaterialModel()
{
ProductNo = productNo,
InsockSupplierId = insockSupplierId,
ETD = etd
};
InsockRawMaterialController.Insert(insertModel);
if (insertModel.ETD > rawMaterial.ETD)
{
rawMaterial.ETD = insertModel.ETD;
}
}
}
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
insockMaterialList = InsockMaterialController.Select();
orderList = OrdersController.SelectByOutsoleMaterial();
insockSupplierList = InsockSuppliersController.Select();
insockRawMaterialList = InsockRawMaterialController.Select();
List <String> lastCodeList = orderList.Select(o => o.LastCode).Distinct().ToList();
foreach (string lastCode in lastCodeList)
{
var productNoList = orderList.Where(w => w.LastCode == lastCode).Select(s => s.ProductNo).Distinct().ToList();
var insockMaterialList_D1 = insockMaterialList.Where(w => productNoList.Contains(w.ProductNo)).ToList();
var supplierPerLastCode = insockMaterialList_D1.Select(s => s.InsockSupplierId).Distinct().ToList();
suppIdShowInGridviewList.AddRange(supplierPerLastCode);
}
suppIdShowInGridviewList = suppIdShowInGridviewList.Distinct().OrderBy(s => s).ToList();
DataTable dt = new DataTable();
Dispatcher.Invoke(new Action(() => {
dt.Columns.Add("LastCode", typeof(String));
DataGridTextColumn columnLastCode = new DataGridTextColumn();
columnLastCode.Header = "Last Code";
columnLastCode.Binding = new Binding("LastCode");
columnLastCode.FontWeight = FontWeights.Bold;
dgInsockDelivery.Columns.Add(columnLastCode);
Binding bindingWidth1 = new Binding();
bindingWidth1.Source = columnLastCode;
bindingWidth1.Path = new PropertyPath("ActualWidth");
ColumnDefinition cd1 = new ColumnDefinition();
cd1.SetBinding(ColumnDefinition.WidthProperty, bindingWidth1);
gridTotal.ColumnDefinitions.Add(cd1);
dt.Columns.Add("Quantity", typeof(Int32));
DataGridTextColumn columnQuantity = new DataGridTextColumn();
columnQuantity.Header = "Quantity";
columnQuantity.Binding = new Binding("Quantity");
dgInsockDelivery.Columns.Add(columnQuantity);
Binding bindingWidth2 = new Binding();
bindingWidth2.Source = columnQuantity;
bindingWidth2.Path = new PropertyPath("ActualWidth");
ColumnDefinition cd2 = new ColumnDefinition();
cd2.SetBinding(ColumnDefinition.WidthProperty, bindingWidth2);
gridTotal.ColumnDefinitions.Add(cd2);
dt.Columns.Add("Reject", typeof(Int32));
DataGridTextColumn column4 = new DataGridTextColumn();
column4.Header = "Reject";
column4.Binding = new Binding("Reject");
dgInsockDelivery.Columns.Add(column4);
Binding bindingWidth4 = new Binding();
bindingWidth4.Source = column4;
bindingWidth4.Path = new PropertyPath("ActualWidth");
ColumnDefinition cd4 = new ColumnDefinition();
cd4.SetBinding(ColumnDefinition.WidthProperty, bindingWidth4);
gridTotal.ColumnDefinitions.Add(cd4);
dgInsockDelivery.FrozenColumnCount = 3;
for (int i = 0; i < suppIdShowInGridviewList.Count; i++)
{
var insockSupplier = insockSupplierList.FirstOrDefault(f => f.InsockSupplierId == suppIdShowInGridviewList[i]);
if (insockSupplier != null)
{
dt.Columns.Add(String.Format("Column{0}", suppIdShowInGridviewList[i]), typeof(String));
DataGridTextColumn column = new DataGridTextColumn();
column.Header = insockSupplier.InsockSupplierName;
column.Binding = new Binding(String.Format("Column{0}", suppIdShowInGridviewList[i]));
column.FontWeight = FontWeights.Bold;
Style style = new Style(typeof(DataGridCell));
style.Setters.Add(new Setter(TextBlock.TextAlignmentProperty, TextAlignment.Center));
Setter setterBackground = new Setter();
setterBackground.Property = DataGridCell.BackgroundProperty;
setterBackground.Value = new Binding(String.Format("Column{0}Background", suppIdShowInGridviewList[i]));
style.Setters.Add(setterBackground);
Setter setterToolTip = new Setter();
setterToolTip.Property = DataGridCell.ToolTipProperty;
setterToolTip.Value = new Binding(String.Format("Column{0}ToolTip", suppIdShowInGridviewList[i]));
style.Setters.Add(setterToolTip);
column.CellStyle = style;
dgInsockDelivery.Columns.Add(column);
Binding bindingWidth = new Binding();
bindingWidth.Source = column;
bindingWidth.Path = new PropertyPath("ActualWidth");
ColumnDefinition cd = new ColumnDefinition();
cd.SetBinding(ColumnDefinition.WidthProperty, bindingWidth);
gridTotal.ColumnDefinitions.Add(cd);
DataColumn columnBackground = new DataColumn(String.Format("Column{0}Background", suppIdShowInGridviewList[i]), typeof(SolidColorBrush));
DataColumn columnToolTip = new DataColumn(String.Format("Column{0}ToolTip", suppIdShowInGridviewList[i]), typeof(String));
columnBackground.DefaultValue = Brushes.White;
dt.Columns.Add(columnBackground);
dt.Columns.Add(columnToolTip);
}
}
}));
foreach (var lastCode in lastCodeList)
{
DataRow dr = dt.NewRow();
dr["LastCode"] = lastCode;
var productNoList = orderList.Where(w => w.LastCode == lastCode).Select(s => s.ProductNo).Distinct().ToList();
var insockMaterialList_D1 = insockMaterialList.Where(w => productNoList.Contains(w.ProductNo)).ToList();
var insockSupplierIdList = insockMaterialList_D1.Select(s => s.InsockSupplierId).Distinct().ToList();
var qtyTotalList = new List <Int32>();
var qtyRejectList = new List <Int32>();
foreach (var insockSupplierId in insockSupplierIdList)
{
var outsoleMaterialList_D2 = insockMaterialList_D1.Where(o => o.InsockSupplierId == insockSupplierId).ToList();
int qtyTotal = 0;
int qtyRejectTotal = 0;
foreach (string productNo in productNoList)
{
var insockMaterialList_D3 = outsoleMaterialList_D2.Where(w => w.ProductNo == productNo).ToList();
var sizeNoList = insockMaterialList.Where(w => w.ProductNo == productNo).Select(s => s.SizeNo).Distinct().ToList();
foreach (var sizeNo in sizeNoList)
{
int qtyMax = insockMaterialList_D3.Where(w => w.SizeNo == sizeNo).Sum(s => s.Quantity - s.QuantityReject);
int qtyReject = insockMaterialList_D3.Where(w => w.SizeNo == sizeNo).Sum(s => s.QuantityReject);
qtyTotal += qtyMax;
qtyRejectTotal += qtyReject;
}
}
dr[String.Format("Column{0}", insockSupplierId)] = "x";
dr[String.Format("Column{0}Background", insockSupplierId)] = Brushes.Green;
var suppName = insockSupplierList.FirstOrDefault(f => f.InsockSupplierId == insockSupplierId).InsockSupplierName;
if (suppName != null)
{
dr[String.Format("Column{0}ToolTip", insockSupplierId)] = string.Format("{0}{1}", suppName, qtyRejectTotal > 0 ? String.Format("\nQtyReject: {0}", qtyRejectTotal.ToString()) : "");
}
qtyTotalList.Add(qtyTotal);
qtyRejectList.Add(qtyRejectTotal);
}
if (qtyRejectList.Count > 0)
{
dr["Reject"] = qtyRejectList.Max();
}
if (qtyTotalList.Count > 0)
{
dr["Quantity"] = qtyTotalList.Max();
}
dt.Rows.Add(dr);
}
Dispatcher.Invoke(new Action(() =>
{
dgInsockDelivery.ItemsSource = dt.AsDataView();
// Row Tail
TextBlock lblTotal = new TextBlock();
lblTotal.Text = "TOTAL";
lblTotal.Margin = new Thickness(1, 0, 0, 0);
lblTotal.FontWeight = FontWeights.Bold;
Border bdrTotal = new Border();
Grid.SetColumn(bdrTotal, 2);
Grid.SetColumnSpan(bdrTotal, 1);
bdrTotal.BorderThickness = new Thickness(1, 0, 1, 1);
bdrTotal.BorderBrush = Brushes.Black;
bdrTotal.Child = lblTotal;
gridTotal.Children.Add(bdrTotal);
TextBlock lblQuantityTotal = new TextBlock();
lblQuantityTotal.Text = dt.Compute("Sum(Quantity)", "").ToString();
lblQuantityTotal.Margin = new Thickness(1, 0, 0, 0);
lblQuantityTotal.FontWeight = FontWeights.Bold;
Border bdrQuantityTotal = new Border();
Grid.SetColumn(bdrQuantityTotal, 3);
bdrQuantityTotal.BorderThickness = new Thickness(0, 0, 1, 1);
bdrQuantityTotal.BorderBrush = Brushes.Black;
bdrQuantityTotal.Child = lblQuantityTotal;
gridTotal.Children.Add(bdrQuantityTotal);
dgInsockDelivery.ItemsSource = dt.AsDataView();
TextBlock lblRejectMaximunTotal = new TextBlock();
lblRejectMaximunTotal.Text = dt.Compute("Sum(Reject)", "").ToString();
lblRejectMaximunTotal.Margin = new Thickness(1, 0, 0, 0);
lblRejectMaximunTotal.FontWeight = FontWeights.Bold;
Border bdrRejectMaximumTotal = new Border();
Grid.SetColumn(bdrRejectMaximumTotal, 4);
bdrRejectMaximumTotal.BorderThickness = new Thickness(0, 0, 1, 1);
bdrRejectMaximumTotal.BorderBrush = Brushes.Black;
bdrRejectMaximumTotal.Child = lblRejectMaximunTotal;
gridTotal.Children.Add(bdrRejectMaximumTotal);
dgInsockDelivery.ItemsSource = dt.AsDataView();
}));
}
