コード例 #1
0
 public static CBE.CustomerAppointmentCBE GetCustomerAppointmentById(CBE.CustomerAppointmentCBE customerQueue)
 {
     CBE.CustomerAppointmentCollection customerQueues = new CBE.CustomerAppointmentCollection();
     try
     {
         string    spName  = Constants.oraclePackagePrefix + "CUSTOMER_APPOINTMENT_GETBYID";
         DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
         command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_TMS_ID", DbType.Int32, customerQueue.TmsId, ParameterDirection.Input));
         command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_CUSTOMER_APPOINTMENT_ID", DbType.Int32, customerQueue.CustomerAppointmentId, ParameterDirection.Input));
         customerQueues = ConvertDataTableToCollection(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]);
         return(customerQueues[0]);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #2
0
 public static CBE.CustomerAppointmentCollection GetCustomerAppointmentByAccountId(CBE.CustomerAppointmentCBE CustomerAppointment)
 {
     VaaaN.MLFF.Libraries.CommonLibrary.CBE.CustomerAppointmentCollection CustomerAppointmentQueues = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.CustomerAppointmentCollection();
     try
     {
         string    spName  = Constants.oraclePackagePrefix + "CUSTAPPOINTMENT_GETACC_ID";
         DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
         command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_TMS_ID", DbType.Int32, CustomerAppointment.TmsId, ParameterDirection.Input));
         command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ACCOUNT_ID", DbType.Int32, CustomerAppointment.AccountId, ParameterDirection.Input));
         DataSet   ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName);
         DataTable dt = ds.Tables[tableName];
         return(CustomerAppointmentQueues = ConvertDataTableToCollection(dt));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }