示例#1
0
 private void singerHistoryToolStripMenuItem_Click(object sender, EventArgs e)
 {
     if (_queuerForm != null && _rowIndex >= 0 && _rowIndex < dataGridViewQueue.Rows.Count)
     {
         string singerkey = dataGridViewQueue.Rows[_rowIndex].Cells["SingerKey"].Value.ToString();
         if (singerkey != null && singerkey.Trim().Length > 0)
         {
             SingerHistory sh = new SingerHistory();
             sh.SetUp(_queuerForm.scc, singerkey);
             sh.ShowDialog();
         }
     }
 }
示例#2
0
        private void btnHistory_Click(object sender, EventArgs e)
        {
            /*
             * string xml = "";
             * if (cmbEvent.SelectedItem != null)
             * {
             *      TSCEvents tscevent = cmbEvent.SelectedItem as TSCEvents;
             *      if (tscevent != null)
             *      {
             *              xml = scc.GetSingerHistoryForVenue(tscevent.VenueKey);
             *      }
             * }
             * else
             * {
             *      xml = scc.GetSingerHistoryForVenue("");
             * }
             * if (xml.Trim().Length > 0)
             * {
             *      Dictionary<string, SingerHistoryStore> history = new Dictionary<string, SingerHistoryStore>();
             *      XmlDataDocument doc = new XmlDataDocument();
             *      if (Utility.IsValidXml(xml) == true)
             *      {
             *              doc.LoadXml(xml);
             *              XmlNodeList nodes = doc.SelectNodes("/Root/Data");
             *
             *              foreach (XmlNode node in nodes)
             *              {
             *                      string singerKey = Utility.GetXmlString(node, "SingerKey").Trim();
             *                      DateTime EventDate = Utility.GetXmlDateTime(node, "EventDate");
             *                      string song = Utility.GetXmlString(node, "QueueSong").Trim();
             *                      string artist = Utility.GetXmlString(node, "QueueArtist").Trim();
             *                      if (singerKey.Length > 0 && song.Length > 0)
             *                      {
             *                              SingerHistoryRecord record = new SingerHistoryRecord(singerKey, song, artist, EventDate);
             *                              if (history.ContainsKey(singerKey) == true)
             *                              {
             *                                      history[singerKey].history.Add(record);
             *                              }
             *                              else
             *                              {
             *                                      SingerHistoryStore store = new SingerHistoryStore();
             *                                      store.history.Add(record);
             *                                      history.Add(singerKey, store);
             *                              }
             *                      }
             *              }
             *      }
             *      if (history != null && history.Count > 0)
             *      {
             *              Excel.Application app = null;
             *              Excel.Workbook workbook = null;
             *              Excel.Worksheet worksheet = null;
             *              Excel.Range worksheet_range = null;
             *              app = new Excel.Application();
             *              app.Visible = true;
             *              workbook = app.Workbooks.Add(1);
             *              worksheet = (Excel.Worksheet)workbook.Sheets[1];
             *              int row = 1;
             *              foreach (KeyValuePair<string, SingerHistoryStore> pair in history)
             *              {
             *                      foreach (SingerHistoryRecord record in pair.Value.history)
             *                      {
             *                              worksheet.Cells[row, 1] = record.SingerKey;
             *                              worksheet.Cells[row, 2] = record.date;
             *                              worksheet.Cells[row, 3] = record.Song;
             *                              worksheet.Cells[row, 4] = record.Artist;
             *                              row++;
             *                      }
             *              }
             *              Excel.Range startcell = worksheet.Cells[1, 1];
             *              Excel.Range endcell = worksheet.Cells[row, 4];
             *              worksheet.Range[startcell, endcell].Columns.AutoFit();
             *      }
             * }
             */
            SingerHistory sh = new SingerHistory();

            sh.SetUp(scc, "");
            sh.ShowDialog();
        }