protected void btnPrint_Click(object sender, EventArgs e)
{
string msg = string.Empty;
try
{
dsRptBeatWiseCanalDetailTableAdapters.RptBeatWiseCanalDetailTableAdapter ds = new dsRptBeatWiseCanalDetailTableAdapters.RptBeatWiseCanalDetailTableAdapter();
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("dsRptBeatWiseCanalDetail", (DataTable)ds.GetData(Convert.ToInt64(ddlSubDiv.SelectedValue), Convert.ToInt64(ddlDivision.SelectedValue)));
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = Server.MapPath("Reports/rptBeatWiseCanalDetail.rdlc");
viewer.LocalReport.DataSources.Add(rds);
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
using (System.IO.FileStream fs = new System.IO.FileStream(Server.MapPath("Reports/BeatWiseCanalDetail.pdf"), System.IO.FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
}
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "newWindow", "window.open('Reports/BeatWiseCanalDetail.pdf','_blank','status=1,toolbar=0,menubar=0,location=1,scrollbars=1,resizable=1,width=800,height=600');", true);
}
catch (Exception ex)
{
Global.ErrorInsert(ex.Message, formname, "btnPrint_Click");
msg = "Error" + ex.Message;
}
}
private void RenderPerformanceReport(DateTime startdt, DateTime endingdt)
{
try
{
ReportViewerDisplay.Reset();
SqlConnection con = HomeController.GetConnection();
con.Open();
string sqlQuery = "sp_EDW_User_Reports";
System.Data.DataTable dt = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@StartDate", startdt);
da.SelectCommand.Parameters.AddWithValue("@EndDate", endingdt);
da.Fill(dt);
ReportViewerDisplay.LocalReport.DataSources.Clear();
Microsoft.Reporting.WebForms.ReportDataSource rpdc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSetEDWReporting", dt);
ReportViewerDisplay.LocalReport.DataSources.Add(rpdc);
ReportViewerDisplay.LocalReport.EnableExternalImages = true;
ReportViewerDisplay.LocalReport.ReportPath = Server.MapPath("~/Reports/ReportEdwWorkersProductivity.rdlc");
ReportViewerDisplay.LocalReport.Refresh();
}
catch (Exception)
{
}
}
public Byte[] GetReport(string ReportFile,string DataSourceName,object DataSource,
List<KeyValuePair<string, string>> ReportParameters=null,bool LoadCompanyParameters=false)
{
ReportDataSource reportDataSource = new Microsoft.Reporting.WebForms.ReportDataSource();
reportDataSource.Name = DataSourceName;
reportDataSource.Value = DataSource;
List<ReportParameter> reportList = new List<ReportParameter>();
if (LoadCompanyParameters)
{
List<KeyValuePair<string, string>> companyParameters = GetCompanyReportInfo();
foreach (var param in companyParameters)
{
ReportParameter reportParam = new ReportParameter(param.Key, param.Value);
reportList.Add(reportParam);
}
}
if (ReportParameters != null && ReportParameters.Count > 0)
{
foreach (var param in ReportParameters)
{
ReportParameter reportParam = new ReportParameter(param.Key, param.Value);
reportList.Add(reportParam);
}
}
ReportParameter[] reportParameters = reportList.ToArray();
Byte[] bytes = PDFReport.InitialReport(ReportFile, reportDataSource, reportParameters);
return bytes;
}
public WebForms.ReportViewer ReportViewer()
{
FileInfo reportFullPath = this.ReportFile;
//check to make sure the file ACTUALLY exists, before we start working on it
if (reportFullPath != null)
{
//map the reporting engine to the .rdl/.rdlc file
LoadReportDefinitionFile(CurrentReportViewer.LocalReport, reportFullPath);
// 1. Clear Report Data
CurrentReportViewer.LocalReport.DataSources.Clear();
// 2. Load new data
// Look-up the DB query in the "DataSets" element of the report file (.rdl/.rdlc which contains XML)
RDL.Report reportDef = this.ReportDefinition;
//Load any other report parameters (which are not part of the DB query).
//If any of the parameters are required, make sure they were provided, or show an error message. Note: SSRS cannot render the report if required parameters are missing
CheckReportParameters(CurrentReportViewer.LocalReport);
if (!ErrorMessages.Any())
{
// Run each query (usually, there is only one) and attach each to the report
foreach (RDL.DataSet ds in reportDef.GetDataSetsInReportSections())
{
WebForms.ReportDataSource rds = GetReportDataSource(reportDef, ds);
CurrentReportViewer.LocalReport.DataSources.Add(rds);
}
}
CurrentReportViewer.LocalReport.Refresh();
}
return(CurrentReportViewer);
}
protected void lbView_Click(object sender, EventArgs e)
{
if (ddlArea.SelectedIndex > 0)
{
this.rvWorkSchedule.ProcessingMode = ProcessingMode.Local;
ISSA.Pages.Reports.DataSet1 DS_Report = new ISSA.Pages.Reports.DataSet1();
DS_Report.EnforceConstraints = false;
ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter Rpt_TableAdapter = new ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter();
Rpt_TableAdapter.Fill(DS_Report.TA_RPT_WorkSchedule, ddlYear.SelectedValue, ddlMonth.SelectedValue, Convert.ToByte(ddlArea.SelectedValue), ddlShift.SelectedValue);
if (DS_Report.TA_RPT_WorkSchedule.Rows.Count > 0)
{
ISSA.Pages.Reports.DataSet1.dtParametersDataTable dtParam = new ISSA.Pages.Reports.DataSet1.dtParametersDataTable();
DataRow dr = dtParam.NewRow();
dr["ParamOne"] = ddlMonth.SelectedItem.Text + ", " + ddlYear.SelectedValue;
dr["ParamTwo"] = ddlArea.SelectedItem.Text;
if (ddlShift.SelectedIndex == 0)
{
dr["ParamThree"] = "All";
}
else
{
dr["ParamThree"] = ddlShift.SelectedItem.Text;
}
dr["User"] = MISC.getUserName().ToUpper();;
dr["Date"] = DateTime.Now;
dtParam.Rows.Add(dr);
Microsoft.Reporting.WebForms.ReportDataSource RpDs1 = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.ReportDataSource RpDsParameters = new Microsoft.Reporting.WebForms.ReportDataSource();
RpDs1.Name = "TA_RPT_WorkSchedule";
RpDs1.Value = DS_Report.TA_RPT_WorkSchedule;
RpDsParameters.Name = "dtParameters";
RpDsParameters.Value = dtParam;
rvWorkSchedule.LocalReport.ReportPath = "Pages/Reports/rpt_WorkSchedule.rdlc";
rvWorkSchedule.LocalReport.DataSources.Clear();
rvWorkSchedule.LocalReport.DataSources.Add(RpDs1);
rvWorkSchedule.LocalReport.DataSources.Add(RpDsParameters);
rvWorkSchedule.LocalReport.Refresh();
rvWorkSchedule.Visible = true;
rvWorkSchedule.ShowReportBody = true;
mpeViewWorkSchedule.Show();
}
else
{
ShowMessage("No record found for selected parameters. Schedule may not have been created.", MessageType.Info);
mpeViewWorkSchedule.Hide();
}
}
else
{
ShowMessage("Area is required", MessageType.Warning);
//mpeViewWorkSchedule.Hide();
}
}
protected void RunUndefinedDest()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "uspUndefinedDestinations";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
dsUndefinedDest dsDetail = new dsUndefinedDest();
while (dr.Read())
{
dsDetail.Tables[0].Rows.Add(System.Convert.ToDateTime(dr[0].ToString()), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), dr[6].ToString());
}
dr.Close();
this.rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.Reset();
Microsoft.Reporting.WebForms.ReportDataSource rdInvDetail = new Microsoft.Reporting.WebForms.ReportDataSource("dsUndefinedDest", dsDetail.Tables[0]);
this.rptViewer.LocalReport.DataSources.Add(rdInvDetail);
this.rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.rptViewer.LocalReport.ReportPath = @"Reports\UndefinedDestinations2.rdlc";
this.rptViewer.LocalReport.Refresh();
}
protected void DownloadIndent(int id, string type)
{
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;
//here
//set report
//set report datasurce
IndentReportService _IndentReportService = new IndentReportService();
List <Services.Models.IndentReportDataSet> dataSource = _IndentReportService.GetIndentDetailById(id);
if (dataSource.Count > 0)
{
//foreach (var ds in dataSource)
//{
// if (ds.PlantId == null)
// {
// ds.PlantName = "General";
// }
//}
rvSiteMapping.Visible = false;
pnlNoData.Visible = false;
byte[] bytes = null;
if (type == "PR")
{
String reportFolder = System.Configuration.ConfigurationManager.AppSettings["SSRSReportsFolder"].ToString();
rvSiteMapping.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource);
datasrc.Name = "DataSet1";
//datasrc.DataSourceId=
rvSiteMapping.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource));
bytes = rvSiteMapping.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
}
else
{
String reportFolder = System.Configuration.ConfigurationManager.AppSettings["SSRSReportsFolder"].ToString();
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource);
datasrc.Name = "DataSet1";
//datasrc.DataSourceId=
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource));
bytes = ReportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
}
DownloadFile(bytes, string.Format("{0}.pdf", dataSource[0].IndentNo.Replace("/", "-")));
}
}
protected void Page_Load(object sender, EventArgs e)
{
string htqdRqStart = string.Empty;
string htqdRqEnd = string.Empty;
string ssdq = string.Empty;
string htlb = string.Empty;
try
{
htqdRqStart = Request.QueryString["htqdRqStart"].ToString();
htqdRqEnd = Request.QueryString["htqdRqEnd"].ToString();
ssdq = Request.QueryString["ssdq"].ToString();
htlb = Request.QueryString["ContractTypeNum"].ToString();
}
catch
{
}
if (!IsPostBack)
{
//Response.Write("<script type='text/javascript'>window.close();</script>");
DataTable dt = RetrieveTjfx_Htba_Report(htqdRqStart, htqdRqEnd, ssdq, htlb);
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource();
rds.Name = "DataSet1";
rds.Value = dt;
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(rds);
this.ReportViewer1.Visible = true;
this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("./Report1.rdlc");
this.ReportViewer1.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string fileName = Guid.NewGuid().ToString();
byte[] bytes = ReportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out extension,
out streamids, out warnings);
string fileSaveName, fileSaveUrl;
fileSaveName = DateTime.Now.ToString("yyyyMMddHHmmss") + "." + extension;
fileSaveUrl = "./AllFiles/" + fileSaveName;
fileSaveUrl = Server.MapPath(fileSaveUrl);
FileStream fs = new FileStream(fileSaveUrl, FileMode.Create);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write(bytes);
bw.Close();
fs.Close();
Response.Write("<script type='text/javascript'> window.open('./AllFiles/" + fileSaveName + "') ;</script>");
Response.Write("<script type='text/javascript'>window.close();</script>");
}
}
protected void RunOriginSummary()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "uspRptSummaryByOrigin";
cmd.CommandType = CommandType.StoredProcedure;
if (Session["profilename"].ToString() == "Client")
{
cmd.Parameters.Add(new SqlParameter("@ClientId", Session["ClientId"].ToString()));
}
else
{
cmd.Parameters.Add(new SqlParameter("@ClientId", this.lstClient.SelectedValue.ToString()));
}
SqlDataReader dr = cmd.ExecuteReader();
dsInvoiceSummary dsSummary = new dsInvoiceSummary();
while (dr.Read())
{
//dsSummary.Tables[0].Rows.Add(dr[0].ToString(), System.Convert.ToDouble(dr[1].ToString()));
dsSummary.Tables[0].Rows.Add(dr[0].ToString(), dr[1].ToString(), System.Convert.ToDouble(dr[2].ToString()), dr[3].ToString());
}
this.rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.Reset();
Microsoft.Reporting.WebForms.ReportDataSource rdInvSummary = new Microsoft.Reporting.WebForms.ReportDataSource("dsInvoiceSummary", dsSummary.Tables[0]);
this.rptViewer.LocalReport.DataSources.Add(rdInvSummary);
this.rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.rptViewer.LocalReport.ReportPath = @"Reports\StatementSummaryBySrc.rdlc";
Microsoft.Reporting.WebForms.ReportParameter ClientDescription = null;
if (Session["profilename"].ToString() == "Client")
{
ClientDescription = new Microsoft.Reporting.WebForms.ReportParameter("ClientDescription", Session["ClientDesc"].ToString());
}
else
{
ClientDescription = new Microsoft.Reporting.WebForms.ReportParameter("ClientDescription", this.lstClient.SelectedItem.ToString());
}
this.rptViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { ClientDescription });
this.rptViewer.LocalReport.EnableHyperlinks = true;
this.rptViewer.LocalReport.Refresh();
}
private void renderMachinesListReport()
{
DashboardData reportData = new DashboardData();
var data = reportData.GetMachinesList();
var reportDataSource1 = new Microsoft.Reporting.WebForms.ReportDataSource();
reportDataSource1.Name = "dsMachinesList";
reportDataSource1.Value = data;
this.ReportViewer1.LocalReport.DataSources.Add(reportDataSource1);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Rdlc/MachinesList.rdlc");
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ZoomMode = ZoomMode.PageWidth;
}
protected void rptViewer_Drillthrough(object sender, Microsoft.Reporting.WebForms.DrillthroughEventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "uspRptDetailByOrigin";
cmd.CommandType = CommandType.StoredProcedure;
if (Session["profilename"].ToString() == "Client")
{
cmd.Parameters.Add(new SqlParameter("@ClientId", Session["ClientId"].ToString()));
}
else
{
cmd.Parameters.Add(new SqlParameter("@ClientId", this.lstClient.SelectedValue.ToString()));
}
Microsoft.Reporting.WebForms.ReportParameterInfoCollection DrillThroughValues = e.Report.GetParameters();
cmd.Parameters.Add(new SqlParameter("@Src", DrillThroughValues[0].Values[0]));
SqlDataReader dr = cmd.ExecuteReader();
dsInvoiceDetail ds = new dsInvoiceDetail();
while (dr.Read())
{
ds.Tables[0].Rows.Add(dr[0].ToString(), System.Convert.ToDateTime(dr[1].ToString()), dr[2].ToString(), dr[3].ToString(), System.Convert.ToInt32(dr[4].ToString()), System.Convert.ToDouble(dr[5].ToString()));
}
dr.Close();
conn.Close();
conn.Dispose();
this.rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.Reset();
LocalReport drillThroughReport = (LocalReport)e.Report;
Microsoft.Reporting.WebForms.ReportDataSource rdInvDetail = new Microsoft.Reporting.WebForms.ReportDataSource("dsInvoiceDetailwhatever", ds.Tables[0]);
drillThroughReport.DataSources.Add(rdInvDetail);
this.rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.rptViewer.LocalReport.ReportPath = @"Reports\StatementDetailBySrc.rdlc";
Microsoft.Reporting.WebForms.ReportParameter Origin = new Microsoft.Reporting.WebForms.ReportParameter("Origin", DrillThroughValues[0].Values[0]);
this.rptViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { Origin });
this.rptViewer.LocalReport.Refresh();
}
protected void RenderReport()
{
try
{
DataCommandService dataCommandDB = DataCommandService.GetInstance();
PageDB pageDB = new PageDB();
viewer.Reset();
LoadReportDefinition(viewer.LocalReport);
viewer.LocalReport.DataSources.Clear();
foreach (CodeTorch.Core.ReportParameter p in GetReportParameters())
{
string parameterValue = null;
if (p.Value != null)
{
parameterValue = p.Value.ToString();
}
Microsoft.Reporting.WebForms.ReportParameter rp = new Microsoft.Reporting.WebForms.ReportParameter(p.Name, parameterValue);
viewer.LocalReport.SetParameters(rp);
}
foreach (CodeTorch.Core.ReportDataSource dataSource in Me.ReportDataSources)
{
DataTable data = GetData(dataCommandDB, pageDB, dataSource);
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource(dataSource.Name, data);
viewer.LocalReport.DataSources.Add(rds);
}
viewer.LocalReport.DisplayName = "Report";
viewer.LocalReport.Refresh();
viewer.Visible = true;
this.Visible = true;
}
catch (Exception ex)
{
Common.LogException(ex, false);
page.DisplayErrorAlert(String.Format("<strong>The following error(s) occurred:</strong>{0}", Common.GetExceptionMessage(ex, 4)));
}
}
private void RenderEdWEntryReport(Dictionary <string, string> dictRes)
{
try
{
ReportViewerDisplay.Reset();
string sqlQuery = "sp_EDW_Reports_TEST";
SqlConnection con = HomeController.GetConnection();
con.Open();
System.Data.DataTable dt = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
//ADD PARAMETERS FOR LISTING REPORT
DateTime defaultStartDateTime = dictRes.ContainsKey("dates") ? DateTime.ParseExact(dictRes["dates"].Split(',')[0], "yyyy-MM-dd", null) : DateTime.Now.AddYears(-1);
DateTime defaultEndDateTime = dictRes.ContainsKey("dates") ? DateTime.ParseExact(dictRes["dates"].Split(',')[1], "yyyy-MM-dd", null) : DateTime.Now;
da.SelectCommand.Parameters.AddWithValue("@cnstncy_nbr", dictRes["const"]);
da.SelectCommand.Parameters.AddWithValue("@app_type", dictRes["appType"]);
da.SelectCommand.Parameters.AddWithValue("@worker_type", dictRes["workerType"]);
da.SelectCommand.Parameters.AddWithValue("@status", dictRes["status"]);
da.SelectCommand.Parameters.AddWithValue("@StartDate", defaultStartDateTime);
da.SelectCommand.Parameters.AddWithValue("@EndDate", defaultEndDateTime);
da.Fill(dt);
ReportViewerDisplay.LocalReport.DataSources.Clear();
Microsoft.Reporting.WebForms.ReportDataSource rpdc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dt);
ReportViewerDisplay.LocalReport.DataSources.Add(rpdc);
ReportViewerDisplay.LocalReport.EnableExternalImages = true;
ReportViewerDisplay.LocalReport.ReportPath = Server.MapPath("~/Reports/ReportEdwListing.rdlc");
//ReportViewerDisplay.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("Dates", new string[] { defaultStartDateTime.ToString(), defaultEndDateTime.ToString() }, true));
ReportParameter stDate = new ReportParameter("stDate", defaultStartDateTime.ToString());
ReportParameter eDate = new ReportParameter("eDate", defaultEndDateTime.ToString());
ReportViewerDisplay.LocalReport.SetParameters(new ReportParameter[] { stDate, eDate });
ReportViewerDisplay.LocalReport.Refresh();
}
catch (Exception)
{
}
}
private void RetrieveFieldsDetailLocal()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = 0 AND InvReceiptFlag = 'R' AND InvReceiptCode = '" + mlDATATABLE.Rows[0]["InvReceiptCode"].ToString() + "'" +
" AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
//Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource("INV_RECEIPT_DATAH", mlDATATABLE);
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
ReportViewer1.LocalReport.Refresh();
}
public static string CreateReceiptPrintout2(DataSet ds, string reportName)
{
Microsoft.Reporting.WebForms.LocalReport lr = new Microsoft.Reporting.WebForms.LocalReport();
lr.DataSources.Clear();
lr.ReportPath = FrameworkSetting.Setting.AbsoluteReportFolder + reportName;
//Emnable Image
lr.EnableExternalImages = true;
//
foreach (DataTable dt in ds.Tables)
{
Microsoft.Reporting.WebForms.ReportDataSource rs = new Microsoft.Reporting.WebForms.ReportDataSource();
rs.Name = dt.TableName;
rs.Value = dt;
lr.DataSources.Add(rs);
}
return(BuildPrintoutFile(lr, "PDF"));
}
private void PopulateReport()
{
List <Models.Medicine> medicines = null;
using (Models.MyDBContext d = new Models.MyDBContext())
{
medicines = d.medicines.OrderBy(a => a.name).ToList();
//var v = from a in d.medicines select a;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/rpt_medicineDetails.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
Microsoft.Reporting.WebForms.ReportDataSource rd = new Microsoft.Reporting.WebForms.ReportDataSource("medicineDetails", medicines);
ReportViewer1.LocalReport.DataSources.Add(rd);
ReportViewer1.LocalReport.Refresh();
}
}
public void CreatePDF(string argStrFilePath, string argStrFileName, DataTable argDataTable, string argStrDataSetName, bool argBoolIsForceDownload)
{
// argStrFilePath = @"~/Reports/"
// Variables
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
// Setup the report viewer object and get the array of bytes
ReportDataSource reportDataSource = new Microsoft.Reporting.WebForms.ReportDataSource {
Name = argStrDataSetName, Value = argDataTable
};
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = HttpContext.Current.Server.MapPath(argStrFilePath + argStrFileName + ".rdlc");//"YourReportHere.rdlc";
viewer.LocalReport.DataSources.Clear();
viewer.LocalReport.DataSources.Add(reportDataSource);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
// Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.BufferOutput = true;
HttpContext.Current.Response.ContentType = string.IsNullOrEmpty(mimeType) ? "application/pdf" : mimeType;
//Forec to download
if (argBoolIsForceDownload)
{
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + argStrFileName + DateTime.Now.Ticks.ToString() + "." + extension);
}
else //Direct to browser if has Acrobat plug-in available
{
HttpContext.Current.Response.AddHeader("content-disposition", "inline; filename=" + argStrFileName + DateTime.Now.Ticks.ToString() + "." + extension);
}
HttpContext.Current.Response.BinaryWrite(bytes); // create the file
HttpContext.Current.Response.Flush(); // send it to the client to download
HttpContext.Current.Response.Close();
}
protected void generateWorkSchedule()
{
this.rvWorkSchedule.ProcessingMode = ProcessingMode.Local;
ISSA.Pages.Reports.DataSet1 DS_Report = new ISSA.Pages.Reports.DataSet1();
DS_Report.EnforceConstraints = false;
ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter Rpt_TableAdapter = new ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter();
Rpt_TableAdapter.Fill(DS_Report.TA_RPT_WorkSchedule, ddlYear.SelectedValue, ddlMonth.SelectedValue, Convert.ToByte(ddlArea.SelectedValue), ddlShift.SelectedValue);
ISSA.Pages.Reports.DataSet1.dtParametersDataTable dtParam = new ISSA.Pages.Reports.DataSet1.dtParametersDataTable();
DataRow dr = dtParam.NewRow();
dr["ParamOne"] = ddlMonth.SelectedItem.Text + ", " + ddlYear.SelectedValue;
dr["ParamTwo"] = ddlArea.SelectedItem.Text;
if (ddlShift.SelectedIndex == 0)
{
dr["ParamThree"] = "All";
}
else
{
dr["ParamThree"] = ddlShift.SelectedItem.Text;
}
dr["User"] = loggedInUser;
dr["Date"] = DateTime.Now;
dtParam.Rows.Add(dr);
Microsoft.Reporting.WebForms.ReportDataSource RpDs1 = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.ReportDataSource RpDsParameters = new Microsoft.Reporting.WebForms.ReportDataSource();
RpDs1.Name = "TA_RPT_WorkSchedule";
RpDs1.Value = DS_Report.TA_RPT_WorkSchedule;
RpDsParameters.Name = "dtParameters";
RpDsParameters.Value = dtParam;
this.rvWorkSchedule.LocalReport.ReportPath = "Pages/Reports/rpt_WorkSchedule.rdlc";
this.rvWorkSchedule.LocalReport.DataSources.Clear();
this.rvWorkSchedule.LocalReport.DataSources.Add(RpDs1);
this.rvWorkSchedule.LocalReport.DataSources.Add(RpDsParameters);
this.rvWorkSchedule.LocalReport.Refresh();
this.rvWorkSchedule.Visible = true;
this.rvWorkSchedule.ShowReportBody = true;
}
public void LoadReport(CDTReportDataIn objCDTReportDataIn)
{
Orders objOrders;
try
{
string [] sOrderTax_Discnt;
switch (objCDTReportDataIn.ReportName)
{
case Constants.RPT_CUSTBILL:
_lr.ReportPath = ConfigurationManager.AppSettings["reportPath"].ToString() + "rptCustBill.rdlc";
objOrders = new Orders();
sOrderTax_Discnt = objOrders.getOrderTaxForBill(objCDTReportDataIn.OrderID);
//Set the parameters
ReportParameter p1 = new ReportParameter("HotelName", objCDTReportDataIn.HotelName);
_lr.SetParameters(new ReportParameter[] { p1 });
ReportParameter p2 = new ReportParameter("OrderID", objCDTReportDataIn.OrderID.ToString());
_lr.SetParameters(new ReportParameter[] { p2 });
ReportParameter p3 = new ReportParameter("TotalTax", sOrderTax_Discnt[0]);
_lr.SetParameters(new ReportParameter[] { p3 });
ReportParameter p4 = new ReportParameter("DiscountPrcnt", sOrderTax_Discnt[1]);
_lr.SetParameters(new ReportParameter[] { p4 });
Microsoft.Reporting.WebForms.ReportDataSource rds;
rds = null;
rds = new Microsoft.Reporting.WebForms.ReportDataSource();
rds.Name = "dsCustBill";
rds.Value = objOrders.getCustBill(objCDTReportDataIn.OrderID).Tables[0];
_lr.DataSources.Add(rds);
break;
}
}
finally
{
objOrders = null;
}
}
public static string CreateReceiptPrintout(DataTable dtData, DataTable dtDetail, string reportName)
{
Microsoft.Reporting.WebForms.LocalReport lr = new Microsoft.Reporting.WebForms.LocalReport();
lr.ReportPath = FrameworkSetting.Setting.AbsoluteReportFolder + reportName;
lr.EnableExternalImages = true;
Microsoft.Reporting.WebForms.ReportDataSource rsInvoice = new Microsoft.Reporting.WebForms.ReportDataSource();
rsInvoice.Name = dtData.TableName;
rsInvoice.Value = dtData;
lr.DataSources.Add(rsInvoice);
Microsoft.Reporting.WebForms.ReportDataSource rsInvoiceDetail = new Microsoft.Reporting.WebForms.ReportDataSource();
rsInvoiceDetail.Name = dtDetail.TableName;
rsInvoiceDetail.Value = dtDetail;
lr.DataSources.Add(rsInvoiceDetail);
return(BuildPrintoutFile(lr, "PDF"));
}
private void renderProductionDetailedReport(ReportParameters para)
{
ReportData reportData = new ReportData();
var data = reportData.GetProductionDetailedReport(para);
var reportDataSource1 = new Microsoft.Reporting.WebForms.ReportDataSource();
reportDataSource1.Name = "dsProductionDetailedReport";
reportDataSource1.Value = data;
this.ReportViewer1.LocalReport.DataSources.Add(reportDataSource1);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Rdlc/ProductionDetailedReport.rdlc");
ReportParameter[] rptParams = new ReportParameter[2];
rptParams[0] = new ReportParameter("paraDateFrom", para.DateFrom.Date.ToString(), true);
rptParams[1] = new ReportParameter("paraDateTo", para.DateTo.Date.ToString(), true);
this.ReportViewer1.LocalReport.SetParameters(rptParams);
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ZoomMode = ZoomMode.PageWidth;
}
private DataTable GetData(string parameterName, string dataSourceName)
{
FileInfo reportFullPath = this.ReportFile;
//check to make sure the file ACTUALLY exists, before we start working on it
if (reportFullPath == null)
{
return(null);
}
var errorMessages = new List <ErrorMessage>();
//map the reporting engine to the .rdl/.rdlc file
LoadReportDefinitionFile(CurrentReportViewer.LocalReport, reportFullPath);
// Look-up the DB query in the "DataSets" element of the report file (.rdl/.rdlc which contains XML)
RDL.Report reportDef = this.ReportDefinition;
CheckReportParameters(CurrentReportViewer.LocalReport);
var parameter = reportDef.ReportParameters.FirstOrDefault(p => p.Name.Equals(parameterName));
if (parameter == null)
{
ReportSingleErroMessage($"The parameter {parameterName } was not found in report {ReportName}");
return(null);
}
// Run each query (usually, there is only one) and attach each to the report
var validValue = parameter.ValidValues.FirstOrDefault(v => v.DataSetName.Equals(dataSourceName));
if (validValue == null)
{
ReportSingleErroMessage($"The parameter {parameterName } has no valid DataSetName ({dataSourceName}) for report {ReportName}");
return(null);
}
RDL.DataSet ds = parameter.ValidValues.FirstOrDefault().DataSet;
WebForms.ReportDataSource rds = GetReportDataSource(reportDef, ds);
return((DataTable)rds.Value);
}
public static byte[] RenderReport(ExportRDLCCommand reportDefinition, Hashtable dataItems, out string mime, out string ext)
{
byte[] retVal;
LocalReport localReport = new LocalReport();
localReport.DataSources.Clear();
LoadReportDefinition(localReport, reportDefinition);
foreach (CodeTorch.Core.ReportDataSource dataSource in reportDefinition.ReportDataSources)
{
DataTable data = (DataTable)dataItems[dataSource.Name];
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource(dataSource.Name, data);
localReport.DataSources.Add(rds);
}
localReport.Refresh();
retVal = Export(localReport, reportDefinition, out mime, out ext);
return(retVal);
}
//Metodo para Mostrar el archivo
private void RenderReport(ReportViewer Report, HttpResponse Response)
{
try
{
Warning[] warnings = null;
string[] streamids;
string mimeType = "";
string encoding;
string extension = "pdf";
string filename = "Liq" + Session["conse"].ToString() + "Ac"+Session["acta"].ToString();
//Dataset para Liquidacion
ObjectDataSource ObjectDataSource1 = new ObjectDataSource("Generals.Web.Datasets.Ds_liquiTableAdapters.Sp_RevisarLiquidacionTableAdapter", "GetData");
ObjectDataSource1.SelectParameters.Add("conse", Session["Conse"].ToString());
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DsLiqui", ObjectDataSource1);
//DataSet para Consumo
ObjectDataSource ObjectDataSource2 = new ObjectDataSource("Generals.Web.Datasets.Ds_liquiTableAdapters.Sp_Consumos_RevisarLiquiTableAdapter", "GetData");
ObjectDataSource2.SelectParameters.Add("acta", Session["acta"].ToString());
Microsoft.Reporting.WebForms.ReportDataSource rds1 = new Microsoft.Reporting.WebForms.ReportDataSource("DsConsumos", ObjectDataSource2);
Report.LocalReport.DataSources.Add(rds);
Report.LocalReport.DataSources.Add(rds1);
// Report.LocalReport.DataSources.Add(this.Page.FindControl("ObjectDataSource1"));
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
//// esto es solo para mostrar l pdf en una pagina
var saveAs = string.Format("{0}.pdf", Path.Combine(Server.MapPath(@"~\File\Documentos\"), filename));
if (idx == 0)
{
while (File.Exists(saveAs))
{
idx += 1;
saveAs = string.Format("{0}.{1}.pdf", Path.Combine(Server.MapPath(@"~\File\Documentos\"), filename), idx);
}
using (var stream = new FileStream(saveAs, FileMode.Create, FileAccess.Write))
{
stream.Write(bytes, 0, bytes.Length);
stream.Close();
}
}
Doc = new BllDocumentos.Documentos();
Doc.DocuActa = int.Parse(Session["acta"].ToString());
Doc.DocuTiDo = 13;
Doc.DocuFeCa = System.DateTime.Now;
Doc.DocuUsCa = Usuario.username;
Doc.DocuUrLo = "~/File/Documentos/"+filename+"."+ extension;
Doc.DocuSincro = "1";
Doc.DocuVeri = "1";
Doc.DocuFeVe = System.DateTime.Now.ToString();
Doc.DocuUsVe = Usuario.username; ;
int r = Doc.Insert();
if (r > 0)
{
// Panel p = new Panel(); ;
// Response.Clear();
// Response.Buffer = true;
// Response.ContentType = "application/pdf";
// Response.AddHeader("content-disposition", "attachment;filename="+filename+"."+ extension);
// Response.Charset = "";
// this.EnableViewState = false;
// ScriptManager pr = new ScriptManager();
// System.IO.StringWriter sw = new System.IO.StringWriter();
// System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
// p.Controls.Add(pr);
// p.Controls.Add(Report);
// p.RenderControl(htw);
// Response.Write(sw.ToString());
// Response.End();
//// Response.Buffer = true;
////Response.Clear();
//// Response.ContentType = mimeType;
//// Response.AddHeader("content-Disposition", "attachment; filename=" + filename + "." + extension);
//// Response.BinaryWrite(bytes);
//// Response.Flush();
//Response.Close();
Response.Redirect("GestionBandejas.aspx", false);
}
}
catch (Exception ex)
{
Log.EscribirError(ex);
}
finally
{
Response.Redirect("~/GestionBandejas.aspx", false);
}
}
//Metodo para Mostrar el archivo
private void RenderReport(ReportViewer Report, HttpResponse Response)
{
try
{
Warning[] warnings = null;
string[] streamids;
string mimeType = "";
string encoding;
string extension = "pdf";
string filename = "Proceso" + Session["Proc"].ToString() + "Acta" + Session["acta"].ToString();
ObjectDataSource ObjectDataSource1 = new ObjectDataSource("Generals.Web.Datasets.DstProcesoSimpliTableAdapters.Sp_Proceso_SimpliTableAdapter", "GetData");
ObjectDataSource1.SelectParameters.Add("conse", Session["Proc"].ToString());
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DsPr", ObjectDataSource1);
Report.LocalReport.DataSources.Add(rds);
// Report.LocalReport.DataSources.Add(this.Page.FindControl("ObjectDataSource1"));
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);
//// esto es solo para mostrar l pdf en una pagina
//Response.Clear();
//Response.ContentType = mimeType;
//Response.AppendHeader("content-Disposition", "attachment;filename=" + filename + "." + extension);
var saveAs = string.Format("{0}.pdf", Path.Combine(Server.MapPath(@"~\File\Documentos\"), filename));
if (idx == 0)
{
while (File.Exists(saveAs))
{
idx += 1;
saveAs = string.Format("{0}.{1}.pdf", Path.Combine(Server.MapPath(@"~\File\Documentos\"), filename), idx);
}
using (var stream = new FileStream(saveAs, FileMode.Create, FileAccess.Write))
{
stream.Write(bytes, 0, bytes.Length);
stream.Close();
}
}
//Response.WriteFile(Server.MapPath(@"~\File\Documentos\" + filename + "." + extension));
//Response.BinaryWrite(bytes);
//Response.TransmitFile(Server.MapPath(@"~\File\Documentos\" + filename + "." + extension));
//Response.BinaryWrite(bytes);
Doc = new BllDocumentos.Documentos();
Doc.DocuActa = int.Parse(Session["acta"].ToString());
Doc.DocuTiDo = 16;
Doc.DocuFeCa = System.DateTime.Now;
Doc.DocuUsCa = Usuario.username;
Doc.DocuUrLo = "~/File/Documentos/" + filename + "." + extension;
Doc.DocuSincro = "1";
Doc.DocuVeri = "1";
Doc.DocuFeVe = System.DateTime.Now.ToString();
Doc.DocuUsVe = Usuario.username; ;
int r = Doc.Insert();
if (r > 0)
{
// Response.Flush();
//HttpContext.Current.Response.Buffer = true;
//HttpContext.Current.Response.Clear();
//HttpContext.Current.Response.ContentType = mimeType;
//HttpContext.Current.Response.AddHeader("content-Disposition", "attachment; filename=" + "Proceso" + Session["acta"].ToString() + "." + extension);
//HttpContext.Current.Response.BinaryWrite(bytes);
//HttpContext.Current.Response.Flush();
//Response.Redirect("GestionBandejas.aspx");
//HttpContext.Current.Response.Close();
//Response.Buffer = true;
//Response.Clear();
//Response.ContentType = mimeType;
//Response.AddHeader("content-Disposition", "attachment; filename=" + "Proceso" + Session["acta"].ToString() + "." + extension);
//Response.BinaryWrite(bytes);
//Response.Flush();
Response.Redirect("GestionBandejas.aspx");
//HttpContext.Current.Response.Close();
}
}
catch (Exception ex)
{
Response.Redirect("GestionBandejas.aspx", false); Log.EscribirError(ex);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource();
//rds.DataSourceId = "AbiMatuEnterprise_GetAllAGENTs";
//rds.Name = "dsReceipt";
//rvProducts.LocalReport.DataSources.Clear();
//rvProducts.Reset();
//rvProducts.LocalReport.Refresh();
//rvProducts.LocalReport.ReportPath = "Report.rdlc";
//rvProducts.LocalReport.DataSources.Add(rds);
//rvProducts.LocalReport.Refresh();
//Fill the datasource from DB
//AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter ta = new AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter();
//AdventureWorks.vProductAndDescriptionDataTable dt = new AdventureWorks.vProductAndDescriptionDataTable();
//ta.Fill(dt);
////Create an instance of Barcode Professional
//Neodynamic.WebControls.BarcodeProfessional.BarcodeProfessional bcp = new Neodynamic.WebControls.BarcodeProfessional.BarcodeProfessional();
////Barcode settings
//bcp.Symbology = Neodynamic.WebControls.BarcodeProfessional.Symbology.Code128;
//bcp.BarHeight = 0.25f;
////Update DataTable with barcode image
//foreach (AdventureWorks.vProductAndDescriptionRow row in dt.Rows)
//{
// //Set the value to encode
// bcp.Code = row.ProductID.ToString();
// //Generate the barcode image and store it into the Barcode Column
// row.Barcode = bcp.GetBarcodeImage(System.Drawing.Imaging.ImageFormat.Png);
//}
////Create ReportViewer
//Microsoft.Reporting.WebForms.ReportViewer viewer = new Microsoft.Reporting.WebForms.ReportViewer();
////Create Report Data Source
//Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("AdventureWorks_vProductAndDescription", dt);
//viewer.LocalReport.DataSources.Add(rptDataSource);
//viewer.LocalReport.ReportPath = Server.MapPath("BarcodeReport.rdlc");
////Export to PDF
//string mimeType;
//string encoding;
//string fileNameExtension;
//string[] streams;
//Microsoft.Reporting.WebForms.Warning[] warnings;
//byte[] pdfContent = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
////Return PDF
//this.Response.Clear();
//this.Response.ContentType = "application/pdf";
//this.Response.AddHeader("Content-disposition", "attachment; filename=BarcodeReport.pdf");
//this.Response.BinaryWrite(pdfContent);
//this.Response.End();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
DataTable dt = new DataTable();
dt = sqlLOCATIONProvider.GetAllLOCATIONsForReport();
//GridView1.DataSource = dt;
//GridView1.DataBind();
//Create ReportViewer
Microsoft.Reporting.WebForms.ReportViewer viewer = new Microsoft.Reporting.WebForms.ReportViewer();
//Create Report Data Source
Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dt);
viewer.LocalReport.DataSources.Add(rptDataSource);
viewer.LocalReport.ReportPath = Server.MapPath("Report.rdlc");
}
//protected void ddlOrganization_DataBound(object sender, EventArgs e)
//{
// ddlOrganization.Items.Insert(0, new ListItem("All Organizations", "0"));
// ddlOrganization.SelectedIndex = 0;
//}
//protected void ddlLocation_DataBound(object sender, EventArgs e)
//{
// ddlLocation.Items.Insert(0, new ListItem("All Locations", "0"));
// ddlLocation.SelectedIndex = 0;
//}
//protected void ddlOrganization_SelectedIndexChanged(object sender, EventArgs e)
//{
// BindLocation(ddlOrganization.SelectedValue);
//}
//protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
//{
// // Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), txtDate1.Text, txtDate2.Text);
//}
//protected void btnRxReport_Click(object sender, EventArgs e)
//{
// if(Request.QueryString["patID"]!=null)
// Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), Request.QueryString["patID"].ToString());
//}
protected void Filldata(int ClinicID, int FacilityID, string PatientID)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("eCareXdb_NewDataSet_sp_ReportMedLog");
DataTable dtPatInfo =GetData(ClinicID, FacilityID, PatientID);
rds.Value = dtPatInfo;
ReportViewer2.LocalReport.ReportPath = "Reports/RptMedLog.rdlc";
ReportParameter PatID = new ReportParameter("PatientID", PatientID);
ReportParameter[] rp = new ReportParameter[] {PatID};
ReportViewer2.LocalReport.SetParameters(rp);
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
}
protected void RunInternational()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "uspRptInternational";
cmd.CommandType = CommandType.StoredProcedure;
if (Session["profilename"].ToString() == "Client")
{
cmd.Parameters.Add(new SqlParameter("@ClientId", Session["ClientId"].ToString()));
}
else
{
cmd.Parameters.Add(new SqlParameter("@ClientId", this.lstClient.SelectedValue.ToString()));
}
cmd.Parameters.Add(new SqlParameter("@StartDate", this.txtStartDate.Text));
cmd.Parameters.Add(new SqlParameter("@EndDate", this.txtEndDate.Text));
SqlDataReader dr = cmd.ExecuteReader();
dsInvoiceDetail dsDetail = new dsInvoiceDetail();
while (dr.Read())
{
dsDetail.Tables[0].Rows.Add(dr[0].ToString(), System.Convert.ToDateTime(dr[1].ToString()), dr[2].ToString(), dr[3].ToString(), System.Convert.ToInt32(dr[4].ToString()), System.Convert.ToDouble(dr[5].ToString()));
}
dr.Close();
this.rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.Reset();
Microsoft.Reporting.WebForms.ReportDataSource rdInvDetail = new Microsoft.Reporting.WebForms.ReportDataSource("dsInvoiceDetail", dsDetail.Tables[0]);
this.rptViewer.LocalReport.DataSources.Add(rdInvDetail);
this.rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.rptViewer.LocalReport.ReportPath = @"Reports\International.rdlc";
// Get the date range to show on the report
var startDate = (from dta in dsDetail.Tables[0].AsEnumerable()
orderby dta.Field <DateTime>("CallDate") ascending
select(dta.Field <DateTime>("CallDate"))).FirstOrDefault();
var endDate = (from dta in dsDetail.Tables[0].AsEnumerable()
orderby dta.Field <DateTime>("CallDate") ascending
select(dta.Field <DateTime>("CallDate"))).LastOrDefault();
// Configure report params
Microsoft.Reporting.WebForms.ReportParameter ClientDescription = null;
if (Session["profilename"].ToString() == "Client")
{
ClientDescription = new Microsoft.Reporting.WebForms.ReportParameter("ClientDescription", Session["ClientDesc"].ToString());
}
else
{
ClientDescription = new Microsoft.Reporting.WebForms.ReportParameter("ClientDescription", this.lstClient.SelectedItem.ToString());
}
Microsoft.Reporting.WebForms.ReportParameter ReportDescription = new Microsoft.Reporting.WebForms.ReportParameter("ReportDescription", "From : " + startDate + Environment.NewLine + "To : " + endDate);
this.rptViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { ClientDescription, ReportDescription });
this.rptViewer.LocalReport.Refresh();
}
protected void Filldata(int ClinicID, int FacilityID, string date1,string date2)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("eCareXdb_NewDataSet_sp_ReportNewPrescription");
//rds.Name = "table1";
rds.Value = GetData( ClinicID, FacilityID, date1, date2);
ReportViewer2.LocalReport.ReportPath = "Reports/RptNewPatient.rdlc";
ReportParameter Date1 = new ReportParameter("Date1", date1);
ReportParameter Date2 = new ReportParameter("Date2", date2);
ReportParameter[] rp = new ReportParameter[] { Date1, Date2 };
ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
//protected void ddlOrganization_DataBound(object sender, EventArgs e)
//{
// ddlOrganization.Items.Insert(0, new ListItem("All Organizations", "0"));
// ddlOrganization.SelectedIndex = 0;
//}
//protected void ddlLocation_DataBound(object sender, EventArgs e)
//{
// ddlLocation.Items.Insert(0, new ListItem("All Locations", "0"));
// ddlLocation.SelectedIndex = 0;
//}
//protected void ddlOrganization_SelectedIndexChanged(object sender, EventArgs e)
//{
// bindLocation(ddlOrganization.SelectedValue);
//}
//protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
//{
// // Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), txtDate1.Text, txtDate2.Text);
//}
//protected void btnRxReport_Click(object sender, EventArgs e)
//{
// Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), ddlSType.SelectedValue, txtDate1.Text, txtDate2.Text);
//}
protected void Filldata(int DrugID, int FacilityID, string DType, string date1, string date2)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet4_sp_ReportDrugActivityLog");
//rds.Name = "table1";
rds.Value = GetData(DrugID, FacilityID, DType, date1, date2);
ReportViewer2.LocalReport.ReportPath = "Reports/RptSInventLog.rdlc";
ReportParameter SPDrugID = new ReportParameter("DrugID", DrugID.ToString());
ReportParameter SPType = new ReportParameter("DType", DType);
ReportParameter FacID = new ReportParameter("FacID", FacilityID.ToString());
ReportParameter Date1 = new ReportParameter("FromDate", date1);
ReportParameter Date2 = new ReportParameter("ToDate", date2);
ReportParameter[] rp = new ReportParameter[] { SPDrugID, SPType, FacID, Date1, Date2 };
ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
private void RetrieveFieldsDetailPDF1()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filename = "";
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.27in</PageWidth>" +
" <PageHeight>11.69in</PageHeight>" +
" <MarginTop>0.7874in</MarginTop>" +
" <MarginLeft>0.98425in</MarginLeft>" +
" <MarginRight>0.98425in</MarginRight>" +
" <MarginBottom>0.7874in</MarginBottom>" +
"</DeviceInfo>";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = 0 AND InvReceiptFlag = 'R' AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
//byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamIds, out warnings);
string path = Server.MapPath("~/pj_delinv/Print_Files");
// Open PDF File in Web Browser
filename = "InvReceipt";
extension = "pdf";
FileStream file = new FileStream(path + "/" + filename + "." + extension, FileMode.OpenOrCreate, FileAccess.ReadWrite);
file.Write(bytes, 0, bytes.Length);
file.Dispose();
WebClient client = new WebClient();
Byte[] buffer = client.DownloadData(path + "/" + filename + "." + extension);
if (buffer != null)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", buffer.Length.ToString());
Response.BinaryWrite(buffer);
}
}
protected void Filldata(int ClinicID, int FacilityID, string rxstatus, string date1, string date2)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet4_sp_ReportDrugActivity");
//rds.Name = "table1";
if (rxstatus != "P" && rxstatus != "S")
rxstatus = "%";
rds.Value = GetData(ClinicID, FacilityID, rxstatus, date1, date2);
ReportViewer2.Reset();
ReportViewer2.LocalReport.ReportPath = "Reports/RptSLog.rdlc";
ReportParameter Date1 = new ReportParameter("FromDate", date1);
ReportParameter Date2 = new ReportParameter("ToDate", date2);
ReportParameter[] rp = new ReportParameter[] { Date1, Date2 };
ReportViewer2.LocalReport.EnableHyperlinks = true;
ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
protected void ReportViewer2_Drillthrough(object sender, DrillthroughEventArgs e)
{
Microsoft.Reporting.WebForms.ReportDataSource rdis = new Microsoft.Reporting.WebForms.ReportDataSource("dsDInventLog_sp_ReportDrugActivityLog");
//rds.Name = "table1";
int rdrugID=0, rfacID=0;
String rdrugName="", rclinName="", rdType="S";
String date1="", date2="";
LocalReport report = (LocalReport)e.Report;
//ReportViewer2.LocalReport.ReportPath = "Reports/RptSInventLog.rdlc";
IList<ReportParameter> list = report.OriginalParametersToDrillthrough;
int i = 0;
foreach (ReportParameter param in list) {
switch (i)
{
case 0:
rdrugID = Convert.ToInt32(param.Values[0].ToString());
break;
case 1:
rdrugName = param.Values[0].ToString();
break;
case 2:
rdType = param.Values[0].ToString();
break;
case 3:
rfacID = Convert.ToInt32(param.Values[0].ToString());
break;
case 4:
rclinName = param.Values[0].ToString();
break;
case 5:
date1 = param.Values[0].ToString();
break;
case 6:
date2 = param.Values[0].ToString();
break;
}
i++;
}
rdis.Value = GetInventData(rdrugID, rfacID, rdType, date1, date2);
ReportParameter DrugID = new ReportParameter("DrugID", rdrugID.ToString());
ReportParameter DType = new ReportParameter("DName", rdrugName);
ReportParameter DName = new ReportParameter("DType", rdType);
ReportParameter FacID = new ReportParameter("FacID", rfacID.ToString());
ReportParameter CName = new ReportParameter("CName", rclinName);
ReportParameter Date1 = new ReportParameter("FromDate", date1);
ReportParameter Date2 = new ReportParameter("ToDate", date2);
ReportParameter[] rp = new ReportParameter[] { DrugID, DType, FacID, Date1, Date2 };
report.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
report.DataSources.Add(rdis);
//report.LocalReport.DataSources.Clear();
//report.LocalReport.DataSources.Add(rds);
//report.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
protected void Filldata(int ClinicID, int FacilityID, string date1, string date2)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSetPayment");
//rds.Name = "table1";
rds.Value = GetDate(ClinicID, FacilityID, date1, date2);
ReportViewer2.LocalReport.ReportPath = "Reports/RptPayment.rdlc";
ReportParameter LocationName = new ReportParameter("LocationName", "7/7/2009");
ReportParameter Date1 = new ReportParameter("FromDate", date1);
ReportParameter Date2 = new ReportParameter("ToDate", date2);
ReportParameter[] rp = new ReportParameter[] { LocationName, Date1, Date2 };
ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
public void GetRDLCContents()
{
#region Get RDLC Contents
string _ReportPath = "";
string mimeType;
string encoding;
string fileNameExtension;
string[] streams;
DataSet _DataSetGetRdlCName = null;
DataSet _DataSetRdlForMainReport = null;
DataSet _DataSetRdlForSubReport = null;
DataRow[] dr = null;
DataRow[] _drSubReport = null;
string _OrderingMethod = "";
string strErrorMessage = "";
LogManager objLogManager = null;
ReportParameter[] _RptParam = null;
int LocationId = 1;
reportViewer1 = new Microsoft.Reporting.WebForms.ReportViewer();
string strIds = "";
try
{
_ReportPath = Server.MapPath(".") + System.Configuration.ConfigurationManager.AppSettings["MedicationPerscriptionReportUrl"];
if (_ReportPath == "")
{
strErrorMessage = "ReportPath is Missing In WebConfig";
ScriptManager.RegisterStartupScript(Label1, Label1.GetType(), ClientID.ToString(), "ShowError('" + strErrorMessage + "', true);", true);
return;
}
}
catch (Exception ex)
{
Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
strErrorMessage = "ReportPath Key is Missing In WebConfig";
ScriptManager.RegisterStartupScript(Label1, Label1.GetType(), ClientID.ToString(), "ShowError('" + strErrorMessage + "', true);", true);
return;
}
finally
{
objLogManager = null;
}
try
{
Streamline.UserBusinessServices.ClientMedication objectClientMedications = null;
objectClientMedications = new ClientMedication();
_DataSetGetRdlCName = objectClientMedications.GetRdlCNameDataBase(1026);
_DataSetGetRdlCName.Tables[0].TableName = "DocumentCodes";
_DataSetGetRdlCName.Tables[1].TableName = "DocumentCodesRDLSubReports";
if (_DataSetGetRdlCName.Tables["DocumentCodes"].Rows.Count > 0)
{
dr = _DataSetGetRdlCName.Tables["DocumentCodes"].Select();
if ((dr[0]["DocumentName"] != DBNull.Value || !String.IsNullOrEmpty(dr[0]["DocumentName"].ToString())) && (dr[0]["ViewStoredProcedure"] != DBNull.Value || !String.IsNullOrEmpty(dr[0]["ViewStoredProcedure"].ToString())))
{
#region Get the StoredProceudreName and Execute
string _StoredProcedureName = "";
string _ReportName = "";
_StoredProcedureName = dr[0]["ViewStoredProcedure"].ToString();
_ReportName = dr[0]["DocumentName"].ToString();
this.reportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
this.reportViewer1.LocalReport.ReportPath = _ReportPath + "\\" + _ReportName + ".rdlc";
this.reportViewer1.LocalReport.DataSources.Clear();
//Testing By Vikas Vyas
reportViewer1.LocalReport.Refresh();
//End
string str = Session["MedicationIdsForConsentDetailPage"].ToString();
_DataSetRdlForMainReport = objectClientMedications.GetDataForHarborStandardConsentRdlC(_StoredProcedureName, Convert.ToInt32((((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId)), str, Convert.ToInt32(HiddenFieldLatestDocumentVersionId.Value));
Microsoft.Reporting.WebForms.ReportDataSource DataSource = new Microsoft.Reporting.WebForms.ReportDataSource("RDLReportDataSet_" + _StoredProcedureName, _DataSetRdlForMainReport.Tables[0]);
DataSet dstemp = (DataSet)Session["DataSetRdlTemp"];
if (dstemp == null)
{
dstemp = _DataSetRdlForMainReport;
}
else
{
dstemp.Merge(_DataSetRdlForMainReport);
}
Session["DataSetRdlTemp"] = dstemp;
#endregion
if (_DataSetGetRdlCName.Tables["DocumentCodesRDLSubReports"].Rows.Count > 0)
{
_drSubReport = _DataSetGetRdlCName.Tables["DocumentCodesRDLSubReports"].Select();
reportViewer1.LocalReport.SubreportProcessing -= new Microsoft.Reporting.WebForms.SubreportProcessingEventHandler(SetSubDataSource);
reportViewer1.LocalReport.SubreportProcessing += new Microsoft.Reporting.WebForms.SubreportProcessingEventHandler(SetSubDataSource);
for (int i = 0; i < _drSubReport.Length; i++)
{
if ((_drSubReport[i]["SubReportName"] != DBNull.Value || !String.IsNullOrEmpty(_drSubReport[i]["SubReportName"].ToString())) && (_drSubReport[i]["StoredProcedure"] != DBNull.Value || !String.IsNullOrEmpty(_drSubReport[i]["StoredProcedure"].ToString())))
{
#region Get the StoredProcedureName For SubReport and Execute
string _SubReportStoredProcedure = "";
string _SubReportName = "";
_SubReportStoredProcedure = _drSubReport[i]["StoredProcedure"].ToString();
_SubReportName = _drSubReport[i]["SubReportName"].ToString();
string str2 = Session["MedicationIdsForConsentDetailPage"].ToString();
_DataSetRdlForSubReport = objectClientMedications.GetDataForHarborStandardConsentRdlC(_SubReportStoredProcedure, Convert.ToInt32((((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId)), str2, Convert.ToInt32(HiddenFieldLatestDocumentVersionId.Value));
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource(_SubReportName, _DataSetRdlForSubReport.Tables[0]);
reportViewer1.LocalReport.DataSources.Add(rds);
string strRootPath = Server.MapPath(".");
System.IO.StreamReader RdlSubReport = new System.IO.StreamReader(_ReportPath + "\\" + _SubReportName.Trim() + ".rdlc");
reportViewer1.LocalReport.LoadReportDefinition(RdlSubReport);
#endregion
}
}
}
_RptParam = new ReportParameter[3];
_RptParam[0] = new ReportParameter("ClientId", Convert.ToString(((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId));
string str1 = Session["MedicationIdsForConsentDetailPage"].ToString();
_RptParam[1] = new ReportParameter("ClientMedicationId", str1);
_RptParam[2] = new ReportParameter("ClientName", Convert.ToString(((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.LastName + ", " + ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.FirstName));
reportViewer1.LocalReport.SetParameters(_RptParam);
reportViewer1.LocalReport.Refresh();
reportViewer1.LocalReport.DataSources.Add(DataSource);
strIds = str1;
//ScriptManager.RegisterStartupScript(Label1, Label1.GetType(), ClientID.ToString(), "ShowPrintDiv('" + Session["ChangedOrderMedicationIds"].ToString() + "');", true);
}
}
#endregion
try
{
if (Session["imgId1"] == null || Session["imgId1"] == "")
{
string str = Session["MedicationIdsForConsentDetailPage"].ToString();
Session["imgId1"] = str;
}
else
{
Session["imgId1"] = Convert.ToInt32(Session["imgId1"]) + 1;
}
}
catch (Exception ex)
{
}
#region DeleteOldRenderedImages
try
{
using (Streamline.BaseLayer.RDLCPrint objRDLC = new RDLCPrint())
{
objRDLC.DeleteRenderedImages(Server.MapPath("RDLC\\" + Context.User.Identity.Name));
}
}
catch (Exception ex)
{
Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
}
#endregion
string reportType = "PDF";
IList <Stream> m_streams;
m_streams = new List <Stream>();
Microsoft.Reporting.WebForms.Warning[] warnings;
string deviceInfo = "<DeviceInfo><OutputFormat>PDF</OutputFormat><StartPage>0</StartPage></DeviceInfo>";
//try
//{
// if (Session["imgId1"] == null)
// {
// string str = Session["MedicationIdsForConsentDetailPage"].ToString();
// Session["imgId1"] = str;
// }
// else
// {
// Session["imgId1"] = Convert.ToInt32(Session["imgId1"]) + 1;
// }
//}
//catch (Exception ex)
//{
//}
if (Session["imgId1"] == null)
{
Session["imgId1"] = strIds;
}
using (Streamline.BaseLayer.RDLCPrint objRDLC = new RDLCPrint())
{
//objRDLC.Run(this.reportViewer1.LocalReport, Server.MapPath("RDLC\\" + Context.User.Identity.Name), Session["imgId1"].ToString(), false, false);
objRDLC.RunConsent(this.reportViewer1.LocalReport, Server.MapPath("RDLC\\" + Context.User.Identity.Name), Session["imgId1"].ToString(), false, false);
renderedBytes = reportViewer1.LocalReport.Render(reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
}
//ScriptManager.RegisterStartupScript(Label1, Label1.GetType(), ClientID.ToString(), "ShowPrintDiv('" + Session["imgId1"].ToString() + "');", true);
}
catch (Exception ex)
{
Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
}
finally
{
_DataSetGetRdlCName = null;
_DataSetRdlForMainReport = null;
_DataSetRdlForSubReport = null;
_RptParam = null;
}
}
protected void CallTempData(int SurveyID, int ReportNumber)
{
string query = "";
DataSet ReportSet = new DataSet();
query = "Select SCID.*, SCID.Remark Description, IM.ItemName, IM.Unit, IM.HSNCode, IM.CGST, IM.SGST, IM.IGST, 0 IGSTValue, QH.QuotationNo, QH.QuotationDate, QH.PaymentTerm, QH.CurrencyID, CM.Currency, CurrencyUnit, CurrencyTotal, IGM.GroupName, SCIH.quotationdone, SCIH.ClientID, CMM.ClientName, CMM.Address1, CMM.Address2, CMM.City, CMM.State, CMM.PostalCode, CMM.Country, CMM.GSTNo from SurveyClientItemDetailsVersion SCID, ItemMaster IM, ItemGroupMaster IGM, SurveyClientItemHead SCIH, QuotationHeader QH, QuotationHeaderVersion QHV, CurrencyMaster CM, ClientMaster CMM where SCID.SurveyID=SCIH.surveyID and SCIH.ClientID=CMM.ClientID and IM.GroupID=IGM.GroupID and SCID.ItemID=IM.ItemID and SCIH.SurveyID=QH.SurveyID and QH.CurrencyID=CM.CurrencyID and SCIH.SurveyID=QHV.SurveyID and SCID.versionid=QHV.versionid and SCIH.SurveyID=" + SurveyID + " and SCID.VersionID=QHV.VersionID and QHV.VersionID=" + rblVersion.SelectedValue;
SqlDataAdapter adpt = new SqlDataAdapter(query, conn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
adpt.Fill(ReportSet, "QuotationTable");
if (ReportSet.Tables["QuotationTable"].Rows.Count <= 0)
{
UpdateVersion();
CallTempData(int.Parse(Session["SurveyID"].ToString()), 1);
}
double totalamt = 0;
double amount = 0;
string quotationNo = "";
for (int i = 0; i < ReportSet.Tables["QuotationTable"].Rows.Count; i++)
{
quotationNo = ReportSet.Tables["QuotationTable"].Rows[i]["QuotationNo"].ToString();
double total = double.Parse(ReportSet.Tables["QuotationTable"].Rows[i]["CurrencyTotal"].ToString());
double gst = 0;
if (ReportSet.Tables["QuotationTable"].Rows[i]["IGST"].ToString().Trim().Length > 0)
{
gst = double.Parse(ReportSet.Tables["QuotationTable"].Rows[i]["IGST"].ToString());
}
else
{
gst = 0;
}
//double qty = double.Parse(dt.Rows[i]["Quantity"].ToString());
double gstTotal = (total * gst) / 100;
ReportSet.Tables["QuotationTable"].Rows[i]["IGSTValue"] = gstTotal;
totalamt = totalamt + (total + gstTotal);
amount = amount + total;
}
lblQuotationNumber.Text = quotationNo;
string wordamount = "";
rv.LocalReport.DataSources.Clear(); //clear report
//string reportHeading = "";
//if (rbActDetails.Checked == true)
//{
//string path = Server.MapPath("");
if (ReportNumber == 1)
{
rv.LocalReport.ReportPath = Server.MapPath("QuotationReportDescription.rdlc"); // bind reportviewer with .rdlc
wordamount = NumberToWords(Int32.Parse(Math.Round(totalamt, 0).ToString()));
}
if (ReportNumber == 2)
{
rv.LocalReport.ReportPath = Server.MapPath("QuotationReport.rdlc"); // bind reportviewer with .rdlc
wordamount = NumberToWords(Int32.Parse(Math.Round(totalamt, 0).ToString()));
}
if (ReportNumber == 3)
{
rv.LocalReport.ReportPath = Server.MapPath("QuotationReportwithoutGSTWithDescription.rdlc"); // bind reportviewer with .rdlc
wordamount = NumberToWords(Int32.Parse(Math.Round(amount, 0).ToString()));
}
if (ReportNumber == 4)
{
rv.LocalReport.ReportPath = Server.MapPath("QuotationReportwithoutGSTWithwithoutDescription.rdlc"); // bind reportviewer with .rdlc
wordamount = NumberToWords(Int32.Parse(Math.Round(amount, 0).ToString()));
}
// reportHeading = "Degtails Report - Account Wise Grey Challan Register from " + dtpFrom.Value.ToString("dd-MMM-yyyy") + " to " + dtpTo.Value.ToString("dd-MMM-yyyy");
//}
//if (rbActSummary.Checked == true)
//{
// DataReportViewer.LocalReport.ReportEmbeddedResource = "WeaverStock.net.Reports.ChallanRegisterGreyActSummary.rdlc"; // bind reportviewer with .rdlc
// reportHeading = "Summary Report - Account Wise Grey Challan Register from " + dtpFrom.Value.ToString("dd-MMM-yyyy") + " to " + dtpTo.Value.ToString("dd-MMM-yyyy");
//}
Microsoft.Reporting.WebForms.ReportDataSource dataset = new Microsoft.Reporting.WebForms.ReportDataSource("QuotationTable", ReportSet.Tables["QuotationTable"]); // set the datasource
rv.LocalReport.DataSources.Add(dataset);
/// Get Firm Data to Print on Header
///
List <ReportParameter> paramList = new List <ReportParameter>();
//conn = DC.FirmDataConnection();
////lstChallan.Items.Add("(All)");
//conn.Close();
//cmd = new SqlCommand("Select * from FirmMaster", conn);
//if (conn.State == ConnectionState.Closed)
// conn.Open();
//SqlDataReader drFirm;
//drFirm = cmd.ExecuteReader();
//paramList.Add(new ReportParameter("ReportHeading", reportHeading));
//while (drFirm.Read())
//{
paramList.Add(new ReportParameter("CustomerName", "Name"));
paramList.Add(new ReportParameter("Address1", "Address1"));
paramList.Add(new ReportParameter("Address2", ""));
paramList.Add(new ReportParameter("City", "City"));
paramList.Add(new ReportParameter("State", "State"));
paramList.Add(new ReportParameter("PostalCode", "Pin Code"));
paramList.Add(new ReportParameter("Country", "India"));
paramList.Add(new ReportParameter("GSTNo", "GST"));
paramList.Add(new ReportParameter("AmountInWord", wordamount));
rv.LocalReport.SetParameters(paramList);
//}
//drFirm.Close();
//conn.Close();
rv.LocalReport.Refresh();
//rv.ReportRefresh(); // refresh report
//SqlCommand cmd = new SqlCommand(query, conn);
////cmd.Parameters.Add(new SqlParameter("@ClientID", SqlDbType.NVarChar, ClientID.Trim().Length)).Value = ClientID.Trim();
////cmd.Parameters.Add(new SqlParameter("@SurveyEngineerID", SqlDbType.NVarChar, Session["userID"].ToString().Trim().Length)).Value = Session["userID"].ToString().Trim();
//SqlDataAdapter adpt = new SqlDataAdapter();
//adpt.SelectCommand = cmd;
//DataTable dt = new DataTable();
//DataColumn c = new DataColumn("sno", typeof(int));
//c.AutoIncrement = true;
//c.AutoIncrementSeed = 1;
//c.AutoIncrementStep = 1;
//dt.Columns.Add(c);
//adpt.Fill(dt);
//bool finishsurvey = true;
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// //double total = double.Parse(dt.Rows[i]["QuotedPriceTotal"].ToString());
// //double qty = double.Parse(dt.Rows[i]["Quantity"].ToString());
// //double CurrTotal = total / CurrencyValue;
// //double unit = CurrTotal / qty;
// //dt.Rows[i]["CurrencyUnit"] = unit;
// //dt.Rows[i]["CurrencyTotal"] = CurrTotal;
// //dt.Rows[i]["Currency"] = ddlCurrency.SelectedItem.ToString();
// //if (total <= 0 || bool.Parse(dt.Rows[i]["Changestatus"].ToString())==true)
// // finishsurvey = false;
//}
//if (SurveyID > 0)
//{
// if (dt.Rows.Count > 0)
// {
// //if ((bool)dt.Rows[dt.Rows.Count - 1]["quotationdone"] == true)
// //{
// // gvitemdisplay.DataSource = dt;
// // gvitemdisplay.DataBind();
// // txtClientName.Enabled = false;
// //}
// //else
// //{
// gvFeed.DataSource = dt;
// gvFeed.DataBind();
// txtClientName.Enabled = false;
// //}
// }
//}
//if (finishsurvey == true)
// btnFinishSurvey.Enabled = false;
//else
// btnFinishSurvey.Enabled = true;
//SqlCommand cmdQNo = new SqlCommand("Select * from QuotationHeader where SurveyID=" + SurveyID, conn);
//if (conn.State == ConnectionState.Closed)
// conn.Open();
//SqlDataReader drq = cmdQNo.ExecuteReader();
//bool quotationdone = false;
//if(drq.Read())
//{
// lblQuotationNumber.Text = drq["QuotationNo"].ToString();
// quotationdone = true;
//}
//drq.Close();
//if(quotationdone==false)
//{ lblQuotationNumber.Text = "Quotation Number will generate once costing done for all Item and Click on Finish Quotation Button"; }
//else
//{
// gvFeed.DataSource = dt;
// gvFeed.DataBind();
// txtClientNamze.Enabled = true;
// txtQuantity.Enabled = true;
// txtRemark.Enabled = true;
// btnSubmit.Enabled = true;
// ddlItem.Enabled = true;
//}
//if (conn.State == ConnectionState.Closed)
// conn.Open();
//conn.Close();
}
private void RetrieveFieldsDetailPDF()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filename = "";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = 0 AND InvReceiptFlag = 'R' AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
filename = "InvReceipt";
extension = "pdf";
// Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + filename + "." + extension);
Response.BinaryWrite(bytes); // create the file
Response.Flush(); // send it to the client to download
Response.End();
//Body.Size.Width + Report.Margins.Left + Report.Margins.Right <= Report.PageSize.Width
}
protected void Filldata(int PPID)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSetLowCost");
//rds.Name = "table1";
//rds.Value = GetData(PPID);
ReportViewer2.LocalReport.ReportPath = "Reports/RptTimesheet.rdlc";
SqlConnection sqlCon = new SqlConnection(conStr);
//string sqlQuery = "select p.pat_FName, p.pat_LName, p.pat_DOB, p.pat_Gender, p.LastModified,pin.PI_PolicyID,pin.PI_GroupNo,pin.PI_BINNo,PI_InsdName,PI_InsdRel,ins.Ins_Name,p.Doc_ID,ph.Phrm_ID,pa.PA_Desc,ph.Phrm_Name,ph.Phrm_Address1,ph.Phrm_Address2,ph.Phrm_City,ph.Phrm_State,ph.Phrm_Zip,ph.Phrm_Phone,ph.Phrm_Fax from Patient_Info p, Patient_Ins pin, Patient_Allergies pa,Pharmacy_Info ph,Insurance_Info ins where p.pat_ID =" + Int32.Parse(patID) + " and pin.pat_ID=" + Int32.Parse(patID) + " and pa.pat_ID=" + Int32.Parse(patID) + "and p.Phrm_ID=ph.Phrm_ID and pin.Ins_ID=ins.Ins_ID";
SqlCommand sqlCmd = new SqlCommand("sp_ReportTimeSheet", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter sp_PPID = sqlCmd.Parameters.Add("@PPID", SqlDbType.Int);
sp_PPID.Value = PPID;
SqlParameter sp_Date1 = sqlCmd.Parameters.Add("@SDate", SqlDbType.Date);
sp_Date1.Direction = ParameterDirection.Output;
SqlParameter sp_Date2 = sqlCmd.Parameters.Add("@EDate", SqlDbType.Date);
sp_Date2.Direction = ParameterDirection.Output;
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
DataSet dsPatient = new DataSet();
try
{
sqlDa.Fill(dsPatient);
ReportParameter Date1 = new ReportParameter("FromDate", sp_Date1.Value.ToString());
ReportParameter Date2 = new ReportParameter("ToDate", sp_Date2.Value.ToString());
ReportParameter[] rp = new ReportParameter[] { Date1, Date2 };
ReportViewer2.LocalReport.SetParameters(rp);
rds.Value = dsPatient.Tables[0];
}
catch (Exception ex)
{
}
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
ReportViewer2.LocalReport.DataSources.Clear();
ReportViewer2.LocalReport.DataSources.Add(rds);
ReportViewer2.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
private void RetrieveFieldsDetailLocal()
{
string mlCRITERIA = "";
string mlTANGGALFROM = "";
string mlTANGGALTO = "";
mlTANGGALFROM = FormatDateyyyyMMdd(mlTXTTANGGALFROM.Text);
mlTANGGALTO = FormatDateyyyyMMdd(mlTXTTANGGALTO.Text);
if ((mlTANGGALFROM != "") || (mlTANGGALTO != ""))
{
mlCRITERIA = "((PROCEEDSDATE BETWEEN '" + mlTANGGALFROM + "' AND '" + mlTANGGALTO + "') OR (DELIVEREDDATE BETWEEN '" + mlTANGGALFROM + "' AND '" + mlTANGGALTO + "') " +
"OR (RETURNEDDATE BETWEEN '" + mlTANGGALFROM + "' AND '" + mlTANGGALTO + "') OR (DONEDATE BETWEEN '" + mlTANGGALFROM + "' AND '" + mlTANGGALTO + "')) ";
}
if (mlDDLREPORTNAME.SelectedItem.Value != "InvDeliverySummary.rdlc")
{
if (mlDDLBRANCH.SelectedItem.Value != "-- Pilih --")
{
mlCRITERIA = mlCRITERIA + " AND BRANCH = '" + mlDDLBRANCH.SelectedItem.Value + "'";
}
mlSQL2 = "SELECT * FROM INV_DELIVERY_STATUS_BRANCH " +
"WHERE " + mlCRITERIA + "";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE = InsertReaderToDatatable(mlDATATABLE, mlDATAROW, mlREADER2);
}
else
{
mlSQL2 = "SELECT * FROM INV_DELIVERY_STATUS " +
"WHERE " + mlCRITERIA + "";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE = InsertReaderToDatatable(mlDATATABLE, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/" + mlDDLREPORTNAME.SelectedItem.Value + "");
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "REPORTING MONITORING DELIVERY INVOICE");
//Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource("INV_RECEIPT_DATAH", mlDATATABLE);
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
if (mlDDLREPORTNAME.SelectedItem.Value != "InvDeliverySummary.rdlc")
{
mlDATASOURCE.Name = "INV_DELIVERY_STATUSBRANCH";
}
else
{
mlDATASOURCE.Name = "INV_DELIVERY_STATUS";
}
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/" + mlDDLREPORTNAME.SelectedItem.Value + "";
mlREPORTH.DataSources.Add(mlDATASOURCE);
//ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlCOMPNAME, mlCOMPADDR, mlTITLE });
ReportViewer1.LocalReport.Refresh();
}
//protected void ddlOrganization_DataBound(object sender, EventArgs e)
//{
// ddlOrganization.Items.Insert(0, new ListItem("All Organizations", "0"));
// ddlOrganization.SelectedIndex = 0;
//}
//protected void ddlLocation_DataBound(object sender, EventArgs e)
//{
// ddlLocation.Items.Insert(0, new ListItem("All Locations", "0"));
// ddlLocation.SelectedIndex = 0;
//}
//protected void ddlOrganization_SelectedIndexChanged(object sender, EventArgs e)
//{
// BindLocation(ddlOrganization.SelectedValue);
//}
//protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
//{
// // Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), txtDate1.Text, txtDate2.Text);
//}
//protected void btnRxReport_Click(object sender, EventArgs e)
//{
// if(Request.QueryString["patID"]!=null)
// Filldata(int.Parse(ddlOrganization.SelectedValue), int.Parse(ddlLocation.SelectedValue), Request.QueryString["patID"].ToString());
//}
protected void Filldata(int ClinicID, int FacilityID, string RxReqID)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("eCareXDBDataSet_sp_ReportRxReq");
DataTable dtRxReqInfo =GetData(ClinicID, FacilityID, RxReqID);
rds.Value = dtRxReqInfo;
ReportViewer3.LocalReport.ReportPath = "Reports/RptRxReq.rdlc";
ReportParameter RxRequestID = new ReportParameter("RxRequestID", RxReqID);
ReportParameter[] rp = new ReportParameter[] {RxRequestID};
ReportViewer3.LocalReport.SetParameters(rp);
ReportViewer3.LocalReport.DataSources.Clear();
ReportViewer3.LocalReport.DataSources.Add(rds);
ReportViewer3.LocalReport.Refresh();
}
private void RetrieveFieldsDetailPDF()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filename = "";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = 0 AND InvReceiptFlag = 'R' AND InvReceiptCode = '" + mlDATATABLE.Rows[0]["InvReceiptCode"].ToString() + "'" +
" AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
filename = "InvReceipt";
extension = "pdf";
// Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + filename + "." + extension);
Response.BinaryWrite(bytes); // create the file
Response.Flush(); // send it to the client to download
Response.End();
//Body.Size.Width + Report.Margins.Left + Report.Margins.Right <= Report.PageSize.Width
}
private void RetrieveFieldsDetailLocal()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = 0 AND InvReceiptFlag = 'R' AND InvReceiptCode = '" + mlDATATABLE.Rows[0]["InvReceiptCode"].ToString() + "'" +
" AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
//Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource("INV_RECEIPT_DATAH", mlDATATABLE);
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
ReportViewer1.LocalReport.Refresh();
}
private void ThrirdWay()
{
string[] recommendedInputPaths = new string[] { @"C:\Automation\Input", @"C:\Automation\OutPut", @"C:\Automation\Processed" };
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("Files Created", EventLogEntryType.Error);
}
try
{
DirectoryCreation(recommendedInputPaths);
//string[] accdbDirectory = System.IO.Directory.GetFiles(recommendedInputPaths[0], "*.xlsx");
//string filePath = @"C:\Kalya Solutions\GMB insights (Discovery Report) - 2020-1-12 - 2020-1-18 - 54dfdd99d13944a11e53e473d2e7a7b4.xlsx";
foreach (string accdbFile in Directory.GetFiles(recommendedInputPaths[0], "*.xlsx"))
{
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("Files Read", EventLogEntryType.SuccessAudit);
}
//string connectioFile = accdbFile;
// string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + accdbFile + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";
DataTable resultsDataset = new DataTable();
// using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + accdbFile + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";"))
// {
// OleDbCommand cmd = new OleDbCommand("SELECT * FROM [GMB insights (Discovery Report)$]", conn);
// conn.Open();
// OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
// adapter.Fill(resultsDataset);
// conn.Dispose();
// resultsDataset.Dispose();
// }
IExcelDataReader excelReader;
FileStream stream = File.Open(accdbFile, FileMode.Open, FileAccess.Read);
excelReader = ExcelReaderFactory.CreateReader(stream);
DataSet result = excelReader.AsDataSet(new ExcelDataSetConfiguration()
{
ConfigureDataTable = (_) => new ExcelDataTableConfiguration()
{
UseHeaderRow = true
}
});
excelReader.Close();
resultsDataset = result.Tables[0];
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("Data Set Prepared", EventLogEntryType.SuccessAudit);
}
//string moveDestinationPath = Path.Combine(recommendedInputPaths[2], Path.GetFileNameWithoutExtension("GMB insights (Discovery Report) - 2020-1-12 - 2020-1-18 - 54dfdd99d13944a11e53e473d2e7a7b4.xlsx"));
//File.Move(@"C:\Automation\Input\GMB insights (Discovery Report) - 2020-1-12 - 2020-1-18 - 54dfdd99d13944a11e53e473d2e7a7b4.xlsx", moveDestinationPath + DateTime.Now.ToString("_MMMdd_yyyy_HHmmss") + ".xlsx");
int resultDataSetRow = 1;
for (int i = 0; i < 6; i++)
{
DataSet ds = new DataSet();
DataTable mergeTable = new DataTable();
mergeTable.Clear();
mergeTable.Columns.Add("Storecode", typeof(System.String));
mergeTable.Columns.Add("BusinessName", typeof(System.String));
mergeTable.Columns.Add("Address", typeof(System.String));
mergeTable.Columns.Add("Labels", typeof(System.String));
mergeTable.Columns.Add("OverallRating", typeof(System.Double));
mergeTable.Columns.Add("TotalSearches", typeof(System.Double));
mergeTable.Columns.Add("DirectSearches", typeof(System.Double));
mergeTable.Columns.Add("DiscoverySearches", typeof(System.Double));
mergeTable.Columns.Add("TotalViews", typeof(System.Double));
mergeTable.Columns.Add("SearchViews", typeof(System.Double));
mergeTable.Columns.Add("MapsViews", typeof(System.Double));
mergeTable.Columns.Add("TotalActions", typeof(System.Double));
mergeTable.Columns.Add("WebsiteActions", typeof(System.Double));
mergeTable.Columns.Add("DirectionsActions", typeof(System.Double));
mergeTable.Columns.Add("PhoneCallActions", typeof(System.Double));
DataRow workRow = mergeTable.NewRow();
mergeTable.Rows.Add(workRow);
mergeTable.Rows[0][0] = resultsDataset.Rows[resultDataSetRow]["Store code"];
mergeTable.Rows[0][1] = resultsDataset.Rows[resultDataSetRow]["Business name"];
mergeTable.Rows[0][2] = resultsDataset.Rows[resultDataSetRow]["Address"];
mergeTable.Rows[0][3] = resultsDataset.Rows[resultDataSetRow]["Labels"];
mergeTable.Rows[0][4] = resultsDataset.Rows[resultDataSetRow]["Overall rating"];
mergeTable.Rows[0][5] = resultsDataset.Rows[resultDataSetRow]["Total searches"];
mergeTable.Rows[0][6] = resultsDataset.Rows[resultDataSetRow]["Direct searches"];
mergeTable.Rows[0][7] = resultsDataset.Rows[resultDataSetRow]["Discovery searches"];
mergeTable.Rows[0][8] = resultsDataset.Rows[resultDataSetRow]["Total views"];
mergeTable.Rows[0][9] = resultsDataset.Rows[resultDataSetRow]["Search views"];
mergeTable.Rows[0][10] = resultsDataset.Rows[resultDataSetRow]["Maps views"];
mergeTable.Rows[0][11] = resultsDataset.Rows[resultDataSetRow]["Total actions"];
mergeTable.Rows[0][12] = resultsDataset.Rows[resultDataSetRow]["Website actions"];
mergeTable.Rows[0][13] = resultsDataset.Rows[resultDataSetRow]["Directions actions"];
mergeTable.Rows[0][14] = resultsDataset.Rows[resultDataSetRow]["Phone call actions"];
ds.Tables.Add(mergeTable);
//ReportDataModels.GMBInformationDataTable gMBInformationRows = ds;
Microsoft.Reporting.WebForms.ReportViewer ReportViewer1 = new Microsoft.Reporting.WebForms.ReportViewer();
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
//Path.Combine(Directory.GetCurrentDirectory(), @"DBObjs\RawDataReport.txt")
ReportViewer1.LocalReport.ReportPath = @"C:\DRL RDLC\Report1.rdlc";
Microsoft.Reporting.WebForms.ReportDataSource datasource = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("Report Created", EventLogEntryType.SuccessAudit);
}
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;
byte[] bytes = ReportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
// string outputFileName = Path.Combine(recommendedInputPaths[1], resultsDataset.Rows[resultDataSetRow]["Business name"] + ".pdf");
//@"C:\Users\v-mapall\source\repos\ExcelCustomApps\GMBRDLC Application\" + resultsDataset.Rows[resultDataSetRow]["Business name"] + ".pdf"
using (FileStream fs = new FileStream(Path.Combine(recommendedInputPaths[1], resultsDataset.Rows[resultDataSetRow]["Business name"] + ".pdf"), FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
}
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("PDF Files Created", EventLogEntryType.SuccessAudit);
}
resultDataSetRow++;
}
//string accdbFileName = Path.GetFileName(accdbFile);
//string moveDestinationPath = Path.Combine(recommendedInputPaths[2], Path.GetFileName(accdbFile));
string moveDestinationPath = Path.Combine(recommendedInputPaths[2], Path.GetFileNameWithoutExtension(accdbFile));
File.Move(accdbFile, moveDestinationPath + DateTime.Now.ToString("_MMMdd_yyyy_HHmmss") + ".xlsx");
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry("Files Were Moved", EventLogEntryType.SuccessAudit);
}
}
}
catch (Exception exeption)
{
using (EventLog eventLog = new EventLog())
{
eventLog.Source = "Application";
eventLog.WriteEntry(exeption.Message, EventLogEntryType.Error);
}
}
}
private void RetrieveFieldsDetailPDF1()
{
string mlTANGGAL = "";
string mlRECEIVEDCODE = "";
string mlRECEIVEDBY = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string filename = "";
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.27in</PageWidth>" +
" <PageHeight>11.69in</PageHeight>" +
" <MarginTop>0.7874in</MarginTop>" +
" <MarginLeft>0.98425in</MarginLeft>" +
" <MarginRight>0.98425in</MarginRight>" +
" <MarginBottom>0.7874in</MarginBottom>" +
"</DeviceInfo>";
mlDATATABLE = (DataTable)Session["FormEditReceiptData"];
mlTANGGAL = FormatDateyyyyMMdd(Convert.ToDateTime(mlDATATABLE.Rows[0]["InvPreparedForDate"]));
mlRECEIVEDCODE = mlDATATABLE.Rows[0]["InvCodeMess"].ToString();
mlRECEIVEDBY = mlDATATABLE.Rows[0]["InvMessName"].ToString();
if (mlDATATABLE.Rows[0]["InvStatus"].ToString() == "PROCEEDS" && mlDATATABLE.Rows[0]["InvReceiptFlag"].ToString() == "R")
{
mlSQL2 = "SELECT * FROM INV_DELIVERY " +
"WHERE Disabled = '0' AND InvReceiptFlag = 'R' AND InvReceiptCode = '" + mlDATATABLE.Rows[0]["InvReceiptCode"].ToString() + "'" +
" AND InvPreparedForDate = '" + mlTANGGAL + "' AND InvCodeMess = '" + mlRECEIVEDCODE + "' AND InvMessName = '" + mlRECEIVEDBY + "' " +
"ORDER BY InvPreparedForDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSQL2, "PB", mlCOMPANYID);
mlDATATABLE1 = InsertReaderToDatatable(mlDATATABLE1, mlDATAROW, mlREADER2);
}
//else
//{
// mlDATATABLE1 = mlDATATABLE.Copy();
//}
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/pj_delinv/InvReceiptH.rdlc");
Microsoft.Reporting.WebForms.ReportParameter mlRECEIPTCODE = new Microsoft.Reporting.WebForms.ReportParameter("ReceiptCode", mlDATATABLE.Rows[0]["InvReceiptCode"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCODEMESS = new Microsoft.Reporting.WebForms.ReportParameter("CodeMess", mlDATATABLE.Rows[0]["InvCodeMess"].ToString());
Microsoft.Reporting.WebForms.ReportParameter mlCOMPNAME = new Microsoft.Reporting.WebForms.ReportParameter("CompanyName", mlCOMPANYNAME);
Microsoft.Reporting.WebForms.ReportParameter mlCOMPADDR = new Microsoft.Reporting.WebForms.ReportParameter("CompanyAddress", mlCOMPANYADDRESS);
Microsoft.Reporting.WebForms.ReportParameter mlTITLE = new Microsoft.Reporting.WebForms.ReportParameter("Title", "INVOICE / RECEIPT");
Microsoft.Reporting.WebForms.ReportDataSource mlDATASOURCE = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.LocalReport mlREPORTH = new Microsoft.Reporting.WebForms.LocalReport();
mlDATASOURCE.Name = "INV_RECEIPT_DATAH";
mlDATASOURCE.Value = mlDATATABLE;
mlREPORTH.ReportEmbeddedResource = "~/pj_delinv/InvReceiptH.rdlc";
mlREPORTH.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
ReportViewer1.LocalReport.ReportEmbeddedResource = mlREPORTH.ReportEmbeddedResource;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(mlDATASOURCE);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { mlRECEIPTCODE, mlCODEMESS, mlCOMPNAME, mlCOMPADDR, mlTITLE });
//byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamIds, out warnings);
string path = Server.MapPath("~/pj_delinv/Print_Files");
// Open PDF File in Web Browser
filename = "InvReceipt";
extension = "pdf";
FileStream file = new FileStream(path + "/" + filename + "." + extension, FileMode.OpenOrCreate, FileAccess.ReadWrite);
file.Write(bytes, 0, bytes.Length);
file.Dispose();
WebClient client = new WebClient();
Byte[] buffer = client.DownloadData(path + "/" + filename + "." + extension);
if (buffer != null)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", buffer.Length.ToString());
Response.BinaryWrite(buffer);
}
}
private void Data_Binding()
{
string productMoFrom = Request.QueryString["productMoFrom"].ToString();
string productMoTo = Request.QueryString["productMoTo"].ToString();
string invFrom = Request.QueryString["invFrom"].ToString();
string invTo = Request.QueryString["invTo"].ToString();
string dateFrom = Request.QueryString["dateFrom"].ToString();
string dateTo = Request.QueryString["dateTo"].ToString();
string remote_db = DBUtility.remote_db;
string within_code = DBUtility.within_code;
string strSql = "Select b.mo_id,a.id,a.invoice_no,Convert(Varchar(20),a.invoice_date,111) AS invoice_date,c.name AS goods_cname " +
",b.issues_unit,Convert(INT,b.issues_qty) AS issues_qty,d.id AS order_id,d.unit_price,d.p_unit,f.rate" +
",Round((b.issues_qty/f.rate)*Convert(float,d.unit_price),2) AS order_amt" +
",a.linkman,d.table_head,e.m_id" +
" From " + remote_db + "so_issues_mostly a" +
" Inner Join " + remote_db + "so_issues_details b On a.within_code=b.within_code And a.id=b.id" +
" Inner Join " + remote_db + "it_goods c On b.within_code=c.within_code And b.goods_id=c.id" +
" Inner Join " + remote_db + "so_order_details d On b.within_code=d.within_code And b.mo_id=d.mo_id" +
" Inner Join " + remote_db + "so_order_manage e On d.within_code=e.within_code And d.id=e.id And d.ver=e.ver" +
" Inner Join " + remote_db + "it_coding f On d.within_code=f.within_code And d.p_unit=f.unit_code And b.issues_unit=f.basic_unit" +
" Where a.within_code='" + within_code + "' And f.id='*'";
if (dateFrom == "" && invFrom == "" && productMoFrom == "")
{
invFrom = "INV999999999";
invTo = "INV999999999";
}
if (dateFrom != "" && dateTo != "")
{
dateTo = Convert.ToDateTime(dateTo).AddDays(1).ToString("yyyy/MM/dd");
strSql += " And a.invoice_date>='" + dateFrom + "' And a.invoice_date<'" + dateTo + "'";
}
if (productMoFrom != "" && productMoTo != "")
{
strSql += " And b.mo_id>='" + productMoFrom + "' And b.mo_id<='" + productMoTo + "'";
}
if (invFrom != "" && invTo != "")
{
strSql += " And a.invoice_no>='" + invFrom + "' And a.invoice_no<='" + invTo + "'";
}
strSql += " Order By a.invoice_no,a.invoice_date,b.mo_id";
DataTable dtPrint = sh.ExecuteSqlReturnDataTable(strSql);
decimal totalAmt = 0;
this.ReportViewer1.Reset();
//this.ReportViewer1.LocalReport.Dispose();
ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("../Reports/Sa_Iv_VatDeliveryDetails.rdlc");
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("dsSa_Iv_VatDeliveryDetails", dtPrint);
//this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DSDgcf_pad", dtPrint));
//ReportViewer1.LocalReport.DataSources.Add(
//new Microsoft.Reporting.WebForms.ReportDataSource("DSDgcf_pad", dtPrint));
//向報表傳遞多個參數
List <ReportParameter> para = new List <ReportParameter>(); //这里是添加两个字段
para.Add(new ReportParameter("totalAmt", totalAmt.ToString()));
//para.Add(new ReportParameter("userName", "aaa"));
ReportViewer1.LocalReport.SetParameters(para);
ReportViewer1.LocalReport.DataSources.Add(rds);
this.ReportViewer1.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.Percent;
this.ReportViewer1.ZoomPercent = 100;
ReportViewer1.LocalReport.Refresh();
//string doc_type_to = "相關制單";
//string color = "N001";
//ReportViewer1.LocalReport.ReportPath = "Reports\\sample_trace.rdlc";//Report1.rdlc;
//ReportViewer1.LocalReport.EnableExternalImages = true;
////ReportViewer1.LocalReport.SetParameters(new ReportParameter(doc_type_to));//, Guid.NewGuid().ToString()
////向報表傳遞單個參數
////ReportParameter rp = new ReportParameter("doc_type_to", doc_type_to);
////ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
////向報表傳遞多個參數
//ReportParameter[] para = new ReportParameter[3];
//para[0] = new ReportParameter("Remark", txtRemark_head.Text);
//para[1] = new ReportParameter("RouteDep", txtRouteDep.Text);
//para[2] = new ReportParameter("barcode_url", barcode_url);
//ReportViewer1.LocalReport.SetParameters(para);
//ReportDataSource rds = new ReportDataSource("DataSet_Trace", dtPrint);
//ReportViewer1.LocalReport.DataSources.Clear();
//ReportViewer1.LocalReport.DataSources.Add(rds);
//ReportViewer1.LocalReport.Refresh();
//ReportViewer1.LocalReport.Refresh();
}