DataAdapter执行sql语句获取DataTable数据和@output参数数据
public DataTable GetDataWithOuptDict(SqlCommand sqlcmd, Dictionary<string, object> outPutDict) { errorInfo.Clear(); DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(); DataSet dataSet = new DataSet(); using (sqlcmd.Connection = DBConnectionFactory.GetConnection(CompanyID, IsMigrationDB, MigrateTo)) { try { sqlcmd.CommandTimeout = 0; dataAdapter.SelectCommand = sqlcmd; dataAdapter.Fill(dataSet, "Data"); dataTable = dataSet.Tables["Data"]; var keyList = outPutDict.Keys.ToList();//通过这种方式可以遍历dict并更新其value foreach(var key in keyList) { outPutDict[key] = dataAdapter.SelectCommand.Parameters[key].Value; } errorInfo.HasError = false; } catch (SqlException e) { // Add SQL command to exception to make it easier to debug throw new Exception(sqlcmd.CommandText, e); } } return dataTable; }
好的程序员,他们删掉的代码,比留下来的还要多很多。

浙公网安备 33010602011771号