//获取单条记录
private GSCommonItemModel Query(Hashtable equalFields)
{
string sql = GenderSQL(equalFields);
DataTable dt = DbHelperSQL.Query(sql).Tables["dt"];
if (dt.Rows.Count > 0)
{
GSCommonItemModel gsrim = new GSCommonItemModel();
FillData(gsrim, dt.Rows[0]);
return gsrim;
}
else
{
return null;
}
}
private void QueryList(Hashtable equalFields, List<ReportItemModel> rimList)
{
string sql = GenderSQL(equalFields);
DataTable dt = DbHelperSQL.Query(sql).Tables["dt"];
if (dt.Rows.Count > 0)
{
GSCommonItemModel gsrim;
foreach (DataRow dr in dt.Rows)
{
gsrim = new GSCommonItemModel();
FillData(gsrim, dr);
rimList.Add(gsrim);
}
}
}
//填充数据到模板
private void FillData(GSCommonItemModel gsrim, DataRow dr)
{
gsrim.ItemNo = Convert.ToInt32(dr["itemno"]);
gsrim.XueValue = dr["bloodpercent"] == DBNull.Value ? "" : dr["bloodpercent"].ToString();
gsrim.GSValue = dr["marrowpercent"] == DBNull.Value ? "" : dr["marrowpercent"].ToString();
}
//获取多条记录
private List<ReportItemModel> QueryList(Hashtable equalFields)
{
string sql = GenderSQL(equalFields);
DataTable dt = DbHelperSQL.Query(sql).Tables["dt"];
if (dt.Rows.Count > 0)
{
List<ReportItemModel> rfList = new List<ReportItemModel>();
GSCommonItemModel rim;
foreach (DataRow dr in dt.Rows)
{
rim = new GSCommonItemModel();
FillData(rim, dr);
rfList.Add(rim);
}
return rfList;
}
else
{
return null;
}
}