private void PrintReportDetailTotalTest(DataTable m_dsReport) { var DT = new ds_dailyDetailTestReport.dtDailyDetailTestReportDataTable(); string sTungayDenNgay = Getsday(Convert.ToDateTime(dtpFromDate.Text)) + " --- đến --- " + Getsday(Convert.ToDateTime(dtpTodate.Text)); if (!InvaliData(_dsReport)) { return; } var crpt = new VD_1C_crpt_DailyParamTestReport1(); var objForm = new frmPrintPreview("", crpt, true, true); try { crpt.SetDataSource(m_dsReport); //crpt.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + // " Nhân viên " // .Replace("#$X$#", // Strings.Chr(34) + "&Chr(13)&" + // Strings.Chr(34)) + Strings.Chr(34); crpt.SetParameterValue("ParentBranchName", globalVariables.ParentBranch_Name); crpt.SetParameterValue("BranchName", globalVariables.Branch_Name); crpt.SetParameterValue("sCondition", sTungayDenNgay); // crpt.SetParameterValue("TotalTest", intGetTotalTest( DT)); objForm.crptViewer.ReportSource = crpt; objForm.ShowDialog(); Utility.DefaultNow(this); } catch (Exception ex) { Utility.DefaultNow(this); } }
private int intGetTotalTest(ds_dailyDetailTestReport.dtDailyDetailTestReportDataTable dt) { int Reval = 0; string TestType_ID = ","; foreach (DataRow dr in dt.Rows) { if (dr["PrintDetail"] == "1") { Reval += Convert.ToInt16(dr["Amount"]); } else { if (Strings.InStr(TestType_ID, "," + dr["TestType_ID"] + ",", CompareMethod.Text) > 0) { } else { TestType_ID += dr["TestType_ID"] + ","; Reval += Convert.ToInt32(dr["NumOfTest"]); } } } return(Reval); }