/// <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;
}
}