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