package stockmanagementpro;

import javax.ejb.*;
import java.util.*;
import java.rmi.*;
import user.*;
import java.sql.*;

public interface StockManagementData
    extends javax.ejb.EJBObject {
  public int[] checkUser(String userName, String userPassword) throws RemoteException;
  public int createUser(User user) throws RemoteException;
  public int updateUser(User user) throws RemoteException;
  public int deleteUser(User user) throws RemoteException;
  public String[][] getUserByUserName(String userName) throws RemoteException;
  public int createUserLog(String programName, String operationContent,
                           String userName) throws RemoteException;
  public int deleteUserLog(Integer id) throws RemoteException;
  public String[] getTableNames() throws RemoteException;
  public String[][] getDataByTableName(String tableName) throws RemoteException;
  public int setDataByTableName(String tableName, String[][] data) throws RemoteException;
  public String[] getLedgerNames() throws RemoteException;
  public int createLedger(String ledgerDate) throws RemoteException;
  public int deleteLedger(String ledgerDate) throws RemoteException;
  public int createGoodsCategory(int parentId, String categoryName, String categoryDescription) throws RemoteException;
  public int updateGoodsCategory(int categoryId, int parentId, String categoryName, String categoryDescription) throws RemoteException;
  public int deleteGoodsCategory(int categoryId) throws RemoteException;
  public String[][] getAllGoodsCategory() throws RemoteException;
  public int createGoods(String goodsBarCode, int categoryId, String goodsName, String goodsNickName, String goodsAssistantName, String goodsPYName, String unit, String specification, String producer, int upperLimit, int lowerLimit, double salePrice, double discount) throws RemoteException;
  public int updateGoods(String goodsBarCode, int categoryId, String goodsName, String goodsNickName, String goodsAssistantName, String goodsPYName, String unit, String specification, String producer, int upperLimit, int lowerLimit, double salePrice, double discount) throws RemoteException;
  public int deleteGoods(String goodsBarCode) throws RemoteException;
  public String[][] getGoodsByGoodsCategory(int goodsCategory) throws RemoteException;
  public String[][] getGoodsByGoodsBarCode(String goodsBarCode) throws RemoteException;
  public String[][] getGoodsByGoodsName(String goodsName) throws RemoteException;
  public String[][] getGoodsByProducer(String producer) throws RemoteException;
  public String[][] getDiscountGoods() throws RemoteException;
  public int setGoodsDiscount(String goodsBarCode, double discount) throws RemoteException;
  public int createSupplier(String[] supplierArray) throws RemoteException;
  public int updateSupplier(String[] supplierArray) throws RemoteException;
  public int deleteSupplier(String supplierName) throws RemoteException;
  public String[][] getSuppliersBySupplierName(String supplierName) throws RemoteException;
  public String[][] getSuppliersBySupplierZone(String supplierZone) throws RemoteException;
  public int createCustomer(String[] customerArray) throws RemoteException;
  public int updateCustomer(String[] customerArray) throws RemoteException;
  public int deleteCustomer(String customerName) throws RemoteException;
  public String[][] getCustomersByCustomerName(String customerName) throws RemoteException;
  public String[][] getCustomersByCustomerZone(String customerZone) throws RemoteException;
  public String[][] getCreditCustomer() throws RemoteException;
  public int setCreditCustomer(String customerName, double creditlimit) throws RemoteException;
  public int createWarehouse(String[] warehouseArray) throws RemoteException;
  public int updateWarehouse(String[] warehouseArray) throws RemoteException;
  public int deleteWarehouse(String warehouseName) throws RemoteException;
  public String[][] getAllWarehouse() throws RemoteException;
  public int createAccountName(int parentId, String accountNameStr) throws RemoteException;
  public int updateAccountName(int accountId, int parentId, String accountNameStr) throws RemoteException;
  public int deleteAccountName(int accountId) throws RemoteException;
  public String[][] getAccountNameByParentid(int parentId) throws RemoteException;
  public String[][] getAllAccountName() throws RemoteException;  public String[][] getAccountBalance(String ledgerDate, int onProcess) throws RemoteException;
  public String[][] getUserLogByProgramName(String programName) throws RemoteException;
  public String[][] getUserLogByOperationContent(String operationContent) throws RemoteException;
  public String[][] getUserLogByUserName(String userName) throws RemoteException;
  public String[][] getUserLogByOperationDate(Timestamp startDate, Timestamp endDate) throws RemoteException;
  public String[][] getStockLedgerByStringField(String ledgerDate, String fieldName, String fieldValue, int orderType) throws RemoteException;
  public String[][] getStockLedgerByOrderDate(String ledgerDate, Timestamp startDate, Timestamp endDate, int orderType) throws RemoteException;
  public String[][] getStockSubLedgerByOrderId(String ledgerDate, String orderId) throws RemoteException;
  public int createStockLedgerAndSub(String ledgerDate, String[] stockLedger, String[][] stockSubLedger) throws RemoteException;
  public int updateStockLedgerAndSub(String ledgerDate, String[] stockLedger, String[][] stockSubLedger) throws RemoteException;
  public int cancelStockLedgerAndSub(String ledgerDate, String orderId, String remark) throws RemoteException;
  public int restoreStockLedgerAndSub(String ledgerDate, String orderId, String remark) throws RemoteException;
  public int signStockLedgerAndSub(String ledgerDate, String fieldName, String userName, String orderId, String remark) throws RemoteException;
  public String[][] getStockLedgerByOnProcess(String ledgerDate, int orderType, int onProcess) throws RemoteException;
  public int createAccountEntry(String ledgerDate, String[] accountEntryLedger, String[][] accountEntrySubLedger, boolean inTransaction, Connection connIn) throws RemoteException;
  public int createCurrentAccountLedger(String ledgerDate, String[] currentAccountLedger, boolean inTransaction, Connection connIn) throws RemoteException;
  public String[] getCurrentAccountLedgerBylinkId(String ledgerDate, String linkId) throws RemoteException;
  public int checkUserSignStockLedgerAndSub(String ledgerDate, String userName, String supplierName, String orderId, String remark) throws RemoteException;
  public String[][] getCurrentAccountLedgerByStringField(String ledgerDate, String fieldName, String fieldValue, int documentType) throws RemoteException;
  public String[][] getCurrentAccountLedgerByOnProcess(String ledgerDate, int documentType, int onProcess) throws RemoteException;
  public String[][] getCurrentAccountLedgerByFillDate(String ledgerDate, Timestamp startDate, Timestamp endDate, int documentType) throws RemoteException;
  public int createCashLedger(String ledgerDate, String[] cashLedger, boolean inTransaction, Connection connIn) throws RemoteException;
  public int cashUserSignAccountPayable(String ledgerDate, String userName, String[] currentAccountLedger) throws RemoteException;
  public String[][] getCashLedgerByStringField(String ledgerDate, String fieldName, String fieldValue) throws RemoteException;
  public String[][] getCashLedgerByFillDate(String ledgerDate, Timestamp startDate, Timestamp endDate) throws RemoteException;
  public int cashUserSignStockLedgerForStockReturn(String ledgerDate, String userName, String supplierName, String orderId, String remark, boolean isPay) throws RemoteException;
  public String[][] getAccountEntrySubLedgerByLinkSerialId(String ledgerDate, int linkSerialId) throws RemoteException;
  public String[][] getAccountEntryLedgerByStringField(String ledgerDate, String accountName, String fieldName, String fieldValue) throws RemoteException;
  public String[][] getAccountEntryLedgerByOnProcess(String ledgerDate, String accountName, int onProcess) throws RemoteException;
  public String[][] getAccountEntryLedgerByFillDate(String ledgerDate, Timestamp startDate, Timestamp endDate, String accountName) throws RemoteException;
  public int cancelOrRestoreAccountEntryLedger(String ledgerDate, int serialId, int onProcess, String remark) throws RemoteException;
  public int signAccountEntryLedger(String ledgerDate, String fieldName, String userName, int serialId, int onProcess, String remark) throws RemoteException;
  public int updateAccountEntry(String ledgerDate, String[] accountEntryLedger, String[][] accountEntrySubLedger) throws RemoteException;
  public int signStockLedgerAndSubForFinish(String ledgerDate, String fieldName, String userName, String orderId, int onProcess, String remark) throws RemoteException;
  public String[][] getStocktakeQuantityByWarehouse(String ledgerDate, String warehouse, int onProcess) throws RemoteException;
  public String[][] getStockByWarehouse(String ledgerDate, String warehouse, int onProcess) throws RemoteException;
  public String[][] getStockByGoodsBarcode(String ledgerDate, String goodsBarcode, int onProcess) throws RemoteException;
  public String[][] getStockByUsefulLife(String ledgerDate, String usefulLife, int onProcess) throws RemoteException;
  public int createSaleLedgerAndSub(String ledgerDate, String[] saleLedger, String[][] saleSubLedger) throws RemoteException;
  public int updateSaleLedgerAndSub(String ledgerDate, String[] saleLedger, String[][] saleSubLedger) throws RemoteException;
  public int signSaleLedgerAndSub(String ledgerDate, String fieldName, String userName, String saleId, int onProcess, String remark) throws RemoteException;
  public String[][] getSaleSubLedgerBySaleId(String ledgerDate, String saleId) throws RemoteException;
  public String[][] getSaleLedgerByStringField(String ledgerDate, String fieldName, String fieldValue, int saleType) throws RemoteException;
  public String[][] getSaleLedgerByOnProcess(String ledgerDate, int saleType, int onProcess) throws RemoteException;
  public String[][] getSaleLedgerByOrderDate(String ledgerDate, Timestamp startDate, Timestamp endDate, int saleType) throws RemoteException;
  public int counterUserSignSaleLedgerAndSub(String ledgerDate, String userName, String remark, String warehouse) throws RemoteException;
  public int creditUserSignSaleLedgerAndSub(String ledgerDate, String userName, String remark, String warehouse, String saleId, String customerName) throws RemoteException;
  public int cashUserSignAccountReceivable(String ledgerDate, String userName, String[] currentAccountLedger) throws RemoteException;
  public String[][] getStockSaleOutBySaleOrderLink(String ledgerDate, String saleOrderLink, String saleId) throws RemoteException;
  public int counterUserSignSaleReturn(String ledgerDate, String saleId, String userName, String remark, String warehouse, String[][] stockSubLedger) throws RemoteException;
  public int creditUserSignSaleReturn(String ledgerDate, String saleId, String userName, String remark, String warehouse, String customerName, String[][] stockSubLedger, boolean isPay) throws RemoteException;
}