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())); }
public override bool Exists(IModel iQcMri) { MQcMri qcMri = (MQcMri)iQcMri; strSql = "select * from " + TableName + " where EXAM_ACCESSION_NUM='" + qcMri.EXAM_ACCESSION_NUM + "'"; return(recordIsExist(strSql)); }
private bool SelectMRI(ref ArrayList ExamAccessionNum) { BQcMri bqcmri = new BQcMri(); bool bl = false; for (int i = 0; i < this.dgv_study.SelectedRows.Count; i++) { MQcMri mqcmri = new MQcMri(); mqcmri.EXAM_ACCESSION_NUM = dgv_study.SelectedRows[i].Cells["EXAM_ACCESSION_NUM"].Value.ToString(); bool bl1 = bqcmri.Exists(mqcmri); if (!bl1) { MQcInformation mqcInfor = new MQcInformation(); mqcInfor.EXAM_ACCESSION_NUM = this.dgv_study.SelectedRows[i].Cells["EXAM_ACCESSION_NUM"].Value.ToString(); mqcInfor.LOCAL_ID = this.dgv_study.SelectedRows[i].Cells["STUDY_ID"].Value.ToString(); mqcInfor.NAME = this.dgv_study.SelectedRows[i].Cells["PATIENT_NAME"].Value.ToString(); mqcInfor.SEX = this.dgv_study.SelectedRows[i].Cells["PATIENT_SEX"].Value.ToString(); mqcInfor.STUDY_DATE_TIME = this.dgv_study.SelectedRows[i].Cells["STUDY_DATE_TIME"].Value.ToString(); mqcInfor.PATIENT_ID = this.dgv_study.SelectedRows[i].Cells["PATIENT_ID"].Value.ToString(); ExamAccessionNum.Add(mqcInfor); } else { bl = true; } } return(bl); }
public override int AddMore(Hashtable ht2)//批量插入 { MQcMri qcMri = new MQcMri(); Hashtable ht = new Hashtable(); Hashtable htstr = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); qcMri = (MQcMri)ht2[i]; 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); htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString()); } return(ExecuteNonSql(htstr)); } else { return(0); } }
public override IModel GetModel(string EXAM_ACCESSION_NUM) { strSql = "select * from " + TableName + " where EXAM_ACCESSION_NUM='" + EXAM_ACCESSION_NUM + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MQcMri qcMri = new MQcMri(); if (dt.Rows[0]["BASE_ASH_FOG_VALUE"] == null) { qcMri.BASE_ASH_FOG_VALUE = null; } else { qcMri.BASE_ASH_FOG_VALUE = Convert.ToInt32(dt.Rows[0]["BASE_ASH_FOG_VALUE"].ToString()); } if (dt.Rows[0]["BRIM_BACKGROUND_DENSITY"] == null) { qcMri.BRIM_BACKGROUND_DENSITY = null; } else { qcMri.BRIM_BACKGROUND_DENSITY = Convert.ToInt32(dt.Rows[0]["BRIM_BACKGROUND_DENSITY"].ToString()); } if (dt.Rows[0]["DEVICE_SHADOW"] == null) { qcMri.DEVICE_SHADOW = null; } else { qcMri.DEVICE_SHADOW = Convert.ToInt32(dt.Rows[0]["DEVICE_SHADOW"].ToString()); } if (dt.Rows[0]["DISTINCTION"] == null) { qcMri.DISTINCTION = null; } else { qcMri.DISTINCTION = Convert.ToInt32(dt.Rows[0]["DISTINCTION"].ToString()); } qcMri.EXAM_ACCESSION_NUM = dt.Rows[0]["EXAM_ACCESSION_NUM"].ToString(); if (dt.Rows[0]["EXTERNA_METAL_SHADOW"] == null) { qcMri.EXTERNA_METAL_SHADOW = null; } else { qcMri.EXTERNA_METAL_SHADOW = Convert.ToInt32(dt.Rows[0]["EXTERNA_METAL_SHADOW"].ToString()); } if (dt.Rows[0]["FAST_CONSULT"] == null) { qcMri.FAST_CONSULT = null; } else { qcMri.FAST_CONSULT = Convert.ToInt32(dt.Rows[0]["FAST_CONSULT"].ToString()); } if (dt.Rows[0]["FILM_FORMAT"] == null) { qcMri.FILM_FORMAT = null; } else { qcMri.FILM_FORMAT = Convert.ToInt32(dt.Rows[0]["FILM_FORMAT"].ToString()); } if (dt.Rows[0]["HIST_CONTRAST"] == null) { qcMri.HIST_CONTRAST = null; } else { qcMri.HIST_CONTRAST = Convert.ToInt32(dt.Rows[0]["HIST_CONTRAST"].ToString()); } if (dt.Rows[0]["INF_CRITERION"] == null) { qcMri.INF_CRITERION = null; } else { qcMri.INF_CRITERION = Convert.ToInt32(dt.Rows[0]["INF_CRITERION"].ToString()); } if (dt.Rows[0]["NUMBER_KEY"] == null) { qcMri.NUMBER_KEY = null; } else { qcMri.NUMBER_KEY = Convert.ToInt32(dt.Rows[0]["NUMBER_KEY"].ToString()); } if (dt.Rows[0]["OPE_RESULT"] == null) { qcMri.OPE_RESULT = null; } else { qcMri.OPE_RESULT = Convert.ToInt32(dt.Rows[0]["OPE_RESULT"].ToString()); } qcMri.PATIENT_ID = dt.Rows[0]["PATIENT_ID"].ToString(); qcMri.PATIENT_LOCAL_ID = dt.Rows[0]["PATIENT_LOCAL_ID"].ToString(); qcMri.PATIENT_NAME = dt.Rows[0]["PATIENT_NAME"].ToString(); qcMri.PATIENT_SEX = dt.Rows[0]["PATIENT_SEX"].ToString(); if (dt.Rows[0]["POSTURE_CHOICE"] == null) { qcMri.POSTURE_CHOICE = null; } else { qcMri.POSTURE_CHOICE = Convert.ToInt32(dt.Rows[0]["POSTURE_CHOICE"].ToString()); } if (dt.Rows[0]["QC_DATE"] == null) { qcMri.QC_DATE = null; } else { qcMri.QC_DATE = Convert.ToDateTime(dt.Rows[0]["QC_DATE"].ToString()); } if (dt.Rows[0]["RESOLUTION"] == null) { qcMri.RESOLUTION = null; } else { qcMri.RESOLUTION = Convert.ToInt32(dt.Rows[0]["RESOLUTION"].ToString()); } if (dt.Rows[0]["SCANNING_MODE"] == null) { qcMri.SCANNING_MODE = null; } else { qcMri.SCANNING_MODE = Convert.ToInt32(dt.Rows[0]["SCANNING_MODE"].ToString()); } if (dt.Rows[0]["SCANNING_SCOPE"] == null) { qcMri.SCANNING_SCOPE = null; } else { qcMri.SCANNING_SCOPE = Convert.ToInt32(dt.Rows[0]["SCANNING_SCOPE"].ToString()); } if (dt.Rows[0]["SERIES_LEVEL_NUMBER"] == null) { qcMri.SERIES_LEVEL_NUMBER = null; } else { qcMri.SERIES_LEVEL_NUMBER = Convert.ToInt32(dt.Rows[0]["SERIES_LEVEL_NUMBER"].ToString()); } if (dt.Rows[0]["STRUCTURE_RESOLUTION"] == null) { qcMri.STRUCTURE_RESOLUTION = null; } else { qcMri.STRUCTURE_RESOLUTION = Convert.ToInt32(dt.Rows[0]["STRUCTURE_RESOLUTION"].ToString()); } if (dt.Rows[0]["STUDY_DATE_TIME"] == null) { qcMri.STUDY_DATE_TIME = null; } else { qcMri.STUDY_DATE_TIME = Convert.ToDateTime(dt.Rows[0]["STUDY_DATE_TIME"].ToString()); } if (dt.Rows[0]["TOTAL_SCORE"] == null) { qcMri.TOTAL_SCORE = null; } else { qcMri.TOTAL_SCORE = Convert.ToInt32(dt.Rows[0]["TOTAL_SCORE"].ToString()); } if (dt.Rows[0]["VISCERA_SCANNING"] == null) { qcMri.VISCERA_SCANNING = null; } else { qcMri.VISCERA_SCANNING = Convert.ToInt32(dt.Rows[0]["VISCERA_SCANNING"].ToString()); } return(qcMri); }
private void btn_Save_Click(object sender, EventArgs e) { Hashtable ht = new Hashtable(); for (int i = 0; i < dtMRI.Rows.Count; i++) { if (dtMRI.Rows[i]["EXAM_ACCESSION_NUM"].ToString() == "" || dtMRI.Rows[i]["PATIENT_LOCAL_ID"].ToString() == "") { continue; } MQcMri mf = new MQcMri(); mf.EXAM_ACCESSION_NUM = dtMRI.Rows[i]["EXAM_ACCESSION_NUM"].ToString(); mf.PATIENT_ID = dtMRI.Rows[i]["PATIENT_ID"].ToString(); mf.PATIENT_LOCAL_ID = dtMRI.Rows[i]["PATIENT_LOCAL_ID"].ToString(); mf.PATIENT_NAME = dtMRI.Rows[i]["PATIENT_NAME"].ToString(); mf.PATIENT_SEX = dtMRI.Rows[i]["PATIENT_SEX"].ToString(); mf.STUDY_DATE_TIME = Convert.ToDateTime(dtMRI.Rows[i]["STUDY_DATE_TIME"]); mf.QC_DATE = DateTime.Now; mf.POSTURE_CHOICE = (decimal)dtMRI.Rows[i]["POSTURE_CHOICE"]; mf.SCANNING_SCOPE = (decimal)dtMRI.Rows[i]["SCANNING_SCOPE"]; mf.VISCERA_SCANNING = (decimal)dtMRI.Rows[i]["VISCERA_SCANNING"]; mf.RESOLUTION = (decimal)dtMRI.Rows[i]["RESOLUTION"]; mf.INF_CRITERION = (decimal)dtMRI.Rows[i]["INF_CRITERION"]; mf.SCANNING_MODE = (decimal)dtMRI.Rows[i]["SCANNING_MODE"]; mf.SERIES_LEVEL_NUMBER = (decimal)dtMRI.Rows[i]["SERIES_LEVEL_NUMBER"]; if (!string.IsNullOrEmpty(dtMRI.Rows[i]["BASE_ASH_FOG_VALUE"].ToString())) { mf.BASE_ASH_FOG_VALUE = (decimal)dtMRI.Rows[i]["BASE_ASH_FOG_VALUE"]; mf.BRIM_BACKGROUND_DENSITY = (decimal)dtMRI.Rows[i]["BRIM_BACKGROUND_DENSITY"]; mf.FILM_FORMAT = (decimal)dtMRI.Rows[i]["FILM_FORMAT"]; mf.OPE_RESULT = (decimal)dtMRI.Rows[i]["OPE_RESULT"]; mf.STRUCTURE_RESOLUTION = null; mf.HIST_CONTRAST = null; mf.FAST_CONSULT = null; mf.DEVICE_SHADOW = null; } else { mf.STRUCTURE_RESOLUTION = (decimal)dtMRI.Rows[i]["STRUCTURE_RESOLUTION"]; mf.HIST_CONTRAST = (decimal)dtMRI.Rows[i]["HIST_CONTRAST"]; mf.FAST_CONSULT = (decimal)dtMRI.Rows[i]["FAST_CONSULT"]; mf.DEVICE_SHADOW = (decimal)dtMRI.Rows[i]["DEVICE_SHADOW"]; mf.BASE_ASH_FOG_VALUE = null; mf.BRIM_BACKGROUND_DENSITY = null; mf.FILM_FORMAT = null; mf.OPE_RESULT = null; } mf.EXTERNA_METAL_SHADOW = Convert.ToDecimal(dtMRI.Rows[i]["EXTERNA_METAL_SHADOW"]); mf.TOTAL_SCORE = Convert.ToDecimal(dtMRI.Rows[i]["TOTAL_SCORE"]); mf.DISTINCTION = Convert.ToInt32(dtMRI.Rows[i]["DISTINCTION"]); ht.Add(i, mf); } int j = 0; if (isModify) { j = bqMri.UpdateMore(ht); if (j >= 0) { MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { j = bqMri.AddMore(ht); if (j >= 0) { MessageBoxEx.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); isModify = true; } else { MessageBoxEx.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }