cyq.data 连接mysql_底层数据库操作类库CYQ.DATA查询

单表查询：

using (MAction action = new MAction(“COMP”,"K3"))

{

//查询的字段

string colstr = "COMPNO,NAME";

//设置查询的字段

action.SetSelectColumns(colstr.Split(','));

MDataTable tabme = action.Select();

//绑定dataGridView控件

tabme.Bind(dataGridView1);

}

//自定义SQL查询

StringBuilder sb = new StringBuilder();

sb.Append("(select ");

sb.Append("RTRIM(LTRIM(tt.FTableName)) as FTableName,");

sb.Append("RTRIM(LTRIM(tt.FDescription)) as TDescription,");

sb.Append("RTRIM(LTRIM(tf.FFieldName)) as FFieldName,");

sb.Append("RTRIM(ltrim(tf.FDescription)) as FDescription,tf.FFieldType from");

sb.Append(" T_TableDescription tt inner join  t_FieldDescription tf on tt.FTableID = tf.FTableID ) v ");

if (string.IsNullOrEmpty(txtSearch.Text))

{

try

{

using (MAction action = new MAction(sb.ToString(), "Conn"))

{

MDataTable tabme = action.Select();

tabme.Bind(dataGridView1);

}

}

catch (Exception ex){ MessageBox.Show(ex.Message); }

}

else

{

try

{

using (MAction action = new MAction(sb.ToString(), "Conn"))

{

string sqltext = "";

sqltext = "FTableName like '%" + txtSearch.Text.Trim() + "%'";

sqltext = sqltext + " or " + "TDescription like '%" + txtSearch.Text.Trim() + "%'";

sqltext = sqltext + " or " + "FFieldName like '%" + txtSearch.Text.Trim() + "%'";

sqltext = sqltext + " or " + "FDescription like '%" + txtSearch.Text.Trim() + "%'";

MDataTable tabme = action.Select(sqltext);

tabme.Bind(dataGridView1);

}

}

catch (Exception ex) { MessageBox.Show(ex.Message); }

}