private void btn_Export_Click(object sender, RoutedEventArgs e) { try { string strCardId = tbox_CardId.Text.Trim(); int nCount = HelperDatabase.QueryRecordCount(strCardId); if (nCount > 0) { tblk_PageId.Text = "1/" + (nCount + m_OnePageNums - 1) / m_OnePageNums; List <dsHandleRecord> lstRecord = new List <dsHandleRecord>(); if (HelperDatabase.QueryRecord(0, nCount, strCardId, ref lstRecord)) { string[] strLines = new string[lstRecord.Count]; for (int i = 0; i < strLines.Length; i++) { strLines[i] = string.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}", lstRecord[i].Id, lstRecord[i].HandleType, lstRecord[i].MacId, lstRecord[i].CardId, lstRecord[i].SerialId, lstRecord[i].Money, lstRecord[i].Balance, lstRecord[i].CreateTime); } string strFile = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss") + ".txt"; File.WriteAllLines(strFile, strLines); MessageBox.Show("导出成功!\r\n" + strFile); } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_JumpPage_Click(object sender, RoutedEventArgs e) { try { string[] strPageIds = tblk_PageId.Text.Split('/'); int nStart = int.Parse(strPageIds[0]); int nStop = int.Parse(strPageIds[1]); int nPage = int.Parse(tbox_JumpId.Text.Trim()); if (nPage == 0 || nPage > nStop) { return; } int nIndex = (nPage - 1) * m_OnePageNums; string strCardId = tbox_CardId.Text.Trim(); tblk_PageId.Text = nPage + "/" + nStop; List <dsHandleRecord> lstRecord = new List <dsHandleRecord>(); if (HelperDatabase.QueryRecord(nIndex, m_OnePageNums, strCardId, ref lstRecord)) { dgrd_View.ItemsSource = null; dgrd_View.ItemsSource = lstRecord; } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public HandleRecordUI() { InitializeComponent(); //return;//在anycpu情况下,不能调用sqlite,因sqlite版本不是x64架构; HelperDatabase.Init(); m_random = new Random(); }
private void btn_Delete_Click(object sender, RoutedEventArgs e) { if (dgrd_View.SelectedItem == null) { return; } dsHandleRecord record = (dsHandleRecord)dgrd_View.SelectedItem; if (HelperDatabase.DeleteRecord(record.MacId)) { MessageBox.Show("删除成功!"); } }
private void btn_Query_Click(object sender, RoutedEventArgs e) { string strCardId = tbox_CardId.Text.Trim(); int nCount = HelperDatabase.QueryRecordCount(strCardId); m_OnePageNums = int.Parse(cbox_OnePageNums.Text); if (nCount > 0) { tblk_PageId.Text = "1/" + (nCount + m_OnePageNums - 1) / m_OnePageNums; List <dsHandleRecord> lstRecord = new List <dsHandleRecord>(); if (HelperDatabase.QueryRecord(0, m_OnePageNums, strCardId, ref lstRecord)) { dgrd_View.ItemsSource = null; dgrd_View.ItemsSource = lstRecord; } } }
private void btn_Refresh_Click(object sender, RoutedEventArgs e) { string[] strPageIds = tblk_PageId.Text.Split('/'); int nStart = int.Parse(strPageIds[0]); int nStop = int.Parse(strPageIds[1]); int nIndex = (nStart - 1) * m_OnePageNums; string strCardId = tbox_CardId.Text.Trim(); tblk_PageId.Text = nStart + "/" + nStop; List <dsHandleRecord> lstRecord = new List <dsHandleRecord>(); if (HelperDatabase.QueryRecord(nIndex, m_OnePageNums, strCardId, ref lstRecord)) { dgrd_View.ItemsSource = null; dgrd_View.ItemsSource = lstRecord; } }