C# (CSharp) Com_clDataContext.sp_cloudTCM_by_uid Exemples

Exemple #1

 private void Update_Data(string sUID)
 {
     if (sUID == string.Empty)
     {
         CPatient = null;
         DGMed    = null;
         DGLab    = null;
         DGQ01    = null;
         DGQ02    = null;
         DGQ03    = null;
         DGQ04    = null;
         DGQ05    = null;
         DGQ06    = null;
         DGQ07    = null;
         DGQ08    = null;
         DGQ09    = null;
         DGQ10    = null;
     }
     else
     {
         Com_clDataContext dc = new Com_clDataContext();
         CPatient = new CurrentPatient(sUID);
         DGMed    = dc.sp_meddata_by_uid(sUID).ToList <sp_meddata_by_uidResult>();
         DGLab    = dc.sp_labdata_by_uid(sUID).ToList <sp_labdata_by_uidResult>();
         DGQ01    = dc.sp_cloudmed_by_uid(sUID).ToList <sp_cloudmed_by_uidResult>();
         DGQ02    = dc.sp_cloudlab_by_uid(sUID).ToList <sp_cloudlab_by_uidResult>();
         DGQ03    = dc.sp_cloudDEN_by_uid(sUID).ToList <sp_cloudDEN_by_uidResult>();
         DGQ04    = dc.sp_cloudOP_by_uid(sUID).ToList <sp_cloudOP_by_uidResult>();
         DGQ05    = dc.sp_cloudTCM_by_uid(sUID).ToList <sp_cloudTCM_by_uidResult>();
         DGQ06    = dc.sp_cloudREH_by_uid(sUID).ToList <sp_cloudREH_by_uidResult>();
         DGQ07    = dc.sp_cloudDIS_by_uid(sUID).ToList <sp_cloudDIS_by_uidResult>();
         DGQ08    = dc.sp_cloudALL_by_uid(sUID).ToList <sp_cloudALL_by_uidResult>();
         DGQ09    = dc.sp_cloudSCH_R_by_uid(sUID).ToList <sp_cloudSCH_R_by_uidResult>();
         DGQ10    = dc.sp_cloudSCH_U_by_uid(sUID).ToList <sp_cloudSCH_U_by_uidResult>();
         // StrID: "2020/04/25 上午 02 診 015 號 - (H223505857) 陳俞潔"
         if (unPlug)
         {
             StrID = $"{DateTime.Now.ToString("g", CultureInfo.CurrentUICulture)} - ({_currentPatient.CID}) {_currentPatient.CNAME}";
         }
     }
 }