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