/// <summary>
/// 批量保存数据入数据库
/// </summary>
/// <param name="functionParms">方法的参数</param>
/// <returns>保存数据入库</returns>
public ResultValue[] FuncBatchSaveData(FunctionParms[] funcParms)
{
lock (lockBatch)
{
List<ResultValue> results = new List<ResultValue>();
foreach (FunctionParms funcParm in funcParms)
{
ResultTable resultTable = new ResultTable();
try
{
using (var reader = SQLHelper.ExecuteReader(connectionString, funcParm.FunctionName, funcParm.Pams))
{
List<string> columns = new List<string>();
List<object[]> rows = new List<object[]>();
while (reader.Read())
{
if (columns.Count == 0)
{
columns = new List<string>();
for (int i = 0; i < reader.FieldCount; i++)
{
columns.Add(reader.GetName(i));
}
}
List<object> cellValues = new List<object>();
for (int i = 0; i < reader.FieldCount; i++)
{
object cellValue = reader.GetValue(i);
cellValues.Add(cellValue == DBNull.Value ? null : cellValue);
}
rows.Add(cellValues.ToArray());
}
resultTable.Columns = columns.ToArray();
resultTable.Rows = rows.ToArray();
}
ResultValue resultValue = new ResultValue();
resultValue.ResultTable = resultTable;
results.Add(resultValue);
//SQLHelper.ExecuteNonQuery(connectionString, funcParm.FunctionName, funcParm.Pams);
//results.Add(new ResultValue());
}
catch (Exception e)
{
results.Add(new ResultValue(e));
}
}
return results.ToArray();
}
}
/// <summary>
/// 获取查询结果集合
/// </summary>
/// <param name="functionParms">查询条件</param>
/// <returns>返回结果集合</returns>
public ResultValue FuncGetResults(FunctionParms functionParms)
{
try
{
ResultTable resultTable = new ResultTable();
//using (var reader = SQLHelper.ExecuteReader(connectionString, functionParms.FunctionName, functionParms.Pams))
using (var reader = MySqlHelper.ExecuteDataReader(connectionString, functionParms.FunctionName, functionParms.Pams))
{
List<string> columns = new List<string>();
List<object[]> rows = new List<object[]>();
while (reader.Read())
{
if (columns.Count == 0)
{
columns = new List<string>();
for (int i = 0; i < reader.FieldCount; i++)
{
columns.Add(reader.GetName(i));
}
}
List<object> cellValues = new List<object>();
for (int i = 0; i < reader.FieldCount; i++)
{
object cellValue = reader.GetValue(i);
cellValues.Add(cellValue == DBNull.Value ? null : cellValue);
}
rows.Add(cellValues.ToArray());
}
resultTable.Columns = columns.ToArray();
resultTable.Rows = rows.ToArray();
}
ResultValue resultValue = new ResultValue();
resultValue.ResultTable = resultTable;
return resultValue;
}
catch (Exception e)
{
return new ResultValue(e);
}
}
