/// <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; } }
/// <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; } }
/// <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; } }
/// <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; } }
private void button1_Click(object sender, EventArgs e) { MiniErpDB minierp = new MiniErpDB(); // minierp.GET_ORDER(""); }