/// <summary> /// 得到一个对象实体 /// </summary> public HisClient.Model.his_cl_medical_record DataRowToModel(DataRow row) { HisClient.Model.his_cl_medical_record model=new HisClient.Model.his_cl_medical_record(); if (row != null) { if(row["CL_CODE"]!=null) { model.CL_CODE=row["CL_CODE"].ToString(); } if(row["PHA_CODE"]!=null) { model.PHA_CODE=row["PHA_CODE"].ToString(); } if(row["DOCTOR_CODE"]!=null) { model.DOCTOR_CODE=row["DOCTOR_CODE"].ToString(); } if(row["CL_DATE"]!=null && row["CL_DATE"].ToString()!="") { model.CL_DATE=DateTime.Parse(row["CL_DATE"].ToString()); } if(row["IP"]!=null) { model.IP=row["IP"].ToString(); } if(row["ICD_CODE"]!=null) { model.ICD_CODE=row["ICD_CODE"].ToString(); } if(row["ICD_NAME"]!=null) { model.ICD_NAME=row["ICD_NAME"].ToString(); } if(row["MEMO"]!=null) { model.MEMO=row["MEMO"].ToString(); } if(row["OPT_USER"]!=null) { model.OPT_USER=row["OPT_USER"].ToString(); } if(row["OPT_DATE"]!=null && row["OPT_DATE"].ToString()!="") { model.OPT_DATE=DateTime.Parse(row["OPT_DATE"].ToString()); } if(row["OPT_TERM"]!=null) { model.OPT_TERM=row["OPT_TERM"].ToString(); } if(row["OPT_ORGA"]!=null) { model.OPT_ORGA=row["OPT_ORGA"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public HisClient.Model.his_cl_medical_record GetModel(string CL_CODE) { StringBuilder strSql=new StringBuilder(); strSql.Append("select CL_CODE,PHA_CODE,DOCTOR_CODE,CL_DATE,IP,ICD_CODE,ICD_NAME,MEMO,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA from his_cl_medical_record "); strSql.Append(" where CL_CODE=@CL_CODE "); MySqlParameter[] parameters = { new MySqlParameter("@CL_CODE", MySqlDbType.VarChar,18) }; parameters[0].Value = CL_CODE; HisClient.Model.his_cl_medical_record model=new HisClient.Model.his_cl_medical_record(); DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }