private void ConvertToModel(IDataReader reader, MyTestScore model)
{
if (reader["Id"] != DBNull.Value)
model.Id = Convert.ToInt32(reader["Id"]);
if (reader["UserId"] != DBNull.Value)
model.UserId = Convert.ToInt32(reader["UserId"]);
if (reader["DimensionId"] != DBNull.Value)
model.DimensionId = Convert.ToInt32(reader["DimensionId"]);
if (reader["Score"] != DBNull.Value)
model.Score = reader["Score"].ToString();
}
/// <summary>
/// 取得一条测试分数
/// </summary>
/// <param name="id"></param>
/// <param name="where"></param>
/// <returns></returns>
public MyTestScore GetScore(int id, string where)
{
string sql = "select * from [2015NlCP].[dbo].[score] where [Id]=@Id";
if (!string.IsNullOrEmpty(where))
sql += " and " + where;
SqlParameter[] cmdParams = new SqlParameter[]{
new SqlParameter("@Id", SqlDbType.Int, 4) { Value = id }
};
using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql, cmdParams))
{
if (reader.Read())
{
MyTestScore model = new MyTestScore();
ConvertToModel(reader, model);
return model;
}
else
{
return null;
}
}
}
/// <summary>
/// 取得测试分数列表
/// </summary>
/// <param name="where"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public List<MyTestScore> GetScoreList(string where, string orderBy)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from [2015NlCP].[dbo].[score]");
if (!string.IsNullOrEmpty(where))
sql.Append(" where " + where);
if (!string.IsNullOrEmpty(orderBy))
sql.Append(" order by " + orderBy);
List<MyTestScore> list = new List<MyTestScore>();
using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString()))
{
while (reader.Read())
{
MyTestScore model = new MyTestScore();
ConvertToModel(reader, model);
list.Add(model);
}
}
return list;
}