ru.bgcrm.plugin.arm.dao

Class TmcDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.arm.dao.TmcDAO

public class TmcDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
TmcDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	deleteTmc(int tmcId)
Tmc	getTmc(int tmcId)
java.util.List<Tmc>	getTmcList(int processId)
void	updateTmc(int tmcId, int processId, int realizationId, java.lang.String objectType, java.lang.String objectTitle, int directionId, int storageId, int nomenclatureTypeId, int nomenclatureId, double quantity, int qualityTypeId, int costTypeId, int paymentTypeId, double totalCost, java.lang.String serialNumber, java.util.Date executeDate, int userId)
void	updateTmcDocumentInfo(int tmcId, java.lang.String documentNumber, java.util.Date documentDate, java.lang.String documentType)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TmcDAO

public TmcDAO(java.sql.Connection con)

Method Detail

updateTmc

public void updateTmc(int tmcId,
                      int processId,
                      int realizationId,
                      java.lang.String objectType,
                      java.lang.String objectTitle,
                      int directionId,
                      int storageId,
                      int nomenclatureTypeId,
                      int nomenclatureId,
                      double quantity,
                      int qualityTypeId,
                      int costTypeId,
                      int paymentTypeId,
                      double totalCost,
                      java.lang.String serialNumber,
                      java.util.Date executeDate,
                      int userId)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

getTmcList

public java.util.List<Tmc> getTmcList(int processId)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getTmc

public Tmc getTmc(int tmcId)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

updateTmcDocumentInfo

public void updateTmcDocumentInfo(int tmcId,
                                  java.lang.String documentNumber,
                                  java.util.Date documentDate,
                                  java.lang.String documentType)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteTmc

public void deleteTmc(int tmcId)
               throws java.sql.SQLException

Throws:

java.sql.SQLException