/// <summary>
/// 获取指定的临床医生ID的临床医生记录
/// </summary>
/// <param name="CLINC_DOCTOR_ID"></param>
/// <returns></returns>
public override IModel GetModel(string CLINC_DOCTOR_ID)
{
strSql = "select * from " + TableName + " where CLINIC_DOCTOR_ID ='" + CLINC_DOCTOR_ID + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MClinicDoctorDict clinicDoctorDict = new MClinicDoctorDict();
clinicDoctorDict.CLINIC_DOCTOR_ID = dt.Rows[0]["CLINIC_DOCTOR_ID"].ToString();
clinicDoctorDict.CLINIC_DOCTOR = dt.Rows[0]["CLINIC_DOCTOR"].ToString();
if (dt.Rows[0]["CLINIC_OFFICE_ID"].ToString() == "")
{
clinicDoctorDict.CLINIC_OFFICE_ID = null;
}
else
{
clinicDoctorDict.CLINIC_OFFICE_ID = Convert.ToInt32(dt.Rows[0]["CLINIC_OFFICE_ID"].ToString());
}
clinicDoctorDict.CLINIC_DOCTOR_PYCODE = dt.Rows[0]["CLINIC_DOCTOR_PYCODE"].ToString();
return(clinicDoctorDict);
}
/// <summary>
/// 查询是否存在指定的临床医生记录
/// </summary>
/// <param name="iclinicDoctorDict"></param>
/// <returns></returns>
public override bool Exists(IModel iclinicDoctorDict)
{
MClinicDoctorDict clinicDoctorDict = (MClinicDoctorDict)iclinicDoctorDict;
strSql = "select * from " + TableName + " where CLINIC_DOCTOR_ID='" + clinicDoctorDict.CLINIC_DOCTOR_ID + "'";
return(recordIsExist(strSql));
}
/// <summary>
/// 批量插入临床医生记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MClinicDoctorDict MDoctorDict = new MClinicDoctorDict();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MDoctorDict = (MClinicDoctorDict)ht2[i];
ht.Add("CLINIC_DOCTOR_ID", MDoctorDict.CLINIC_DOCTOR_ID);
ht.Add("CLINIC_DOCTOR", MDoctorDict.CLINIC_DOCTOR);
ht.Add("CLINIC_OFFICE_ID", MDoctorDict.CLINIC_OFFICE_ID);
ht.Add("CLINIC_DOCTOR_PYCODE", MDoctorDict.CLINIC_DOCTOR_PYCODE);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 插入一条临床医生记录
/// </summary>
/// <param name="iclinicDoctorDict"></param>
/// <returns></returns>
public override int Add(IModel iclinicDoctorDict)
{
MClinicDoctorDict clinicDoctorDict = (MClinicDoctorDict)iclinicDoctorDict;
Hashtable ht = new Hashtable();
ht.Add("CLINIC_DOCTOR_ID", clinicDoctorDict.CLINIC_DOCTOR_ID);
ht.Add("CLINIC_DOCTOR", clinicDoctorDict.CLINIC_DOCTOR);
ht.Add("CLINIC_OFFICE_ID", clinicDoctorDict.CLINIC_OFFICE_ID);
ht.Add("CLINIC_DOCTOR_PYCODE", clinicDoctorDict.CLINIC_DOCTOR_PYCODE);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
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());
MClinicDoctorDict MDoctorDict = new MClinicDoctorDict();
MDoctorDict.CLINIC_DOCTOR_ID = dgv_Doctor.Rows[r].Cells["CLINIC_DOCTOR_ID"].Value.ToString();
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[r].Cells["CLINIC_DOCTOR"].Value.ToString()))
{
MDoctorDict.CLINIC_DOCTOR = dgv_Doctor.Rows[r].Cells["CLINIC_DOCTOR"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[r].Cells["CLINIC_OFFICE_ID"].FormattedValue.ToString()))
{
MDoctorDict.CLINIC_OFFICE_ID = Convert.ToInt32(dgv_Doctor.Rows[r].Cells["CLINIC_OFFICE_ID"].Value.ToString());
}
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[r].Cells["CLINIC_DOCTOR_PYCODE"].FormattedValue.ToString()))
{
MDoctorDict.CLINIC_DOCTOR_PYCODE = dgv_Doctor.Rows[r].Cells["CLINIC_DOCTOR_PYCODE"].Value.ToString();
}
htEdit.Add(k, MDoctorDict);
}
if (BDoctorDict.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 (dgv_Doctor.Rows.Count > rowcount - 1) //说明有新增行
{
for (int i = rowcount, j = 0; i < dgv_Doctor.Rows.Count + 1 && j < dgv_Doctor.Rows.Count; i++, j++) //从第rowcount个开始保存
{
MClinicDoctorDict MDoctorDict = new MClinicDoctorDict();
MDoctorDict.CLINIC_DOCTOR_ID = dgv_Doctor.Rows[i - 1].Cells["CLINIC_DOCTOR_ID"].Value.ToString();
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[i - 1].Cells["CLINIC_DOCTOR"].FormattedValue.ToString()))
{
MDoctorDict.CLINIC_DOCTOR = dgv_Doctor.Rows[i - 1].Cells["CLINIC_DOCTOR"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[i - 1].Cells["CLINIC_OFFICE_ID"].FormattedValue.ToString()))
{
MDoctorDict.CLINIC_OFFICE_ID = Convert.ToInt32(dgv_Doctor.Rows[i - 1].Cells["CLINIC_OFFICE_ID"].Value.ToString());
}
if (!string.IsNullOrEmpty(dgv_Doctor.Rows[i - 1].Cells["CLINIC_DOCTOR_PYCODE"].FormattedValue.ToString()))
{
MDoctorDict.CLINIC_DOCTOR_PYCODE = dgv_Doctor.Rows[i - 1].Cells["CLINIC_DOCTOR_PYCODE"].Value.ToString();
}
ht.Add(j, MDoctorDict);
}
}
if (ht.Count > 0)
{
if (BDoctorDict.AddMore(ht) > 0)
{
MessageBoxEx.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
}
