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 + "'");
}
}
