/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.TB_SAMPLE_LOG DataRowToModel(DataRow row) { RuRo.Model.TB_SAMPLE_LOG model = new RuRo.Model.TB_SAMPLE_LOG(); if (row != null) { if (row["LOG_ID"] != null && row["LOG_ID"].ToString() != "") { model.LOG_ID = int.Parse(row["LOG_ID"].ToString()); } if (row["PatientID"] != null && row["PatientID"].ToString() != "") { model.PatientID = int.Parse(row["PatientID"].ToString()); } if (row["BASE_MSG"] != null) { model.BASE_MSG = row["BASE_MSG"].ToString(); } if (row["CLINICAL_MSG"] != null) { model.CLINICAL_MSG = row["CLINICAL_MSG"].ToString(); } if (row["MSG"] != null) { model.MSG = row["MSG"].ToString(); } if (row["STATE"] != null) { model.STATE = row["STATE"].ToString(); } if (row["LOG_DATE"] != null && row["LOG_DATE"].ToString() != "") { model.LOG_DATE = DateTime.Parse(row["LOG_DATE"].ToString()); } if (row["type"] != null) { model.type = row["type"].ToString(); } if (row["LOG_UP"] != null) { model.LOG_UP = row["LOG_UP"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.TB_SAMPLE_LOG GetModel(int LOG_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LOG_ID,PatientID,BASE_MSG,CLINICAL_MSG,MSG,STATE,LOG_DATE,type,LOG_UP from TB_SAMPLE_LOG "); strSql.Append(" where LOG_ID=@LOG_ID"); SqlParameter[] parameters = { new SqlParameter("@LOG_ID", SqlDbType.Int,4) }; parameters[0].Value = LOG_ID; RuRo.Model.TB_SAMPLE_LOG model = new RuRo.Model.TB_SAMPLE_LOG(); DataSet ds = DbHelperSQL_SY.QuerySY(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }