public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineBuildingVo inVo = (LineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_line_building");
sqlQuery.Append(" Where ");
sqlQuery.Append(" building_id = :buildingid ");
sqlQuery.Append(" and factory_cd = :faccd ");
if (inVo.LineId > 0)
{
sqlQuery.Append(" and line_id = :lid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Deletes Line building
/// </summary>
/// <param name="lineId"></param>
/// <param name="buildingId"></param>
private int DeleteLineBuilding(int lineId, int buildingId)
{
LineBuildingVo delInVo = new LineBuildingVo
{
LineId = lineId,
BuildingId = buildingId
};
UpdateResultVo delOutVo = new UpdateResultVo();
try
{
delOutVo = (UpdateResultVo)base.InvokeCbm(new DeleteLineBuildingMasterMntCbm(), delInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
}
return(delOutVo.AffectedCount);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineBuildingVo inVo = (LineBuildingVo)arg;
UpdateResultVo outVo = new UpdateResultVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_line_building");
sqlQuery.Append(" ( ");
sqlQuery.Append(" building_id, ");
sqlQuery.Append(" line_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :buildingid ,");
sqlQuery.Append(" :lineid ,");
sqlQuery.Append(" :registrationusercd ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factrycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("lineid", inVo.LineId);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterString("registrationusercd", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factrycode", UserData.GetUserData().FactoryCode);
outVo.AffectedCount += sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
/// <summary>
/// Adds new line Building
/// </summary>
/// <param name="LineId"></param>
/// <param name="buildingId"></param>
private int AddLineBuilding(int LineId, int buildingId)
{
LineBuildingVo LineBuildInVo = new LineBuildingVo
{
LineId = LineId,
BuildingId = buildingId,
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
UpdateResultVo outVo = new UpdateResultVo();
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddLineBuildingMasterMntCbm(), LineBuildInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
}
return(outVo.AffectedCount);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LineBuildingVo inVo = (LineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select");
sqlQuery.Append(" lb.line_building_id,");
sqlQuery.Append(" lb.building_id,");
sqlQuery.Append(" lb.line_id,");
sqlQuery.Append(" b.building_cd,");
sqlQuery.Append(" b.building_name,");
sqlQuery.Append(" l.line_cd,");
sqlQuery.Append(" l.line_name");
sqlQuery.Append(" from m_line_building lb");
sqlQuery.Append(" inner join m_line l on lb.line_id = l.line_id");
sqlQuery.Append(" inner join m_building b on lb.building_id = b.building_id");
sqlQuery.Append(" where lb.factory_cd = :faccd ");
if (inVo.BuildingId > 0)
{
sqlQuery.Append(" and lb.building_id = :buildingid");
}
if (inVo.LineId > 0)
{
sqlQuery.Append(" and lb.line_id = :lid");
}
if (inVo.LineCode != null)
{
sqlQuery.Append(" and l.line_cd = :lcd");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
sqlParameter.AddParameterString("lcd", inVo.LineCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <LineBuildingVo> outVo = null;
while (dataReader.Read())
{
LineBuildingVo currOutVo = new LineBuildingVo
{
LineBuildingId = Convert.ToInt32(dataReader["line_building_id"]),
BuildingId = Convert.ToInt32(dataReader["building_id"]),
LineId = Convert.ToInt32(dataReader["line_id"]),
LineCode = dataReader["line_cd"].ToString(),
LineName = dataReader["line_name"].ToString(),
BuildingCode = dataReader["building_cd"].ToString(),
BuildingName = dataReader["building_name"].ToString()
};
if (outVo == null)
{
outVo = new ValueObjectList <LineBuildingVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
