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 Btn_Show_Click(object sender, EventArgs e) { if (ddl_Term.SelectedValue == null) { ddl_Term.SelectedValue = "0"; } if (ddl_Degree.SelectedValue == null) { ddl_Degree.SelectedValue = "0"; } if (ddl_Sex.SelectedValue == null) { ddl_Sex.SelectedValue = "0"; } if (txt_SalVorud.Text == null || txt_SalVorud.Text == "") { txt_SalVorud.Text = "0"; } if (ddl_Education.SelectedValue == null) { ddl_Education.SelectedValue = "0"; } if (txt_StCode.Text == string.Empty || txt_StCode.Text == "") { txt_StCode.Text = "0"; Session["stcode"] = txt_StCode.Text; } if (LDD.Field == null) { LDD.Field = "0"; } dtResault = ERB.GetLisAdamSabtenam(ddl_Term.SelectedValue.ToString(), txt_StCode.Text, int.Parse(ddl_Degree.SelectedValue.ToString()), int.Parse(ddl_Education.SelectedValue.ToString()), int.Parse(ddl_Sex.SelectedValue.ToString()), txt_SalVorud.Text.ToString(), int.Parse(ddl_Field.SelectedValue)); if (dtResault.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیغام", ""); } else { img_ExportToExcel1.Visible = true; this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportNotRegistrationLicense.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", cb.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@StCode"].ParameterValue = txt_StCode.Text; rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Degree"].ParameterValue = int.Parse(ddl_Degree.SelectedValue); rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Education"].ParameterValue = int.Parse(ddl_Education.SelectedValue); rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Sex"].ParameterValue = int.Parse(ddl_Sex.SelectedValue); rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@SalVorud"].ParameterValue = txt_SalVorud.Text; rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Field"].ParameterValue = int.Parse(ddl_Field.SelectedValue); rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.RegData(dtResault); rpt.Dictionary.Synchronize(); //rpt.Show(); StiWebViewer1.Report = rpt; StiWebViewer1.ProcessExcel2007Request(); StiWebViewer1.ShowExportToExcel.ToString(); StiWebViewer1.Visible = true; //rpt.Print(true); } Session["stcode"] = null; }
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; }
protected void Page_Load(object sender, EventArgs e) { string id = Request["Id"]; string isPrint = Request["isPrint"]; if (!string.IsNullOrEmpty(id)) { ncelsEntities context = UserHelper.GetCn(); Guid guid = Guid.Parse(id); Document doc = context.Documents.FirstOrDefault(o => o.Id == guid); if (doc != null) { //if (doc.Template != null) { // StiReport report = new StiReport(); // MemoryStream stream = new MemoryStream(doc.Template.Report); // report.Load(stream); // stream.Close(); // foreach (var data in report.Dictionary.Databases.Items.OfType<StiSqlDatabase>()) { // data.ConnectionString = UserHelper.GetCnString(); // } // report.Dictionary.Variables["DocumentId"].Value = guid.ToString(); // report.Dictionary.Variables["EmployeeId"].Value = UserHelper.GetCurrentEmployee().Id.ToString(); // report.Dictionary.Variables["UnitId"].Value = UserHelper.GetCurrentEmployee().Position.Id.ToString(); // StiWebViewer1.Report = report; // if (isPrint == "1") { // StiWebViewer1.ShowToolBar = false; // StiWebViewer1.PrintToDirect(); // } // return; //} Template template = null; StiReport reportCard = new StiReport(); switch (doc.DocumentType) { case 0: //reportCard.Load(Server.MapPath("Reports/CardInc.mrt")); reportCard = ReportHelper.GetReport(new Guid(id), context); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 0); break; case 1: reportCard.Load(Server.MapPath("Reports/CardOut.mrt")); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 1); break; case 2: //reportCard.Load(Server.MapPath("Reports/CardCit.mrt")); reportCard = ReportHelper.GetReport(new Guid(id), context); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 2); break; case 3: reportCard.Load(Server.MapPath("Reports/CardOrd.mrt")); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 3); break; case 4: //reportCard.Load(Server.MapPath("Reports/CardProject.mrt")); reportCard = ReportHelper.GetReport(new Guid(id), context); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 3); break; case 5: reportCard.Load(Server.MapPath("Reports/CardInner.mrt")); template = context.Templates.FirstOrDefault(o => o.TemplateType == 2 && o.Type == 3); break; default: return; } //if (template != null) { //if (reportCard == null) //{ // reportCard = new StiReport(); // MemoryStream stream = new MemoryStream(template.Report); // reportCard.Load(stream); // stream.Close(); //} foreach (var data in reportCard.Dictionary.Databases.Items.OfType <StiSqlDatabase>()) { data.ConnectionString = UserHelper.GetCnString(); } if (reportCard.Dictionary.Variables.Contains("DocumentId")) { reportCard.Dictionary.Variables["DocumentId"].Value = doc.Id.ToString(); } if (reportCard.Dictionary.Variables.Contains("EmployeeId")) { reportCard.Dictionary.Variables["EmployeeId"].Value = UserHelper.GetCurrentEmployee().Id.ToString(); } if (reportCard.Dictionary.Variables.Contains("UnitId")) { reportCard.Dictionary.Variables["UnitId"].Value = UserHelper.GetCurrentEmployee().Position.Id.ToString(); } StiWebViewer1.Report = reportCard; if (isPrint == "1") { StiWebViewer1.ShowToolBar = false; StiWebViewer1.PrintToDirect(); } //} } } }