/// <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); }