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