コード例 #1
0
 private void FindPatientIDbyMaLanKham(string malankham)
 {
     try
     {
         QueryCommand cmd = KcbDanhsachBenhnhan.CreateQuery().BuildCommand();
         cmd.CommandType = CommandType.Text;
         cmd.CommandSql =
             "Select id_benhnhan,ten_benhnhan,gioi_tinh from kcb_danhsach_benhnhan p where exists(select 1 from kcb_luotkham where id_benhnhan=P.id_benhnhan and ma_luotkham like '%" +
             malankham + "%')";
         DataTable temdt = DataService.GetDataSet(cmd).Tables[0];
         if (temdt.Rows.Count <= 0) return;
         if (temdt.Rows.Count == 1)
         {
             AutoFindLastExamandFetchIntoControls(temdt.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), string.Empty);
         }
         else //Show dialog for select
         {
             var _ChonBN = new frm_CHON_BENHNHAN();
             _ChonBN.temdt = temdt;
             _ChonBN.ShowDialog();
             if (!_ChonBN.mv_bCancel)
             {
                 AutoFindLastExamandFetchIntoControls(_ChonBN.Patient_ID, string.Empty);
             }
         }
     }
     catch (Exception ex)
     {
         Utility.ShowMsg("FindPatient().Exception-->" + ex.Message);
     }
 }
コード例 #2
0
        private void FindPatient(string patient_ID)
        {
            try
            {
                QueryCommand cmd = KcbDanhsachBenhnhan.CreateQuery().BuildCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandSql =
                    "Select id_benhnhan,ten_benhnhan,gioi_tinh from kcb_danhsach_benhnhan where id_benhnhan like '%" +
                    patient_ID + "%'";

                DataTable temdt = DataService.GetDataSet(cmd).Tables[0];
                if (temdt.Rows.Count == 1)
                {
                    AutoFindLastExamandFetchIntoControls(temdt.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), string.Empty);
                }
                else //Show dialog for select
                {
                    DataRow[] arrDr = temdt.Select("id_benhnhan=" + patient_ID);
                    if (arrDr.Length == 1)
                        AutoFindLastExamandFetchIntoControls(arrDr[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), string.Empty);
                    else
                    {
                        var _ChonBN = new frm_CHON_BENHNHAN();
                        _ChonBN.temdt = temdt;
                        _ChonBN.ShowDialog();
                        if (!_ChonBN.mv_bCancel)
                        {
                            AutoFindLastExamandFetchIntoControls(_ChonBN.Patient_ID, string.Empty);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg("FindPatient().Exception-->" + ex.Message);
            }
        }
コード例 #3
0
 private void FindPatientIDbyCMT(string CMT)
 {
     try
     {
         DataTable temdt = SPs.KcbTimkiembenhnhantheosocmt(CMT).GetDataSet().Tables[0];
         if (temdt.Rows.Count <= 0) return;
         if (temdt.Rows.Count == 1)
         {
             AutoFindLastExamandFetchIntoControls(temdt.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), string.Empty);
         }
         else //Show dialog for select
         {
             DataRow[] arrDr = temdt.Select(KcbDanhsachBenhnhan.Columns.Cmt+ "='" + CMT + "'");
             if (arrDr.Length == 1)
                 AutoFindLastExamandFetchIntoControls(arrDr[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), string.Empty);
             else
             {
                 var _ChonBN = new frm_CHON_BENHNHAN();
                 _ChonBN.temdt = temdt;
                 _ChonBN.ShowDialog();
                 if (!_ChonBN.mv_bCancel)
                 {
                     AutoFindLastExamandFetchIntoControls(_ChonBN.Patient_ID, string.Empty);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         Utility.ShowMsg("FindPatient().Exception-->" + ex.Message);
     }
 }
コード例 #4
0
        private void FindPatientIDbyBHYT(string Insurance_Num)
        {
            try
            {

                DataTable temdt = SPs.KcbTimkiembenhnhantheomathebhyt(Insurance_Num).GetDataSet().Tables[0];
                if (temdt.Rows.Count <= 0) return;
                if (temdt.Rows.Count == 1)
                {
                    //AutoFindLastExamandFetchIntoControls(temdt.Rows[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), Insurance_Num);
                }
                else //Show dialog for select
                {
                    DataRow[] arrDr = temdt.Select(KcbLuotkham.Columns.MatheBhyt + "='" + Insurance_Num + "'");
                    if (arrDr.Length == 1)
                    {
                        //AutoFindLastExamandFetchIntoControls(arrDr[0][KcbDanhsachBenhnhan.Columns.IdBenhnhan].ToString(), Insurance_Num);
                    }
                    else
                    {
                        var _ChonBN = new frm_CHON_BENHNHAN();
                        _ChonBN.temdt = temdt;
                        _ChonBN.ShowDialog();
                        if (!_ChonBN.mv_bCancel)
                        {
                            //AutoFindLastExamandFetchIntoControls(_ChonBN.Patient_ID, Insurance_Num);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg("FindPatient().Exception-->" + ex.Message);
            }
        }