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