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);
}
