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