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