private void BindXtraReport()
{
DocumentReport obj_Rpt = new DocumentReport();
string connectionString = "SERVER=hijo-axdb;DATABASE=hijo_portal;UID=it_dev;PASSWORD=itdev@2019;";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string sql = "SELECT DISTINCT dbo.tbl_MRP_List_DirectMaterials.ItemCode, dbo.tbl_MRP_List_DirectMaterials.ItemDescription, dbo.tbl_MRP_List_DirectMaterials.ItemDescriptionAddl, dbo.tbl_MRP_List_DirectMaterials.Qty, dbo.tbl_MRP_List_DirectMaterials.QtyPO, dbo.tbl_MRP_List_DirectMaterials.AvailForPO, dbo.tbl_POCreation_Details.ItemPK, dbo.tbl_POCreation_Details.PK FROM dbo.tbl_MRP_List_DirectMaterials LEFT OUTER JOIN dbo.tbl_POCreation_Details ON dbo.tbl_MRP_List_DirectMaterials.PK = dbo.tbl_POCreation_Details.ItemPK WHERE(dbo.tbl_POCreation_Details.MOPNumber = '" + "0000-0319MRP-000064" + "') AND (dbo.tbl_POCreation_Details.Identifier = '1')";
//SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
//DataSet DS = new DataSet();
//adapter.Fill(DS);
//adapter.Dispose();
//obj_Rpt.Report.DataSource = DS;
DataTable dt = DirectMaterials("0000-0319MRP-000064");
obj_Rpt.Report.DataSource = dt;
//obj_Rpt.Report.DataMember = DS.Tables[0].TableName;
obj_Rpt.Report.DataMember = dt.TableName;
obj_Rpt.Col1.DataBindings.Add("Text", null, "ItemCode");
obj_Rpt.Col2.DataBindings.Add("Text", null, "Descripiton");
obj_Rpt.Col3.DataBindings.Add("Text", null, "Qty");
obj_Rpt.Col4.DataBindings.Add("Text", null, "POQty");
obj_Rpt.Col5.DataBindings.Add("Text", null, "RemainingQty");
obj_Rpt.DisplayName = "DocumentReport " + DateTime.Now;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
private void FillReport(bool throwException = true)
{
int count = 0;
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT802> resp = _reportsService.ChildGetAll <Model.Reports.RT802>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x => { x.TypeString = GetGlobalResourceObject("Common", "TrType" + x.type.ToString()).ToString(); x.ClassIdString = GetGlobalResourceObject("Classes", "Class" + x.classId.ToString()) != null ? GetGlobalResourceObject("Classes", "Class" + x.classId.ToString()).ToString() : "NA"; x.DateString = x.eventDt.ToString(_systemService.SessionHelper.GetDateformat() + " HH:mm", CultureInfo.CurrentCulture); });
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
AuditTrail h = new AuditTrail(parameters);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Filters"].Value = texts.Text;
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool throwException = true)
{
ReportCompositeRequest req = GetRequest();
ListResponse <Model.Reports.RT106> resp = _reportsService.ChildGetAll <Model.Reports.RT106>(req);
//if (resp == null || string.IsNullOrEmpty(resp.Error))
//{
// throw new Exception(GetGlobalResourceObject("Errors", "Error_1").ToString());
//}
//if (!resp.Success)
//{
// throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>");
//}
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
TurnoverRate y = new TurnoverRate();
y.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
y.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
resp.Items.ForEach(x => { x.MonthString = CultureInfo.CurrentUICulture.DateTimeFormat.GetMonthName(x.month); x.month = x.month - 1; x.rate = x.rate / 100; });
y.DataSource = resp.Items;
string user = _systemService.SessionHelper.GetCurrentUser();
y.Parameters["User"].Value = user;
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(y);
}
void calReport()
{
var vrsearch = Session["Search"].ToString();
XtraRepTCCDetailsbyAll obj_Rpt = new XtraRepTCCDetailsbyAll();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewTccDetails where Utin ='{0}' OR PayerName LIKE '{0}%' ", vrsearch);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel10.Text = string.Format("By Individual Record Search");
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
void calReport()
{
var vastin = Session["UTIN"].ToString();
XtraRepPayerledge obj_Rpt = new XtraRepPayerledge();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewPayerLedger where PayerUtin='{0}'", vastin);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
obj_Rpt.xrLabel10.Text = string.Format("As At: {0:dddd, d MMMM,yyyy} ", DateTime.Now);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string path = @"\Reports\";
CustomReportStorageWebExtension reportsStorage = new CustomReportStorageWebExtension(path);
ddlReportName.DataSource = reportsStorage.GetUrls();
ddlReportName.DataBind();
//Call function for populate cb
FillStatus();
FillOrgUnit();
}
else
{
XtraReport reportToOpen = null;
switch (ddlReportName.SelectedValue)
{
case "Zaposleni 1":
reportToOpen = new ZaposleniSaoOsig1();
break;
case "Zaposleni 2":
reportToOpen = new ZaposleniSaoOsig2();
break;
case "Zaposleni 3":
reportToOpen = new ZaposleniSaoOsig3();
break;
}
GetReports(reportToOpen);
ASPxWebDocumentViewer1.OpenReport(reportToOpen);
}
}
protected void Page_Load(object sender, EventArgs e)
{
XtraReport1 report = new XtraReport1();
report.AfterPrint += Report_AfterPrint;
ASPxWebDocumentViewer1.OpenReport(report);
}
protected void Page_Load(object sender, EventArgs e)
{
//var cachedReportSource = new CachedReportSourceWeb(new XtraReport1());
//ASPxWebDocumentViewer1.OpenReport(cachedReportSource);
if (!Page.IsPostBack)
{
//View_HLS_SOA(Convert.ToInt32(Session["SOA_PrintKey"]));
switch (Session["DocumentViewer"])
{
case "HLS_SOA":
{
View_HLS_SOA(Convert.ToInt32(Session["SOA_PrintKey"]));
XtraReportSOA reportSOA = new XtraReportSOA();
reportSOA.Parameters["PK"].Value = Convert.ToInt32(Session["SOA_PrintKey"]);
ASPxWebDocumentViewer1.OpenReport(reportSOA);
//ASPxWebDocumentViewer1.ReportSourceId = "HijoPortal.devexrep.XtraReportSOA";
break;
}
case "HLS_BillInv":
{
View_HLS_BillInv(Convert.ToInt32(Session["BillInv_PrintKey"]));
XtraReportBillInv reportBillInv = new XtraReportBillInv();
reportBillInv.Parameters["PK"].Value = Convert.ToInt32(Session["BillInv_PrintKey"]);
ASPxWebDocumentViewer1.OpenReport(reportBillInv);
//ASPxWebDocumentViewer1.ReportSourceId = "HijoPortal.devexrep.XtraReportBillInv";
break;
}
}
}
}
void calReport()
{
var varyear = Session["TaxYear"].ToString();
XtraRepTccYearSummaryChild obj_Rpt = new XtraRepTccYearSummaryChild();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT RevenueOfficeId, RevenueOfficeName, COUNT( DISTINCT TccNo) Reccount, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 1 THEN TccNo END) AS DA, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 2 THEN TccNo END) AS PA, COUNT( DISTINCT CASE WHEN IncomeSourceClassifyId = 3 THEN TccNo END) AS PN, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 4 THEN TccNo END) AS ST, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 5 THEN TccNo END ) AS NR, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 6 THEN TccNo END ) AS UE, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 7 THEN TccNo END) AS DU FROM dbo.ViewTccDetails WHERE YEAR(IssuedDate)='{0}' AND AssessmentYear = YEAR(IssuedDate) - 1 GROUP BY RevenueOfficeId, RevenueOfficeName", varyear);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel11.Text = string.Format("{0}", varyear);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
void calReport()
{
XtraRepSummaryLedger obj_Rpt = new XtraRepSummaryLedger();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName,COALESCE(SUM(TaxPayable), 0) Assessment, COALESCE(SUM(PaymentAmount), 0) Payment, COALESCE(SUM(TaxPayable), 0) - COALESCE(SUM(PaymentAmount), 0) Differences FROM dbo.ViewPayerLedger GROUP BY PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName ORDER BY RevenueOfficeName asc");
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
// obj_Rpt.xrLabel10.Text = string.Format("As At: {0:dddd, d MMMM,yyyy} ", DateTime.Now);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT401> resp = _reportsService.ChildGetAll <Model.Reports.RT401>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x => x.StatusString = GetLocalResourceObject("Status" + x.status.ToString()).ToString());
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LoansReport h = new LoansReport(parameters);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.DataSource = resp.Items;
//string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat());
//string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat());
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
// h.Parameters["Filters"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
protected void Page_Load(object sender, EventArgs e)
{
RelJustificativaBloqueioDeCarga rel = new RelJustificativaBloqueioDeCarga();
ASPxWebDocumentViewer1.OpenReport(rel);
ASPxWebDocumentViewer1.Visible = true;
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT508> resp = _reportsService.ChildGetAll <Model.Reports.RT508>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
string getLan = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PayrollLeavePaymentsReport h = new PayrollLeavePaymentsReport(parameters, getLan);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.DataSource = resp.Items;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
void calReport()
{
var varyear = Session["TaxYear"].ToString();
XtraRepAssessmentYearSummaryChild obj_Rpt = new XtraRepAssessmentYearSummaryChild();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT a.AssessmentYear, a.RevenueOfficeName,a.RevenueOfficeId, COUNT(DISTINCT a.AssessmentNo) AS Reccount, SUM(a.TaxPayable) TotalPayable, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.AssessmentNo END ) AS DA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.AssessmentNo END) AS PA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.AssessmentNo END ) AS PN,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.AssessmentNo END ) AS ST, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.AssessmentNo END ) AS NR, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.AssessmentNo END) AS UE,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.AssessmentNo END) AS DU, COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.TaxPayable END), 0) DAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.TaxPayable END),0) PAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.TaxPayable END ), 0) PNAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.TaxPayable END ),0 ) STAmount, COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.TaxPayable END),0) NRAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.TaxPayable END),0) UEAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.TaxPayable END),0) DUAmount FROM ViewAssessmentInfor a WHERE a.AssessmentYear = {0} GROUP BY a.AssessmentYear, a.RevenueOfficeName,a.RevenueOfficeId ORDER BY a.RevenueOfficeName asc", varyear);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
obj_Rpt.xrLabel11.Text = string.Format("{0}", varyear);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
void calReport()
{
var strrevenue = Session["Revenue"].ToString();
var startdate = Session["Startdate"].ToString();
var enddate = Session["Enddate"].ToString();
//var end= Session["Enddate1"].ToString();
var end = Convert.ToDateTime(Session["Enddate1"].ToString()).ToString("dd/MM/yyyy");
//var strat = Session["startdate1"].ToString();
var strat = Convert.ToDateTime(Session["startdate1"].ToString()).ToString("dd/MM/yyyy");
//DateTime dt = DateTime.ParseExact(startdate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
//DateTime dt2 = DateTime.ParseExact(enddate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
//Console.WriteLine(dt.ToString("yyyy-MM-dd"));
//var gb = dt.ToString("yyyy-MM-dd");
//var gb2 = dt2.ToString("yyyy-MM-dd");
//XtraRepPayment obj_Rpt = new XtraRepPayment();
XtraRepPayment2 obj_Rpt = new XtraRepPayment2();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM ViewPayment WHERE PaymentDate BETWEEN '{0}' AND '{1}' and RevenueCode ='{2}' ORDER BY PaymentDate ASC", startdate, enddate, strrevenue);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1)
{
obj_Rpt.xrLabel10.Text = string.Format("From {0:dd/MM/yyyy} To {1:dd/MM/yyyy}", strat, end);
obj_Rpt.xrLabel8.Text = Session["RevenueName"].ToString();
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
//var cachedReportSource = new CachedReportSourceWeb(new XtraRepPayment());
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT602> resp = _reportsService.ChildGetAll <Model.Reports.RT602>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x =>
{
if (x.hireDate != null)
{
x.hireDateString = x.hireDate.Value.ToString(_systemService.SessionHelper.GetDateformat());
}
else
{
x.hireDateString = string.Empty;
}
if (x.lastReturnDate != null)
{
x.lastReturnDateString = x.lastReturnDate.Value.ToString(_systemService.SessionHelper.GetDateformat());
}
else
{
x.lastReturnDateString = string.Empty;
}
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LeaveBalance h = new LeaveBalance(parameters);
h.DataSource = resp.Items;
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
//string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat());
//string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat());
string user = _systemService.SessionHelper.GetCurrentUser();
//h.Parameters["From"].Value = from;
//h.Parameters["To"].Value = to;
h.Parameters["User"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
protected void Page_Load(object sender, EventArgs e)
{
XtraReport1 report = new XtraReport1();
report.Parameters["dataInicial"].Value = Session["dataInicial"].ToString();
report.Parameters["dataFinal"].Value = Session["dataFinal"].ToString();
report.Parameters["finalidade"].Value = Session["finalidade"].ToString();
report.RequestParameters = false;
ASPxWebDocumentViewer1.OpenReport(report);
}
void calReport()
{
var startdate = Session["Startdate"].ToString();
var enddate = Session["Enddate"].ToString();
var valagencyname = Session["AgencyName"].ToString();
DateTime dt = DateTime.ParseExact(startdate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
DateTime dt2 = DateTime.ParseExact(enddate, "dd/mm/yyyy", CultureInfo.InvariantCulture);
//Console.WriteLine(dt.ToString("yyyy-MM-dd"));
var gb = dt.ToString("yyyy-MM-dd");
var gb2 = dt2.ToString("yyyy-MM-dd");
//strquery = String.Format("SELECT AgencyName, AgencyCode,SUM(Amount) Amount FROM dbo.vwCollection WHERE PaymentDate BETWEEN '{0}' AND '{1}' GROUP BY AgencyName, AgencyCode ORDER BY AgencyName ASC", gb, gb2);
XtraRepRevenue obj_Rpt = new XtraRepRevenue();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT RevenueName,RevenueCode,SUM(Amount) Amount FROM dbo.vwCollection WHERE PaymentDate BETWEEN '{0}' AND '{1}' GROUP BY RevenueName,RevenueCode ORDER BY RevenueName ASC", gb, gb2);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
// obj_Rpt.xrLabel10.Text = string.Format("From {0:dd/MM/yyyy} To {1:dd/MM/yyyy}", strat, end);
//obj_Rpt.xrLabel11.Text = string.Format("From : {0} To: {1} ", vryearfrom, vryearto);
//obj_Rpt.xrTableCell1.Text = string.Format("{0} - {1}", vryearfrom, vryearto);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
List <XMLDictionary> statusList = Common.XMLDictionaryList(_systemService, "13");
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT601> resp = _reportsService.ChildGetAll <Model.Reports.RT601>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
errorMSG.Text = "";
string format = _systemService.SessionHelper.GetDateformat();
resp.Items.ForEach(s =>
{
s.endDateString = s.endDate.ToString(format, CultureInfo.CurrentCulture);
s.startDateString = s.startDate.ToString(format, CultureInfo.CurrentCulture);
if (s.returnDate.HasValue)
{
s.returnDateString = s.returnDate.Value.ToString(format, CultureInfo.CurrentCulture);
}
s.isPaidString = s.isPaid ? GetLocalResourceObject("Paid1").ToString() : GetLocalResourceObject("Paid0").ToString();
s.statusString = statusList.Where(y => y.key == s.status).Count() != 0 ? statusList.Where(y => y.key == s.status).First().value : "";
});
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
LeaveList h = new LeaveList(parameters);
h.DataSource = resp.Items;
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
//string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat());
//string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat());
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
// h.Parameters["Fitlers"].Value = texts.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT113> resp = _reportsService.ChildGetAll <Model.Reports.RT113>(req);
//if (!resp.Success)
//{
// throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>");
//}
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
resp.Items.ForEach(x => {
x.licenseExpiryDateString = x.licenseExpiryDate == null ? " " : ((DateTime)x.licenseExpiryDate).ToString(_systemService.SessionHelper.GetDateformat());
x.licenseIssueDateString = x.licenseIssueDate == null ? " " : ((DateTime)x.licenseIssueDate).ToString(_systemService.SessionHelper.GetDateformat());
});
string getLang = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
BranchWorkforce h = new BranchWorkforce(parameters, getLang);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.DataSource = resp.Items;
// string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
// string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
string user = _systemService.SessionHelper.GetCurrentUser();
//h.Parameters["Fitlers"].Value = texts.Text;
h.Parameters["User"].Value = user;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
//PendingPunchListRequest req = new PendingPunchListRequest();
//if (vals.Text == "")
//{
// req.ppTypeParam = "0";
//}
//else
//{
// req.ppTypeParam = rep_params.Substring(2, 1);
//}
//req.udid = "0";
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.TimeAttendance.PendingPunch> resp = _timeAttendanceService.ChildGetAll <Model.TimeAttendance.PendingPunch>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
//resp.Items.ForEach(x =>
//{
// if (x.hireDate != null)
// x.hireDateString = ((DateTime)(x.hireDate)).ToString(_systemService.SessionHelper.GetDateformat(), System.Threading.Thread.CurrentThread.CurrentCulture);
// if (x.terminationDate != null)
// x.terminationDateString = ((DateTime)(x.terminationDate)).ToString(_systemService.SessionHelper.GetDateformat(), System.Threading.Thread.CurrentThread.CurrentCulture);
//});
string getLan = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
PendingPunches h = new PendingPunches(parameters, getLan);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
//h.Parameters["User"].Value = _systemService.SessionHelper.GetCurrentUser();
// h.Parameters["Filters"].Value = texts.Text;
h.DataSource = resp.Items;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
public void FillReport(bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT201> resp = _reportsService.ChildGetAll <Model.Reports.RT201>(req);
//if (!resp.Success)
//{
// throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>");
//}
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
string getLang = _systemService.SessionHelper.getLangauge();
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
SalaryHistory h = new SalaryHistory(parameters, getLang);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
resp.Items.ForEach(x => {
x.PaymentFrequencyString = x.paymentFrequency.HasValue? GetGlobalResourceObject("Common", ((PaymentFrequency)x.paymentFrequency).ToString()).ToString():"";
x.SalaryTypeString = x.salaryType.HasValue ? GetGlobalResourceObject("Common", ((SalaryType)x.salaryType).ToString()).ToString() : "";
x.EffectiveDateString = x.effectiveDate.ToString(_systemService.SessionHelper.GetDateformat(), CultureInfo.CurrentCulture);
});
h.DataSource = resp.Items;
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
h.CreateDocument();
//string format = "Pdf";
//string fileName = String.Format("Report.{0}", format);
//MemoryStream ms = new MemoryStream();
//h.ExportToPdf(ms,new DevExpress.XtraPrinting.PdfExportOptions() { ShowPrintDialogOnOpen = true });
//Response.Clear();
//Response.ContentType = "application/pdf";
//Response.AddHeader("Content-Disposition", String.Format("{0}; filename={1}", "inline", fileName));
//Response.BinaryWrite(ms.ToArray());
//Response.End();
ASPxWebDocumentViewer1.OpenReport(h);
ASPxWebDocumentViewer1.DataBind();
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
ReportCompositeRequest req = GetRequest();
ListResponse <Model.Reports.RT402> resp = _reportsService.ChildGetAll <Model.Reports.RT402>(req);
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
}
for (int i = 0; i < resp.Items.Count; i++)
{
if (i == 0)
{
resp.Items[i].balance = resp.Items[i].amount;
}
else
{
resp.Items[i].balance = resp.Items[i - 1].balance + resp.Items[i].amount;
}
resp.Items[i].dateStringFormat = resp.Items[i].date.ToString(_systemService.SessionHelper.GetDateformat());
}
LoanStatement h = new LoanStatement();
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.DataSource = resp.Items;
// string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
// string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
string user = _systemService.SessionHelper.GetCurrentUser();
h.Parameters["User"].Value = user;
h.Parameters["EmployeeName"].Value = employeeFilter.SelectedItem.Text;
h.Parameters["descriptionTrxType1"].Value = GetLocalResourceObject("descriptionTrxType1");
h.Parameters["descriptionTrxType2"].Value = GetLocalResourceObject("descriptionTrxType2");
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
private void FillReport(bool isInitial = false, bool throwException = true)
{
string rep_params = vals.Text;
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Model.Reports.RT111> resp = _reportsService.ChildGetAll <Model.Reports.RT111>(req);
//if (!resp.Success)
//{
// throw new Exception(resp.Error + "<br>" + GetGlobalResourceObject("Errors", "ErrorLogId") + resp.LogId + "</br>");
//}
if (!resp.Success)
{
Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString());
return;
}
Dictionary <string, string> parameters = Web.UI.Forms.Common.FetchReportParameters(texts.Text);
BankAccounts h = new BankAccounts(parameters);
h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No;
h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No;
h.DataSource = resp.Items;
// string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
// string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"));
string user = _systemService.SessionHelper.GetCurrentUser();
//h.Parameters["PositionName"].Value = jobInfo1.GetPosition();
h.Parameters["User"].Value = user;
//h.Parameters["Status"].Value = statusCombo.SelectedItem.Text;
h.CreateDocument();
ASPxWebDocumentViewer1.DataBind();
ASPxWebDocumentViewer1.OpenReport(h);
}
protected void Page_Load(object sender, EventArgs e)
{
ReportCompositeRequest req = GetRequest();
ListResponse <Model.Reports.RT201> resp = _reportsService.ChildGetAll <Model.Reports.RT201>(req);
SalaryHistory h = new SalaryHistory(new Dictionary <string, string> (), "");
h.DataSource = resp.Items;
ASPxWebDocumentViewer1.OpenReport(h);
}
void calReport()
{
//var vryearfrom = Session["yearFrom"].ToString();
//var vryearto = Session["yearTo"].ToString();
//var varofficename = Session["Revenueoffice"].ToString();
var varofficename = Session["RevenueOfficename"].ToString();
var varyear = Session["TaxYear"].ToString();
//var varyear = Session["TaxYear"].ToString();
XtraRepTccDetails2 obj_Rpt = new XtraRepTccDetails2();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewTccDetailsInfors WHERE YEAR(IssuedDate) BETWEEN {0} AND {0} AND RevenueOfficeName='{1}' ORDER BY PayerName ASC, TccNo ASC, TaxYear DESC", varyear, varofficename);
//string strquery = String.Format("SELECT * FROM dbo.ViewTccDetails WHERE YEAR(IssuedDate) BETWEEN {0} AND {1} AND RevenueOfficeName='{2}' AND AssessmentYear = YEAR(IssuedDate) - 1 ORDER BY PayerName ASC", vryearfrom, vryearto, varofficename);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
//obj_Rpt.xrLabel10.Text = string.Format("From {0} to {1}", vryearfrom, vryearto);
//obj_Rpt.xrLabel11.Text = string.Format("{0} ", varofficename);
obj_Rpt.xrLabel10.Text = string.Format("{0} ", varyear);
obj_Rpt.xrLabel11.Text = string.Format("{0} ", varofficename);
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["dataInicio"] != null && Session["dataFim"] != null)
{
XtraReport_TodasCallResultCampanha report = new XtraReport_TodasCallResultCampanha();
report.Parameters["parameter1"].Value = Session["dataInicio"].ToString();
report.Parameters["parameter2"].Value = Session["dataFim"].ToString();
report.RequestParameters = false;
ASPxWebDocumentViewer1.OpenReport(report);
}
else
{
Response.Redirect("Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Thread.CurrentThread.CurrentCulture = Utilidades.getCulture();
this.AsyncMode = true;
string url = HttpContext.Current.Request.Url.AbsoluteUri;
if (url.Contains('/'))
{
string[] valor = url.Split('/');
string dato = valor[valor.Length - 1];
if (dato.Length == 50)
{
ASPxWebDocumentViewer1.OpenReport(CreateReport(dato));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string apiUrl = WebConfigurationManager.AppSettings["api_url"];
// string df = Request.QueryString["from"];
// string dt = Request.QueryString["to"];
string df = "20190101";
string dt = "20200503";
int d = Convert.ToInt32(Request.QueryString["d"]);
string type = Request.QueryString["type"];
if (string.IsNullOrEmpty(type))
{
type = "easafcl16";
}
string prms = Request.QueryString["prms"];
int reportId = -1;
int airlineId = -1;
int flightStatusId = -1;
int employeeId = 297;
JsonDataSource dataSource = null;
switch (type)
{
case "easafcl16":
var rptEASAFCL16 = new RptFlight();
dataSource = new JsonDataSource();
dataSource.JsonSource = new UriJsonSource(new Uri(apiUrl + "odata/crew/flights/app2/?id=" + employeeId + "&df=" + df + "&dt=" + dt + "&status=" + flightStatusId + "&airline=" + airlineId + "&report=" + reportId));
dataSource.Fill();
rptEASAFCL16.DataSource = dataSource;
ASPxWebDocumentViewer1.OpenReport(rptEASAFCL16);
break;
default:
break;
}
// var report = new RptTwoPageLogBook();
// var jsonDataSource = new JsonDataSource();
// jsonDataSource.JsonSource = new UriJsonSource(new Uri("http://fleet.flypersia.aero/api.airpocket/odata/fuel/report/?$top=2020&dt=2020-01-12T00:00:00&df=2020-01-12T00:00:00&%24orderby=STDDay%2CSTDLocal&%24filter=(FlightId%20gt%200)"));
// jsonDataSource.Fill();
//report.DataSource = jsonDataSource;
}
void calReport()
{
var vastin = Session["UTIN"].ToString();
//var vryearfrom = Session["yearFrom"].ToString();
//var vryearto = Session["yearTo"].ToString();
//var vryearfrom = Session["Fromyear"].ToString();
//var vryearto = Session["Toyear"].ToString();
//var vroffice = Session["Revenueoffice"].ToString();
XtraRepTccDetails obj_Rpt = new XtraRepTccDetails();
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM dbo.ViewTccDetails where Utin='{0}' ", vastin);
using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString))
{
connect.Open();
_command = new SqlCommand(strquery, connect)
{
CommandType = CommandType.Text
};
_command.CommandTimeout = 0;
responses.Clear();
_adp = new SqlDataAdapter(_command);
_adp.Fill(responses);
connect.Close();
}
if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0)
{
//obj_Rpt.xrLabel10.Text = string.Format("From {0} To: {1} ", vryearfrom, vryearto);
obj_Rpt.xrLabel10.Visible = false;
obj_Rpt.Report.DataSource = responses;
obj_Rpt.Report.DataMember = responses.Tables[0].TableName;
ASPxWebDocumentViewer1.OpenReport(obj_Rpt);
}
}
