private void SetSqlCommandInputParamValue(DbCommand command, object[] param, string query)
{
// Set parameters
String[] inParamNames = GetSqlParamNames(query);
for (int i = 0; i < inParamNames.Length; i++)
{
//var para = new MySqlParameter(inParamNames[i], param[i]);
var para = command.CreateParameter();
para.ParameterName = inParamNames[i];
para.Value = param[i];
para.DbType = DbTypeUtil.GetDBType(para.Value);
if (para.DbType == DbType.String &&
para.Value != null &&
string.IsNullOrEmpty(para.Value.ToString()))
{
para.Value = null;
}
if (para.Value == null)
{
para.Value = Convert.DBNull;
}
command.Parameters.Add(para);
}
}
public void AddParameter(string name, SqlDbType type)
{
_parameters.SetParameter(new ParameterDefinition()
{
Name = name,
DbType = DbTypeUtil.ConvertToDbType(type)
});
}
/// <summary>
/// Adds a parameter to the select command.
/// </summary>
public void AddParameter(string name, object value)
{
_parameters.SetParameter(new ParameterDefinition()
{
Name = name,
Value = value,
DbType = DbTypeUtil.GetDbType(value)
});
}
public void AddParameter(string name, SqlDbType type, int size, string source)
{
_parameters.SetParameter(new ParameterDefinition()
{
Name = name,
DbType = DbTypeUtil.ConvertToDbType(type),
Size = size,
SourceColumn = source
});
}
public void AddParameter(string name, SqlDbType type, int size, ParameterDirection direction)
{
_parameters.SetParameter(new ParameterDefinition()
{
Name = name,
DbType = DbTypeUtil.ConvertToDbType(type),
Size = size,
Direction = direction
});
}
/// <summary>
/// Adds parameters to the select command.
/// </summary>
public void AddParameter(IDictionary <string, object> parameters)
{
_parameters.Clear();
if (parameters != null)
{
foreach (var kvp in parameters)
{
_parameters.SetParameter(new ParameterDefinition()
{
Name = kvp.Key,
Value = kvp.Value,
DbType = DbTypeUtil.GetDbType(kvp.Value)
});
}
}
}
private void SetProcCommandInputParamValue(DbCommand command, object[] param, String[] inParamNames)
{
// Set parameters
for (int i = 0; i < inParamNames.Length; i++)
{
var para = command.CreateParameter();
para.ParameterName = inParamNames[i];
para.Value = param[i];
if (para.Value is DataTable)
{
var sqlPara = para as SqlParameter;
if (sqlPara == null)
{
throw new Exception("Only SQL Server supports a parameter of DataTable Type.");
}
sqlPara.SqlDbType = SqlDbType.Structured;
}
else
{
para.DbType = DbTypeUtil.GetDBType(para.Value);
}
if (para.DbType == DbType.String &&
para.Value != null &&
string.IsNullOrEmpty(para.Value.ToString()))
{
para.Value = null;
}
if (para.Value == null)
{
para.Value = Convert.DBNull;
}
command.Parameters.Add(para);
}
}
public MyDbUtil(DbTypes dbType = DbTypes.SqlServer)
{
_connectionString = ConfigurationManager.AppSettings["DefaultConnectionString"];
_paramPrefix = DbTypeUtil.GetDbParamPrefix(dbType);
}
public MySearchUtil(DbTypes dbType = DbTypes.SqlServer)
{
_sqlParameterPrefix = DbTypeUtil.GetDbParamPrefix(dbType);
}
