Package 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	Description
TmcDAO(Connection con)

Method Summary

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

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

TmcDAO

public TmcDAO(Connection con)

Method Details

updateTmc

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

Throws:

SQLException

getTmcList

public List<Tmc> getTmcList(int processId)
                     throws SQLException

Throws:

SQLException

getTmc

public Tmc getTmc(int tmcId)
           throws SQLException

Throws:

SQLException

updateTmcDocumentInfo

public void updateTmcDocumentInfo(int tmcId,
 String documentNumber,
 Date documentDate,
 String documentType)
                           throws SQLException

Throws:

SQLException

deleteTmc

public void deleteTmc(int tmcId)
               throws SQLException

Throws:

SQLException