public static PatientInfo01 GetPatientInfo01(int mrn) { PatientInfo01 tmp = null; string sqlString = " select a.mrn as 'mrn', a.pname as 'pName', a.psex as 'pSex' , a.age as 'pAge', a.ageunit as 'ageUnit' " + " from pmain a where a.mrn = @MRN "; SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@MRN", SqlDbType.Int) }; cmdParms[0].Value = mrn; DataSet ds = DbHelperSQL_18.Query(sqlString, cmdParms); DataTable dt = ds.Tables["ds"]; if (dt.Rows.Count == 0) { tmp = null; } else { DataRow dr = dt.Rows[0]; string sTmp = ""; int iTmp = 0; tmp = new PatientInfo01(mrn, dr["pName"].ToString().Trim(), "", 0, ""); if (int.TryParse(dr["pAge"].ToString().Trim(), out iTmp)) { tmp.pAge = iTmp; } switch (dr["ageUnit"].ToString().Trim().ToUpper()) { case "Y": tmp.ageUnit = "岁"; break; case "M": tmp.ageUnit = "月"; break; case "D": tmp.ageUnit = "日"; break; } switch (dr["pSex"].ToString().Trim().ToUpper()) { case "F": tmp.pSex = "女"; break; case "M": tmp.pSex = "男"; break; } } return(tmp); }
public ActionResult GetPatientInformation01(int mrn) { PatientInfo01 tmp = PatientInfoDAO.GetPatientInfo01(mrn); return(Json(tmp, JsonRequestBehavior.AllowGet)); }