コード例 #1
0
 private void Details_Click(object sender, RoutedEventArgs e)
 {
     RoomClass rc = new RoomClass();
     var a = this.historyEquipment.SelectedItem;
     var b = a as DataRowView;
     int _Eid = Convert.ToInt32(b.Row[0]);
     MySqlDataReader reader=rc.queryHistoryEquipmentInformation(_Eid);
     HistoryEquipmentDetails _Details = new HistoryEquipmentDetails();
     if (reader.Read())
     {
         _Details.number.Text = reader["NUMBER"].ToString();
         _Details.name.Text=reader["NAME"].ToString();
         _Details.type.Text = reader["TYPE_NAME"].ToString();
         _Details.room.Text = reader["ROOM_NAME"].ToString();
         _Details.takeUser.Text = reader["TAKE_NAME"].ToString();
         _Details.takeTime.Text = Convert.ToDateTime(reader["TAKE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT);
         _Details.userName.Text = reader["USER_NAME"].ToString();
         _Details.time.Text = Convert.ToDateTime(reader["STORAGE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT);
     }
     _Details.Owner = Window.GetWindow(this);
     _Details.ShowDialog();
 }
コード例 #2
0
        private void Details_Click(object sender, RoutedEventArgs e)
        {
            RoomClass               rc       = new RoomClass();
            var                     a        = this.historyEquipment.SelectedItem;
            var                     b        = a as DataRowView;
            int                     _Eid     = Convert.ToInt32(b.Row[0]);
            MySqlDataReader         reader   = rc.queryHistoryEquipmentInformation(_Eid);
            HistoryEquipmentDetails _Details = new HistoryEquipmentDetails();

            if (reader.Read())
            {
                _Details.number.Text   = reader["NUMBER"].ToString();
                _Details.name.Text     = reader["NAME"].ToString();
                _Details.type.Text     = reader["TYPE_NAME"].ToString();
                _Details.room.Text     = reader["ROOM_NAME"].ToString();
                _Details.takeUser.Text = reader["TAKE_NAME"].ToString();
                _Details.takeTime.Text = Convert.ToDateTime(reader["TAKE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT);
                _Details.userName.Text = reader["USER_NAME"].ToString();
                _Details.time.Text     = Convert.ToDateTime(reader["STORAGE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT);
            }
            _Details.Owner = Window.GetWindow(this);
            _Details.ShowDialog();
        }