private void _bldCommand(string name, string sql_text, MsDatParameters db_parms)
{
if (String.IsNullOrEmpty(name) == true)
{
Name = _splitTableName(sql_text);
}
else
{
Name = name;
}
Text = sql_text;
var _dbps = new MsDatParameters();
if (db_parms != null)
{
foreach (MsDatParameter _dbp in db_parms)
{
_dbps.Add(_dbp.Name, _dbp.FieldType, _dbp.Type, _dbp.Direction, _dbp.Value);
}
}
Value = _dbps;
}
//-----------------------------------------------------------------------------------------------------------------------------
// ExecuteProc
//-----------------------------------------------------------------------------------------------------------------------------
/// <summary>
///
/// </summary>
/// <param name="connection_string"></param>
/// <param name="stored_procedure_name"></param>
/// <returns></returns>
public MsDatParameters GetSqlParameters(string connection_string, string stored_procedure_name)
{
var _dbps = new MsDatParameters();
SqlParameter[] _sbps = SqlHelperParameterCache.GetSpParameterSet(connection_string, stored_procedure_name);
foreach (SqlParameter _s in _sbps)
{
_dbps.Add(_s.ParameterName, _s.SqlDbType, _s.Direction, DBNull.Value);
}
return(_dbps);
}
