//填充数据到模板 private void FillData(GSReportItemModel gsrim, DataRow dr) { //rim.ReceiveDate = (DateTime)dr["receivedate"]; //rim.SectionNo = (int)dr["sectionno"]; //rim.TestTypeNo = (int)dr["testtypeno"]; //rim.SampleNo = dr["sampleno"].ToString(); gsrim.ItemNo = Convert.ToInt32(dr["itemno"]); gsrim.ItemResult = dr["reportvalueall"] == DBNull.Value ? "" : dr["reportvalueall"].ToString().Trim(); gsrim.ReportText = dr["reporttext"] == DBNull.Value ? "" : dr["reporttext"].ToString().Trim(); gsrim.IsFile = dr["isfile"] == DBNull.Value ? -1 : (int)dr["isfile"]; gsrim.FilePath = dr["graphfilename"] == DBNull.Value ? "" : dr["graphfilename"].ToString().Trim(); }
//获取单条记录 private GSReportItemModel Query(Hashtable equalFields) { string sql = GenderSQL(equalFields); DataTable dt = DbHelperSQL.Query(sql).Tables["dt"]; if (dt.Rows.Count > 0) { GSReportItemModel gsrim = new GSReportItemModel(); 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) { GSReportItemModel gsrim; foreach (DataRow dr in dt.Rows) { gsrim = new GSReportItemModel(); 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>(); GSReportItemModel rim; foreach (DataRow dr in dt.Rows) { rim = new GSReportItemModel(); FillData(rim, dr); rfList.Add(rim); } return rfList; } else { return null; } }