/// <summary>
/// 查询是否存在指定的临床科室记录
/// </summary>
/// <param name="iclinicOfficeDept"></param>
/// <returns></returns>
public override bool Exists(IModel iclinicOfficeDept)
{
MClinicOfficeDict clinicOfficeDict = (MClinicOfficeDict)iclinicOfficeDept;
strSql = "select * from " + TableName + " where CLINC_OFFICE_ID=" + clinicOfficeDict.CLINIC_OFFICE_ID;
return(recordIsExist(strSql));
}
/// <summary>
/// 批量插入临床科室记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MClinicOfficeDict MOfficeDict = new MClinicOfficeDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MOfficeDict = (MClinicOfficeDict)ht2[i];
ht.Add("CLINIC_OFFICE_ID", MOfficeDict.CLINIC_OFFICE_ID);
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.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
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());
MClinicOfficeDict MOfficeDict = new MClinicOfficeDict();
MOfficeDict.CLINIC_OFFICE_ID = Convert.ToInt32(GvDept.Rows[r].Cells["CLINIC_OFFICE_ID"].Value.ToString());
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["CLINIC_OFFICE"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE = GvDept.Rows[r].Cells["CLINIC_OFFICE"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["PATIENT_SOURCE_ID"].Value.ToString()))
{
MOfficeDict.PATIENT_SOURCE_ID = Convert.ToInt32(((DataGridViewComboBoxCell)GvDept.Rows[r].Cells["PATIENT_SOURCE_ID"]).Value.ToString());
}
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["CLINIC_OFFICE_CODE"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE_CODE = GvDept.Rows[r].Cells["CLINIC_OFFICE_CODE"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["CLINIC_OFFICE_FLAG"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE_FLAG = GvDept.Rows[r].Cells["CLINIC_OFFICE_FLAG"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["STUDY_UID_HEADER"].Value.ToString().Trim()))
{
MOfficeDict.STUDY_UID_HEADER = GvDept.Rows[r].Cells["STUDY_UID_HEADER"].Value.ToString().Trim();
}
if (ExpressionValidat.IsNumeric(GvDept.Rows[r].Cells["CUR_SERIAL_NUM"].Value.ToString()))
{
MOfficeDict.CUR_SERIAL_NUM = Convert.ToInt32(GvDept.Rows[r].Cells["CUR_SERIAL_NUM"].Value.ToString());
}
if (!string.IsNullOrEmpty(GvDept.Rows[r].Cells["CLINIC_OFFICE_PYCODE"].Value.ToString()))
{
MOfficeDict.CLINIC_OFFICE_PYCODE = GvDept.Rows[r].Cells["CLINIC_OFFICE_PYCODE"].Value.ToString().Trim();
}
htEdit.Add(k, MOfficeDict);
}
if (BOfficeDict.UpdateMore(htEdit) >= 0)
{
MessageBoxEx.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
htRow.Clear();
i = 0;
return(true);
}
private bool SaveData()//批量保存
{
Hashtable ht = new Hashtable();
if (GvDept.Rows.Count > rowcount - 1) //说明有新增行
{
for (int i = rowcount, j = 0; i <= GvDept.Rows.Count && j < GvDept.Rows.Count; i++, j++) //从第rowcount个开始保存
{
MClinicOfficeDict MOfficeDict = new MClinicOfficeDict();
MOfficeDict.CLINIC_OFFICE_ID = Convert.ToInt32(GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_ID"].Value.ToString());
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["CLINIC_OFFICE"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE = GvDept.Rows[i - 1].Cells["CLINIC_OFFICE"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["PATIENT_SOURCE_ID"].Value.ToString()))
{
MOfficeDict.PATIENT_SOURCE_ID = Convert.ToInt32(((DataGridViewComboBoxCell)GvDept.Rows[i - 1].Cells["PATIENT_SOURCE_ID"]).Value.ToString());
}
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_CODE"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE_CODE = GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_CODE"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_FLAG"].Value.ToString().Trim()))
{
MOfficeDict.CLINIC_OFFICE_FLAG = GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_FLAG"].Value.ToString().Trim();
}
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["STUDY_UID_HEADER"].Value.ToString().Trim()))
{
MOfficeDict.STUDY_UID_HEADER = GvDept.Rows[i - 1].Cells["STUDY_UID_HEADER"].Value.ToString().Trim();
}
if (ExpressionValidat.IsNumeric(GvDept.Rows[i - 1].Cells["CUR_SERIAL_NUM"].Value.ToString()))
{
MOfficeDict.CUR_SERIAL_NUM = Convert.ToInt32(GvDept.Rows[i - 1].Cells["CUR_SERIAL_NUM"].Value.ToString());
}
if (!string.IsNullOrEmpty(GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_PYCODE"].Value.ToString()))
{
MOfficeDict.CLINIC_OFFICE_PYCODE = GvDept.Rows[i - 1].Cells["CLINIC_OFFICE_PYCODE"].Value.ToString().Trim();
}
ht.Add(j, MOfficeDict);
}
}
if (ht.Count > 0)
{
if (BOfficeDict.AddMore(ht) > 0)
{
MessageBoxEx.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
}
/// <summary>
/// 插入一条临床科室记录
/// </summary>
/// <param name="iclinicOfficeDept"></param>
/// <returns></returns>
public override int Add(IModel iclinicOfficeDept)
{
MClinicOfficeDict clinicOfficeDept = (MClinicOfficeDict)iclinicOfficeDept;
Hashtable ht = new Hashtable();
ht.Add("CLINC_OFFICE_ID", clinicOfficeDept.CLINIC_OFFICE_ID);
ht.Add("CLINC_OFFICE", clinicOfficeDept.CLINIC_OFFICE);
ht.Add("PATIENT_SOURCE_ID", clinicOfficeDept.PATIENT_SOURCE_ID);
ht.Add("CLINIC_OFFICE_CODE", clinicOfficeDept.CLINIC_OFFICE_CODE);
ht.Add("CLINIC_OFFICE_FLAG", clinicOfficeDept.CLINIC_OFFICE_FLAG);
ht.Add("CUR_SERIAL_NUM", clinicOfficeDept.CUR_SERIAL_NUM);
ht.Add("STUDY_UID_HEADER", clinicOfficeDept.STUDY_UID_HEADER);
ht.Add("CLINIC_OFFICE_PYCODE", clinicOfficeDept.CLINIC_OFFICE_PYCODE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 获取检查申请号
/// 注意：mWorkList.EXAM_ACCESSION_NUM = mUserDeptDict.DEPT_AREA + mWorkList.ACCESSION_NO;，即检查申请序号=科室域+检查流水号，科室域：检查科室：RY，申请科室：CD
///mWorkList.STUDY_INSTANCE_UID = mUserDeptDict.STUDY_UID_HEADER + mWorkList.ACCESSION_NO;，即检查实例UID=检查UID头+检查流水号，检查流水号为数据库自动生成，为当前最大值
/// </summary>
/// <param name="ACCESSION_NO"></param>
/// <returns></returns>
public bool GetExamAccessionNum(IModel iWorklist)
{
MWorkList mWorkList = (MWorkList)iWorklist;
bool issuccess = true;
BClinicOfficeDict bClinicOfficeDict = new BClinicOfficeDict();
MClinicOfficeDict mClinicOfficeDict = (MClinicOfficeDict)bClinicOfficeDict.GetModel(mWorkList.EXAM_DEPT);
if ((mWorkList.EXAM_ACCESSION_NUM == null || mWorkList.EXAM_ACCESSION_NUM == "") && mClinicOfficeDict != null)
{
mWorkList.EXAM_ACCESSION_NUM = mClinicOfficeDict.CLINIC_OFFICE_FLAG + mWorkList.ACCESSION_NO;
mWorkList.STUDY_INSTANCE_UID = mClinicOfficeDict.STUDY_UID_HEADER + mWorkList.ACCESSION_NO;
}
else
{
issuccess = false;
}
return(issuccess);
}
/// <summary>
/// 获取指定临床科室ID的临床科室记录
/// </summary>
/// <param name="CLINC_OFFICE_ID"></param>
/// <returns></returns>
public override IModel GetModel2(string CLINC_OFFICE_ID)
{
strSql = "select * from " + TableName + " where CLINC_OFFICE_ID = " + CLINC_OFFICE_ID;
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MClinicOfficeDict clinicOfficeDict = new MClinicOfficeDict();
clinicOfficeDict.CLINIC_OFFICE_ID = Convert.ToInt32(dt.Rows[0]["CLINC_OFFICE_ID"].ToString());
clinicOfficeDict.CLINIC_OFFICE = dt.Rows[0]["CLINC_OFFICE"].ToString();
clinicOfficeDict.CLINIC_OFFICE_FLAG = dt.Rows[0]["CLINIC_OFFICE_FLAG"].ToString();
clinicOfficeDict.STUDY_UID_HEADER = dt.Rows[0]["STUDY_UID_HEADER"].ToString();
clinicOfficeDict.CLINIC_OFFICE_PYCODE = dt.Rows[0]["CLINIC_OFFICE_PYCODE"].ToString();
if (dt.Rows[0]["PATIENT_SOURCE_ID"].ToString() == "")
{
clinicOfficeDict.PATIENT_SOURCE_ID = null;
}
else
{
clinicOfficeDict.PATIENT_SOURCE_ID = Convert.ToInt32(dt.Rows[0]["PATIENT_SOURCE_ID"].ToString());
}
if (dt.Rows[0]["CUR_SERIAL_NUM"].ToString() == "")
{
clinicOfficeDict.CUR_SERIAL_NUM = null;
}
else
{
clinicOfficeDict.CUR_SERIAL_NUM = Convert.ToInt32(dt.Rows[0]["CUR_SERIAL_NUM"].ToString());
}
clinicOfficeDict.CLINIC_OFFICE_CODE = dt.Rows[0]["CLINIC_OFFICE_CODE"].ToString();
return(clinicOfficeDict);
}
