public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { GlobalLocalItemVo inVo = (GlobalLocalItemVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_global_local_item "); sqlQuery.Append(" Where "); sqlQuery.Append(" local_item_id = :localitemid "); sqlQuery.Append(" and factory_cd = :faccd "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("localitemid", inVo.LocalItemId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); GlobalLocalItemVo outVo = new GlobalLocalItemVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { GlobalLocalItemVo inVo = (GlobalLocalItemVo)arg; GlobalLocalItemVo outVo = new GlobalLocalItemVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_global_local_item"); sqlQuery.Append(" ( "); sqlQuery.Append(" global_item_id, "); sqlQuery.Append(" local_item_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append(" VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :globalitemid, "); sqlQuery.Append(" :localitemid, "); sqlQuery.Append(" :registrationusercode, "); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId); sqlParameter.AddParameterInteger("localitemid", inVo.LocalItemId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { GlobalLocalItemVo inVo = (GlobalLocalItemVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select gl.global_local_item_id "); sqlQuery.Append(" from m_global_local_item gl "); sqlQuery.Append(" where gl.factory_cd = :faccd "); if (inVo.GlobalItemId > 0) { sqlQuery.Append(" and gl.global_item_id = :globalitemid "); } if (inVo.LocalItemId > 0) { sqlQuery.Append(" and gl.local_item_id = :localitemid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.GlobalItemId > 0) { sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId); } if (inVo.LocalItemId > 0) { sqlParameter.AddParameterInteger("localitemid", inVo.LocalItemId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <GlobalLocalItemVo> outVo = null; while (dataReader.Read()) { GlobalLocalItemVo currOutVo = new GlobalLocalItemVo(); currOutVo.GlobalLocalItemId = ConvertDBNull <Int32>(dataReader, "global_local_item_id"); if (outVo == null) { outVo = new ValueObjectList <GlobalLocalItemVo>(); } outVo.add(currOutVo); } dataReader.Close(); 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 override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { GlobalLocalItemVo inVo = (GlobalLocalItemVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select gl.global_local_item_id, gl.global_item_id, li.item_name, li.item_id "); sqlQuery.Append(" from m_local_item li "); sqlQuery.Append(" LEFT JOIN m_global_local_item gl on gl.global_item_id = :globalitemid AND gl.local_item_id=li.item_id "); sqlQuery.Append(" where li.factory_cd = :faccd "); if (inVo.GlobalItemId > 0) { sqlQuery.Append(" and gl.global_item_id IS NULL OR gl.global_item_id = :globalitemid "); } if (inVo.LocalItemId > 0) { sqlQuery.Append(" and gl.local_item_id = :localitemid "); } sqlQuery.Append(" order by gl.global_local_item_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.GlobalItemId > 0) { sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId); } if (inVo.LocalItemId > 0) { sqlParameter.AddParameterInteger("localitemid", inVo.LocalItemId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); GlobalLocalItemVo outVo = new GlobalLocalItemVo(); while (dataReader.Read()) { GlobalLocalItemVo currOutVo = new GlobalLocalItemVo(); currOutVo.GlobalLocalItemId = ConvertDBNull <Int32>(dataReader, "global_local_item_id"); currOutVo.GlobalItemId = ConvertDBNull <Int32>(dataReader, "global_item_id"); currOutVo.LocalItemId = ConvertDBNull <Int32>(dataReader, "item_id"); currOutVo.LocalItemName = ConvertDBNull <string>(dataReader, "item_name"); outVo.GlobalLocalItemListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }