private void tsbPrint_Click(object sender, EventArgs e) { //string strsql = ReportQueries.QMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, true); string strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth); clsReports.PrintMonthlyProgress(strsql); }
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(); }
private void FillActionGrid() { DataRowView dr = (DataRowView)cboManagerFrom.SelectedItem; if (string.IsNullOrEmpty(dr["director_id"].ToString()) || string.IsNullOrEmpty(dr["manager_id"].ToString())) { return; } string strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, dr["director_id"].ToString(), dr["manager_id"].ToString()); DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); DataTable tb = db.GetDataTable(conn, strsql); dgv01.Rows.Clear(); try { foreach (DataRow row in tb.Rows) { dgv01.Rows.Add(row["action_id"].ToString(), row["action_description"].ToString(), false ); } dgv01.CurrentCell = null; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void tsbPrint_Click(object sender, EventArgs e) { string strsql = ""; Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString()); //switch (rptType) switch (cboReportType.SelectedValue.ToString()) { //case "MonthlyProgress": case "1": if (cboDirector.SelectedValue.ToString() == "-0-" && cboManager.SelectedValue.ToString() == "-0-") { //strsql = ReportQueries.QMonthlyProgress(cboOPYear.Text, (int)m, true, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString()); strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m); } else { //strsql = ReportQueries.QMonthlyProgress(cboOPYear.Text, (int)m, false, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString()); strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString()); } clsReports.PrintMonthlyProgress(strsql); break; //case "ActionCompletedByTheme": case "2": strsql = ReportQueries.QActionCompletedByTheme(cboOPYear.Text, (int)m); DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); DataTable tb = db.GetDataTable(conn, strsql); if (tb.Rows.Count == 0) { strsql = ReportQueries.QActionCompletedByTheme(cboOPYear.Text); } clsReports.PrintActionByThemeGraph(strsql); break; //case "ActionCompletedByStatus": case "3": strsql = ReportQueries.QActionCompletedByStatus(cboOPYear.Text, (int)m); clsReports.PrintActionByStatusGraph(strsql); break; //case "PrintStrategyDashboard": case "4": strsql = ReportQueries.QPrintStrategyDashboard(cboOPYear.Text, (int)m); clsReports.PrintStrategyDashboard(strsql); break; } }
private void PrintSubReportyMonth() { Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString()); //string month = OPGlobals.currentMonth.ToString(); string year = cboOPYear.Text; string servicePlanSql = GetServicePlanForSubReporting(year, (int)m, cboServicePlan.SelectedValue.ToString()); //"Select A.id As service_plan_id, A.service_plan, B.actions As action, C.kpm As kpm, D.cwp As cwp From service_plan A" //+ " Left Join(Select action.service_plan_id, COUNT(*) As actions From action Group By action.service_plan_id) B" //+ " On B.service_plan_id = A.id Left Join (Select kpi.service_plan_id, COUNT(*) As kpm From kpi Group By kpi.service_plan_id) C" //+ " On C.service_plan_id = A.id Left Join (Select capital_works.capital_works_service_plann_id As service_plan_id, COUNT(*) As cwp From capital_works Group By capital_works.capital_works_service_plann_id) D" //+ " On D.service_plan_id = A.id where service_plan != '-NONE-';"; string actionSql = "", kpmSql = "", cwpSql = ""; actionSql = MonthlyProgress.GetQueryMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m); cwpSql = CapitalWork.GetSQLCapitalWorksMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m); kpmSql = KeyPerformanceIndex.GetMonthlyKPIProgressQuery(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m); clsReports.PrintSubReport(servicePlanSql, actionSql, kpmSql, cwpSql); }
private void PrintActionsByMonth() { string strsql = ""; Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString()); if (tabControl1.SelectedIndex == 0) { if (cboDirector.SelectedValue.ToString() != "-0-") // && cboManager.SelectedValue.ToString() != "-0-") { strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString()); } else { strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m); } } else { strsql = MonthlyProgress.GetQueryMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m); } clsReports.PrintMonthlyProgressForCouncil(strsql); }
private void FillGrid() { string strsql; DataRowView dr1 = (DataRowView)cboDirector.SelectedItem; DataRowView dr2 = (DataRowView)cboManager.SelectedItem; if (dr2 != null) { strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, dr1["director_id"].ToString(), dr2["manager_id"].ToString()); } else { if (opt2.Checked) { strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth); } else if (opt1.Checked) { strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, OPGlobals.CurrentUser.DirectorID); } else { strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, OPGlobals.CurrentUser.DirectorID, OPGlobals.CurrentUser.ManagerID); } } DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); DataTable tb = db.GetDataTable(conn, strsql); dgv01.Rows.Clear(); try { foreach (DataRow row in tb.Rows) { dgv01.Rows.Add(new String[] { (dgv01.RowCount + 1).ToString(), " ", row["action_id"].ToString(), row["action_id"].ToString() + " " + row["action_description"].ToString(), String.Format("{0:dd-MMM-yyyy}", row["delivery_program_targetdate"]), row["manager_id"].ToString(), row["manager_description"].ToString(), row["status_id"].ToString(), "", row["progress_pecentage"].ToString(), row["progress_description"].ToString(), row["theme_color"].ToString(), row["status_color"].ToString(), String.IsNullOrEmpty(row["status_id"].ToString()) ? "1" : "0", row["status_id"].ToString(), row["progress_pecentage"].ToString(), row["progress_description"].ToString() }); //dgv01.Rows[8].Cells[8].Style.BackColor = Color.Beige; } MyDLLs.MyGridUtils.ColorDataGrid(dgv01, 0, 11); MyDLLs.MyGridUtils.ColorDataGrid(dgv01, 8, 12); dgv01.CurrentCell = null; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }