public static void WriteMemberToList(ListMember member) { Object[] member_values = member.GetValues(); string filename = (string)member_values[0]; int row = Convert.ToInt32(member_values[1]); byte[] bytes; using (ExcelPackage p = new ExcelPackage(new FileInfo(filename))) { ExcelWorksheet ws = p.Workbook.Worksheets.First(); ws.Cells[row, 1].Value = member_values[3]; //serial ws.Cells[row, 2].Value = member_values[4]; //uid ws.Cells[row, 3].Value = member_values[8]; //entry times ws.Cells[row, 4].Value = member_values[7]; //entry days ws.Cells[row, 5].Value = ws.Cells[row - 1, 5].Value; //copy down options ws.Cells[row, 6].Value = member_values[5]; //user ws.Cells[row, 7].Value = member_values[6]; //description bytes = p.GetAsByteArray(); } File.WriteAllBytes(filename, bytes); }
//add new card to selected list private void button4_Click(object sender, EventArgs e) { ListMember member = ListUtilities.GenerateNewMember((string)checkedListBox1.SelectedItem); FillTabPage3(member.GetValues().SubArray(0, 9).Cast <string>().ToArray()); tabPage3.Name = "Add"; tabControl1.TabPages.Add(tabPage3); tabControl1.SelectedTab = tabPage3; }
private async Task SearchAndFill() { string tbt = textBox1.Text.Trim(); if (tbt != previous_search) { dataGridView1.Enabled = false; previous_search = tbt; if (tbt != "") { if (tbt.Length > 1) { if (tbt[0] == '*' && tbt[1] == 'h') { try { tbt = UInt64.Parse(tbt.Substring(2), System.Globalization.NumberStyles.HexNumber) + ""; } catch (Exception ex) { return; } } } else if (tbt[0] == '*') { tbt = ""; } DataTable local_dt = null; await Task.Run(() => { local_dt = dt.Clone(); local_dt.Clear(); for (int index_counter = 0; index_counter < members.Length; index_counter++) { ListMember lm = members[index_counter]; if (lm.Contains(tbt)) { local_dt.Rows.Add(new Func <Object[]>(() => { Object[] objects = lm.GetValues(); objects[objects.Length - 1] = index_counter; return(objects); }).Invoke()); } } }); dataGridView1.DataSource = local_dt; dt = local_dt; } else { dt.Clear(); } dataGridView1.Enabled = true; } }