bool IWareHouseDao.addWareHouse(Entity.WareHouse WareHouse) { int flag = -1; if (con.State == ConnectionState.Closed) { con.Open(); } try { string sql = "insert into Warehouse values(:warehouseid,:name,:address)"; OracleCommand cmd = new OracleCommand(sql, con); cmd.Parameters.Add(":warehouseid", OracleDbType.Int32); cmd.Parameters.Add(":name", OracleDbType.Varchar2); cmd.Parameters.Add(":address", OracleDbType.Varchar2); cmd.Parameters[0].Value = WareHouse.WareHouseID; cmd.Parameters[1].Value = WareHouse.Name; cmd.Parameters[2].Value = WareHouse.Address; flag = cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } if (flag != -1) { return(true); } else { return(false); } }
/* List<Entity.WareHouse> IWareHouseDao.getWarehouseNoticeList(int employeeID) * { * List<WareHouse> m_wh = new List<WareHouse>(); * if (con.State == ConnectionState.Closed) * con.Open(); * * try * { * string sql = "select warehouseID, name, address" + "from warehouse" + "where warehouseid in ( select warehouseid from warehousenotice nature join warehouse_good where employeeid = :employeeid)"; + OracleCommand cmd = new OracleCommand(sql, con); + OracleDataReader DataReader = cmd.ExecuteReader(); + + while (DataReader.Read()) + { + WareHouse warehouse = new WareHouse(); + + int m_wh_id = (int)DataReader["warehouseID"]; + string m_wh_name = DataReader["name"].ToString(); + string m_wh_address = DataReader["address"].ToString(); + + warehouse.WareHouseID = m_wh_id; + warehouse.Name = m_wh_name; + warehouse.Address = m_wh_address; + + m_wh.Add(warehouse); + } + } + catch (Exception ex) + { + MessageBox.Show(ex.ToString()); + } + finally + { + con.Close(); + } + return m_wh; + }*/ bool IWareHouseDao.updateWareHouse(Entity.WareHouse warehouse) { int result = -1; string sql = "update warehouse set name = :name, address = :address where warehouseid = :id"; if (con.State == ConnectionState.Closed) { con.Open(); } try { OracleCommand cmd = new OracleCommand(sql, con); cmd.Parameters.Add(":name", OracleDbType.Varchar2); cmd.Parameters.Add(":address", OracleDbType.Varchar2); cmd.Parameters[0].Value = warehouse.Name; cmd.Parameters[1].Value = warehouse.Address; result = cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } if (result != -1) { return(true); } return(false); }