private static SqlParameter[] CreateParam(TijianParamInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@Nick", info.Nick),
new SqlParameter("@ParamName", info.ParamName),
new SqlParameter("@ParamValue", info.ParamValue)
};
return(param);
}
public IList <TijianParamInfo> GetParamInfo(string nick)
{
IList <TijianParamInfo> list = new List <TijianParamInfo>();
SqlParameter param = new SqlParameter("@nick", nick);
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_INFO, param);
foreach (DataRow dr in dt.Rows)
{
TijianParamInfo info = new TijianParamInfo();
info = new TijianParamInfo();
info.Nick = nick;
info.ParamName = dr["ParamName"].ToString();
info.ParamValue = decimal.Parse(dr["ParamValue"].ToString());
list.Add(info);
}
return(list);
}