public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <MoldItemVo> inVo = (ValueObjectList <MoldItemVo>)vo;
if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
{
return(null);
}
MoldItemVo delInVo = inVo.GetList()[0];
deleteMoldItemCbm.Execute(trxContext, inVo.GetList()[0]);
UpdateResultVo resultVo = null;
foreach (MoldItemVo molditem in inVo.GetList())
{
MoldItemVo MoldItemOutVo = (MoldItemVo)addMoldItemCbm.Execute(trxContext, molditem);
if (resultVo == null)
{
resultVo = new UpdateResultVo();
}
resultVo.AffectedCount += MoldItemOutVo.AffectedCount;
}
return(resultVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" Delete From m_mold_item");
sqlQuery.Append(" Where mold_id = :moldid ");
if (inVo.GlobalItemId > 0)
{
sqlQuery.Append(" and global_item_id = :globalitemid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
if (inVo.GlobalItemId > 0)
{
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
}
MoldItemVo outVo = new MoldItemVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void AddGlobalAndLocalItem(TransactionContext trxContext, ValueObjectList <MoldItemVo> moldItemInVo)
{
if (moldItemInVo != null && moldItemInVo.GetList().Count > 0)
{
foreach (MoldItemVo moldItemVo in moldItemInVo.GetList())
{
if (globalItemList.ContainsKey(moldItemVo.GlobalItemCode))
{
continue;
}
if (localItemList.ContainsKey(moldItemVo.LocalItemCode))
{
continue;
}
if (moldList.ContainsKey(moldItemVo.MoldCode))
{
moldItemVo.MoldId = (int)moldList[moldItemVo.MoldCode];
}
MoldItemVo moldItemOutVo = (MoldItemVo)addGlobalItemLocalItemCbm.Execute(trxContext, moldItemVo);
if (moldItemOutVo != null)
{
globalItemList.Add(moldItemOutVo.GlobalItemCode, moldItemOutVo.GlobalItemId);
localItemList.Add(moldItemOutVo.LocalItemCode, moldItemOutVo.LocalItemId);
}
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" Update m_mold_item");
sqlQuery.Append(" Set std_cycle_time = :stdcycletime, ");
sqlQuery.Append(" model_id = :modelid, ");
sqlQuery.Append(" drawing_no = :drawingno ");
sqlQuery.Append(" Where factory_cd = :factcode");
sqlQuery.Append(" and mold_id = :moldid ");
sqlQuery.Append(" and global_item_id = :globalitemid ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterDecimal("stdcycletime", inVo.StdCycleTime);
sqlParameter.AddParameterInteger("modelid", inVo.ModelId);
sqlParameter.AddParameterString("drawingno", inVo.DrawingNo);
sqlParameter.AddParameterString("factcode", trxContext.UserData.FactoryCode);
MoldItemVo outVo = new MoldItemVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void AddMoldItemStdCycleTime(TransactionContext trxContext, ValueObjectList <MoldItemVo> moldItemInVo)
{
if (moldItemInVo != null && moldItemInVo.GetList().Count > 0)
{
foreach (MoldItemVo moldItemVo in moldItemInVo.GetList())
{
if (moldList.ContainsKey(moldItemVo.MoldCode))
{
moldItemVo.MoldId = (int)moldList[moldItemVo.MoldCode];
}
if (modelList.ContainsKey(moldItemVo.ModelCode))
{
moldItemVo.ModelId = (int)modelList[moldItemVo.ModelCode];
}
if (globalItemList.ContainsKey(moldItemVo.GlobalItemCode))
{
moldItemVo.GlobalItemId = (int)globalItemList[moldItemVo.GlobalItemCode];
}
ValueObjectList <MoldItemVo> checkMoldItem = (ValueObjectList <MoldItemVo>)getMoldItemCbm.Execute(trxContext, moldItemVo);
if (checkMoldItem == null || checkMoldItem.GetList() == null || checkMoldItem.GetList().Count == 0)
{
MoldItemVo MoldItemOutVo = (MoldItemVo)addmoldItemCbm.Execute(trxContext, moldItemVo);
}
else
{
MoldItemVo MoldItemOutVo = (MoldItemVo)updateMoldItemCbm.Execute(trxContext, moldItemVo);
}
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldItemVo inVo = (MoldItemVo)vo;
int globalItemSapItemId;
if (!(inVo.GlobalLocalItemId > 0))
{
MoldItemVo globalitemsapitemOutVo = (MoldItemVo)addglobalItemSapItemCbm.Execute(trxContext, inVo);
globalItemSapItemId = globalitemsapitemOutVo.GlobalLocalItemId;
}
else
{
globalItemSapItemId = inVo.GlobalLocalItemId;
}
if (globalItemSapItemId > 0)
{
foreach (MoldItemVo curVo in inVo.MoldItemListVo)
{
curVo.GlobalLocalItemId = globalItemSapItemId;
}
if (!(inVo.MoldItemListVo.Count > 0))
{
deleteGlobalitemSapItemCbm.Execute(trxContext, inVo);
}
inVo.GlobalLocalItemId = globalItemSapItemId;
return(deleteAndAddMoldItemCbm.Execute(trxContext, inVo));
}
return(null);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
// Building SQL
StringBuilder sql = new StringBuilder();
sql.Append("DELETE FROM m_gtrs_global_item_sap_item ");
sql.Append(" WHERE global_item_sap_item_id=:globalitemsapitemid");
sql.Append(" AND factory_cd=:factorycd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("globalitemsapitemid", inVo.GlobalLocalItemId);
sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode);
//execute SQL
MoldItemVo outVo = new MoldItemVo();
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ");
sqlQuery.Append(" sit.global_local_item_id");
sqlQuery.Append(" from m_global_item_local_item sit");
sqlQuery.Append(" where sit.factory_cd = :factorycode ");
sqlQuery.Append(" and sit.sap_item_cd = :sapitemcd ");
if (inVo.GlobalItemId > 0)
{
sqlQuery.Append(" and sit.global_item_id = :globalid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.GlobalItemId > 0)
{
sqlParameter.AddParameterInteger("globalid", inVo.GlobalItemId);
}
sqlParameter.AddParameterString("sapitemcd", inVo.LocalItemCode);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <MoldItemVo> outVo = null;
while (dataReader.Read())
{
MoldItemVo currVo = new MoldItemVo
{
GlobalLocalItemId = ConvertDBNull <int>(dataReader, "global_local_item_id"),
};
if (outVo == null)
{
outVo = new ValueObjectList <MoldItemVo>();
}
outVo.add(currVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select");
sqlQuery.Append(" mo.mold_id,");
sqlQuery.Append(" mo.mold_name, ");
sqlQuery.Append(" gi.global_item_cd, ");
sqlQuery.Append(" gmi.std_cycle_time ");
sqlQuery.Append(" from m_mold mo ");
sqlQuery.Append(" inner join m_mold_item gmi on gmi.mold_id = mo.mold_id ");
sqlQuery.Append(" inner join m_global_local_item gli on gli.global_item_id = gmi.global_item_id ");
sqlQuery.Append(" inner join m_global_item gi on gi.global_item_id = gli.global_item_id ");
sqlQuery.Append(" inner join m_local_item li on li.item_id = gli.local_item_id ");
sqlQuery.Append(" where gmi.factory_cd = :factorycode ");
sqlQuery.Append(" and gi.global_item_cd = :sapitemcd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("sapitemcd", inVo.GlobalItemCode);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
// sqlQuery.Append(" order by gi.global_item_id ");
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <MoldItemVo> outVo = null;
while (dataReader.Read())
{
MoldItemVo currVo = new MoldItemVo
{
MoldId = ConvertDBNull <int>(dataReader, "mold_id"),
MoldName = ConvertDBNull <string>(dataReader, "mold_name"),
GlobalItemCode = ConvertDBNull <string>(dataReader, "global_item_cd"),
StdCycleTime = ConvertDBNull <decimal>(dataReader, "std_cycle_time")
};
if (outVo == null)
{
outVo = new ValueObjectList <MoldItemVo>();
}
outVo.add(currVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// updates Line Machine
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
if (MoldItem_dgv.RowCount > 0)
{
}
ValueObjectList <MoldItemVo> inVo = new ValueObjectList <MoldItemVo>();
foreach (DataGridViewRow row in MoldItem_dgv.Rows)
{
if (row.Cells["colSelect"].Value.ToString() == "True")
{
MoldItemVo selectedItem = (MoldItemVo)row.DataBoundItem;
MoldItemVo addVo = new MoldItemVo();
addVo.MoldId = selectedItem.MoldId;
addVo.StdCycleTime = selectedItem.StdCycleTime;
addVo.GlobalItemId = selectedItem.GlobalItemId;
inVo.add(addVo);
}
}
UpdateResultVo outVo = null;
try
{
Cursor.Current = Cursors.WaitCursor;
outVo = (UpdateResultVo)base.InvokeCbm(new UpdateModelItemForMultipleItemCbm(), inVo, 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)
{
MoldItemVo inVo = (MoldItemVo)arg;
MoldItemVo outVo = new MoldItemVo();
// Building SQL
StringBuilder sql = new StringBuilder();
sql.Append("Insert into m_mold_item");
sql.Append("(");
sql.Append(" mold_id,");
sql.Append(" global_item_id,");
sql.Append(" std_cycle_time,");
sql.Append(" model_id,");
sql.Append(" drawing_no,");
sql.Append(" registration_user_cd,");
sql.Append(" registration_date_time,");
sql.Append(" factory_cd");
sql.Append(") values (");
sql.Append(" :moldid,");
sql.Append(" :globalitemid,");
sql.Append(" :stdcycletime,");
sql.Append(" :modelid,");
sql.Append(" :drawingno,");
sql.Append(" :registrationusercd,");
sql.Append(" :registrationdatetime,");
sql.Append(" :factrycode ");
sql.Append(" ) ");
sql.Append("RETURNING mold_item_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterDecimal("stdcycletime", inVo.StdCycleTime);
sqlParameter.AddParameterInteger("modelid", inVo.ModelId);
sqlParameter.AddParameterString("drawingno", inVo.DrawingNo);
sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factrycode", trxContext.UserData.FactoryCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
// Building SQL
StringBuilder sql = new StringBuilder();
sql.Append("Insert into m_gtrs_global_item_sap_item");
sql.Append("(");
sql.Append(" global_item_id,");
sql.Append(" sap_item_cd,");
sql.Append(" registration_user_cd,");
sql.Append(" registration_date_time,");
sql.Append(" factory_cd");
sql.Append(") values (");
sql.Append(" :globalitemid,");
sql.Append(" :sapitemcd,");
sql.Append(" :registrationusercd,");
sql.Append(" :registrationdatetime,");
sql.Append(" :factrycode ");
sql.Append(" ) ");
sql.Append("RETURNING global_item_sap_item_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterString("sapitemcd", inVo.LocalItemCode);
sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factrycode", trxContext.UserData.FactoryCode);
//execute SQL
int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
MoldItemVo outVo = null;
if (outId > 0)
{
outVo = new MoldItemVo();
outVo.GlobalLocalItemId = outId;
}
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private MoldItemVo FormConditionVo()
{
MoldItemVo inVo = new MoldItemVo();
if (Mold_cmb.SelectedIndex > -1)
{
inVo.MoldId = Convert.ToInt32(Mold_cmb.SelectedValue);
}
if (SapItem_cmb.SelectedIndex > -1)
{
inVo.GlobalItemId = Convert.ToInt32(SapItem_cmb.SelectedValue);
}
return(inVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldDetailVo inVo = (MoldDetailVo)vo;
MoldItemVo moldItemInVo = new MoldItemVo();
moldItemInVo.MoldId = inVo.MoldId;
deleteMoldItemCbm.Execute(trxContext, moldItemInVo);
CavityVo cavityInVo = new CavityVo();
cavityInVo.MoldId = inVo.MoldId;
deleteCavityByMoldIdCbm.Execute(trxContext, cavityInVo);
return(deleteMoldDetailMasterMntCbm.Execute(trxContext, inVo));
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("SELECT ");
sqlQuery.Append(" si.sap_matnr_item_cd, ");
sqlQuery.Append(" si.sap_maktx_item_name, ");
sqlQuery.Append(" gi.global_item_id ");
sqlQuery.Append(" FROM v_sap_item si");
sqlQuery.Append(" inner join m_global_item gi on gi.global_item_cd = si.sap_matnr_item_cd ");
sqlQuery.Append(" WHERE gi.factory_cd = :factorycode ORDER BY si.sap_matnr_item_cd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
ValueObjectList <MoldItemVo> outVo = null;
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
MoldItemVo currVo = new MoldItemVo();
currVo.GlobalItemId = ConvertDBNull <int>(dataReader, "global_item_id");
currVo.GlobalItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd");
currVo.GlobalItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name");
if (outVo == null)
{
outVo = new ValueObjectList <MoldItemVo>();
}
outVo.add(currVo);
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <MoldItemVo> inVo = (ValueObjectList <MoldItemVo>)vo;
UpdateResultVo resultVo = null;
foreach (MoldItemVo molditem in inVo.GetList())
{
MoldItemVo MoldItemOutVo = (MoldItemVo)updateMoldItemDao.Execute(trxContext, molditem);
if (resultVo == null)
{
resultVo = new UpdateResultVo();
}
resultVo.AffectedCount += MoldItemOutVo.AffectedCount;
}
return(resultVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select mo.mold_id, mo.mold_cd, mo.mold_name,gi.global_item_id, gi.global_item_cd, mi.std_cycle_time, si.sap_maktx_item_name ");
sqlQuery.Append(" from m_mold mo ");
sqlQuery.Append(" inner join m_mold_detail md on mo.mold_id = md.mold_id ");
sqlQuery.Append(" inner join m_mold_item mi on mi.mold_id = mo.mold_id ");
sqlQuery.Append(" inner join m_global_item gi on gi.global_item_id = mi.global_item_id ");
sqlQuery.Append(" left join v_sap_item si on gi.global_item_cd = si.sap_matnr_item_cd ");
sqlQuery.Append(" where mo.factory_cd = :factorycode ");
if (inVo.MoldId > 0)
{
sqlQuery.Append(" and mo.mold_id = :moldid ");
}
if (inVo.GlobalItemId > 0)
{
sqlQuery.Append(" and gi.global_item_id = :globalitemid ");
}
sqlQuery.Append(" order by mo.mold_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//sqlQuery.Append(" order by gi.global_item_id ");
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <MoldItemVo> MoldItemListVo = null;
while (dataReader.Read())
{
MoldItemVo currVo = new MoldItemVo
{
MoldId = ConvertDBNull <int>(dataReader, "mold_id"),
MoldCode = ConvertDBNull <string>(dataReader, "mold_cd"),
MoldName = ConvertDBNull <string>(dataReader, "mold_name"),
GlobalItemId = ConvertDBNull <int>(dataReader, "global_item_id"),
GlobalItemCode = ConvertDBNull <string>(dataReader, "global_item_cd"),
GlobalItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name"),
StdCycleTime = ConvertDBNull <decimal>(dataReader, "std_cycle_time")
};
if (MoldItemListVo == null)
{
MoldItemListVo = new ValueObjectList <MoldItemVo>();
}
MoldItemListVo.add(currVo);
}
dataReader.Close();
return(MoldItemListVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(MoldItemVo conditionInVo)
{
MoldItem_dgv.DataSource = null;
MoldItemVo inVo = new MoldItemVo();
if (Mold_cmb.SelectedIndex > -1)
{
inVo.MoldId = Convert.ToInt32(Mold_cmb.SelectedValue);
}
if (SapItem_cmb.SelectedIndex > -1)
{
inVo.GlobalItemId = Convert.ToInt32(SapItem_cmb.SelectedValue);
}
try
{
ValueObjectList <MoldItemVo> outVo = (ValueObjectList <MoldItemVo>)base.InvokeCbm(new GetMoldItemCbm(), inVo, false);
MoldItem_dgv.AutoGenerateColumns = false;
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
messageData = new MessageData("mmce00027", Properties.Resources.mmce00027);
logger.Info(messageData, new NullReferenceException());
popUpMessage.Information(messageData, Text);
return;
}
outVo.GetList().ForEach(t =>
{
t.IsExists = t.GlobalItemCode != null ? "True" : "False";
t.StdCycleTime = t.StdCycleTime.Equals(DBNull.Value) ? default(decimal) : Convert.ToDecimal(t.StdCycleTime.ToString("N2"));
});
BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null);
if (bindingSource1.Count > 0)
{
MoldItem_dgv.DataSource = bindingSource1;
if (MoldItem_dgv.Rows.Count > 0)
{
foreach (DataGridViewRow row in MoldItem_dgv.Rows)
{
if ((bool)row.Cells["colSelect"].FormattedValue)
{
row.Cells["clmstdcycletime"].ReadOnly = false;
}
else
{
row.Cells["clmstdcycletime"].ReadOnly = true;
}
}
}
//Update_btn.Enabled = true;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //Line machine
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
MoldItem_dgv.ClearSelection();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldItemVo inVo = (MoldItemVo)arg;
MoldItemVo outVo = new MoldItemVo();
/// Delete sql
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" Delete From m_mold_item");
sqlQuery.Append(" Where global_item_id = :globalitemid ");
sqlQuery.Append(" and factory_cd = :factorycode ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
MoldItemVo moldItemOutVo = new MoldItemVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
// Building SQL
StringBuilder sql = new StringBuilder();
sql.Append("Insert into m_mold_item");
sql.Append("(");
sql.Append(" mold_id,");
sql.Append(" global_item_sap_item_id,");
sql.Append(" std_cycle_time,");
sql.Append(" registration_user_cd,");
sql.Append(" registration_date_time,");
sql.Append(" factory_cd");
sql.Append(") values (");
sql.Append(" :moldid,");
sql.Append(" :globalitemsapitemid,");
sql.Append(" :stdcycletime,");
sql.Append(" :registrationusercd,");
sql.Append(" :registrationdatetime,");
sql.Append(" :factrycode ");
sql.Append(" ) ");
sql.Append("RETURNING mold_item_id;");
foreach (MoldItemVo curVo in inVo.MoldItemListVo)
{
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", curVo.MoldId);
sqlParameter.AddParameterInteger("globalitemsapitemid", inVo.GlobalLocalItemId);
sqlParameter.AddParameterDecimal("stdcycletime", curVo.StdCycleTime);
sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factrycode", trxContext.UserData.FactoryCode);
//outVo.AffectedCount = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
outVo.AffectedCount += sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldItemVo inVo = (MoldItemVo)vo;
///global item add
GlobalItemVo checkGlobalItemInVo = new GlobalItemVo();
checkGlobalItemInVo.GlobalItemCode = inVo.GlobalItemCode;
GlobalItemVo checkGlobalItemOutVo = (GlobalItemVo)getGlobalItemMasterMntCbm.Execute(trxContext, checkGlobalItemInVo);
GlobalItemVo globalItemOutVo = null;
if (checkGlobalItemOutVo == null || checkGlobalItemOutVo.GlobalItemListVo == null || checkGlobalItemOutVo.GlobalItemListVo.Count == 0)
{
GlobalItemVo globalItemInVo = new GlobalItemVo();
globalItemInVo.GlobalItemCode = inVo.GlobalItemCode;
globalItemInVo.GlobalItemName = inVo.GlobalItemCode;
globalItemOutVo = (GlobalItemVo)addGlobalItemMasterMntCbm.Execute(trxContext, globalItemInVo);
}
else
{
globalItemOutVo = checkGlobalItemOutVo.GlobalItemListVo[0];
}
///local item add
ItemVo checkLocalItemInVo = new ItemVo();
checkLocalItemInVo.ItemCode = inVo.LocalItemCode;
ItemVo checkLocalItemOutVo = (ItemVo)getItemMasterMntCbm.Execute(trxContext, checkLocalItemInVo);
ItemVo localItemOutVo = null;
if (checkLocalItemOutVo == null || checkLocalItemOutVo.ItemListVo == null || checkLocalItemOutVo.ItemListVo.Count == 0)
{
ItemVo localItemInVo = new ItemVo();
localItemInVo.ItemCode = inVo.LocalItemCode;
localItemInVo.ItemName = inVo.LocalItemCode;
localItemOutVo = (ItemVo)addItemMasterMntCbm.Execute(trxContext, localItemInVo);
}
else
{
localItemOutVo = checkLocalItemOutVo.ItemListVo[0];
}
GlobalLocalItemVo globalLocalItemInVo = new GlobalLocalItemVo();
globalLocalItemInVo.GlobalItemId = globalItemOutVo.GlobalItemId;
globalLocalItemInVo.LocalItemId = localItemOutVo.ItemId;
//check and add globallocalitem link table
ValueObjectList <GlobalLocalItemVo> checkGlobalLocalItemVo = (ValueObjectList <GlobalLocalItemVo>)checkGlobalLocalItemMasterMntCbm.Execute(trxContext, globalLocalItemInVo);
if (checkGlobalLocalItemVo == null || checkGlobalLocalItemVo.GetList() == null || checkGlobalLocalItemVo.GetList().Count == 0)
{
GlobalLocalItemVo moldItemOutVo = (GlobalLocalItemVo)addGlobalLocalItemMasterMntCbm.Execute(trxContext, globalLocalItemInVo);
}
inVo.GlobalItemId = globalItemOutVo.GlobalItemId;
inVo.LocalItemId = localItemOutVo.ItemId;
return(inVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldItemVo inVo = (MoldItemVo)vo;
return((MoldItemVo)updateMoldItemDao.Execute(trxContext, inVo));
}
