Beispiel #1
0
 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();
 }
Beispiel #2
0
 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];
 }
Beispiel #3
0
 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();
 }
Beispiel #4
0
 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("仪器标识");
 }
Beispiel #5
0
        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);
            }
        }
Beispiel #6
0
 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 = "";
 }