public ProductionPlan(SessionInfo _session, ProductionPlanModel model = null)
{
InitializeComponent();
this._repo = new ProductionPlanRepo();
this.domain = new ProductionPlanModel();
epiSession = _session;
}
private void btnSaveNew_Click(object sender, EventArgs e)
{
if (saveData())
{
ProductionPlan = new ProductionPlanModel();
loadData();
}
}
public ProductionPlanModel Get(SessionInfo _session)
{
ProductionPlanModel model = new ProductionPlanModel();
model.WorkDateFrom = DateTime.Now;
model.WorkDateTo = DateTime.Now;
model.DueDateFrom = DateTime.Now;
model.DueDateTo = DateTime.Now;
model.Resources = _repoResrc.GetAll(_session.PlantID).ToList();
model.WorkOrders = GetWorksPlan(_session).ToList();
return model;
}
private void btnEdit_Click(object sender, EventArgs e)
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
ProductionPlanModel model = (ProductionPlanModel)ProductionPlanBO.Instance.FindByPK(id);
frmProductPlanDetail frm = new frmProductPlanDetail();
frm.ProductionPlan = model;
if (frm.ShowDialog() == DialogResult.OK)
{
LoadInfoSearch();
}
}
private void BindContent(ProductionPlanModel model)
{
ClearBinding();
txtWorkOrderNumForm.DataBindings.Add("Text", model, "WorkOrderNumForm", false, DataSourceUpdateMode.OnPropertyChanged);
txtWorkOrderNumTo.DataBindings.Add("Text", model, "WorkOrderNumTo", false, DataSourceUpdateMode.OnPropertyChanged);
dtpWorkDateFrom.DataBindings.Add("Value", model, "WorkDateFrom", true, DataSourceUpdateMode.OnPropertyChanged);
dtpWorkDateTo.DataBindings.Add("Value", model, "WorkDateTo", true, DataSourceUpdateMode.OnPropertyChanged);
dtpDueDateFrom.DataBindings.Add("Value", model, "DueDateFrom", true, DataSourceUpdateMode.OnPropertyChanged);
dtpDueDateTo.DataBindings.Add("Value", model, "DueDateTo", true, DataSourceUpdateMode.OnPropertyChanged);
cboMachineGroup.DataSource = model.Resources;
cboMachineGroup.DisplayMember = "ResourceDescription";
cboMachineGroup.ValueMember = "ResourceID";
cboMachineGroup.DataBindings.Add("SelectedValue", model, "MachineCode", true, DataSourceUpdateMode.OnPropertyChanged);
cboMachine.DataSource = model.Resources;
cboMachine.DisplayMember = "ResourceDescription";
cboMachine.ValueMember = "ResourceID";
cboMachine.DataBindings.Add("SelectedValue", model, "MachineCode", true, DataSourceUpdateMode.OnPropertyChanged);
}
private void butClear_Click(object sender, EventArgs e)
{
domain = _repo.Get(epiSession);
BindContent(domain);
}
private void ProductionPlan_Load(object sender, EventArgs e)
{
domain = _repo.Get(epiSession);
BindContent(domain);
}
private void SetPlannedGrid(ProductionPlanModel model)
{
int i = 0;
if (model.WorkOrders.Count == 0) return;
dgvPlanned.Rows.Clear();
foreach (var p in model.WorkOrdersPlanned)
{
dgvPlanned.Rows.Add(i + 1, p.WorkOrderId, p.WorkOrderNum, p.ProcessStep, p.ProcessLine, p.IssueDate, p.DueDate, p.PossessionName, p.PICName, p.Yield);
if (i % 2 == 1)
{
this.dgvPlanned.Rows[i].DefaultCellStyle.BackColor = Color.Beige;
}
i++;
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
txtRate.Text = "";
int rowCount = grvData.RowCount;
for (int i = 0; i < rowCount; i++)
{
try
{
if (i < 5)
{
continue;
}
progressBar1.Invoke((Action)(() => { progressBar1.Value = i - 2; }));
txtRate.Invoke((Action)(() => { txtRate.Text = string.Format("{0}/{1}", i - 2, rowCount - 3); }));
string _productCode = Lib.ToString(grvData.GetRowCellValue(i, "F7"));
string _ordercode = Lib.ToString(grvData.GetRowCellValue(i, "F5"));
int _cnt = Lib.ToInt(grvData.GetRowCellValue(i, "F6"));
//Kiểm tra nếu mã nhóm hoặc mã sản phẩm trống thì next
if (string.IsNullOrEmpty(_ordercode) || string.IsNullOrEmpty(_productCode))
{
continue;
}
Expression exp2 = new Expression("OrderCode", _ordercode);
Expression exp1 = new Expression("Cnt", _cnt);
ArrayList arr = ProductionPlanBO.Instance.FindByExpression(exp1.And(exp2));
ProductionPlanModel product = new ProductionPlanModel();
#region SetValue
string a = "";
product.OrderCode = _ordercode; // Mô tả AssyOrder F5
product.ProductCode = _productCode; // Mô tả ID F7
product.AssemblyProduct = Lib.ToString(grvData.GetRowCellValue(i, "F1")); //Assembly order & CNT
product.Stt = Lib.ToInt(grvData.GetRowCellValue(i, "F3")); //Mô tả số thứ tự
product.JgDate = Lib.ToDate3(grvData.GetRowCellValue(i, "F4")); //date
if (Lib.ToDate3(grvData.GetRowCellValue(i, "F4")) == new DateTime(1950, 1, 1))
{
product.JgDate = Lib.ToDate2(grvData.GetRowCellValue(i, "DATEF4").ToString());
}
product.Cnt = _cnt; //Mô tả CNT
product.Description = Lib.ToString(grvData.GetRowCellValue(i, "F8")); //Description
product.Qty = Lib.ToInt(grvData.GetRowCellValue(i, "F9"));
product.SalesOrder = Lib.ToString(grvData.GetRowCellValue(i, "F10")); // Order
product.ShipTo = Lib.ToString(grvData.GetRowCellValue(i, "F11")); // đích
product.SVia = Lib.ToString(grvData.GetRowCellValue(i, "F12"));
product.Code = Lib.ToString(grvData.GetRowCellValue(i, "F13"));
product.OrderNew = Lib.ToString(grvData.GetRowCellValue(i, "F14"));
product.ProductCodeNew = Lib.ToString(grvData.GetRowCellValue(i, "F16"));
product.Note = Lib.ToString(grvData.GetRowCellValue(i, "F17"));
product.RequestDate = Lib.ToDate3(grvData.GetRowCellValue(i, "F18")); // ngày khách hàng yêu cầu
if (Lib.ToDate3(grvData.GetRowCellValue(i, "F18")) == new DateTime(1950, 1, 1))
{
product.RequestDate = Lib.ToDate2(grvData.GetRowCellValue(i, "DATEF18"));
}
product.MaMoto = Lib.ToString(grvData.GetRowCellValue(i, "F21"));
product.MaMoto1 = Lib.ToString(grvData.GetRowCellValue(i, "F22"));
product.OrderCodeFull = product.OrderCode + product.Cnt;
product.AssemblyDate = new DateTime(9999, 01, 01);
#endregion
if (arr.Count > 0)
{
product.UpdatedAt = DateTime.Now;
for (int j = 0; j < arr.Count; j++)
{
product.ID = (arr[j] as ProductionPlanModel).ID;
ProductionPlanBO.Instance.Update(product);
}
}
else
{
product.UpdatedAt = DateTime.Now;
product.CreatedAt = DateTime.Now;
product.ID = (int)ProductionPlanBO.Instance.Insert(product);
//lstProductionPlanBO.Add(product);
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi lưu dữ liệu tại dòng " + i + Environment.NewLine + ex.ToString());
}
}
}
protected ProductionPlanFacade(ProductionPlanModel model) : base(model)
{
}