private void HistoryOrder_Click(object sender, RoutedEventArgs e) { SystemManager sm = new SystemManager(); var a = this.EquiplogGrid.SelectedItem; var b = a as DataRowView; int _LogId = Convert.ToInt32(b.Row[0]); OperationEquipmentInfo opi = new OperationEquipmentInfo(); MySqlDataReader reader = sm.getEquipmentInfo(_LogId); if (reader.HasRows) { if (reader.Read()) { opi.number.Text = reader["NUMBER"].ToString(); opi.Ename.Text = reader["NAME"].ToString(); opi.Etype.Text = reader["TYPE_NAME"].ToString(); opi.room.Text = reader["ROOM_NAME"].ToString(); opi.Otype.Text = OperationTypeString.getTypeStr(int.Parse(reader["TYPE"].ToString())); opi.Ouser.Text = reader["ACCOUNT"].ToString(); opi.Etime.Text = Convert.ToDateTime(reader["STORAGE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT); opi.Otime.Text = Convert.ToDateTime(reader["DATE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT); } opi.Owner = Window.GetWindow(this); opi.ShowDialog(); } }
private void HistoryOrder_Click(object sender, RoutedEventArgs e) { SystemManager sm = new SystemManager(); var a = this.EquiplogGrid.SelectedItem; var b = a as DataRowView; int _LogId = Convert.ToInt32(b.Row[0]); OperationEquipmentInfo opi = new OperationEquipmentInfo(); MySqlDataReader reader = sm.getEquipmentInfo(_LogId); if (reader.HasRows) { if (reader.Read()) { opi.number.Text = reader["NUMBER"].ToString(); opi.Ename.Text = reader["NAME"].ToString(); opi.Etype.Text = reader["TYPE_NAME"].ToString(); opi.room.Text = reader["ROOM_NAME"].ToString(); opi.Otype.Text = OperationTypeString.getTypeStr(int.Parse(reader["TYPE"].ToString())); opi.Ouser.Text = reader["ACCOUNT"].ToString(); opi.Etime.Text = Convert.ToDateTime(reader["STORAGE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT); opi.Otime.Text = Convert.ToDateTime(reader["DATE_TIME"]).ToString(BaseRequest.DATE_MS_FORMAT); } opi.Owner = Window.GetWindow(this); opi.ShowDialog(); } }