protected void grdConfirmation_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { if (e.CommandName == "ShowReport") { StiWebViewer1.ResetReport(); //DTO.University.Graduate.GraduateFormsDTO GFD = new DTO.University.Graduate.GraduateFormsDTO(); StiReport rpt = new StiReport(); string[] arg = e.CommandArgument.ToString().Split(','); int inquiryId = Convert.ToInt32(arg[0]); int inquiryType = Convert.ToInt32(arg[1]); string stcode = arg[2].ToString(); //GFD.stCode = stcode; //var dr = gBsn.getCourseReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/TaeedTahsili.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@stcode"].ParameterValue = stcode; rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@Type"].ParameterValue = inquiryType; rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@InquiryID"].ParameterValue = inquiryId; rpt.CompiledReport.DataSources["[dbo].[SP_GetStudentPic]"].Parameters["@stcode"].ParameterValue = stcode; //rpt.RegData(dr); StiWebViewer1.Visible = true; StiWebViewer1.Report = rpt; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } var reqId = Convert.ToInt32(Request.QueryString["r"]); var stcode = _business.GetCheckOutStudentIDByReqID(reqId); var report = new StiReport(); report.Load(Server.MapPath("../Reports/CheckOutBankInfo.mrt")); report.Dictionary.Databases.Clear(); report.Dictionary.Databases.AddRange(new StiDatabase[2] { new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()), new StiSqlDatabase("Connection2", CB.ReportConnection.ToString()) }); report.Dictionary.Variables["StCode"].Value = stcode; StiWebViewer1.ResetReport(); StiWebViewer1.Report = report; StiWebViewer1.Visible = true; // int reqID = Convert.ToInt32(Request.QueryString["r"]); // int s = Convert.ToInt32(Request.QueryString["s"]); // CheckOutStatusEnum.FareghReqStatus status = new CheckOutStatusEnum.FareghReqStatus(); // status = (CheckOutStatusEnum.FareghReqStatus)s; // string stcode = business.GetCheckOutStudentIDByReqID(reqID); // this.StiWebViewer1.ResetReport(); // StiWebViewer1.Visible = true; // StiReport rpt = new StiReport(); // rpt.Load(Server.MapPath("../Reports/CheckOutBankInfo.mrt")); // rpt.ReportCacheMode = StiReportCacheMode.On; // rpt.Dictionary.Databases.Clear(); //// rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", dao.ReportConnection.ToString())); // rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", "Data Source=192.168.1.21;Initial Catalog=Supplementary_test;Password=t123*t456;User ID=teamuser")); // rpt.Compile(); // rpt.CompiledReport.DataSources["[Request].[SP_GetBankAcountInfoCheckOut]"].Parameters["@stcode"].ParameterValue = 99900999; // //rpt.CompiledReport.DataSources["[Request].[SP_GetStudentInfoByStCode]"].Parameters["@stcode"].ParameterValue = 99900999; // DataTable dtResault = new DataTable(); // rpt.RegData(dtResault); // StiWebViewer1.Report = rpt; // StiWebViewer1.Visible = true; }
protected void btnOk_Click(object sender, EventArgs e) { if (Session["printDocument_Type"] != null) { Session.Remove("printDocument_Stcode"); Session.Remove("printDocument_Type"); } StiReport rpt = new StiReport(); switch (Convert.ToInt32(drpForms.SelectedValue)) { case 1: StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; dr = GFB.getStatusReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/GraduateStatus.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Graduate].[SP_getFormVaziatInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.RegData(dr); StiWebViewer1.Report = rpt; break; case 2: StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; dr = GFB.getDrafReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/GraduateDraft.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Graduate].[SP_getFormDraftInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.CompiledReport.DataSources["[request].[SP_Get_StudentLoanInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.RegData(dr); StiWebViewer1.Report = rpt; break; case 3: //ریزنمره var SFD = GFB.getStudentFeraghatDocument(ViewState["stCode"].ToString()); if (SFD.dateRiznomreErsal != null && SFD.dateRiznomreErsal.Trim() != "" && SFD.dateRiznomreErsal.Trim() != "-") { showMessage("برای این دانشجو در تاریخ " + SFD.dateRiznomreErsal + " ریز نمره ارسال شده است."); } StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; rpt.Load(Server.MapPath("../Reports/FinalWorkbook.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Graduate].[SP_getFormMarkListInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.CompiledReport.DataSources["[Graduate].[SP_getPayanFormMarkListInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.CompiledReport.DataSources["[Graduate].[SP_getPayanFormMarkListInfo]"].Parameters["@multiPayan"].ParameterValue = (ddl_PayanType.SelectedItem.Value == "1" ? 1 : 0); rpt.CompiledReport.DataSources["[dbo].[SP_GetStudentPic]"].Parameters["@stcode"].ParameterValue = stCode; StiWebViewer1.Report = rpt; setLog(Convert.ToInt32(stCode)); break; case 4: StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; dr = GFB.getCourseReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/CorsePassesByType.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Graduate].[SP_getCoursePassedInfo]"].Parameters["@stcode"].ParameterValue = stCode; rpt.CompiledReport.DataSources["[dbo].[SP_GetStudentPic]"].Parameters["@stcode"].ParameterValue = stCode; rpt.RegData(dr); StiWebViewer1.Report = rpt; break; case 5: //استعلام گواهی موقت case 6: //استعلام دانشنامه type = Convert.ToInt32(drpForms.SelectedValue); if (chkRizNomre.Checked && type == 6) { type = 61; } StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; dr = GFB.getCourseReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/TaeedTahsili.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@stcode"].ParameterValue = stCode; rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@Type"].ParameterValue = type; rpt.CompiledReport.DataSources["Graduate.SP_getFormTaeedieTahsili"].Parameters["@InquiryID"].ParameterValue = drpInquiry.SelectedItem.Value; rpt.CompiledReport.DataSources["[dbo].[SP_GetStudentPic]"].Parameters["@stcode"].ParameterValue = stCode; //vam dar rpt.RegData(dr); StiWebViewer1.Report = rpt; break; case 7: //گواهینامه موقت var SFD_G = GFB.getStudentFeraghatDocument(ViewState["stCode"].ToString()); if (SFD_G.dateGovahiSodur != null && SFD_G.dateGovahiSodur.Trim() != "" && SFD_G.dateGovahiSodur.Trim() != "-") { showMessage("برای این دانشجو در تاریخ " + SFD_G.dateGovahiSodur + " گواهینامه موقت ارسال شده است."); } DataTable dt; CheckOutRefahBusiness refah = new CheckOutRefahBusiness(); dt = refah.GetAllDebitByStcode(ViewState["stCode"].ToString()); if (dt.Rows.Count != 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[0]["DebitTypeID"].ToString() == "1") { divLoanInfo.Visible = true; break; } } DateTime date; Boolean flag = DateTime.TryParse(txtPayDate.Text, new System.Globalization.CultureInfo("fa-IR"), System.Globalization.DateTimeStyles.None, out date); if (!flag) { revPayDate.IsValid = false; } } else { divLoanInfo.Visible = false; clearTextBox(); } StiWebViewer1.Visible = true; StiWebViewer1.ResetReport(); stCode = (string)ViewState["stCode"]; GFD.stCode = stCode; dr = GFB.getCourseReportInfo(GFD); rpt.Load(Server.MapPath("../Reports/GovahiMovaghatPayanTahsil.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@stcode"].ParameterValue = ViewState["stCode"].ToString(); rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@date"].ParameterValue = txtPayDate.Text; rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@monthPay"].ParameterValue = txtAmount.Text; rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@acountNumber"].ParameterValue = txtAcountNumber.Text; rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@bankName"].ParameterValue = txtBankName.Text; rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@branchName"].ParameterValue = txtBranchName.Text; rpt.CompiledReport.DataSources["[Graduate].[SP_getFormGovahiMovaghatPayanTahsilat]"].Parameters["@address"].ParameterValue = txtAddress.Text; rpt.RegData(dr); StiWebViewer1.Report = rpt; break; case 8: //دانشنامه var SFD_Danesh = GFB.getStudentFeraghatDocument(ViewState["stCode"].ToString()); if (SFD_Danesh.dateDaneshnameSodur != null && SFD_Danesh.dateDaneshnameSodur.Trim() != "" && SFD_Danesh.dateDaneshnameSodur.Trim() != "-") { showMessage("برای این دانشجو در تاریخ " + SFD_Danesh.dateDaneshnameSodur + " دانشنامه صادر شده است."); } StiWebViewer1.ResetReport(); if (GFB.IsEquivalentTwoYearsGraduated(ViewState["stCode"].ToString())) { rpt.Load(Server.MapPath("../Reports/Daneshname_Kardani.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("conn", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["Graduate.sp_getFormKardani"].Parameters["@stcode"].ParameterValue = ViewState["stCode"].ToString(); } else { rpt.Load(Server.MapPath("../Reports/daneshname.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("conn", CB.SupplementaryReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["Graduate.sp_getFromDaneshname"].Parameters["@stcode"].ParameterValue = ViewState["stCode"].ToString(); } StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; break; } revPayDate.IsValid = true; }