/// <summary> 获取数据源
///
/// </summary>
/// <returns>DataSet</returns>
public DataSet GetData()
{
IDbHelper dbHelper = DbHelper.GetDbHelper(SqlType.SqlServer, m_dbSchema.DatabaseSchema.ConnectionString);
StringBuilder sb = new StringBuilder();
sb.AppendLine(txtSql.Text);
sb.AppendLine(txtSql1.Text);
sb.AppendLine(txtSql2.Text);
dbHelper.CreateCommand(sb.ToString());
DataSet dataSet = dbHelper.ExecuteQueryDataSet();
for (int i = 0; i < dataSet.Tables.Count; i++)
{
dataSet.Tables[i].TableName = "T" + (i + 1);
}
//这是对应关系的时候主键必须唯一
string strPK = txtKey.Text.Trim();
string strForign = txtKey1.Text.Trim();
string strKey2 = txtKey2.Text.Trim();
if (dataSet.Tables.Count == 3)
{
dataSet.Relations.Add("1", dataSet.Tables["T1"].Columns[strPK], dataSet.Tables["T2"].Columns[strForign]);
dataSet.Relations.Add("2", dataSet.Tables["T2"].Columns[strForign], dataSet.Tables["T3"].Columns[strKey2]);
}
else if (dataSet.Tables.Count == 2)
{
dataSet.Relations.Add("1", dataSet.Tables["T1"].Columns[strPK], dataSet.Tables["T2"].Columns[strForign]);
}
return(dataSet);
}
private DataSet GetBindSource(BindSourceHelper.BindClass bindClass)
{
IDbHelper helper = DbHelper.GetDbHelper(bindClass.SqlType, bindClass.Connections);
helper.CreateCommand(bindClass.BindSql);
DataSet ds = helper.ExecuteQueryDataSet();
for (int i = 0; i < ds.Tables.Count; i++)
{
//ds.Tables[i].TableName = lstBseUis[i].ControlName;
}
return(ds);
}
