/// <summary>
/// 查询是否存在某个病人记录
/// </summary>
/// <param name="ipatientInf"></param>
/// <returns></returns>
public override bool Exists(IModel ipatientInf)
{
MArchives patientInf = (MArchives)ipatientInf;
strSql = "select * from " + TableName + " where PATIENT_ID='" + patientInf.PATIENT_ID + "'";
return(recordIsExist(strSql));
}
/// <summary>
/// 查询是否存在指定的档案记录
/// </summary>
/// <param name="iarchives"></param>
/// <returns></returns>
public override bool Exists(IModel iarchives)
{
MArchives archives = (MArchives)iarchives;
strSql = "select PATIENT_ID from " + TableName + " where PATIENT_ID = '" + archives.PATIENT_ID + "'";
return(recordIsExist(strSql));
}
/// <summary>
/// 插入一条病人档案记录
/// </summary>
/// <param name="iarchives"></param>
/// <returns></returns>
public override int Add(IModel iarchives)
{
MArchives archives = (MArchives)iarchives;
Hashtable ht = new Hashtable();
ht.Add("PATIENT_ID", archives.PATIENT_ID);
ht.Add("PATIENT_NAME", archives.PATIENT_NAME);
ht.Add("PATIENT_SEX", archives.PATIENT_SEX);
ht.Add("PATIENT_AGE", archives.PATIENT_AGE);
ht.Add("PATIENT_AGE_UNIT", archives.PATIENT_AGE_UNIT);
ht.Add("PATIENT_BIRTH", archives.PATIENT_BIRTH);
ht.Add("TELEPHONE_NUM", archives.TELEPHONE_NUM);
ht.Add("IDENTITY_CARD_NO", archives.IDENTITY_CARD_NO);
ht.Add("NATIVE_PLACE", archives.NATIVE_PLACE);
ht.Add("BIRTH_PLACE", archives.BIRTH_PLACE);
ht.Add("HABITATION", archives.HABITATION);
ht.Add("MAILING_ADDRESS", archives.MAILING_ADDRESS);
ht.Add("ZIP_CODE", archives.ZIP_CODE);
ht.Add("INSURANCE_NO", archives.INSURANCE_NO);
ht.Add("BESPEAK_TIME", archives.BESPEAK_TIME);
ht.Add("CHARGE_CLASS", archives.CHARGE_CLASS);
ht.Add("INP_NO", archives.INP_NO);
ht.Add("OPD_NO", archives.OPD_NO);
ht.Add("PATIENT_IDENTITY", archives.PATIENT_IDENTITY);
int i = ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString());
ht = new Hashtable();
ht.Add("PATIENT_ID", archives.PATIENT_ID);
ht.Add("A1", archives.A1);
ht.Add("A2", archives.A2);
ht.Add("A3", archives.A3);
ht.Add("A4", archives.A4);
i += ExecuteSql(StringConstructor.InsertSql(TableName_Sub, ht).ToString());
return(i);
}
/// <summary>
/// 获取特定ID的病人记录，返回的是Patient_inf的Model实体
/// </summary>
/// <param name="PATIENT_ID"></param>
/// <returns></returns>
public override IModel GetModel(string PATIENT_ID)
{
strSql = "select * from " + TableName + " where PATIENT_ID ='" + PATIENT_ID + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MArchives patientInf = new MArchives();
patientInf.BIRTH_PLACE = dt.Rows[0]["BIRTH_PLACE"].ToString();
patientInf.HABITATION = dt.Rows[0]["HABITATION"].ToString();
patientInf.IDENTITY_CARD_NO = dt.Rows[0]["IDENTITY_CARD_NO"].ToString();
patientInf.INP_NO = dt.Rows[0]["INP_NO"].ToString();
patientInf.MAILING_ADDRESS = dt.Rows[0]["MAILING_ADDRESS"].ToString();
patientInf.NATIVE_PLACE = dt.Rows[0]["NATIVE_PLACE"].ToString();
patientInf.OPD_NO = dt.Rows[0]["OPD_NO"].ToString();
patientInf.PATIENT_ENGLISH_NAME = dt.Rows[0]["PATIENT_ENGLISH_NAME"].ToString();
patientInf.PATIENT_ID = dt.Rows[0]["PATIENT_ID"].ToString();
patientInf.PATIENT_NAME = dt.Rows[0]["PATIENT_NAME"].ToString();
patientInf.PATIENT_SEX = dt.Rows[0]["PATIENT_SEX"].ToString();
patientInf.TELEPHONE_NUMBER = dt.Rows[0]["TELEPHONE_NUMBER"].ToString();
patientInf.ZIP_CODE = dt.Rows[0]["ZIP_CODE"].ToString();
if (dt.Rows[0]["VISIT_TIMES"].ToString() == "")
{
patientInf.VISIT_TIMES = null;
}
else
{
patientInf.VISIT_TIMES = Convert.ToInt32(dt.Rows[0]["VISIT_TIMES"].ToString());
}
if (dt.Rows[0]["PATIENT_BIRTH"].ToString() == "")
{
patientInf.PATIENT_BIRTH = null;
}
else
{
patientInf.PATIENT_BIRTH = Convert.ToDateTime(dt.Rows[0]["PATIENT_BIRTH"].ToString());
}
return(patientInf);
}
/// <summary>
/// 插入一条新病人纪录
/// </summary>
/// <param name="ipatientInf"></param>
/// <returns></returns>
public override int Add(IModel ipatientInf)
{
MArchives patientInf = (MArchives)ipatientInf;
Hashtable ht = new Hashtable();
ht.Add("BIRTH_PLACE", patientInf.BIRTH_PLACE);
ht.Add("HABITATION", patientInf.HABITATION);
ht.Add("IDENTITY_CARD_NO", patientInf.IDENTITY_CARD_NO);
ht.Add("INP_NO", patientInf.INP_NO);
ht.Add("MAILING_ADDRESS", patientInf.MAILING_ADDRESS);
ht.Add("NATIVE_PLACE", patientInf.NATIVE_PLACE);
ht.Add("OPD_NO", patientInf.OPD_NO);
ht.Add("PATIENT_BIRTH", patientInf.PATIENT_BIRTH);
ht.Add("PATIENT_CLASS", patientInf.PATIENT_CLASS);
ht.Add("PATIENT_ENGLISH_NAME", patientInf.PATIENT_ENGLISH_NAME);
ht.Add("PATIENT_ID", patientInf.PATIENT_ID);
ht.Add("PATIENT_NAME", patientInf.PATIENT_NAME);
ht.Add("PATIENT_SEX", patientInf.PATIENT_SEX);
ht.Add("TELEPHONE_NUMBER", patientInf.TELEPHONE_NUMBER);
ht.Add("VISIT_TIMES", patientInf.VISIT_TIMES);
ht.Add("ZIP_CODE", patientInf.ZIP_CODE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 更新或插入新数据到表PATIENT_INF中
/// </summary>
public bool SetPatientInf(IModel iPatientInf)
{
MArchives mPatientInf = (MArchives)iPatientInf;
BArchives bArchives = new BArchives();
int i = 0;
//if (IsNew)
//{
// i= bArchives.Add(mPatientInf);
// //EXAM_TIMES = "1";
//}
//else
//{
if (!bArchives.Exists(mPatientInf))
{
i = bArchives.Add(mPatientInf);
}
else
{
i = bArchives.Update(mPatientInf, "where PATIENT_ID='" + mPatientInf.PATIENT_ID + "'");
}
//}
return(i < 0 ? false : true);
}
/// <summary>
/// 获取指定病人ID的档案记录
/// </summary>
/// <param name="PATIENT_ID"></param>
/// <returns></returns>
public override IModel GetModel(string PATIENT_ID)
{
strSql = "select * from " + TableName + " where PATIENT_ID = '" + PATIENT_ID + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MArchives archives = new MArchives();
archives.PATIENT_ID = dt.Rows[0]["PATIENT_ID"].ToString();
archives.PATIENT_NAME = dt.Rows[0]["PATIENT_NAME"].ToString();
archives.PATIENT_SEX = dt.Rows[0]["PATIENT_SEX"].ToString();
archives.PATIENT_AGE_UNIT = dt.Rows[0]["PATIENT_AGE_UNIT"].ToString();
archives.BIRTH_PLACE = dt.Rows[0]["BIRTH_PLACE"].ToString();
archives.HABITATION = dt.Rows[0]["HABITATION"].ToString();
archives.IDENTITY_CARD_NO = dt.Rows[0]["IDENTITY_CARD_NO"].ToString();
archives.INSURANCE_NO = dt.Rows[0]["INSURANCE_NO"].ToString();
archives.MAILING_ADDRESS = dt.Rows[0]["MAILING_ADDRESS"].ToString();
archives.NATIVE_PLACE = dt.Rows[0]["NATIVE_PLACE"].ToString();
archives.TELEPHONE_NUM = dt.Rows[0]["TELEPHONE_NUM"].ToString();
archives.ZIP_CODE = dt.Rows[0]["ZIP_CODE"].ToString();
archives.INP_NO = dt.Rows[0]["INP_NO"].ToString();
archives.OPD_NO = dt.Rows[0]["OPD_NO"].ToString();
archives.PATIENT_IDENTITY = dt.Rows[0]["PATIENT_IDENTITY"].ToString();
if (dt.Rows[0]["PATIENT_AGE"].ToString() == "")
{
archives.PATIENT_AGE = null;
}
else
{
archives.PATIENT_AGE = Convert.ToInt32(dt.Rows[0]["PATIENT_AGE"].ToString());
}
if (dt.Rows[0]["PATIENT_BIRTH"].ToString() == "")
{
archives.PATIENT_BIRTH = null;
}
else
{
archives.PATIENT_BIRTH = Convert.ToDateTime(dt.Rows[0]["PATIENT_BIRTH"].ToString());
}
if (dt.Rows[0]["CHARGE_CLASS"].ToString() == "")
{
archives.CHARGE_CLASS = null;
}
else
{
archives.CHARGE_CLASS = Convert.ToInt32(dt.Rows[0]["CHARGE_CLASS"].ToString());
}
if (dt.Rows[0]["BESPEAK_TIME"].ToString() == "")
{
archives.BESPEAK_TIME = null;
}
else
{
archives.BESPEAK_TIME = Convert.ToDateTime(dt.Rows[0]["BESPEAK_TIME"].ToString());
}
strSql = "select * from " + TableName_Sub + " where PATIENT_ID = '" + PATIENT_ID + "'";
dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(archives);
}
archives.A1 = dt.Rows[0]["A1"].ToString();
archives.A4 = dt.Rows[0]["A4"].ToString();
if (dt.Rows[0]["A2"].ToString() == "")
{
archives.A2 = null;
}
else
{
archives.A2 = Convert.ToInt32(dt.Rows[0]["A2"].ToString());
}
if (dt.Rows[0]["A3"].ToString() == "")
{
archives.A3 = null;
}
else
{
archives.A3 = Convert.ToInt32(dt.Rows[0]["A3"].ToString());
}
return(archives);
}
