private void LoadReport()
{
try
{
string ConnectionString = _host.ConnectionString;
Stimulsoft.Report.StiReport _report = new StiReport();
_report.Load(Resources.mrtBarcodeDetailes);
_report.Dictionary.Databases.Clear();
_report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("PofficeCOD186", ConnectionString));
_report.Compile();
_report["UserID"] = (param.UserID.Trim() == string.Empty ? "0" : param.UserID.Trim());
_report["fDate"] = (param.FirstDate.Trim() == string.Empty ? "1500/01/01" : param.FirstDate.Trim());
_report["lDate"] = (param.LastDate.Trim() == string.Empty ? "1500/01/01" : param.LastDate.Trim());
_report["StateCode"] = (param.StateCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.LastStateCode));
_report["CityCode"] = (param.CityCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.CityCode));
_report["PostNode"] = (param.PostNodeCode.Trim() == string.Empty ? 0 : Convert.ToInt32(param.PostNodeCode));
_report["StatusID"] = (param.BarcodeStatusID.Trim() == string.Empty ? 0 :Convert.ToInt32(param.BarcodeStatusID));
_report["UserName"] = _LoginDetails.Pname + " " + _LoginDetails.RolePname + " از " + _LoginDetails.StateName;
_report["ReportDate"] = DateAndTime.GetSQLDate10DigitShamsi() + " -- " + DateAndTime.GetSQLTime8Digit();
StiWebViewer1.Report = _report;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptBarcodeDetail ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UserValidate();
ReportObject(ANP.Data.BaseData.Library.Encryption.Decrypt(Request.QueryString["pra"].ToString()));
string ConnectionString = _host.ConnectionString;
Stimulsoft.Report.StiReport _report = new StiReport();
_report.Load(Resources.mrtFinancialParcelOfFirstState);
_report.Dictionary.Databases.Clear();
_report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("PofficeCOD186", ConnectionString));
_report.Compile();
_report["FirstState"] = (ddlState == string.Empty ? 0 : Convert.ToInt32(ddlState));
_report["FirstCity"] = (ddlCity == string.Empty ? 0 : Convert.ToInt32(ddlCity));
_report["FirstPostNode"] = (ddlPostNode == string.Empty ? 0 : Convert.ToInt32(ddlPostNode));
_report["LastState"] = (ddlLastState == string.Empty ? 0 : Convert.ToInt32(ddlLastState));
_report["LastCity"] = (ddlLastCity == string.Empty ? 0 : Convert.ToInt32(ddlLastCity));
_report["LastPostNode"] = (ddlLastPostNode == string.Empty ? 0 : Convert.ToInt32(ddlLastPostNode));
_report["FirstDate"] = Fdate;
_report["LastDate"] = Ldate;
_report["PayType"] = (ddlCredit == string.Empty ? 0 : Convert.ToInt32(ddlCredit));
_report["BarcodeStatus"] = (ddlBarcodeStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeStatus));
_report["BarcodeSubStatus"] = (ddlBarcodeSubStatus == string.Empty ? 0 : Convert.ToInt32(ddlBarcodeSubStatus));
_report["UserName"] = _LoginDetails.Pname + " " + _LoginDetails.RolePname + " از " + _LoginDetails.StateName;
_report["ReportDate"] = DateAndTime.GetSQLDate10DigitShamsi() + " -- " + DateAndTime.GetSQLTime8Digit();
StiWebViewer1.Report = _report;
}
catch (Exception ex)
{
string Query = string.Format(@"EXECUTE sp_FilltblErrorProgrammer
@Message=N'{0}'
,@DateError='{1}'
,@PhysicalPath=N'{2}'
,@UserHostAddress='{3}'
,@Browser='{4}'"
, "Error For Load Report : rptFinancialParcelOfFirstState ; Detail : " + ex.Message.Replace("'", "''")
, DateAndTime.GetDateTime16Digit_Latin(), "", "", "");
_host.SqlExecute(Query);
}
}