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