コード例 #1
0
ファイル: StockDAO.cs プロジェクト: JISUNGUK/MiniERP_2019
        /// <summary>
        /// 재고 데이터 조회 함수
        /// </summary>
        /// <param name="warehouse_code">재고조회 프로시저 매개변수 - 창고번호</param>
        /// <param name="item_code">재고조회 프로시저 매개변수 - 품목번호</param>
        /// <returns></returns>
        public List <Stock> Get_Stock(string warehouse_code, string item_code)
        {
            MiniErpDB miniErp = new MiniErpDB();

            try
            {
                var result = miniErp.GET_STOCK(warehouse_code, item_code);
                foreach (var item in result)
                {
                    Stock stock = new Stock();
                    stock.Item_code      = item.Item_code;
                    stock.Stock_name     = item.Item_name;
                    stock.Warehouse_code = item.Warehouse_code;
                    stock.Warehouse_name = item.Warehouse_name;
                    stock.Stock_standard = item.Item_standard;
                    stock.Stock_count    = item.Stock_count;

                    stocks.Add(stock);
                }

                return(stocks);
            }
            catch
            {
                throw;
            }
        }
コード例 #2
0
ファイル: StockDAO.cs プロジェクト: JISUNGUK/MiniERP_2019
        /// <summary>
        /// 재고등록 함수
        /// </summary>
        /// <param name="item_code">재고등록 프로시저 매개변수 - 품목번호</param>
        /// <param name="warehouse_code">재고등록 프로시저 매개변수 - 창고번호</param>
        /// <param name="stock_count">재고등록 프로시저 매개변수 - 품목갯수</param>
        public void Set_Stock_Item(string item_code, string warehouse_code, int stock_count)
        {
            MiniErpDB miniErp = new MiniErpDB();

            try
            {
                miniErp.SET_STOCK_ITEM(item_code, warehouse_code, stock_count);
            }
            catch
            {
                throw;
            }
        }
コード例 #3
0
        /// <summary>
        /// 거래수정 함수
        /// </summary>
        /// <param name="trade">거래수정 프로시저 매개변수 - 거래객체</param>
        /// <returns></returns>
        public int UpdateTrade(Trade trade)
        {
            MiniErpDB miniErpDB = new MiniErpDB();

            try
            {
                return(miniErpDB.MODIFY_TRADE(trade.Trade_code, trade.Clerk_code, trade.Warehouse_code, trade.Trade_status));
            }
            catch
            {
                throw;
            }
        }
コード例 #4
0
        /// <summary>
        /// 물류등록 함수
        /// </summary>
        /// <param name="dist">물류등록 프로시저의 매개변수</param>
        public void SET_DISTRIBUTION(Distribution dist)
        {
            MiniErpDB db = new MiniErpDB();

            try
            {
                db.SET_DISTRIBUTION(null, dist.Before_warehouse_code, dist.After_warehouse_code, dist.Item_code, dist.Dist_count, dist.Move_date);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #5
0
 private void button1_Click(object sender, EventArgs e)
 {
     MiniErpDB minierp = new MiniErpDB();
     // minierp.GET_ORDER("");
 }