public bool AddNewStockPreaparing(OriginalPOsequence _sequence, Schedule _schedule)
{
try
{
StockMeasure stockMeasure = GetStockMeasure(_schedule);
if (stockMeasure == null)
{
return(false);
}
using (StockContext = new StockContext(database))
{
StockContext.StockPreparing.Add(new StockPreparing
{
SequenceNo = _sequence.SequenceNo,
SequenceQty = _sequence.Quantity,
StockMeasure_Id = stockMeasure.id,
UpdateTime = DateTime.Now
});
StockContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public SeqInfo(OriginalPOsequence _seq, int _cuttingQty, bool _finish)
{
id = _seq.id;
SeqNo = ShareFuncs.GetInt(_seq.SequenceNo);
SeqQty = ShareFuncs.GetInt(_seq.Quantity);
Finish = _finish;
CuttingQty = _cuttingQty;
}
public bool AddNewOriginalSequence(OriginalPOsequence _originalSequence)
{
try
{
using (SequenceContext = new SequenceContext(database))
{
SequenceContext.OriginalPOsequences.Add(_originalSequence);
SequenceContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool UpdateOriginalSequence(OriginalPOsequence _originalSequence)
{
try
{
using (SequenceContext = new SequenceContext(database))
{
var poSequence = SequenceContext.OriginalPOsequences.Find(_originalSequence.id);
SequenceContext.Entry(poSequence).State = EntityState.Modified;
SequenceContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public OriginalPOsequence Handle_getOrderSequence(int _row, int _totalSeq)
{
try
{
var seq = new OriginalPOsequence
{
TotalSequence = _totalSeq,
Quantity = OleDb_readCellNumber(_row, ExcelColumnDef.QuantityCol),
SequenceNo = Handle_getSequenceNumber(_row, ExcelColumnDef.SequenceCol),
SizeType = Handle_getSizeType(_row)
};
seq.OriginalSizes = Handle_getOriginalSize(_row, seq.SizeType != null ? (int)seq.SizeType : 0);
return(seq);
}
catch { return(null); }
}
public bool AddNewStockPreaparing(OriginalPOsequence _sequence, int _stockMeasureId)
{
try
{
using (StockContext = new StockContext(database))
{
StockContext.StockPreparing.Add(new StockPreparing
{
SequenceNo = _sequence.SequenceNo,
SequenceQty = _sequence.Quantity,
StockMeasure_Id = _stockMeasureId,
UpdateTime = DateTime.Now,
});
StockContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public BeamCutSeq AddNewBeamSeq(OriginalPOsequence originalPOsequence, int componentId, int BeamCutPoId)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutSeqs.Add(new BeamCutSeq
{
OriginalPo_Id = originalPOsequence.OriginalPO_Id,
Component_Id = componentId,
BeamCutPo_Id = BeamCutPoId,
SequenceNo = originalPOsequence.SequenceNo,
SequenceQty = originalPOsequence.Quantity,
Finish = false,
CutQty = 0,
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
private void UpdateSelectedSchedule()
{
SelectedOriginalPo = new OriginalPO();
SelectedSchedule = new Schedule();
SelectedSequence = new OriginalPOsequence();
SelectedScheduleLine = string.Empty;
txtProductionLine.Text = string.Empty;
if (lbSchedule.SelectedItem == null)
{
return;
}
SelectedSchedule = ScheduleQuery.GetSchedule((lbSchedule.SelectedItem as Schedule).id);
SelectedProductionLine = BuildingQuery.GetProductionLine(ShareFuncs.GetInt(SelectedSchedule.ProductionLine_Id));
txtProductionLine.Text = SelectedScheduleLine = SelectedProductionLine.LineName;
UpdateModelComponent();
UpdateOgiginalSequence();
}
private void UpdateSelectedOriginalSequence()
{
lb_checkout_seq.Text = SelectedSequence.EKanbanStatus = string.Empty;
if (cb_Sequence.SelectedItem == null)
{
return;
}
SelectedSequence = new OriginalPOsequence();
SelectedSequence = SequenceQuery.GetOriginalSequence((cb_Sequence.SelectedItem as OriginalPOsequence).id);
if (SelectedSequence != null)
{
var EKanbanLoading = EKanbanTaskQuery.GetEKanbanLoadingBySequence(SelectedSequence.id);
if (EKanbanLoading != null)
{
SelectedSequence.EKanbanStatus = ((SysActionCode)EKanbanLoading.SysActionCode).ToString();
lb_checkout_seq.Text = SelectedSequence.EKanbanStatus;
}
}
}
//public OriginalPO GetOriginalPo(BeamCutComponent _beamcutComponent)
//{
// return GetOriginalPo(ShareFuncs.GetInt(_beamcutComponent.OriginalPo_Id));
//}
public OriginalPO GetOriginalPo(OriginalPOsequence _originalPOsequence)
{
return(GetOriginalPo(ShareFuncs.GetInt(_originalPOsequence.OriginalPO_Id)));
}
public SizeCtrl(object sequence, bool header)
{
InitializeComponent();
this.Margin = new Padding(0);
CurrentSeq = new OriginalPOsequence();
try
{
CurrentSeq = sequence as OriginalPOsequence;
CurrentSeq = SequenceQuery.GetOriginalSequence(CurrentSeq.id);
}
catch { }
if (!header)
{
tableLayoutPanel1.RowStyles[0].Height = 0;
this.Height = 20;
if (CurrentSeq.SequenceNo % 2 != 0)
{
this.tableLayoutPanel1.BackColor = Color.FromArgb(179, 195, 203);
}
else
{
this.tableLayoutPanel1.BackColor = Color.FromArgb(230, 254, 253);
}
}
else
{
tableLayoutPanel1.RowStyles[1].Height = 0;
this.Height = 30;
this.tableLayoutPanel1.BackColor = Color.FromArgb(155, 252, 246);
this.tableLayoutPanel1.ForeColor = Color.FromArgb(6, 10, 255);
return;
}
tableLayoutPanel1.Controls.Add(new Label
{
Text = $"{CurrentSeq.SequenceNo}/{CurrentSeq.TotalSequence}",
AutoSize = false,
Dock = DockStyle.Fill,
TextAlign = ContentAlignment.MiddleCenter,
Font = new Font("Arial Narrow", 10, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)))
}
, 0, 1);
tableLayoutPanel1.Controls.Add(new Label
{
Text = CurrentSeq.Quantity.ToString(),
AutoSize = false,
Dock = DockStyle.Fill,
TextAlign = ContentAlignment.MiddleCenter,
Font = new Font("Arial Narrow", 10, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)))
}, 1, 1);
foreach (var item in CurrentSeq.OriginalSizes)
{
for (int i = 3; i <= 32; i++)
{
if (item.SizeId != null && item.SizeId == i)
{
tableLayoutPanel1.Controls.Add(
new Label
{
Text = item.Quantity.ToString(),
AutoSize = false,
Dock = DockStyle.Fill,
TextAlign = ContentAlignment.MiddleCenter,
Font = new Font("Arial Narrow", 10, FontStyle.Bold, GraphicsUnit.Point, ((byte)(0)))
}
, i - 1, 1);
}
}
}
}
