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