public ParamInfo GetParamByID(int paramid)
{
ParamInfo param = null;
//新建参数列表
SqlParameter parm = new SqlParameter(PARAM_PARAM_ID, System.Data.SqlDbType.Int);
//绑定参数
parm.Value = paramid;
//执行query
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, SQL_SELECT_PARAM_BY_ID, parm))
{
if (rdr.Read())
{
param = new ParamInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
}
else
{
param = new ParamInfo();
}
}
return param;
}
public IList<ParamInfo> GetParams()
{
IList<ParamInfo> param = new List<ParamInfo>();
//Execute a query to read the categories
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, SQL_SELECT_PARAMS, null))
{
while (rdr.Read())
{
ParamInfo parm = new ParamInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
param.Add(parm);
}
}
return param;
}
