public IList<ParamInfo> GetParamByParamName(string paramname)
{
IList<ParamInfo> paramall = new List<ParamInfo>();
SqlParameter param = new SqlParameter(PARAM_PARAM_NAME, SqlDbType.NVarChar);
param.Value = paramname;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_PARAM_BY_PARAMNAME, param))
{
while (rdr.Read())
{
ParamInfo newparam = new ParamInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
paramall.Add(newparam);
}
}
return paramall;
}
