private static IDataParameter[] ToSqlParameter(DbBaseProvider dbProvider, SqlParam[] paramList)
{
IDataParameter[] list = new IDataParameter[paramList.Length];
for (int i = 0; i < paramList.Length; i++)
{
SqlParam param = paramList[i];
list[i] = dbProvider.CreateParameter(param.ParamName, param.DbTypeValue, param.Size, param.Value.Value);
}
return list;
}
/// <summary>
///
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
internal static SqlParam[] ConvertSqlParam(IDataParameter[] parameters)
{
SqlParam[] paramList = new SqlParam[parameters.Length];
for (int i = 0; i < parameters.Length; i++)
{
var p = parameters[i];
int size = 0;
int dbType = (int)p.DbType;
if (p is SqlParameter)
{
size = ((SqlParameter)p).Size;
dbType = Convert.ToInt32(((SqlParameter)p).SqlDbType);
}
else if (p is MySqlParameter)
{
size = ((MySqlParameter)p).Size;
dbType = Convert.ToInt32(((MySqlParameter)p).MySqlDbType);
}
paramList[i] = new SqlParam()
{
ParamName = p.ParameterName,
DbTypeValue = dbType,
Size = size,
Value = new ProtoObject(p.Value)
};
}
return paramList;
}
private string GetParamToString(SqlParam[] list)
{
StringBuilder sb = new StringBuilder();
foreach (var item in list)
{
sb.AppendLine(string.Format(" {0}:{1}", item.ParamName, item.Value));
}
return sb.ToString();
}