private bool SelectRY_DIAG_DICT(ref ArrayList ExamAccessionNum)
{
BQcRyDiagDict bqrd = new BQcRyDiagDict();
bool bl = false;
for (int i = 0; i < this.dgv_study.SelectedRows.Count; i++)
{
MQcRyDiagDict mqrd = new MQcRyDiagDict();
mqrd.EXAM_ACCESSION_NUM = dgv_study.SelectedRows[i].Cells["EXAM_ACCESSION_NUM"].Value.ToString();
bool bl1 = bqrd.Exists(mqrd);
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 bool Exists(IModel iQcRyDiagDict)
{
MQcRyDiagDict qcRyDiagDict = (MQcRyDiagDict)iQcRyDiagDict;
strSql = "select * from " + TableName + " where EXAM_ACCESSION_NUM='" + qcRyDiagDict.EXAM_ACCESSION_NUM + "'";
return(recordIsExist(strSql));
}
public override int Update(IModel iQcRyDiagDict, string where)
{
MQcRyDiagDict qcRyDiagDict = (MQcRyDiagDict)iQcRyDiagDict;
Hashtable ht = new Hashtable();
ht.Add("CT_POSITIVE_RATE", qcRyDiagDict.CT_POSITIVE_RATE);
ht.Add("DISTINCTION", qcRyDiagDict.DISTINCTION);
ht.Add("DRPT_AGE", qcRyDiagDict.DRPT_AGE);
ht.Add("DRPT_APP_DATE", qcRyDiagDict.DRPT_APP_DATE);
ht.Add("DRPT_APPROVER", qcRyDiagDict.DRPT_APPROVER);
ht.Add("DRPT_CLIN_DIAG", qcRyDiagDict.DRPT_CLIN_DIAG);
ht.Add("DRPT_DESCRIPTION", qcRyDiagDict.DRPT_DESCRIPTION);
ht.Add("DRPT_EXAM_ITEM", qcRyDiagDict.DRPT_EXAM_ITEM);
ht.Add("DRPT_EXAM_TEC", qcRyDiagDict.DRPT_EXAM_TEC);
ht.Add("DRPT_FILM_DATE", qcRyDiagDict.DRPT_FILM_DATE);
ht.Add("DRPT_IMPRESSION", qcRyDiagDict.DRPT_IMPRESSION);
ht.Add("DRPT_LOCAL_ID", qcRyDiagDict.DRPT_LOCAL_ID);
ht.Add("DRPT_NAME", qcRyDiagDict.DRPT_NAME);
ht.Add("DRPT_NUMBER", qcRyDiagDict.DRPT_NUMBER);
ht.Add("DRPT_RPT_DATE", qcRyDiagDict.DRPT_RPT_DATE);
ht.Add("DRPT_SEX", qcRyDiagDict.DRPT_SEX);
ht.Add("DRPT_TRANSCRIBER", qcRyDiagDict.DRPT_TRANSCRIBER);
ht.Add("EXAM_ACCESSION_NUM", qcRyDiagDict.EXAM_ACCESSION_NUM);
ht.Add("INQ_AGE", qcRyDiagDict.INQ_AGE);
ht.Add("INQ_DOCTOR", qcRyDiagDict.INQ_DOCTOR);
ht.Add("INQ_EXAM_ITEM_DIAG", qcRyDiagDict.INQ_EXAM_ITEM_DIAG);
ht.Add("INQ_LOCAL_ID", qcRyDiagDict.INQ_LOCAL_ID);
ht.Add("INQ_NAME", qcRyDiagDict.INQ_NAME);
ht.Add("INQ_NUMBER", qcRyDiagDict.INQ_NUMBER);
ht.Add("INQ_OPE_DATE", qcRyDiagDict.INQ_OPE_DATE);
ht.Add("INQ_OPERATION", qcRyDiagDict.INQ_OPERATION);
ht.Add("INQ_PATH_DESCRIPTION", qcRyDiagDict.INQ_PATH_DESCRIPTION);
ht.Add("INQ_PATH_DOCTOR", qcRyDiagDict.INQ_PATH_DOCTOR);
ht.Add("INQ_PATH_NO", qcRyDiagDict.INQ_PATH_NO);
ht.Add("INQ_SEX", qcRyDiagDict.INQ_SEX);
ht.Add("MR_POSITIVE_RATE", qcRyDiagDict.MR_POSITIVE_RATE);
ht.Add("NUMBER_KEY", qcRyDiagDict.NUMBER_KEY);
ht.Add("PATIENT_ID", qcRyDiagDict.PATIENT_ID);
ht.Add("PATIENT_LOCAL_ID", qcRyDiagDict.PATIENT_LOCAL_ID);
ht.Add("PATIENT_NAME", qcRyDiagDict.PATIENT_NAME);
ht.Add("PATIENT_SEX", qcRyDiagDict.PATIENT_SEX);
ht.Add("PITCH", qcRyDiagDict.PITCH);
ht.Add("QC_DATE", qcRyDiagDict.QC_DATE);
ht.Add("QUALITATIVE", qcRyDiagDict.QUALITATIVE);
ht.Add("STUDY_DATE_TIME", qcRyDiagDict.STUDY_DATE_TIME);
ht.Add("TOTAL_SCORE", qcRyDiagDict.TOTAL_SCORE);
ht.Add("XR_POSITIVE_RATE", qcRyDiagDict.XR_POSITIVE_RATE);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
public override int AddMore(Hashtable ht2)//批量插入
{
MQcRyDiagDict qcRyDiagDict = new MQcRyDiagDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
qcRyDiagDict = (MQcRyDiagDict)ht2[i];
ht.Add("CT_POSITIVE_RATE", qcRyDiagDict.CT_POSITIVE_RATE);
ht.Add("DISTINCTION", qcRyDiagDict.DISTINCTION);
ht.Add("DRPT_AGE", qcRyDiagDict.DRPT_AGE);
ht.Add("DRPT_APP_DATE", qcRyDiagDict.DRPT_APP_DATE);
ht.Add("DRPT_APPROVER", qcRyDiagDict.DRPT_APPROVER);
ht.Add("DRPT_CLIN_DIAG", qcRyDiagDict.DRPT_CLIN_DIAG);
ht.Add("DRPT_DESCRIPTION", qcRyDiagDict.DRPT_DESCRIPTION);
ht.Add("DRPT_EXAM_ITEM", qcRyDiagDict.DRPT_EXAM_ITEM);
ht.Add("DRPT_EXAM_TEC", qcRyDiagDict.DRPT_EXAM_TEC);
ht.Add("DRPT_FILM_DATE", qcRyDiagDict.DRPT_FILM_DATE);
ht.Add("DRPT_IMPRESSION", qcRyDiagDict.DRPT_IMPRESSION);
ht.Add("DRPT_LOCAL_ID", qcRyDiagDict.DRPT_LOCAL_ID);
ht.Add("DRPT_NAME", qcRyDiagDict.DRPT_NAME);
ht.Add("DRPT_NUMBER", qcRyDiagDict.DRPT_NUMBER);
ht.Add("DRPT_RPT_DATE", qcRyDiagDict.DRPT_RPT_DATE);
ht.Add("DRPT_SEX", qcRyDiagDict.DRPT_SEX);
ht.Add("DRPT_TRANSCRIBER", qcRyDiagDict.DRPT_TRANSCRIBER);
ht.Add("EXAM_ACCESSION_NUM", qcRyDiagDict.EXAM_ACCESSION_NUM);
ht.Add("INQ_AGE", qcRyDiagDict.INQ_AGE);
ht.Add("INQ_DOCTOR", qcRyDiagDict.INQ_DOCTOR);
ht.Add("INQ_EXAM_ITEM_DIAG", qcRyDiagDict.INQ_EXAM_ITEM_DIAG);
ht.Add("INQ_LOCAL_ID", qcRyDiagDict.INQ_LOCAL_ID);
ht.Add("INQ_NAME", qcRyDiagDict.INQ_NAME);
ht.Add("INQ_NUMBER", qcRyDiagDict.INQ_NUMBER);
ht.Add("INQ_OPE_DATE", qcRyDiagDict.INQ_OPE_DATE);
ht.Add("INQ_OPERATION", qcRyDiagDict.INQ_OPERATION);
ht.Add("INQ_PATH_DESCRIPTION", qcRyDiagDict.INQ_PATH_DESCRIPTION);
ht.Add("INQ_PATH_DOCTOR", qcRyDiagDict.INQ_PATH_DOCTOR);
ht.Add("INQ_PATH_NO", qcRyDiagDict.INQ_PATH_NO);
ht.Add("INQ_SEX", qcRyDiagDict.INQ_SEX);
ht.Add("MR_POSITIVE_RATE", qcRyDiagDict.MR_POSITIVE_RATE);
ht.Add("NUMBER_KEY", qcRyDiagDict.NUMBER_KEY);
ht.Add("PATIENT_ID", qcRyDiagDict.PATIENT_ID);
ht.Add("PATIENT_LOCAL_ID", qcRyDiagDict.PATIENT_LOCAL_ID);
ht.Add("PATIENT_NAME", qcRyDiagDict.PATIENT_NAME);
ht.Add("PATIENT_SEX", qcRyDiagDict.PATIENT_SEX);
ht.Add("PITCH", qcRyDiagDict.PITCH);
ht.Add("QC_DATE", qcRyDiagDict.QC_DATE);
ht.Add("QUALITATIVE", qcRyDiagDict.QUALITATIVE);
ht.Add("STUDY_DATE_TIME", qcRyDiagDict.STUDY_DATE_TIME);
ht.Add("TOTAL_SCORE", qcRyDiagDict.TOTAL_SCORE);
ht.Add("XR_POSITIVE_RATE", qcRyDiagDict.XR_POSITIVE_RATE);
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);
}
MQcRyDiagDict qcRyDiagDict = new MQcRyDiagDict();
if (dt.Rows[0]["CT_POSITIVE_RATE"] == null)
{
qcRyDiagDict.CT_POSITIVE_RATE = null;
}
else
{
qcRyDiagDict.CT_POSITIVE_RATE = Convert.ToInt32(dt.Rows[0]["CT_POSITIVE_RATE"].ToString());
}
if (dt.Rows[0]["DISTINCTION"] == null)
{
qcRyDiagDict.DISTINCTION = null;
}
else
{
qcRyDiagDict.DISTINCTION = Convert.ToInt32(dt.Rows[0]["DISTINCTION"].ToString());
}
if (dt.Rows[0]["DRPT_AGE"] == null)
{
qcRyDiagDict.DRPT_AGE = null;
}
else
{
qcRyDiagDict.DRPT_AGE = Convert.ToInt32(dt.Rows[0]["DRPT_AGE"].ToString());
}
if (dt.Rows[0]["DRPT_APP_DATE"] == null)
{
qcRyDiagDict.DRPT_APP_DATE = null;
}
else
{
qcRyDiagDict.DRPT_APP_DATE = Convert.ToInt32(dt.Rows[0]["DRPT_APP_DATE"].ToString());
}
if (dt.Rows[0]["DRPT_APPROVER"] == null)
{
qcRyDiagDict.DRPT_APPROVER = null;
}
else
{
qcRyDiagDict.DRPT_APPROVER = Convert.ToInt32(dt.Rows[0]["DRPT_APPROVER"].ToString());
}
if (dt.Rows[0]["DRPT_CLIN_DIAG"] == null)
{
qcRyDiagDict.DRPT_CLIN_DIAG = null;
}
else
{
qcRyDiagDict.DRPT_CLIN_DIAG = Convert.ToInt32(dt.Rows[0]["[DRPT_CLIN_DIAG"].ToString());
}
if (dt.Rows[0]["DRPT_DESCRIPTION"] == null)
{
qcRyDiagDict.DRPT_DESCRIPTION = null;
}
else
{
qcRyDiagDict.DRPT_DESCRIPTION = Convert.ToInt32(dt.Rows[0]["DRPT_DESCRIPTION"].ToString());
}
if (dt.Rows[0]["DRPT_EXAM_ITEM"] == null)
{
qcRyDiagDict.DRPT_EXAM_ITEM = null;
}
else
{
qcRyDiagDict.DRPT_EXAM_ITEM = Convert.ToInt32(dt.Rows[0]["DRPT_EXAM_ITEM"].ToString());
}
if (dt.Rows[0]["DRPT_EXAM_TEC"] == null)
{
qcRyDiagDict.DRPT_EXAM_TEC = null;
}
else
{
qcRyDiagDict.DRPT_EXAM_TEC = Convert.ToInt32(dt.Rows[0]["DRPT_EXAM_TEC"].ToString());
}
if (dt.Rows[0]["DRPT_FILM_DATE"] == null)
{
qcRyDiagDict.DRPT_FILM_DATE = null;
}
else
{
qcRyDiagDict.DRPT_FILM_DATE = Convert.ToInt32(dt.Rows[0]["DRPT_FILM_DATE"].ToString());
}
if (dt.Rows[0]["DRPT_IMPRESSION"] == null)
{
qcRyDiagDict.DRPT_IMPRESSION = null;
}
else
{
qcRyDiagDict.DRPT_IMPRESSION = Convert.ToInt32(dt.Rows[0]["DRPT_IMPRESSION"].ToString());
}
if (dt.Rows[0]["DRPT_LOCAL_ID"] == null)
{
qcRyDiagDict.DRPT_LOCAL_ID = null;
}
else
{
qcRyDiagDict.DRPT_LOCAL_ID = Convert.ToInt32(dt.Rows[0]["DRPT_LOCAL_ID"].ToString());
}
if (dt.Rows[0]["DRPT_NAME"] == null)
{
qcRyDiagDict.DRPT_NAME = null;
}
else
{
qcRyDiagDict.DRPT_NAME = Convert.ToInt32(dt.Rows[0]["DRPT_NAME"].ToString());
}
if (dt.Rows[0]["DRPT_NUMBER"] == null)
{
qcRyDiagDict.DRPT_NUMBER = null;
}
else
{
qcRyDiagDict.DRPT_NUMBER = Convert.ToInt32(dt.Rows[0]["DRPT_NUMBER"].ToString());
}
if (dt.Rows[0]["DRPT_RPT_DATE"] == null)
{
qcRyDiagDict.DRPT_RPT_DATE = null;
}
else
{
qcRyDiagDict.DRPT_RPT_DATE = Convert.ToInt32(dt.Rows[0]["DRPT_RPT_DATE"].ToString());
}
if (dt.Rows[0]["DRPT_SEX"] == null)
{
qcRyDiagDict.DRPT_SEX = null;
}
else
{
qcRyDiagDict.DRPT_SEX = Convert.ToInt32(dt.Rows[0]["DRPT_SEX"].ToString());
}
if (dt.Rows[0]["DRPT_TRANSCRIBER"] == null)
{
qcRyDiagDict.DRPT_TRANSCRIBER = null;
}
else
{
qcRyDiagDict.DRPT_TRANSCRIBER = Convert.ToInt32(dt.Rows[0]["DRPT_TRANSCRIBER"].ToString());
}
qcRyDiagDict.EXAM_ACCESSION_NUM = dt.Rows[0]["EXAM_ACCESSION_NUM"].ToString();
if (dt.Rows[0]["INQ_AGE"] == null)
{
qcRyDiagDict.INQ_AGE = null;
}
else
{
qcRyDiagDict.INQ_AGE = Convert.ToInt32(dt.Rows[0]["INQ_AGE"].ToString());
}
if (dt.Rows[0]["INQ_DOCTOR"] == null)
{
qcRyDiagDict.INQ_DOCTOR = null;
}
else
{
qcRyDiagDict.INQ_DOCTOR = Convert.ToInt32(dt.Rows[0]["INQ_DOCTOR"].ToString());
}
if (dt.Rows[0]["INQ_EXAM_ITEM_DIAG"] == null)
{
qcRyDiagDict.INQ_EXAM_ITEM_DIAG = null;
}
else
{
qcRyDiagDict.INQ_EXAM_ITEM_DIAG = Convert.ToInt32(dt.Rows[0]["INQ_EXAM_ITEM_DIAG"].ToString());
}
if (dt.Rows[0]["INQ_LOCAL_ID"] == null)
{
qcRyDiagDict.INQ_LOCAL_ID = null;
}
else
{
qcRyDiagDict.INQ_LOCAL_ID = Convert.ToInt32(dt.Rows[0]["INQ_LOCAL_ID"].ToString());
}
if (dt.Rows[0]["INQ_NAME"] == null)
{
qcRyDiagDict.INQ_NAME = null;
}
else
{
qcRyDiagDict.INQ_NAME = Convert.ToInt32(dt.Rows[0]["INQ_NAME"].ToString());
}
if (dt.Rows[0]["INQ_NUMBER"] == null)
{
qcRyDiagDict.INQ_NUMBER = null;
}
else
{
qcRyDiagDict.INQ_NUMBER = Convert.ToInt32(dt.Rows[0]["INQ_NUMBER"].ToString());
}
if (dt.Rows[0]["INQ_OPE_DATE"] == null)
{
qcRyDiagDict.INQ_OPE_DATE = null;
}
else
{
qcRyDiagDict.INQ_OPE_DATE = Convert.ToInt32(dt.Rows[0]["INQ_OPE_DATE"].ToString());
}
if (dt.Rows[0]["INQ_OPERATION"] == null)
{
qcRyDiagDict.INQ_OPERATION = null;
}
else
{
qcRyDiagDict.INQ_OPERATION = Convert.ToInt32(dt.Rows[0]["INQ_OPERATION"].ToString());
}
if (dt.Rows[0]["INQ_PATH_DESCRIPTION"] == null)
{
qcRyDiagDict.INQ_PATH_DESCRIPTION = null;
}
else
{
qcRyDiagDict.INQ_PATH_DESCRIPTION = Convert.ToInt32(dt.Rows[0]["INQ_PATH_DESCRIPTION"].ToString());
}
if (dt.Rows[0]["INQ_PATH_DOCTOR"] == null)
{
qcRyDiagDict.INQ_PATH_DOCTOR = null;
}
else
{
qcRyDiagDict.INQ_PATH_DOCTOR = Convert.ToInt32(dt.Rows[0]["INQ_PATH_DOCTOR"].ToString());
}
if (dt.Rows[0]["INQ_PATH_NO"] == null)
{
qcRyDiagDict.INQ_PATH_NO = null;
}
else
{
qcRyDiagDict.INQ_PATH_NO = Convert.ToInt32(dt.Rows[0]["INQ_PATH_NO"].ToString());
}
if (dt.Rows[0]["INQ_SEX"] == null)
{
qcRyDiagDict.INQ_SEX = null;
}
else
{
qcRyDiagDict.INQ_SEX = Convert.ToInt32(dt.Rows[0]["INQ_SEX"].ToString());
}
if (dt.Rows[0]["MR_POSITIVE_RATE"] == null)
{
qcRyDiagDict.MR_POSITIVE_RATE = null;
}
else
{
qcRyDiagDict.MR_POSITIVE_RATE = Convert.ToInt32(dt.Rows[0]["MR_POSITIVE_RATE"].ToString());
}
if (dt.Rows[0]["NUMBER_KEY"] == null)
{
qcRyDiagDict.NUMBER_KEY = null;
}
else
{
qcRyDiagDict.NUMBER_KEY = Convert.ToInt32(dt.Rows[0]["NUMBER_KEY"].ToString());
}
qcRyDiagDict.PATIENT_ID = dt.Rows[0]["PATIENT_ID"].ToString();
qcRyDiagDict.PATIENT_LOCAL_ID = dt.Rows[0]["PATIENT_LOCAL_ID"].ToString();
qcRyDiagDict.PATIENT_NAME = dt.Rows[0]["PATIENT_NAME"].ToString();
qcRyDiagDict.PATIENT_SEX = dt.Rows[0]["PATIENT_SEX"].ToString();
if (dt.Rows[0]["PITCH"] == null)
{
qcRyDiagDict.PITCH = null;
}
else
{
qcRyDiagDict.PITCH = Convert.ToInt32(dt.Rows[0]["PITCH"].ToString());
}
if (dt.Rows[0]["QC_DATE"] == null)
{
qcRyDiagDict.QC_DATE = null;
}
else
{
qcRyDiagDict.QC_DATE = Convert.ToDateTime(dt.Rows[0]["QC_DATE"].ToString());
}
if (dt.Rows[0]["QUALITATIVE"] == null)
{
qcRyDiagDict.QUALITATIVE = null;
}
else
{
qcRyDiagDict.QUALITATIVE = Convert.ToInt32(dt.Rows[0]["QUALITATIVE"].ToString());
}
if (dt.Rows[0]["STUDY_DATE_TIME"] == null)
{
qcRyDiagDict.STUDY_DATE_TIME = null;
}
else
{
qcRyDiagDict.STUDY_DATE_TIME = Convert.ToDateTime(dt.Rows[0]["STUDY_DATE_TIME"].ToString());
}
if (dt.Rows[0]["TOTAL_SCORE"] == null)
{
qcRyDiagDict.TOTAL_SCORE = null;
}
else
{
qcRyDiagDict.TOTAL_SCORE = Convert.ToInt32(dt.Rows[0]["TOTAL_SCORE"].ToString());
}
if (dt.Rows[0]["XR_POSITIVE_RATE"] == null)
{
qcRyDiagDict.XR_POSITIVE_RATE = null;
}
else
{
qcRyDiagDict.XR_POSITIVE_RATE = Convert.ToInt32(dt.Rows[0]["XR_POSITIVE_RATE"].ToString());
}
return(qcRyDiagDict);
}
