public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MachineAndEquipmentVo inVo = (MachineAndEquipmentVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into public.m_machine_equipment(machine_id,equipment_id) "); sql.Append("values(:machine_id,:equipment_id)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); // DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); sqlParameter.AddParameterInteger("equipment_id", inVo.EquipmentID); //execute SQL MachineAndEquipmentVo outVo = new MachineAndEquipmentVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MachineAndEquipmentVo inVo = (MachineAndEquipmentVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <MachineAndEquipmentVo> voList = new ValueObjectList <MachineAndEquipmentVo>(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select machine_equip_id, machine_id, equipment_id from public.m_machine_equipment"); sql.Append(" Where 1=1 "); // if (inVo.MachineID > 0) { sql.Append(" and machine_id = :machine_id "); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); } if (inVo.EquipmentID > 0) { sql.Append(" and equipment_id = :equipment_id "); sqlParameter.AddParameterInteger("equipment_id", inVo.EquipmentID); } if (inVo.MachineAndEquipmentID > 0) { sql.Append(" and machine_equip_id = :machine_equip_id "); sqlParameter.AddParameterInteger("machine_equip_id", inVo.MachineAndEquipmentID); } //create command //DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { MachineAndEquipmentVo outVo = new MachineAndEquipmentVo { //convert MachineAndEquipmentID = int.Parse(dataReader["machine_equip_id"].ToString()), MachineID = int.Parse(dataReader["machine_id"].ToString()), EquipmentID = int.Parse(dataReader["equipment_id"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MachineAndEquipmentVo inVo = (MachineAndEquipmentVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from public.m_machine_equipment Where 1=1 "); if (inVo.MachineID > 0) { sql.Append(" and machine_id = :machine_id "); sqlParameter.AddParameterInteger("machine_id", inVo.MachineID); } if (inVo.EquipmentID > 0) { sql.Append(" and equipment_id = :equipment_id "); sqlParameter.AddParameterInteger("equipment_id", inVo.EquipmentID); } if (inVo.MachineAndEquipmentID > 0) { sql.Append(" and machine_equip_id = :machine_equip_id "); sqlParameter.AddParameterInteger("machine_equip_id", inVo.MachineAndEquipmentID); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL MachineVo outVo = new MachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }