/// <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>
/// 批量插入用户记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MUser user = new MUser();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
user = (MUser)ht2[i];
ht.Add("DOCTOR_ID", user.DOCTOR_ID);
ht.Add("DOCTOR_NAME", user.DOCTOR_NAME);
ht.Add("CLINIC_OFFICE_CODE", user.CLINIC_OFFICE_CODE);
ht.Add("CLINIC_OFFICE", user.CLINIC_OFFICE);
ht.Add("DOCTOR_ROLE", user.DOCTOR_ROLE);
ht.Add("DOCTOR_PWD", user.DOCTOR_PWD);
ht.Add("CREATE_DATE", user.CREATE_DATE);
ht.Add("DOCTOR_LEVEL", user.DOCTOR_LEVEL);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 插入一条报告记录
/// </summary>
/// <param name="ireport"></param>
/// <returns></returns>
public override int Add(IModel ireport)
{
MReport report = (MReport)ireport;
Hashtable ht = new Hashtable();
ht.Add("EXAM_ACCESSION_NUM", report.EXAM_NO);
ht.Add("EXAM_PARA", report.EXAM_PARA);
ht.Add("DESCRIPTION", report.DESCRIPTION);
ht.Add("IMPRESSION", report.IMPRESSION);
ht.Add("RECOMMENDATION", report.RECOMMENDATION);
ht.Add("DICTATOR", report.DICTATOR);
ht.Add("TRANSCRIBER", report.TRANSCRIBER);
ht.Add("APPROVER", report.APPROVER);
ht.Add("APPROVE_DATE_TIME", report.APPROVE_DATE_TIME);
ht.Add("REPORT_DATE_TIME", report.REPORT_DATE_TIME);
ht.Add("AFFIRMANT", report.AFFIRMANT);
ht.Add("AFFIRM_DATE_TIME", report.AFFIRM_DATE_TIME);
ht.Add("IS_ABNORMAL", report.IS_ABNORMAL);
ht.Add("REPORT_TYPE", report.REPORT_TYPE);
ht.Add("PRINT_TEMPLATE", report.PRINT_TEMPLATE);
ht.Add("PRINT_COUNT", report.PRINT_COUNT);
ht.Add("REPORT_NAME", report.REPORT_NAME);
ht.Add("FIELD_INF", report.FIELD_INF);
int i = ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString(), ht);
return(i);
}
public override int Add(IModel iQcFilm)
{
MQcFilm qcFilm = (MQcFilm)iQcFilm;
Hashtable ht = new Hashtable();
ht.Add("ADHIBIT", qcFilm.ADHIBIT);
ht.Add("BASE_ASH_FOG_VALUE", qcFilm.BASE_ASH_FOG_VALUE);
ht.Add("BLANK_EXPOSAL_DENSITY", qcFilm.BLANK_EXPOSAL_DENSITY);
ht.Add("DIAGNOSE_AREA_VALUE", qcFilm.DIAGNOSE_AREA_VALUE);
ht.Add("DIRT", qcFilm.DIRT);
ht.Add("DISTINCTION", qcFilm.DISTINCTION);
ht.Add("EXAM_ACCESSION_NUM", qcFilm.EXAM_ACCESSION_NUM);
ht.Add("EXTERNA_SHADOW", qcFilm.EXTERNA_SHADOW);
ht.Add("FINGER_MARK", qcFilm.FINGER_MARK);
ht.Add("IVP_CONTRAST", qcFilm.IVP_CONTRAST);
ht.Add("IVP_DEVELOP", qcFilm.IVP_DEVELOP);
ht.Add("IVP_FILM_POSTURE_PLACE", qcFilm.IVP_FILM_POSTURE_PLACE);
ht.Add("IVP_LETTER_ARRANGE", qcFilm.IVP_LETTER_ARRANGE);
ht.Add("IVP_LETTER_NO", qcFilm.IVP_LETTER_NO);
ht.Add("IVP_PHOTOGRAPHS_ENOUGH", qcFilm.IVP_PHOTOGRAPHS_ENOUGH);
ht.Add("IVP_PROJECTION_CENTRAGE", qcFilm.IVP_PROJECTION_CENTRAGE);
ht.Add("KNUCKLE_ARRANGEMENT_FOCUS", qcFilm.KNUCKLE_ARRANGEMENT_FOCUS);
ht.Add("KNUCKLE_IMAGE_DISTORTION", qcFilm.KNUCKLE_IMAGE_DISTORTION);
ht.Add("KNUCKLE_LETTER_ARRANGE", qcFilm.KNUCKLE_LETTER_ARRANGE);
ht.Add("KNUCKLE_LONG_AXIS_PARALLEL", qcFilm.KNUCKLE_LONG_AXIS_PARALLEL);
ht.Add("KNUCKLE_PROJECTION", qcFilm.KNUCKLE_PROJECTION);
ht.Add("KNUCKLE_RESOLUTION", qcFilm.KNUCKLE_RESOLUTION);
ht.Add("KNUCKLE_WRAP", qcFilm.KNUCKLE_WRAP);
ht.Add("LIGHT_LEAK", qcFilm.LIGHT_LEAK);
ht.Add("NICK", qcFilm.NICK);
ht.Add("NUMBER_KEY", qcFilm.NUMBER_KEY);
ht.Add("PATIENT_ID", qcFilm.PATIENT_ID);
ht.Add("PATIENT_LOCAL_ID", qcFilm.PATIENT_LOCAL_ID);
ht.Add("PATIENT_NAME", qcFilm.PATIENT_NAME);
ht.Add("PATIENT_SEX", qcFilm.PATIENT_SEX);
ht.Add("QC_DATE", qcFilm.QC_DATE);
ht.Add("STATIC_SHADOW", qcFilm.STATIC_SHADOW);
ht.Add("STERNUM_ARRANGEMENT_FOCUS", qcFilm.STERNUM_ARRANGEMENT_FOCUS);
ht.Add("STERNUM_BLADEBONE", qcFilm.STERNUM_BLADEBONE);
ht.Add("STERNUM_BOARD", qcFilm.STERNUM_BOARD);
ht.Add("STERNUM_BREAST", qcFilm.STERNUM_BREAST);
ht.Add("STERNUM_FIRST_FORTH_WHETTLE", qcFilm.STERNUM_FIRST_FORTH_WHETTLE);
ht.Add("STERNUM_IMAGE_DISTORTION", qcFilm.STERNUM_IMAGE_DISTORTION);
ht.Add("STERNUM_LETTER_ARRANGE", qcFilm.STERNUM_LETTER_ARRANGE);
ht.Add("STERNUM_LETTER_NO", qcFilm.STERNUM_LETTER_NO);
ht.Add("STUDY_DATE_TIME", qcFilm.STUDY_DATE_TIME);
ht.Add("TOTAL_SCORE", qcFilm.TOTAL_SCORE);
ht.Add("UGI_BLEB", qcFilm.UGI_BLEB);
ht.Add("UGI_CAVITY_LINE", qcFilm.UGI_CAVITY_LINE);
ht.Add("UGI_CONTRAST", qcFilm.UGI_CONTRAST);
ht.Add("UGI_FLOCCULENCE", qcFilm.UGI_FLOCCULENCE);
ht.Add("UGI_INDICATION_RANGE", qcFilm.UGI_INDICATION_RANGE);
ht.Add("UGI_INF_CRITERION", qcFilm.UGI_INF_CRITERION);
ht.Add("UGI_MUCOSAL_FOLD", qcFilm.UGI_MUCOSAL_FOLD);
ht.Add("UGI_PATIENT_TYPE", qcFilm.UGI_PATIENT_TYPE);
ht.Add("UGI_PHOTOGRAPHS_ENOUGH", qcFilm.UGI_PHOTOGRAPHS_ENOUGH);
ht.Add("UGI_PROJECTION_CASE", qcFilm.UGI_PROJECTION_CASE);
ht.Add("WATER_MARK", qcFilm.WATER_MARK);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 批量插入用户角色记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MUsersRole MUserRol = new MUsersRole();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MUserRol = (MUsersRole)ht2[i];
ht.Add("ROLE_ID", MUserRol.ROLE_ID);
ht.Add("ROLE_NAME", MUserRol.ROLE_NAME);
ht.Add("EXAM_CLASS", MUserRol.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", MUserRol.EXAM_SUB_CLASS);
ht.Add("FUN_MODEL", MUserRol.FUN_MODEL);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入临床科室记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MClinicOfficeDict MOfficeDict = new MClinicOfficeDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MOfficeDict = (MClinicOfficeDict)ht2[i];
ht.Add("CLINIC_OFFICE_ID", MOfficeDict.CLINIC_OFFICE_ID);
ht.Add("CLINIC_OFFICE", MOfficeDict.CLINIC_OFFICE);
ht.Add("PATIENT_SOURCE_ID", MOfficeDict.PATIENT_SOURCE_ID);
ht.Add("CLINIC_OFFICE_CODE", MOfficeDict.CLINIC_OFFICE_CODE);
ht.Add("CLINIC_OFFICE_FLAG", MOfficeDict.CLINIC_OFFICE_FLAG);
ht.Add("CUR_SERIAL_NUM", MOfficeDict.CUR_SERIAL_NUM);
ht.Add("STUDY_UID_HEADER", MOfficeDict.STUDY_UID_HEADER);
ht.Add("CLINIC_OFFICE_PYCODE", MOfficeDict.CLINIC_OFFICE_PYCODE);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入检查类别记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MExamClass examClass = new MExamClass();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
examClass = (MExamClass)ht2[i];
ht.Add("EXAM_CLASS", examClass.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examClass.EXAM_SUB_CLASS);
ht.Add("DICOM_MODALITY", examClass.DICOM_MODALITY);
ht.Add("LOCAL_ID_CLASS", examClass.LOCAL_ID_CLASS);
ht.Add("TAG_IMAGE_NAME", examClass.TAG_IMAGE_NAME);
ht.Add("DEVICE", examClass.DEVICE);
ht.Add("SORT_ID", examClass.SORT_ID);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入对照记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MExamVsCharge model = new MExamVsCharge();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
model = (MExamVsCharge)ht2[i];
ht.Add("EXAM_ITEM_CODE", model.EXAM_ITEM_CODE);
ht.Add("CHARGE_ITEM_NO", model.CHARGE_ITEM_NO);
ht.Add("CHARGE_ITEM_CODE", model.CHARGE_ITEM_CODE);
ht.Add("CHARGE_ITEM_SPEC", model.CHARGE_ITEM_SPEC);
ht.Add("AMOUNT", model.AMOUNT);
ht.Add("UNITS", model.UNITS);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
public override int Add(IModel iQcMri)
{
MQcMri qcMri = (MQcMri)iQcMri;
Hashtable ht = new Hashtable();
ht.Add("BASE_ASH_FOG_VALUE", qcMri.BASE_ASH_FOG_VALUE);
ht.Add("BRIM_BACKGROUND_DENSITY", qcMri.BRIM_BACKGROUND_DENSITY);
ht.Add("DEVICE_SHADOW", qcMri.DEVICE_SHADOW);
ht.Add("DISTINCTION", qcMri.DISTINCTION);
ht.Add("EXAM_ACCESSION_NUM", qcMri.EXAM_ACCESSION_NUM);
ht.Add("EXTERNA_METAL_SHADOW", qcMri.EXTERNA_METAL_SHADOW);
ht.Add("FAST_CONSULT", qcMri.FAST_CONSULT);
ht.Add("FILM_FORMAT", qcMri.FILM_FORMAT);
ht.Add("HIST_CONTRAST", qcMri.HIST_CONTRAST);
ht.Add("INF_CRITERION", qcMri.INF_CRITERION);
ht.Add("NUMBER_KEY", qcMri.NUMBER_KEY);
ht.Add("OPE_RESULT", qcMri.OPE_RESULT);
ht.Add("PATIENT_ID", qcMri.PATIENT_ID);
ht.Add("PATIENT_LOCAL_ID", qcMri.PATIENT_LOCAL_ID);
ht.Add("PATIENT_NAME", qcMri.PATIENT_NAME);
ht.Add("PATIENT_SEX", qcMri.PATIENT_SEX);
ht.Add("POSTURE_CHOICE", qcMri.POSTURE_CHOICE);
ht.Add("QC_DATE", qcMri.QC_DATE);
ht.Add("RESOLUTION", qcMri.RESOLUTION);
ht.Add("SCANNING_MODE", qcMri.SCANNING_MODE);
ht.Add("SCANNING_SCOPE", qcMri.SCANNING_SCOPE);
ht.Add("SERIES_LEVEL_NUMBER", qcMri.SERIES_LEVEL_NUMBER);
ht.Add("STRUCTURE_RESOLUTION", qcMri.STRUCTURE_RESOLUTION);
ht.Add("STUDY_DATE_TIME", qcMri.STUDY_DATE_TIME);
ht.Add("TOTAL_SCORE", qcMri.TOTAL_SCORE);
ht.Add("VISCERA_SCANNING", qcMri.VISCERA_SCANNING);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 批量插入系统功能记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MSystemFun MsysFun = new MSystemFun();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MsysFun = (MSystemFun)ht2[i];
ht.Add("MODEL_ID", MsysFun.MODEL_ID);
ht.Add("UP_MODEL_ID", MsysFun.UP_MODEL_ID);
ht.Add("MODEL_CLASS", MsysFun.MODEL_CLASS);
ht.Add("DEL_FLAG", MsysFun.DEL_FLAG);
ht.Add("SORT_FLAG", MsysFun.SORT_FLAG);
ht.Add("MODEL_PLACE", MsysFun.MODEL_PLACE);
ht.Add("MODEL_NAME", MsysFun.MODEL_NAME);
ht.Add("IMAGE_ADDRESS", MsysFun.IMAGE_ADDRESS);
htstr.Add(i, StringConstructor.InsertSql(cp.Uid + "." + TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入检查项目记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MExamItemDict examItemDict = new MExamItemDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
examItemDict = (MExamItemDict)ht2[i];
ht.Add("EXAM_ITEM_CODE", examItemDict.EXAM_ITEM_CODE);
ht.Add("EXAM_ITEM_NAME", examItemDict.EXAM_ITEM_NAME);
ht.Add("INPUT_CODE", examItemDict.INPUT_CODE);
ht.Add("EXAM_CLASS", examItemDict.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examItemDict.EXAM_SUB_CLASS);
ht.Add("SORT_ID", examItemDict.SORT_ID);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// ÅúÁ¿²åÈëÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MReqScanImage scanImage = new MReqScanImage();
Hashtable ht = new Hashtable();
int j = 0;
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
scanImage = (MReqScanImage)ht2[i];
ht.Add("EXAM_NO", scanImage.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", scanImage.IMAGE_INDEX);
ht.Add("IMAGE_FILE", scanImage.IMAGE_FILE);
ht.Add("OPERATOR", scanImage.OPERATOR);
j += ExecuteSql(StringConstructor.InsertSql(TableName, ht), ht);
}
return(j);
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入临床医生记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MClinicDoctorDict MDoctorDict = new MClinicDoctorDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MDoctorDict = (MClinicDoctorDict)ht2[i];
ht.Add("CLINIC_DOCTOR_ID", MDoctorDict.CLINIC_DOCTOR_ID);
ht.Add("CLINIC_DOCTOR", MDoctorDict.CLINIC_DOCTOR);
ht.Add("CLINIC_OFFICE_ID", MDoctorDict.CLINIC_OFFICE_ID);
ht.Add("CLINIC_DOCTOR_PYCODE", MDoctorDict.CLINIC_DOCTOR_PYCODE);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入对照列表
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MUserExamClass MUserRol = new MUserExamClass();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MUserRol = ((MUserExamClass)ht2[i]);
ht.Add("DB_USER", MUserRol.DB_USER);
ht.Add("DEPT_NAME", MUserRol.DEPT_NAME);
ht.Add("EXAM_CLASS", MUserRol.EXAM_CLASS);
ht.Add("USER_DEPT", MUserRol.USER_DEPT);
ht.Add("REPORT_CAPABILITY", MUserRol.REPORT_CAPABILITY);
bool bl = Exists(MUserRol);
if (bl)
{
continue; //如果存在则不添加
}
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 批量插入影像设备记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MImgEquipment imgEquipment = new MImgEquipment();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
imgEquipment = (MImgEquipment)ht2[i];
ht.Add("IMG_EQUIPMENT_ID", imgEquipment.IMG_EQUIPMENT_ID);
ht.Add("IMG_EQUIPMENT_NAME", imgEquipment.IMG_EQUIPMENT_NAME);
ht.Add("CLINIC_OFFICE_CODE", imgEquipment.CLINIC_OFFICE_ID);
ht.Add("OFFICE", imgEquipment.OFFICE);
ht.Add("SERIAL_CLASS", imgEquipment.SERIAL_CLASS);
ht.Add("EQUIPMENT_STATE", imgEquipment.EQUIPMENT_STATE);
ht.Add("OPERATOR_DOCTOR", imgEquipment.OPERATOR_DOCTOR);
ht.Add("IP", imgEquipment.IP);
ht.Add("LAST_CALL", imgEquipment.LAST_CALL);
ht.Add("EQU_GUID", imgEquipment.EQU_GUID);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 插入一条预约记录
/// </summary>
/// <param name="ibespeak"></param>
/// <returns></returns>
public override int Add(IModel ibespeak)
{
MBespeak bespeak = (MBespeak)ibespeak;
Hashtable ht = new Hashtable();
ht.Add("BESPEAK_ID", bespeak.BESPEAK_ID);
ht.Add("PATIENT_ID", bespeak.PATIENT_ID);
ht.Add("PATIENT_NAME", bespeak.PATIENT_NAME);
ht.Add("PATIENT_SEX", bespeak.PATIENT_SEX);
ht.Add("PATIENT_AGE", bespeak.PATIENT_AGE);
ht.Add("PATIENT_AGE_UNIT", bespeak.PATIENT_AGE_UNIT);
ht.Add("IS_MARRIAGE", bespeak.IS_MARRIAGE);
ht.Add("PATIENT_SOURCE", bespeak.PATIENT_SOURCE);
ht.Add("INP_NO", bespeak.INP_NO);
ht.Add("BED_NO", bespeak.BED_NO);
ht.Add("CHARGES", bespeak.CHARGES);
ht.Add("CHARGE_CLASS", bespeak.CHARGE_CLASS);
ht.Add("REG_DOCTOR", bespeak.REG_DOCTOR);
ht.Add("QUEUE_NO", bespeak.QUEUE_NO);
ht.Add("BESPEAK_TIME", bespeak.BESPEAK_TIME);
ht.Add("EXAM_PART", bespeak.EXAM_PART);
ht.Add("EXAM_CLASS", bespeak.EXAM_CLASS);
ht.Add("PREGNANCY", bespeak.PREGNANCY);
ht.Add("REQ_DEPT", bespeak.REQ_DEPT);
ht.Add("REQ_DOCTOR", bespeak.REQ_DOCTOR);
ht.Add("RELATION", bespeak.RELATION);
ht.Add("CLINC_DIAG", bespeak.CLINIC_DIAG);
ht.Add("INSURANCE_NO", bespeak.INSURANCE_NO);
ht.Add("LAST_CATAMENIA", bespeak.LAST_CATAMENIA);
ht.Add("FLAG", bespeak.FLAG);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
public override int Add(IModel iQcDeptManDict)
{
MQcDeptManDict qcDeptManDict = (MQcDeptManDict)iQcDeptManDict;
Hashtable ht = new Hashtable();
ht.Add("CRITERION_INTEGRALITY", qcDeptManDict.CRITERION_INTEGRALITY);
ht.Add("DEDU_GIST_CRI_INT", qcDeptManDict.DEDU_GIST_CRI_INT);
ht.Add("DEDU_GIST_DIAG_RPT", qcDeptManDict.DEDU_GIST_DIAG_RPT);
ht.Add("DEDU_GIST_EME_EXAM", qcDeptManDict.DEDU_GIST_EME_EXAM);
ht.Add("DEDU_GIST_IMAGE_SYS", qcDeptManDict.DEDU_GIST_IMAGE_SYS);
ht.Add("DEDU_GIST_MAN_SYS", qcDeptManDict.DEDU_GIST_MAN_SYS);
ht.Add("DEDU_GIST_MANAGEMENT", qcDeptManDict.DEDU_GIST_MANAGEMENT);
ht.Add("DEDU_GIST_OS_RES", qcDeptManDict.DEDU_GIST_OS_RES);
ht.Add("DEDU_GIST_POST_TRAIN", qcDeptManDict.DEDU_GIST_POST_TRAIN);
ht.Add("DEDU_GIST_PRE_MEA", qcDeptManDict.DEDU_GIST_PRE_MEA);
ht.Add("DEDU_GIST_REG_STAT", qcDeptManDict.DEDU_GIST_REG_STAT);
ht.Add("DEDU_GIST_RY_LICENCE", qcDeptManDict.DEDU_GIST_RY_LICENCE);
ht.Add("DEDU_GIST_SER_ITEMS", qcDeptManDict.DEDU_GIST_SER_ITEMS);
ht.Add("DEDU_GIST_TITLES", qcDeptManDict.DEDU_GIST_TITLES);
ht.Add("DEPT_MAN_KEY", qcDeptManDict.DEPT_MAN_KEY);
ht.Add("DIAG_REPORT", qcDeptManDict.DIAG_REPORT);
ht.Add("EMERGENCY_EXAM", qcDeptManDict.EMERGENCY_EXAM);
ht.Add("IMAGE_SYSTEM", qcDeptManDict.IMAGE_SYSTEM);
ht.Add("MANAGEMENT", qcDeptManDict.MANAGEMENT);
ht.Add("MANAGEMENT_SYSTEM", qcDeptManDict.MANAGEMENT_SYSTEM);
ht.Add("OVERSEE_RESULT", qcDeptManDict.OVERSEE_RESULT);
ht.Add("POST_TRAIN", qcDeptManDict.POST_TRAIN);
ht.Add("PREVENTIVE_MEASURE", qcDeptManDict.PREVENTIVE_MEASURE);
ht.Add("QC_DATE", qcDeptManDict.QC_DATE);
ht.Add("REGISTER_STAT", qcDeptManDict.REGISTER_STAT);
ht.Add("RY_LICENCE", qcDeptManDict.RY_LICENCE);
ht.Add("SERVICES_ITEMS", qcDeptManDict.SERVICES_ITEMS);
ht.Add("TITLES", qcDeptManDict.TITLES);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条病人来源记录
/// </summary>
/// <param name="ipatientSource"></param>
/// <returns></returns>
public override int Add(IModel ipatientSource)
{
MPatientSource patientSource = (MPatientSource)ipatientSource;
Hashtable ht = new Hashtable();
ht.Add(" PATIENT_SOURCE_ID", patientSource.PATIENT_SOURCE_ID);
ht.Add("PATIENT_SOURCE", patientSource.PATIENT_SOURCE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条报告一体化记录
/// </summary>
/// <param name="ireportRelation"></param>
/// <returns></returns>
public override int Add(IModel ireportRelation)
{
MReportRelation reportRelation = (MReportRelation)ireportRelation;
Hashtable ht = new Hashtable();
ht.Add("EXAM_ACCESSION_NUM", reportRelation.EXAM_ACCESSION_NUM);
ht.Add("EXAM_ACCESSION_NUM_EX", reportRelation.EXAM_ACCESSION_NUM_EX);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条收费项目字典记录
/// </summary>
/// <param name="ichargeItemClassDict"></param>
/// <returns></returns>
public override int Add(IModel ichargeItemClassDict)
{
MChargeItemClassDict chargeItemClassDict = (MChargeItemClassDict)ichargeItemClassDict;
Hashtable ht = new Hashtable();
ht.Add("CLASS_CODE", chargeItemClassDict.CLASS_CODE);
ht.Add("CLASS_NAME", chargeItemClassDict.CLASS_NAME);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条收费类别记录
/// </summary>
/// <param name="ichargeclass"></param>
/// <returns></returns>
public override int Add(IModel ichargeclass)
{
MChargeClass chargeclass = (MChargeClass)ichargeclass;
Hashtable ht = new Hashtable();
ht.Add("CHARGE_TYPE_CODE", chargeclass.CHARGE_TYPE_CODE);
ht.Add("CHARGE_TYPE", chargeclass.CHARGE_TYPE);
ht.Add("CHARGE_RATIO", chargeclass.CHARGE_RATIO);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条对照记录
/// </summary>
/// <param name="ideptVsQueue"></param>
/// <returns></returns>
public override int Add(IModel ideptVsQueue)
{
MDeptVsQueue deptVsQueue = (MDeptVsQueue)ideptVsQueue;
Hashtable ht = new Hashtable();
ht.Add("QUEUE_ID", deptVsQueue.QUEUE_ID);
ht.Add("DEPT_CODE", deptVsQueue.DEPT_CODE);
ht.Add("QUEUE_NAME", deptVsQueue.QUEUE_NAME);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条行政区记录
/// </summary>
/// <param name="iarea"></param>
/// <returns></returns>
public override int Add(IModel iarea)
{
MAreaDict area = (MAreaDict)iarea;
Hashtable ht = new Hashtable();
ht.Add("AREA_CODE", area.AREA_CODE);
ht.Add("AREA_NAME", area.AREA_NAME);
ht.Add("INPUT_CODE", area.INPUT_CODE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条定位图像信息记录
/// </summary>
/// <param name="imodel"></param>
/// <returns></returns>
public override int Add(IModel imodel)
{
MLocationMapInf model = (MLocationMapInf)imodel;
Hashtable ht = new Hashtable();
ht.Add("LOATION_MAP_INF_ID", model.LOATION_MAP_INF_ID);
ht.Add("MAP_FILENAME", model.MAP_FILENAME);
ht.Add("MAP_PART", model.MAP_PART);
ht.Add("MAP_EXPLAIN", model.MAP_EXPLAIN);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条临床医生记录
/// </summary>
/// <param name="iclinicDoctorDict"></param>
/// <returns></returns>
public override int Add(IModel iclinicDoctorDict)
{
MClinicDoctorDict clinicDoctorDict = (MClinicDoctorDict)iclinicDoctorDict;
Hashtable ht = new Hashtable();
ht.Add("CLINIC_DOCTOR_ID", clinicDoctorDict.CLINIC_DOCTOR_ID);
ht.Add("CLINIC_DOCTOR", clinicDoctorDict.CLINIC_DOCTOR);
ht.Add("CLINIC_OFFICE_ID", clinicDoctorDict.CLINIC_OFFICE_ID);
ht.Add("CLINIC_DOCTOR_PYCODE", clinicDoctorDict.CLINIC_DOCTOR_PYCODE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// ²åÈëÒ»ÌõÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="imodel"></param>
/// <returns></returns>
public override int Add(IModel imodel)
{
MReqScanImage model = (MReqScanImage)imodel;
Hashtable ht = new Hashtable();
ht.Add("EXAM_NO", model.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", model.IMAGE_INDEX);
ht.Add("IMAGE_FILE", model.IMAGE_FILE);
ht.Add("OPERATOR", model.OPERATOR);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条病人信息与本地ID对照记录
/// </summary>
/// <param name="ipatientInfLocalId"></param>
/// <returns></returns>
public override int Add(IModel ipatientInfLocalId)
{
MPatientInfLocalId patientInfLocalId = (MPatientInfLocalId)ipatientInfLocalId;
Hashtable ht = new Hashtable();
ht.Add("PATIENT_ID", patientInfLocalId.PATIENT_ID);
ht.Add("LOCAL_ID_CLASS", patientInfLocalId.LOCAL_ID_CLASS);
ht.Add("PATIENT_LOCAL_ID", patientInfLocalId.PATIENT_LOCAL_ID);
ht.Add("EXAM_TIMES", patientInfLocalId.EXAM_TIMES);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条用户角色记录
/// </summary>
/// <param name="iusers_role"></param>
/// <returns></returns>
public override int Add(IModel iusers_role)
{
MUsersRole users_role = (MUsersRole)iusers_role;
Hashtable ht = new Hashtable();
ht.Add("ROLE_ID", users_role.ROLE_ID);
ht.Add("ROLE_NAME", users_role.ROLE_NAME);
ht.Add("EXAM_CLASS", users_role.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", users_role.EXAM_SUB_CLASS);
ht.Add("FUN_MODEL", users_role.FUN_MODEL);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条对照记录
/// </summary>
/// <param name="iuserExamClass"></param>
/// <returns></returns>
public override int Add(IModel iuserExamClass)
{
MUserExamClass userExamClass = (MUserExamClass)iuserExamClass;
Hashtable ht = new Hashtable();
ht.Add("DB_USER", userExamClass.DB_USER);
ht.Add("DEPT_NAME", userExamClass.DEPT_NAME);
ht.Add("EXAM_CLASS", userExamClass.EXAM_CLASS);
ht.Add("USER_DEPT", userExamClass.USER_DEPT);
ht.Add("REPORT_CAPABILITY", userExamClass.REPORT_CAPABILITY);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 插入一条检查项目记录
/// </summary>
/// <param name="iexamItemDict"></param>
/// <returns></returns>
public override int Add(IModel iexamItemDict)
{
MExamItemDict examItemDict = (MExamItemDict)iexamItemDict;
Hashtable ht = new Hashtable();
ht.Add("EXAM_ITEM_CODE", examItemDict.EXAM_ITEM_CODE);
ht.Add("EXAM_ITEM_NAME", examItemDict.EXAM_ITEM_NAME);
ht.Add("INPUT_CODE", examItemDict.INPUT_CODE);
ht.Add("EXAM_CLASS", examItemDict.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examItemDict.EXAM_SUB_CLASS);
ht.Add("SORT_ID", examItemDict.SORT_ID);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}