public void tblOrder_Delete(string OrderID) { string sql = "DELETE FROM tblOrder WHERE OrderID = @OrderID"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection,ConnectionData._MyTransaction); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@OrderID", SqlDbType.NVarChar).Value = OrderID; if (ConnectionData._MyConnection.State == ConnectionState.Closed) { ConnectionData._MyConnection.Open(); } OrderDatailDAO orDao = new OrderDatailDAO(); orDao.tblOrderDetail_Delete(OrderID); cmd.ExecuteNonQuery(); cmd.Dispose(); }
public OrderDatailBUS() { odBUS = new OrderDatailDAO(); }