private bool SaveData()//批量保存 { Hashtable ht = new Hashtable(); if (dgv_PatientSour.Rows.Count > rowcount) //说明有新增行 { for (int i = rowcount, j = 0; i < dgv_PatientSour.Rows.Count && j < dgv_PatientSour.Rows.Count; i++, j++) //从第rowcount个开始保存 { MPatientSource MPatientSour = new MPatientSource(); MPatientSour.PATIENT_SOURCE_ID = Convert.ToInt32(dgv_PatientSour.Rows[i - 1].Cells["PATIENT_SOURCE_ID"].Value.ToString()); if (!string.IsNullOrEmpty((dgv_PatientSour.Rows[i - 1].Cells["PATIENT_SOURCE"]).FormattedValue.ToString())) { MPatientSour.PATIENT_SOURCE = dgv_PatientSour.Rows[i - 1].Cells["PATIENT_SOURCE"].Value.ToString(); } ht.Add(j, MPatientSour); } } if (ht.Count > 0) { if (BPatientSour.AddMore(ht) > 0) { MessageBoxEx.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } return(true); }
/// <summary> /// 查询是否存在指定的病人来源记录 /// </summary> /// <param name="ipatientSource"></param> /// <returns></returns> public override bool Exists(IModel ipatientSource) { MPatientSource patientSource = (MPatientSource)ipatientSource; strSql = "select * from " + TableName + " where PATIENT_SOURCE_ID=" + patientSource.PATIENT_SOURCE_ID; return(recordIsExist(strSql)); }
private bool EditData()//批量修改 { Hashtable htEdit = new Hashtable(); int r = 0; if (htRow.Count > 0) { for (int k = 0; k < htRow.Count; k++) { r = Convert.ToInt32(htRow[k].ToString()); MPatientSource MPatientSour = new MPatientSource(); MPatientSour.PATIENT_SOURCE_ID = Convert.ToInt32(dgv_PatientSour.Rows[r].Cells["PATIENT_SOURCE_ID"].Value.ToString()); if (!string.IsNullOrEmpty((dgv_PatientSour.Rows[r].Cells["PATIENT_SOURCE"]).FormattedValue.ToString())) { MPatientSour.PATIENT_SOURCE = dgv_PatientSour.Rows[r].Cells["PATIENT_SOURCE"].Value.ToString(); } htEdit.Add(k, MPatientSour); } if (BPatientSour.UpdateMore(htEdit) >= 0) { MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } htRow.Clear(); i = 0; return(true); }
/// <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> /// 获取指定ID的病人来源记录 /// </summary> /// <param name="PATIENT_SOURCE_ID"></param> /// <returns></returns> public override IModel GetModel(string PATIENT_SOURCE_ID) { strSql = "select * from " + TableName + " where PATIENT_SOURCE_ID = " + PATIENT_SOURCE_ID; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MPatientSource patientSource = new MPatientSource(); patientSource.PATIENT_SOURCE_ID = Convert.ToInt32(dt.Rows[0]["PATIENT_SOURCE_ID"].ToString()); patientSource.PATIENT_SOURCE = dt.Rows[0]["PATIENT_SOURCE"].ToString(); return(patientSource); }
/// <summary> /// 批量更新病人来源记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int UpdateMore(Hashtable ht2) { MPatientSource patientSource = new MPatientSource(); Hashtable htStr = new Hashtable(); Hashtable ht = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); patientSource = (MPatientSource)ht2[i]; ht.Add(" PATIENT_SOURCE_ID", patientSource.PATIENT_SOURCE_ID); ht.Add("PATIENT_SOURCE", patientSource.PATIENT_SOURCE); htStr.Add(i, StringConstructor.UpdateSql(TableName, ht, " where PATIENT_SOURCE_ID=" + Convert.ToInt32(patientSource.PATIENT_SOURCE_ID))); } return(ExecuteNonSql(htStr)); } return(0); }
/// <summary> /// 批量插入病人来源记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int AddMore(Hashtable ht2) { MPatientSource patientSource = new MPatientSource(); Hashtable ht = new Hashtable(); Hashtable htstr = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); patientSource = (MPatientSource)ht2[i]; ht.Add("PATIENT_SOURCE_ID", patientSource.PATIENT_SOURCE_ID); ht.Add("PATIENT_SOURCE", patientSource.PATIENT_SOURCE); htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString()); } return(ExecuteNonSql(htstr)); } else { return(0); } }
private void WriteToStudy() { mStudy = new MStudy(); mStudy.PATIENT_ID = mWorklist.PATIENT_ID; mStudy.PATIENT_NAME = mWorklist.PATIENT_NAME; mStudy.PATIENT_SEX = mWorklist.PATIENT_SEX; mStudy.PATIENT_BIRTH = mWorklist.PATIENT_BIRTH; mStudy.PATIENT_AGE = mWorklist.PATIENT_AGE; mStudy.PATIENT_AGE_UNIT = mWorklist.PATIENT_AGE_UNIT; BPatientSource bps = new BPatientSource(); MPatientSource mps = (MPatientSource)bps.GetModel(mWorklist.PATIENT_SOURCE); mStudy.PATIENT_SOURCE = mps.PATIENT_SOURCE; mStudy.BIRTH_PLACE = mWorklist.BIRTH_PLACE; mStudy.IDENTITY = mWorklist.PATIENT_IDENTITY; mStudy.CHARGE_TYPE = mWorklist.CHARGE_TYPE.ToString(); mStudy.VISIT_ID = mWorklist.VISIT_ID; mStudy.INP_NO = mWorklist.INP_NO; mStudy.BED_NUM = mWorklist.BED_NUM; mStudy.ZIP_CODE = mWorklist.ZIP_CODE; mStudy.MAILING_ADDRESS = mWorklist.MAILING_ADDRESS; mStudy.TELEPHONE_NUMBER = mWorklist.TELEPHONE_NUM; mStudy.STUDY_ID = mWorklist.PATIENT_LOCAL_ID; mStudy.STUDY_INSTANCE_UID = mWorklist.STUDY_INSTANCE_UID + ".1985.7.5";//创建 mStudy.STUDY_DATE_TIME = DateTime.Now; mStudy.SERIES_COUNT = 0; mStudy.INSTANCE_COUNT = 0; mStudy.MODALITY = ILL.GetConfig.Modality; //配置文件中读取 mStudy.FACILITY = ""; //登陆时取得设备名 mStudy.REFER_DOCTOR = mWorklist.REFER_DOCTOR; mStudy.REFER_DEPT = mWorklist.REFER_DEPT; mStudy.REQ_MEMO = mWorklist.REQ_MEMO; mStudy.REQ_DATE_TIME = mWorklist.REQ_DATE_TIME; mStudy.REQ_DEPT_NAME = mWorklist.REQ_DEPT_NAME; mStudy.SCHEDULED_DATE = mWorklist.SCHEDULED_DATE; mStudy.SCH_OPERATOR = mWorklist.SCH_OPERATOR; mStudy.EXAM_NO = mWorklist.EXAM_NO; mStudy.EXAM_ACCESSION_NUM = mWorklist.EXAM_ACCESSION_NUM; mStudy.EXAM_CLASS = mWorklist.EXAM_CLASS; mStudy.EXAM_SUB_CLASS = mWorklist.EXAM_SUB_CLASS; mStudy.EXAM_ITEM = mWorklist.EXAM_ITEMS; mStudy.EXAM_MODE = mWorklist.EXAM_MODE; mStudy.EXAM_GROUP = mWorklist.EXAM_GROUP; mStudy.EXAM_DEPT_NAME = mWorklist.EXAM_DEPT_NAME; mStudy.EXAM_DOCTOR = mWorklist.EXAM_DOCTOR; mStudy.EXAM_INDEX = mWorklist.EXAM_INDEX; mStudy.IS_ONLINE = 1; mStudy.IS_MATCHED = 1; mStudy.IS_PACKPROCESS = 1; mStudy.REPORT_STATUS = 1; mStudy.APPROVER = "";//报告人--登陆者 mStudy.CLIN_DIAG = mWorklist.CLIN_DIAG; mStudy.CLIN_SYMP = mWorklist.CLIN_SYMP; mStudy.RELEVANT_DIAG = mWorklist.RELEVANT_DIAG; mStudy.RELEVANT_LAB_TEST = mWorklist.RELEVANT_LAB_TEST; mStudy.PHYS_SIGN = mWorklist.PHYS_SIGN; mStudy.DEVICE = mWorklist.DEVICE; if (!bStudy.Exists(mStudy)) { //bStudy.Update(mStudy, " Where EXAM_ACCESSION_NUM='" + mStudy.EXAM_ACCESSION_NUM + "'"); bStudy.Add(mStudy); } else { //bStudy.Update(mStudy, "EXAM_ACCESSION_NUM='" + mWorklist.EXAM_ACCESSION_NUM + "'"); } }