/// <summary>
/// 参数字典转为数组
/// </summary>
/// <param name="d"></param>
/// <param name="paramMap"></param>
/// <returns></returns>
public static DbParameter[] ParameterMapToArray(IDbDialect d, IDictionary <string, object> paramMap)
{
List <DbParameter> parameters = new List <DbParameter>();
foreach (KeyValuePair <String, Object> p in paramMap)
{
parameters.Add(d.CreateParameter(p.Key, p.Value ?? ""));
}
return(parameters.ToArray());
}
/// <summary>
/// 转换为参数
/// </summary>
/// <param name="db"></param>
/// <param name="data"></param>
/// <returns></returns>
public static DbParameter[] ToParams(IDbDialect db, object[,] data)
{
if (data != null)
{
int l = data.GetLength(0);
if (l != 0 && data.GetLength(1) != 2)
{
throw new ArgumentOutOfRangeException("data", "多纬数组的二维长度必须为2");
}
DbParameter[] parameter = new DbParameter[l];
for (int i = 0; i < l; i++)
{
parameter[i] = db.CreateParameter(data[i, 0].ToString(), data[i, 1]);
}
return(parameter);
}
return(null);
}
