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)); }