private void button1_Click(object sender, EventArgs e)
{
DBUtil mydb=new DBUtil();
String con = mydb.chinesetoenglish[filtercombobox.Text];
if (select.Equals("")) select = con;
else select = select+" , " + con;
display();
}
protected void display()
{
DBUtil mydb = new DBUtil();
if (!where.Equals(""))
textBox1.Text = "select " + select + " from " + mydb.chinesetoenglish[dataTableComboBox.Text] + " where " + where;
else
textBox1.Text = "select " + select + " from " + mydb.chinesetoenglish[dataTableComboBox.Text];
}
private void addButton_Click(object sender, EventArgs e)
{
DBUtil mydb = new DBUtil();
if (opValueTextBox.Text.Equals("")) return;
String con = "";
con = mydb.chinesetoenglish[segmentComboBox.SelectedItem.ToString()] + " " + operationTypeComboBox.SelectedItem.ToString() + " '" + opValueTextBox.Text + "' ";
String opStr = "and";
if (logicTypeComboBox.SelectedIndex > 0) opStr = "or";
if (where.Equals("")) where = con;
else where = "(" + where + ") " + opStr + " " + con;
display();
}
private void DataQueryForm_Load(object sender, EventArgs e)
{
Control.CheckForIllegalCrossThreadCalls = false;
FatherForm.Enabled = false;
DBUtil mydb = new DBUtil();
ArrayList list = mydb.getTableList();
dataTableComboBox.Items.Clear();
foreach (String s in list)
{
dataTableComboBox.Items.Add(mydb.englishtochinese[s]);
}
dataTableComboBox.SelectedIndex = 0;
segmentComboBox.Items.Clear();
segmentComboBox.Items.Add("数据插入时间");
segmentComboBox.Items.Add("仪器标识");
}
private void searchDataButton_Click(object sender, EventArgs e)
{
List<string> colList;
DBUtil mydb=new DBUtil();
List<List<string>> list = mydb.executeQueryCmd(textBox1.Text);
colList = mydb.getcloumnname();
searchResultListView.Columns.Clear();
for (int i = 0; i < colList.Count; i++)
{
ColumnHeader header = new ColumnHeader();
header.Text = mydb.englishtochinese[(String)colList[i]];
searchResultListView.Columns.Add(header);
}
searchResultListView.Items.Clear();
foreach (List<string> ele in list)
{
ListViewItem item = new ListViewItem();
item.Text = ele[0];
for (int i = 1; i < ele.Count; i++)
{
item.SubItems.Add(ele[i]);
}
searchResultListView.Items.Add(item);
}
}
private void dataTableComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
DBUtil mydb=new DBUtil();
String tableName = dataTableComboBox.SelectedItem.ToString();
ArrayList list = mydb.getTableColumns(mydb.chinesetoenglish[tableName]);
filtercombobox.Items.Clear();
foreach (String s in list)
{
filtercombobox.Items.Add(mydb.englishtochinese[s]);
}
if(list.Count > 0) filtercombobox.SelectedIndex = 0;
textBox1.Text = "";
}