public static void TestSubReport(string opYear, int opMonth, string directorID, string managerID) { frmPrint frmprint = new frmPrint(); List <DataTable> tbList = new List <DataTable>(); Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider); string strsql = ""; DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); //strsql = ReportQueries.QMonthlyProgress(opYear, opMonth, false, directorID, managerID); strsql = MonthlyProgress.GetQueryMonthlyProgress(opYear, opMonth, directorID, managerID); DataTable tb = db.GetDataTable(conn, strsql); frmprint.dataTable = tb; tb = CapitalWork.GetTableCapitalWorksMonthlyProgress(opYear, opMonth, directorID, managerID); tbList.Add(tb); strsql = KeyPerformanceIndex.GetMonthlyKPIProgressQuery(opYear, opMonth, directorID, managerID); tb = db.GetDataTable(conn, strsql); tbList.Add(tb); frmprint.subDataTable = tbList; frmprint.dataTable = tb; frmprint.reportName = @"rpt1.rdlc"; frmprint.Show(); }
public static void PrintCapitalWorksQBR(string cpw_year, int cpw_month) { frmPrint frmprint = new frmPrint(); frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month); frmprint.reportName = @"rptcpwqbr.rdlc"; frmprint.Show(); }
public static void PrintCapitalWorksCounil(string cpw_year, int cpw_month, string serviceID) { frmPrint frmprint = new frmPrint(); frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month, serviceID); frmprint.reportName = @"rptcpw_progressCouncil.rdlc"; frmprint.Show(); }
public static void PrintCapitalWorksMonthlyProgressByServicePlan(string cpw_year, int cpw_month) { frmPrint frmprint = new frmPrint(); frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month); frmprint.reportName = @"rptcpw_progress_by_service_plan.rdlc"; frmprint.Show(); }