//获取单条记录 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 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); } }
//填充数据到模板 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(); }