public override int Update(IModel iQcCt, string where)
{
MQcDeptManDict qcDeptManDict = (MQcDeptManDict)iQcCt;
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 批量更新检查类别记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(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.UpdateSql(TableName, ht, " where EXAM_CLASS='" + examClass.EXAM_CLASS + "' and EXAM_SUB_CLASS='" + examClass.EXAM_SUB_CLASS + "'"));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
/// <summary>
/// 批量更新检查项目记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(Hashtable ht2)
{
MExamItemDict examItemDict = new MExamItemDict();
Hashtable htStr = new Hashtable();
Hashtable ht = 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.UpdateSql(TableName, ht, " where EXAM_ITEM_CODE = '" + examItemDict.EXAM_ITEM_CODE + "' and EXAM_SUB_CLASS = '" + examItemDict.EXAM_SUB_CLASS + "'"));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
/// <summary>
/// 批量更新系统功能记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(Hashtable ht2)
{
MSystemFun MSysFun = new MSystemFun();
Hashtable htStr = new Hashtable();
Hashtable ht = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MSysFun = (MSystemFun)ht2[i];
ht.Add("MODEL_NAME", MSysFun.MODEL_NAME);
ht.Add("MODEL_PLACE", MSysFun.MODEL_PLACE);
ht.Add("SORT_FLAG", MSysFun.SORT_FLAG);
ht.Add("IMAGE_ADDRESS", MSysFun.IMAGE_ADDRESS);
if (MSysFun.UP_MODEL_ID != null)
{
ht.Add("Up_MODEL_ID", MSysFun.UP_MODEL_ID);
}
htStr.Add(i, StringConstructor.UpdateSql(TableName, ht, " where MODEL_ID=" + MSysFun.MODEL_ID));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
public override int Update(IModel iQcMri, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定报告记录
/// </summary>
/// <param name="ireport"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ireport, string where)
{
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.UpdateSql(TableName, ht, where).ToString(), ht);
return(i);
}
/// <summary>
/// 更新指定的档案记录
/// </summary>
/// <param name="iarchives"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iarchives, string where)
{
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.UpdateSql(TableName, ht, where).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.UpdateSql(TableName_Sub, ht, where).ToString());
return(i);
}
/// <summary>
/// 批量更新用户记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(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.UpdateSql(TableName, ht, " where DOCTOR_ID='" + user.DOCTOR_ID + "'"));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
/// <summary>
/// 更新指定预约记录
/// </summary>
/// <param name="ibespeak"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ibespeak, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 批量更新影像设备记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(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.UpdateSql(TableName, ht, " where IMG_EQUIPMENT_ID = " + imgEquipment.IMG_EQUIPMENT_ID));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
/// <summary>
/// 批量更新临床科室记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int UpdateMore(Hashtable ht2)
{
MClinicOfficeDict MOfficeDict = new MClinicOfficeDict();
Hashtable htStr = new Hashtable();
Hashtable ht = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MOfficeDict = (MClinicOfficeDict)ht2[i];
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.UpdateSql(TableName, ht, " where CLINIC_OFFICE_ID=" + MOfficeDict.CLINIC_OFFICE_ID));
}
return(ExecuteNonSql(htStr));
}
return(0);
}
public override int Update(IModel iQcFilm, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定角色记录
/// </summary>
/// <param name="iusers_role"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iusers_role, string where)
{
MUsersRole users_role = (MUsersRole)iusers_role;
Hashtable ht = new Hashtable();
ht.Add("FUN_MODEL", users_role.FUN_MODEL);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的报告一体化记录
/// </summary>
/// <param name="ireportRelation"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ireportRelation, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的病人来源记录
/// </summary>
/// <param name="ipatientSource"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ipatientSource, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的收费项目字典记录
/// </summary>
/// <param name="ichargeItemClassDict"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ichargeItemClassDict, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的行政区记录
/// </summary>
/// <param name="iarea"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iarea, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定条件的收费类别记录
/// </summary>
/// <param name="ichargeclass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ichargeclass, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的对照记录
/// </summary>
/// <param name="ideptVsQueue"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ideptVsQueue, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// ¸üÐÂÖ¸¶¨µÄÉêÇ뵥ͼÏñ¼Ç¼
/// </summary>
/// <param name="iimage"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iimage, string where)
{
MReqScanImage image = (MReqScanImage)iimage;
Hashtable ht = new Hashtable();
ht.Add("EXAM_NO", image.EXAM_ACCESSION_NUM);
ht.Add("IMAGE_INDEX", image.IMAGE_INDEX);
ht.Add("IMAGE_FILE", image.IMAGE_FILE);
ht.Add("OPERATOR", image.OPERATOR);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的记录
/// </summary>
/// <param name="ipatientInfLocalId"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel ipatientInfLocalId, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的记录
/// </summary>
/// <param name="imodel"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel imodel, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的对照记录
/// </summary>
/// <param name="iuserExamClass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iuserExamClass, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的临床医生记录
/// </summary>
/// <param name="iclinicDoctorDict"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iclinicDoctorDict, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的对照记录
/// </summary>
/// <param name="imodel"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel imodel, string where)
{
MExamVsCharge model = (MExamVsCharge)imodel;
Hashtable ht = new Hashtable();
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);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
public override int Update(IModel iexamItemDict, string where)
{
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.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的用户科室记录
/// </summary>
/// <param name="iuserDeptDict"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iuserDeptDict, string where)
{
MUserDeptDict userDeptDict = (MUserDeptDict)iuserDeptDict;
Hashtable ht = new Hashtable();
ht.Add("DEPT_AREA", userDeptDict.DEPT_AREA);
ht.Add("DEPT_CODE", userDeptDict.DEPT_CODE);
ht.Add("DEPT_NAME", userDeptDict.DEPT_NAME);
ht.Add("RPT_HANDUP_STYLE", userDeptDict.RPT_HANDUP_STYLE);
ht.Add("RPT_ISSUANCE_STYLE", userDeptDict.RPT_ISSUANCE_STYLE);
ht.Add("STUDY_UID_HEADER", userDeptDict.STUDY_UID_HEADER);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
public override int Update(IModel iQcDigitalImage, string where)
{
MQcDigitalImage qcDigitalImage = (MQcDigitalImage)iQcDigitalImage;
Hashtable ht = new Hashtable();
ht.Add("DISTINCTION", qcDigitalImage.DISTINCTION);
ht.Add("EXAM_ACCESSION_NUM", qcDigitalImage.EXAM_ACCESSION_NUM);
ht.Add("EXPOSURE_DOSE", qcDigitalImage.EXPOSURE_DOSE);
ht.Add("EXTERNA_SHADOW", qcDigitalImage.EXTERNA_SHADOW);
ht.Add("FLAG_CONTENT", qcDigitalImage.FLAG_CONTENT);
ht.Add("FLAG_PLACE_ARRANGE", qcDigitalImage.FLAG_PLACE_ARRANGE);
ht.Add("IVP_DEVICE_SHADOW", qcDigitalImage.IVP_DEVICE_SHADOW);
ht.Add("IVP_FILM_POSTURE_PLACE", qcDigitalImage.IVP_FILM_POSTURE_PLACE);
ht.Add("IVP_HIST_CONTRAST", qcDigitalImage.IVP_HIST_CONTRAST);
ht.Add("IVP_PHOTOGRAPHS_ENOUGH", qcDigitalImage.IVP_PHOTOGRAPHS_ENOUGH);
ht.Add("IVP_PROJECTION_CENTRAGE", qcDigitalImage.IVP_PROJECTION_CENTRAGE);
ht.Add("IVP_RESOLUTION", qcDigitalImage.IVP_RESOLUTION);
ht.Add("KNUCKLE_ARRANGEMENT_FOCUS", qcDigitalImage.KNUCKLE_ARRANGEMENT_FOCUS);
ht.Add("KNUCKLE_DEVICE_SHADOW", qcDigitalImage.KNUCKLE_DEVICE_SHADOW);
ht.Add("KNUCKLE_IMAGE_DISTORTION", qcDigitalImage.KNUCKLE_IMAGE_DISTORTION);
ht.Add("KNUCKLE_LONG_AXIS_PARALLEL", qcDigitalImage.KNUCKLE_LONG_AXIS_PARALLEL);
ht.Add("KNUCKLE_PROJECTION", qcDigitalImage.KNUCKLE_PROJECTION);
ht.Add("KNUCKLE_RESOLUTION", qcDigitalImage.KNUCKLE_RESOLUTION);
ht.Add("KNUCKLE_WRAP", qcDigitalImage.KNUCKLE_WRAP);
ht.Add("NUMBER_KEY", qcDigitalImage.NUMBER_KEY);
ht.Add("PATIENT_ID", qcDigitalImage.PATIENT_ID);
ht.Add("PATIENT_LOCAL_ID", qcDigitalImage.PATIENT_LOCAL_ID);
ht.Add("PATIENT_NAME", qcDigitalImage.PATIENT_NAME);
ht.Add("PATIENT_SEX", qcDigitalImage.PATIENT_SEX);
ht.Add("QC_DATE", qcDigitalImage.QC_DATE);
ht.Add("STERNUM_ARRANGEMENT_FOCUS", qcDigitalImage.STERNUM_ARRANGEMENT_FOCUS);
ht.Add("STERNUM_BLADEBONE", qcDigitalImage.STERNUM_BLADEBONE);
ht.Add("STERNUM_BOARD", qcDigitalImage.STERNUM_BOARD);
ht.Add("STERNUM_BREAST", qcDigitalImage.STERNUM_BREAST);
ht.Add("STERNUM_DEVICE_SHADOW", qcDigitalImage.STERNUM_DEVICE_SHADOW);
ht.Add("STERNUM_IMAGE_DISTORTION", qcDigitalImage.STERNUM_IMAGE_DISTORTION);
ht.Add("STERNUM_LUNG_MARKINGS", qcDigitalImage.STERNUM_LUNG_MARKINGS);
ht.Add("STUDY_DATE_TIME", qcDigitalImage.STUDY_DATE_TIME);
ht.Add("TOTAL_SCORE", qcDigitalImage.TOTAL_SCORE);
ht.Add("UGI_BLEB", qcDigitalImage.UGI_BLEB);
ht.Add("UGI_CAVITY_LINE", qcDigitalImage.UGI_CAVITY_LINE);
ht.Add("UGI_CONTRAST", qcDigitalImage.UGI_CONTRAST);
ht.Add("UGI_DEVICE_SHADOW", qcDigitalImage.UGI_DEVICE_SHADOW);
ht.Add("UGI_FLOCCULENCE", qcDigitalImage.UGI_FLOCCULENCE);
ht.Add("UGI_INDICATION_RANGE", qcDigitalImage.UGI_INDICATION_RANGE);
ht.Add("UGI_MUCOSAL_FOLD", qcDigitalImage.UGI_MUCOSAL_FOLD);
ht.Add("UGI_PATIENT_TYPE", qcDigitalImage.UGI_PATIENT_TYPE);
ht.Add("UGI_PHOTOGRAPHS_ENOUGH", qcDigitalImage.UGI_PHOTOGRAPHS_ENOUGH);
ht.Add("UGI_PROJECTION_CASE", qcDigitalImage.UGI_PROJECTION_CASE);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的检查类别的记录
/// </summary>
/// <param name="iexamClass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iexamClass, string where)
{
MExamClass examClass = (MExamClass)iexamClass;
Hashtable ht = new Hashtable();
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("PRINT_PATTERN_CLASS", examClass.PRINT_PATTERN_CLASS);
ht.Add("DEVICE", examClass.DEVICE);
ht.Add("SORT_ID", examClass.SORT_ID);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
/// <summary>
/// 更新指定的科室数据字典
/// </summary>
/// <param name="iDeptDataDict"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iDeptDataDict, string where)
{
MDeptDataDict deptDataDict = (MDeptDataDict)iDeptDataDict;
Hashtable ht = new Hashtable();
ht.Add("AUTHOR", deptDataDict.AUTHOR);
ht.Add("CREATE_DATE_TIME", deptDataDict.CREATE_DATE_TIME);
ht.Add("DATA", deptDataDict.DATA);
ht.Add("DATA_NAME", deptDataDict.DATA_NAME);
ht.Add("DATA_TYPE", deptDataDict.DATA_TYPE);
ht.Add("DEPT_CODE", deptDataDict.DEPT_CODE);
ht.Add("MODIFY_DATE_TIME", deptDataDict.MODIFY_DATE_TIME);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}