//填充数据到模板 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); } }