//加载表数据 void loadTableData() { try { dt = new ReadTable(_systemName.ToUpper().Trim()); dt.SetCustomFunctionName("ZVI_RFC_READ_TABLE"); dt.TableName = _tableName; // dt.Fields.Clear(); // dt.Options.Clear(); //从界面上加载条件与字段列表 for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["FieldName"].Value != null) { if (dataGridView1.Rows[i].Cells["Select"] != null & (bool)dataGridView1.Rows[i].Cells["Select"].Value == true) { string s = dataGridView1.Rows[i].Cells["FieldName"].Value.ToString(); if (!string.IsNullOrEmpty(s)) { dt.AddField(s); } } } } for (int i = 0; i < dataGridView2.Rows.Count; i++) { if (dataGridView2[0, i].Value != null) { string s = dataGridView2[0, i].Value.ToString(); if (!string.IsNullOrEmpty(s)) { dt.AddCriteria(s); } } } dt.RowCount = Convert.ToInt32(rowNum.Text); dt.Run(); } catch (Exception ee) { MessageBox.Show(ee.Message); } }
//加载表数据 void loadTableData() { try { SendMessage("开始"); m_dt = new ReadTable(m_systemName); m_dt.EventMessage += dt_eventMessage; // dt.SetCustomFunctionName("Z_XTRACT_IS_TABLE"); m_dt.SetCustomFunctionName("ZVI_RFC_READ_TABLE"); m_dt.TableName = m_tableName; m_dt.Delimiter = m_delimiter; // dt.Fields.Clear(); // dt.Options.Clear(); //从界面上加载条件与字段列表 SendMessage("加载字段列表"); for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["FieldName"].Value != null) { if (dataGridView1.Rows[i].Cells[0].Value != null) { if ((bool)dataGridView1.Rows[i].Cells[0].Value == true) { string s = dataGridView1.Rows[i].Cells["FieldName"].Value.ToString(); if (!string.IsNullOrEmpty(s)) { m_dt.AddField(s); } } } } } SendMessage("加载条件"); for (int i = 0; i < dataGridView2.Rows.Count; i++) { if (dataGridView2[0, i].Value != null) { string s = dataGridView2[0, i].Value.ToString(); if (!string.IsNullOrEmpty(s)) { m_dt.AddCriteria(s); } } } m_dt.RowCount = Convert.ToInt32(rowNum.Text); SendMessage("开始异步调用"); try { Thread thread = new Thread(new ThreadStart(excute)); thread.Start(); } catch (Exception e) { MessageBox.Show(e.Message); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }