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