/// <summary>
///
/// </summary>
/// <param name="poId"></param>
/// <param name="modelNo"></param>
/// <param name="remains"></param>
public void UpdateRemainsForPo(string poId, string modelNo, int remains)
{
PackingPO po = GetPoByModelAndPoNo(modelNo, poId);
if (po != null)
{
object[] param =
{
new SqlParameter()
{
ParameterName = "@ModelID", Value = modelNo, SqlDbType = SqlDbType.VarChar
},
new SqlParameter()
{
ParameterName = "@PO_NO", Value = poId, SqlDbType = SqlDbType.VarChar
},
new SqlParameter()
{
ParameterName = "@QuantityRemain", Value = remains, SqlDbType = SqlDbType.Int
},
new SqlParameter("@Out_Parameter", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
try
{
_context.Database.ExecuteSqlCommand("EXEC [sp_UpdateRemainsForPo] @ModelID, @PO_NO, @QuantityRemain", param);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
private void btnXuatLe_Click(object sender, EventArgs e)
{
var xuatLe = new RetailProducts();
xuatLe.ShowDialog();
ResetControls();
VisibleControlAddPcb(false);
_currentModel = new Model();
_currentPo = new PackingPO();
}
private void btnVersionOld_Click(object sender, EventArgs e)
{
var old = new FormMain();
old.ShowDialog();
ResetControls();
VisibleControlAddPcb(false);
_currentModel = new Model();
_currentPo = new PackingPO();
}
/// <summary>
/// Trả về QtyPO và Remains theo workingOder và PoNo
/// </summary>
/// <param name="modelNo">Model</param>
/// <param name="poNo">PO</param>
private bool GetQtyPoAndRemainsByWorkingOderAndPoNo(string modelNo, string poNo)
{
_currentPo = _iqcService.GetPoByModelAndPoNo(modelNo, poNo);
if (_currentPo != null)
{
lblQtyPO.Text = _currentPo.QuantityPO.ToString(CultureInfo.InvariantCulture);
lblRemains.Text = _currentPo.QuantityRemain.ToString(CultureInfo.InvariantCulture);
return(true);
}
return(false);
}
/// <summary>
/// Insert PO
/// </summary>
/// <param name="modelId"></param>
/// <param name="po"></param>
/// <param name="qtyPo"></param>
/// <param name="createdBy"></param>
public void InsertPo(string modelId, string po, int qtyPo, string createdBy)
{
var poAdd = new PackingPO()
{
ModelID = modelId,
PO_NO = po,
QuantityPO = qtyPo,
QuantityRemain = qtyPo,
DateCreated = DateTime.Now,
TimeCreated = DateTime.Now.TimeOfDay,
CreateBy = createdBy,
};
try
{
Repository.Insert(poAdd);
}
catch (Exception ex)
{
throw ex;
}
}
