ArrayList alist = new ArrayList();
foreach (DataRow datarow in dt.Rows)
{
Dictionary<string, object> dic = new Dictionary<string, object>();
foreach (DataColumn data in dt.Columns)
{
dic.Add(data.ColumnName, datarow[data.ColumnName].ToString());
}
alist.Add(dic);
}
SerializeResponse(dt.Rows.Count, alist);
接口的方法类型使用datatable类型
public DataTable selectReportDetails(string inventoryId) {
string sql = @"select * from 表名 where 参数名=CONVERT(uniqueidentifier,'"+ 参数+"')";
// getdata()方法执行SQL语句,查询到数据后直接存入datatable中
DataTable dt = clsCommon.GetData(sql);
return dt;
}