//获取单条记录 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; } }