예제 #1
0
        public List <InvoiceAutoItem> ListRest(long id_store)
        {
            string str = "exec USP_INVOICE_AUTO_REST {0}, null";
            SqlLoader <InvoiceAutoItem> sqlLoader = this.loader;

            object[] idStore = new object[] { id_store };
            return(sqlLoader.GetList(str, idStore));
        }
예제 #2
0
        public List <InvoiceAutoItem> ListLot(Guid id_document)
        {
            string str = "exec USP_INVOICE_AUTO_REST null, '{0}'";
            SqlLoader <InvoiceAutoItem> sqlLoader = this.loader;

            object[] idDocument = new object[] { id_document };
            return(sqlLoader.GetList(str, idDocument));
        }
예제 #3
0
        public List <InvoiceAutoItem> ListRest(long id_store, long id_store_to)
        {
            var logger = new SimpleLogger();
            /*2019  расчет перемещения товара*/
            string str = "exec USP_INVOICE_AUTO_REST_2 {0}, null, {1}";

            //str = str.Replace("{0}", id_store.ToString());
            //str = str.Replace("{1}", id_store_to.ToString());
            logger.Trace("Запускаем выборку по складу  " + str);

            SqlLoader <InvoiceAutoItem> sqlLoader = this.loader;

            object[] idStore = new object[] { id_store, id_store_to };
            return(sqlLoader.GetList(str, idStore));
            //return sqlLoader.GetList(str);
        }