public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" Update m_line_sap_item");
sqlQuery.Append(" Set cycle_time = :stdcycletime, ");
sqlQuery.Append(" registration_user_cd = :registrationusercd, ");
sqlQuery.Append(" registration_date_time = :registrationdatetime ");
sqlQuery.Append(" Where factory_cd = :factcode");
sqlQuery.Append(" and line_sap_item_id = :lineitemcycletimeid ");
//sqlQuery.Append(" and line_id = :lineid ");
//sqlQuery.Append(" and sap_item_cd = :sapitemcd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterDecimal("stdcycletime", inVo.StdCycleTime);
sqlParameter.AddParameterInteger("lineitemcycletimeid", inVo.LineItemCycleTimeId);
sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factcode", trxContext.UserData.FactoryCode);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
LineItemCycleTimeVo deleteInVo = (LineItemCycleTimeVo)inList.FirstOrDefault();
ValueObjectList <LineItemCycleTimeVo> addInVo = (ValueObjectList <LineItemCycleTimeVo>)inList.Skip(1).FirstOrDefault();;
//ValueObjectList<LineItemCycleTimeVo> inVo = new ValueObjectList<LineItemCycleTimeVo>();
UpdateResultVo outVo = new UpdateResultVo();
UpdateResultVo resultVo = (UpdateResultVo)deleteLineItemCycleTimeMasterMntCbm.Execute(trxContext, deleteInVo);
if (addInVo != null && addInVo.GetList() != null && addInVo.GetList().Count > 0)
{
foreach (LineItemCycleTimeVo currentVo in addInVo.GetList())
{
resultVo = (UpdateResultVo)addLineItemCycleTimeMasterMntCbm.Execute(trxContext, currentVo);
outVo.AffectedCount = resultVo.AffectedCount;
}
return(outVo);
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_line_sap_item");
sqlQuery.Append(" Where ");
//sqlQuery.Append(" line_sap_item_id = :lineSapItemId ");
sqlQuery.Append(" line_id = :lineid");
//sqlQuery.Append(" and sap_matnr_item_cd = :sapMatnrItemCd ");
sqlQuery.Append(" and factory_cd = :faccd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameterInteger("lineSapItemId", inVo.LineItemCycleTimeId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private LineItemCycleTimeVo FormConditionVo()
{
LineItemCycleTimeVo inVo = new LineItemCycleTimeVo();
inVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
if (SapItem_cmb.SelectedIndex > -1)
{
inVo.SapItemCode = SapItem_cmb.SelectedValue.ToString();
}
else
{
inVo.SapItemCode = null;
}
return(inVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(LineItemCycleTimeVo conditionInVo)
{
StartProgress(Properties.Resources.mmci00009);
LineItem_dgv.DataSource = null;
ValueObjectList <LineItemCycleTimeVo> outVo = null;
try
{
outVo = (ValueObjectList <LineItemCycleTimeVo>)base.InvokeCbm(getLineItemCycleTimeMasterCbm, conditionInVo, false);
}
catch (Framework.ApplicationException exception)
{
CompleteProgress();
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
CompleteProgress();
LineItem_dgv.AutoGenerateColumns = false;
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
SapItem_cmb.DataSource = null;
SapItem_cmb.SelectedIndex = -1;
SapItem_cmb.Text = string.Empty;
return;
}
LineItem_dgv.DataSource = outVo.GetList();
if (SapItem_cmb.SelectedIndex > -1)
{
// do nothing
}
else
{
SapItem_cmb.DataSource = null;
SapItem_cmb.DisplayMember = "SapItemCode";
SapItem_cmb.ValueMember = "SapItemCode";
SapItem_cmb.DataSource = outVo.GetList();
SapItem_cmb.SelectedIndex = -1;
}
LineItem_dgv.ClearSelection();
}
/// <summary>
/// Item code search click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ItemSearch_btn_Click(object sender, EventArgs e)
{
ItemCodeSearchForm frm = new ItemCodeSearchForm();
frm.ShowDialog();
if (frm.sapItemSearchVo != null && frm.sapItemSearchVo.GetList() != null && frm.sapItemSearchVo.GetList().Count > 0)
{
ValueObjectList <SapItemSearchVo> sapItemSearchVo = frm.sapItemSearchVo;
sapItemSearchVo.GetList().ForEach(v => v.SapItemName = v.SapItemCode + " - " + v.SapItemName);
ValueObjectList <LineItemCycleTimeVo> sapItemVo = new ValueObjectList <LineItemCycleTimeVo>();
foreach (SapItemSearchVo itmVo in sapItemSearchVo.GetList())
{
LineItemCycleTimeVo sapItmVo = new LineItemCycleTimeVo();
sapItmVo.SapItemCode = itmVo.SapItemCode;
sapItemVo.add(sapItmVo);
}
ValueObjectList <LineItemCycleTimeVo> grdCycleVo = new ValueObjectList <LineItemCycleTimeVo>();
ValueObjectList <LineItemCycleTimeVo> itmCycleVo = new ValueObjectList <LineItemCycleTimeVo>();
if ((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource != null)
{
itmCycleVo.SetNewList((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource);
}
if (itmCycleVo != null && itmCycleVo.GetList() != null && itmCycleVo.GetList().Count > 0)
{
List <string> sapitemlist = itmCycleVo.GetList().Select(v => v.SapItemCode).ToList();
List <LineItemCycleTimeVo> selectedItem = sapItemVo.GetList().Where(x => !sapitemlist.Contains(x.SapItemCode)).ToList();
itmCycleVo.GetList().AddRange(selectedItem);
}
else
{
itmCycleVo.GetList().AddRange(sapItemVo.GetList());
}
grdCycleVo.SetNewList(itmCycleVo.GetList().Where(x => !String.IsNullOrWhiteSpace(x.SapItemCode))
.Select(x => new LineItemCycleTimeVo {
SapItemCode = x.SapItemCode, StdCycleTimeNull = x.StdCycleTimeNull
})
.GroupBy(x => x.SapItemCode).Select(x => x.FirstOrDefault()).Distinct().ToList());
LineItem_dgv.AutoGenerateColumns = false;
LineItem_dgv.DataSource = null;
LineItem_dgv.DataSource = grdCycleVo.GetList();
LineItem_dgv.ClearSelection();
ValueObjectList <LineItemCycleTimeVo> cmbCycleVo = new ValueObjectList <LineItemCycleTimeVo>();
if ((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource != null)
{
cmbCycleVo.SetNewList((List <LineItemCycleTimeVo>)LineItem_dgv.DataSource);
if ((List <LineItemCycleTimeVo>)SapItem_cmb.DataSource != null)
{
cmbCycleVo.GetList().AddRange((List <LineItemCycleTimeVo>)SapItem_cmb.DataSource);
}
}
SapItem_cmb.DataSource = null;
SapItem_cmb.DisplayMember = "SapItemCode";
SapItem_cmb.ValueMember = "SapItemCode";
SapItem_cmb.DataSource = cmbCycleVo.GetList().Where(x => !String.IsNullOrWhiteSpace(x.SapItemCode))
.Select(x => new LineItemCycleTimeVo {
SapItemCode = x.SapItemCode, StdCycleTimeNull = x.StdCycleTimeNull
})
.GroupBy(x => x.SapItemCode).Select(x => x.FirstOrDefault()).Distinct().ToList();
SapItem_cmb.SelectedIndex = -1;
}
}
/// <summary>
/// updates Line Machine
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
if (LineItem_dgv.RowCount == 0) // || LineItem_dgv.SelectedRows.Count == 0
{
return;
}
if (Line_cmb.Text == string.Empty || Line_cmb.SelectedIndex < 0)
{
messageData = new MessageData("mmce00002", Properties.Resources.mmce00002, LineId_lbl.Text);
popUpMessage.Warning(messageData, Text);
Line_cmb.Focus();
return;
}
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
LineItemCycleTimeVo deleteInVo = new LineItemCycleTimeVo();
deleteInVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
ValueObjectList <LineItemCycleTimeVo> addInVo = new ValueObjectList <LineItemCycleTimeVo>();
foreach (DataGridViewRow row in LineItem_dgv.Rows)
{
if (row.Cells["clmstdcycletime"].Value != null && !row.Cells["clmstdcycletime"].Value.ToString().Equals(string.Empty))
{
decimal cycleTime = Convert.ToDecimal(row.Cells["clmstdcycletime"].Value);
if (cycleTime > 0)
{
LineItemCycleTimeVo selectedItem = (LineItemCycleTimeVo)row.DataBoundItem;
LineItemCycleTimeVo addVo = new LineItemCycleTimeVo();
addVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
addVo.StdCycleTime = cycleTime;
addVo.SapItemCode = row.Cells["colSapItemCode"].Value.ToString();
addInVo.add(addVo);
}
}
}
inVoList.add(deleteInVo);
inVoList.add(addInVo);
//if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
//{
// messageData = new MessageData("mmci00047", Properties.Resources.mmci00047, LineId_lbl.Text);
// popUpMessage.Information(messageData, Text);
// LineItem_dgv.Focus();
// return;
//}
UpdateResultVo outVo = null;
try
{
Cursor.Current = Cursors.WaitCursor;
outVo = (UpdateResultVo)base.InvokeCbm(new AddUpdateLineItemCycleTimeMasterMntCbm(), inVoList, false);
Cursor.Current = Cursors.Default;
}
catch (Framework.ApplicationException exception)
{
Cursor.Current = Cursors.Default;
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null)
{
return;
}
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select ");
sqlQuery.Append(" sap_matnr_item_cd, ");
sqlQuery.Append(" cycle_time, ");
sqlQuery.Append(" line_sap_item_id, ");
sqlQuery.Append(" line_id ");
sqlQuery.Append(" from m_line_sap_item ");
sqlQuery.Append(" where ");
sqlQuery.Append(" factory_cd = :factorycode ");
sqlQuery.Append(" and line_id = :lineid ");
if (inVo.SapItemCode != null)
{
sqlQuery.Append(" and sap_matnr_item_cd = :sapMatnrItemCd ");
}
sqlQuery.Append(" ORDER BY sap_matnr_item_cd, cycle_time");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineItemCycleTimeVo> lineItemCycleTimeVo = null;
while (dataReader.Read())
{
LineItemCycleTimeVo currVo = new LineItemCycleTimeVo();
currVo.LineId = ConvertDBNull <int>(dataReader, "line_id");
currVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd");
if (dataReader["cycle_time"] != null)
{
currVo.StdCycleTimeNull = ConvertDBNull <decimal>(dataReader, "cycle_time");
}
currVo.LineItemCycleTimeId = ConvertDBNull <int>(dataReader, "line_sap_item_id");
if (lineItemCycleTimeVo == null)
{
lineItemCycleTimeVo = new ValueObjectList <LineItemCycleTimeVo>();
}
lineItemCycleTimeVo.add(currVo);
}
dataReader.Close();
return(lineItemCycleTimeVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select "); //lin.line_id,
//sqlQuery.Append(" lin.line_name, ");
sqlQuery.Append(" si.sap_matnr_item_cd, ");
sqlQuery.Append(" si.sap_maktx_item_name, ");
sqlQuery.Append(" subQry.cycle_time, ");
sqlQuery.Append(" subQry.line_sap_item_id, ");
sqlQuery.Append(" subQry.line_id ");
sqlQuery.Append(" from sap_item si ");
sqlQuery.Append("left join(select sap_matnr_item_cd, cycle_time, line_sap_item_id,line_id");
sqlQuery.Append(" from m_line_sap_item li where li.line_id = :lineid) as subQry");
//sqlQuery.Append(" right join m_line lin on lin.line_id = ct.line_id ");
//sqlQuery.Append(" right join sap_item si on si.sap_matnr_item_cd = ct.sap_matnr_item_cd ");
sqlQuery.Append(" on si.sap_matnr_item_cd = subQry.sap_matnr_item_cd ");
sqlQuery.Append(" where ");
sqlQuery.Append(" si.factory_cd = :factorycode ");
//if (inVo.LineId > -1)
//{
// sqlQuery.Append(" and ct.Line_id = :lineid ");
//}
if (inVo.SapItemCode != null)
{
sqlQuery.Append(" and si.sap_matnr_item_cd = :sapMatnrItemCd ");
}
sqlQuery.Append(" ORDER BY si.sap_matnr_item_cd,subQry.cycle_time");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameterInteger("lineId", inVo.LineId);
//if (inVo.SapItemCode != null)
//{
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterString("sapMatnrItemCd", inVo.SapItemCode);
//}
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//sqlQuery.Append(" order by gi.global_item_id ");
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineItemCycleTimeVo> lineItemCycleTimeVo = null;
while (dataReader.Read())
{
LineItemCycleTimeVo currVo = new LineItemCycleTimeVo
{
LineId = ConvertDBNull <int>(dataReader, "Line_id"),
//LineName = ConvertDBNull<string>(dataReader, "line_name"),
SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd"),
SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name"),
StdCycleTime = ConvertDBNull <decimal>(dataReader, "cycle_time"),
LineItemCycleTimeId = ConvertDBNull <int>(dataReader, "line_sap_item_id")
};
if (lineItemCycleTimeVo == null)
{
lineItemCycleTimeVo = new ValueObjectList <LineItemCycleTimeVo>();
}
lineItemCycleTimeVo.add(currVo);
}
dataReader.Close();
return(lineItemCycleTimeVo);
}
