Пример #1
0
 private DataTable GetPrintJob()
 {
     try
     {
         MpiSyncKunjunganQuery mskQ = new MpiSyncKunjunganQuery("a");
         //mskQ.es.Top = 50;
         mskQ.Select(mskQ.RegistrationNo, mskQ.MedicalNo, mskQ.PatientID, mskQ.CreatedDateTime, mskQ.CreatedByUser, mskQ.IsClosed, mskQ.IsDischarged, mskQ.IsEditedKunjungan, mskQ.IsNewKunjungan);
         mskQ.Where((mskQ.IsClosed == true || mskQ.IsDischarged == true || mskQ.IsEditedKunjungan == true || mskQ.IsNewKunjungan == true) && mskQ.IsSkipped == false);
         return mskQ.LoadDataTable();
         /*
         AppProgramQuery joinQuery = new AppProgramQuery("b");
         PrintJobQuery query2 = new PrintJobQuery("a");
         AppUserQuery query3 = new AppUserQuery("c");
         PrinterQuery query4 = new PrinterQuery("d");
         query2.InnerJoin(joinQuery).On(new object[] { joinQuery.ProgramID == query2.ProgramID });
         query2.InnerJoin(query3).On(new object[] { query2.UserID == query3.UserID });
         query2.InnerJoin(query4).On(new object[] { query2.PrinterID == query4.PrinterID });
         query2.Select(new object[] { query2.PrintNo, query4.PrinterName, query3.UserName, joinQuery.ProgramName });
         return query2.LoadDataTable();
         */
     }
     catch (Exception)
     {
     }
     return null;
 }
Пример #2
0
        private DataTable GetPrintJob()
        {
            try
            {
                MpiSyncKunjunganQuery mskQ = new MpiSyncKunjunganQuery("a");
                //mskQ.es.Top = 50;
                mskQ.Select(mskQ.RegistrationNo, mskQ.MedicalNo, mskQ.PatientID, mskQ.CreatedDateTime, mskQ.CreatedByUser, mskQ.IsClosed, mskQ.IsDischarged, mskQ.IsEditedKunjungan, mskQ.IsNewKunjungan);
                mskQ.Where((mskQ.IsClosed == true || mskQ.IsDischarged == true || mskQ.IsEditedKunjungan == true || mskQ.IsNewKunjungan == true) && mskQ.IsSkipped == false);
                return(mskQ.LoadDataTable());

                /*
                 * AppProgramQuery joinQuery = new AppProgramQuery("b");
                 * PrintJobQuery query2 = new PrintJobQuery("a");
                 * AppUserQuery query3 = new AppUserQuery("c");
                 * PrinterQuery query4 = new PrinterQuery("d");
                 * query2.InnerJoin(joinQuery).On(new object[] { joinQuery.ProgramID == query2.ProgramID });
                 * query2.InnerJoin(query3).On(new object[] { query2.UserID == query3.UserID });
                 * query2.InnerJoin(query4).On(new object[] { query2.PrinterID == query4.PrinterID });
                 * query2.Select(new object[] { query2.PrintNo, query4.PrinterName, query3.UserName, joinQuery.ProgramName });
                 * return query2.LoadDataTable();
                 */
            }
            catch (Exception)
            {
            }
            return(null);
        }