/// <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); }