MoveRecord IMoveRecordDao.getSingleMoveRecord(int RemoveID) { MoveRecord MoveRecord = new MoveRecord(); try { if (con.State == ConnectionState.Closed) { con.Open(); } string sql = "select * from move where moveid = :moveid"; OracleCommand cmd = new OracleCommand(sql, con); cmd.Parameters.Add(":moveid", OracleDbType.Int32); cmd.Parameters[":moveid"].Value = RemoveID; OracleDataReader DataReader = cmd.ExecuteReader(); if (DataReader.Read()) { int id = int.Parse(DataReader["moveid"].ToString()); int numbers = int.Parse(DataReader["numbers"].ToString()); DateTime time = (DateTime)DataReader["time"]; int warehouseid = int.Parse(DataReader["warehouseid"].ToString()); int employeeid = int.Parse(DataReader["employeeid"].ToString()); MoveRecord.RemoveID = id; MoveRecord.RemoveTotal = numbers; MoveRecord.RemoveTime = time; // MoveRecord.WareHouse.WareHouseID = warehouseid; IEmployeeDao eDao = new EmployeeDao(); // MoveRecord.Employee = eDao.getSingleEmployee(employeeid); MoveRecord.Employee.EmployeeID = employeeid; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(MoveRecord); }
Shelf IShelfDao.getShelf(int ShelfID) { //throw new NotImplementedException(); Shelf s = new Shelf(); try { if (con.State == ConnectionState.Closed) { con.Open(); } string sql = "select * from shelf where shelfid=" + ShelfID; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader DataReader = cmd.ExecuteReader(); if (DataReader.Read()) { //Shelf shelf = new Shelf(); int s_id = int.Parse(DataReader["shelfid"].ToString()); string name = DataReader["name"].ToString(); string location = DataReader["location"].ToString(); int e_id = int.Parse(DataReader["employeeid"].ToString()); // Employee e = new Employee(); // e.EmployeeID = e_id; s.SelfID = s_id; s.ShelfName = name; s.Location = location; IEmployeeDao edao = new EmployeeDao(); s.Employee = edao.getSingleEmployee(e_id); //int型还是employee型? } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(s); }
//不负责初始化一条订单的每条商品销售信息,暂时就这样 Bill IBillDao.getSingleBill(int BillID) { Bill m_bill = null; try { if (con.State == ConnectionState.Closed) { con.Open(); } string sql = "select * from bill where billid = :id"; OracleCommand cmd = new OracleCommand(sql, con); cmd.Parameters.Add(":id", OracleDbType.Int32); cmd.Parameters[0].Value = BillID; OracleDataReader DataReader = cmd.ExecuteReader(); if (DataReader.Read()) { m_bill = new Bill(); m_bill.BillID = BillID; m_bill.TotalPrice = decimal.Parse(DataReader["totalprice"].ToString()); m_bill.PurchaseingDate = DateTime.Parse(DataReader["purchaseingdate"].ToString()); m_bill.Total_amount = int.Parse(DataReader["goods_total"].ToString()); int employeeId = int.Parse(DataReader["employeeid"].ToString()); int customerid = int.Parse(DataReader["customerid"].ToString()); ICustomerDao cDao = new CustomerDao(); m_bill.Customer = cDao.getSingleCustomer(customerid); IEmployeeDao eDao = new EmployeeDao(); m_bill.Employee = eDao.getSingleEmployee(employeeId); } } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(m_bill); }
Entity.Type ITypeDao.getSingleType(int typeid) { Entity.Type type = null; string sql = "select * from type where typeid = :id"; OracleCommand cmd = new OracleCommand(sql, con); cmd.Parameters.Add("id", OracleDbType.Int32); cmd.Parameters[0].Value = typeid; try { if (con.State == ConnectionState.Closed) { con.Open(); } OracleDataReader DataReader = cmd.ExecuteReader(); if (DataReader.Read()) { type = new Entity.Type(); int id = int.Parse(DataReader["typeid"].ToString()); string name = DataReader["name"].ToString(); int employeeid = int.Parse(DataReader["employeeid"].ToString()); // Employee employee = new Employee(); // employee.EmployeeID = employeeid; IEmployeeDao dao = new EmployeeDao(); type.Employee = dao.getSingleEmployee(employeeid); type.TypeID = id; type.Name = name; // type.Employee = employee; } } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(type); }