private void Retrieve()
{
string convertedfrom = "2017-11-1";
string convertedto = "2017-11-30";
var dt = GetData(convertedfrom, convertedto);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new LabelRpt {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("list1", true)[0] as Telerik.Reporting.List;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadTabStrip1.FindTabByText("Report").Enabled = false;
}
else
{
string ModeData = ModeDD.SelectedValue;
var dt = GetData(ModeData);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new RptCustomer {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
}
}
protected void SearchBT_Click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
if (Ds.Tables.Contains("AP1"))
{
Ds.Tables.Remove("AP1");
}
string sqlstr = selectsql(), strSearch;
strSearch = ACCTB.Text.Trim() + "%";
SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, Conn);
myAdapter.SelectCommand.Parameters.AddWithValue("Search", strSearch);
//myAdapter.SelectCommand.Parameters.AddWithValue("Search1", strSearch);
myAdapter.Fill(Ds, "AP1"); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (Ds.Tables["AP1"].Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("Finance005", Ds.Tables["AP1"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
//ACPGV.DataSource = Ds.Tables["ACP"];
//ACPGV.DataBind();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>");
}
}
protected void btnReporte_Click(object sender, EventArgs e)
{
gridPanel.Visible = false;
formPanel.Visible = false;
List <Plan_Reporte> Datos = new List <Plan_Reporte>();
for (int i = 0; i < gridPlanes.Rows.Count; i++)
{
Plan_Reporte linea = new Plan_Reporte();
linea.ID = gridPlanes.Rows[i].Cells[0].Text;
linea.Descripcion = gridPlanes.Rows[i].Cells[1].Text;
linea.Especialidad = gridPlanes.Rows[i].Cells[2].Text;
Datos.Add(linea);
}
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", Datos));
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
reportPanel.Visible = true;
ReportViewer1.ShowReportBody = true;
//btnVolver_Reporte.Visible = true;
}
protected void DbInit()
{
DataTable dt = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql().ToString(), Conn);
myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt.Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("工時成本", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
else
{
MessageLT.Text = @"
<div class='form-group'>
<h3 class='text-info text-center'>沒有資料 </ h3 >
</div>";
}
}
protected void SearchBT_Click(object sender, EventArgs e)
{
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
if (Ds.Tables.Contains("QC"))
{
Ds.Tables.Remove("QC");
}
string sqlstr = selectsql();
SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, Conn);
myAdapter.Fill(Ds, "QC"); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (Ds.Tables["QC"].Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("VN002", Ds.Tables["QC"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>");
}
}
public override void Abas_AntesDeTrocarAba(AbaBeforeChangedCancelEventArgs e)
{
base.Abas_AntesDeTrocarAba(e);
if (e.IndiceDaAba == 3)
{
TelerikReport.Report1 dd = new TelerikReport.Report1();
using (ContatoEstadoBLL bll = new ContatoEstadoBLL())
{
bll.Filters = GetFilters();
dd.DataSource = bll.listaRelatorio();
ReportViewer1.Report = dd;
ReportViewer1.DataBind();
}
}
if (e.IndiceDaAba == 4)
{
TelerikReport.Report3 dd = new TelerikReport.Report3();
using (ContatoEstadoBLL bll = new ContatoEstadoBLL())
{
bll.Filters = GetFilters();
dd.DataSource = bll.listaRelatorio();
ReportViewer2.Report = dd;
ReportViewer2.DataBind();
}
}
}
protected void DbInit(int iid)
{
DataTable dt = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql("明細", iid).ToString(), Conn);
myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt.Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("MGT004", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
DataTable dt2 = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql("單頭", iid).ToString(), Conn);
myAdapter.Fill(dt2); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
ReportDataSource source2 = new ReportDataSource("MGT004_1", dt2);
ReportViewer1.LocalReport.DataSources.Add(source2);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
else
{
F_ErrorShow("搜尋不到資料");
}
}
protected void btnviewreport_Click(object sender, EventArgs e)
{
ReportViewer1.Visible = true;
var res = validatedate();
if (res == false)
{
errordiv.Visible = true;
ReportViewer1.Visible = false;
}
else
{
ReportViewer1.Visible = true;
parm.Fromdate = DateTime.ParseExact(txtFrom.Text.Trim(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy");
parm.ToDate = DateTime.ParseExact(txtTo.Text.Trim(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy");
var DataSet1 = MapSvc.getNewHotelsAddedReport(parm);
ReportDataSource rds = new ReportDataSource("DataSet1", DataSet1);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = "staticdata/hotels/rptNewhotelsReport.rdlc";
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.Visible = true;
ReportViewer1.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.PageWidth;
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int dispozicijaId = int.Parse(Request.QueryString["dispozicijaId"]);
var Header = DispozicijaRM.GetHeader(dispozicijaId);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Header", Header));
var Body = DispozicijaRM.GetBody(dispozicijaId);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Body", Body));
var Info = DispozicijaRM.GetDispozicijaInfo(dispozicijaId);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Info", Info));
var Primalac = DispozicijaRM.GetPrimalacInfo(dispozicijaId);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Primalac", Primalac));
var Posiljalac = DispozicijaRM.GetPosiljalacInfo(dispozicijaId);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Posiljalac", Posiljalac));
ReportViewer1.LocalReport.ReportPath = Server.MapPath("") + "/Dispozicija.rdlc";
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
/// <summary>
/// Leonardo Carrion
/// 06/may/2021
/// Efecto: cargar el reporte con los datos filtrados
/// Requiere: -
/// Modifica: datasource del reporte
/// Devuelve: -
/// </summary>
public void cargarDatosReporte()
{
Periodo periodo = new Periodo();
periodo.anoPeriodo = Convert.ToInt32(ddlPeriodos.SelectedValue);
Proyectos proyecto = new Proyectos();
proyecto.idProyecto = Convert.ToInt32(ddlProyectos.SelectedValue);
Unidad unidad = new Unidad();
unidad.idUnidad = Convert.ToInt32(ddlUnidades.SelectedValue);
Session["listaReporteEgresos"] = reporte_DetalleEjecucionesServicios.getReporteEgresosPorUnidades(proyecto.idProyecto, periodo.anoPeriodo, unidad.idUnidad);
ReportViewer1.Reset();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("ReporteDetalleEjecuciones.rdlc");
ReportDataSource reportDataSource = null;
List <ReporteDetalleEjecucion> listaReporteDuracion = (List <ReporteDetalleEjecucion>)Session["listaReporteEgresos"];
reportDataSource = new ReportDataSource("DataSet1", listaReporteDuracion);
if (reportDataSource.Equals(null) == false)
{
ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
}
ReportViewer1.DataBind();
}
public void LoadStudentChallan()
{
try
{
if (Request.QueryString["ChallanID"] != "" && Request.QueryString["ChallanID"] != null)
{
List <GetChallan_Result> lstChallan = db.GetChallan(Convert.ToInt32(Request.QueryString["ChallanID"])).ToList();
List <GetChallanService_Result> lstCS = db.GetChallanService(Convert.ToInt32(Request.QueryString["ChallanID"])).ToList();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reporting/Reports/rptGetChallan.rdlc");
ReportDataSource datasource = new ReportDataSource("DataSet1", lstChallan);
ReportDataSource datasource2 = new ReportDataSource("DataSet2", lstCS);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
ReportViewer1.LocalReport.DataSources.Add(datasource2);
ReportViewer1.LocalReport.EnableExternalImages = true;
string imagePath = new Uri(Server.MapPath("~/assets/img/CampusConnectLogo.png")).AbsoluteUri;
ReportParameter parameter = new ReportParameter("ImagePath", imagePath);
ReportViewer1.LocalReport.SetParameters(parameter);
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["userInfo"] == null)
{
Response.Redirect("/Home/Login");
}
if (!IsPostBack)
{
int idPokupi = Int32.Parse(Request.QueryString["id"]);
mssql s = new mssql();
List <UlazSkidanje> u = s.UlazSkidanje.Where(x => x.Id == idPokupi).ToList();
List <UlazSkidanjeProizvodVM> usp = s.UlazSkidanjeProizvod.Include("Proizvod").Include("Proizvod.Klasa").Where(x => x.UlazSkidanjeId == idPokupi).Select(x => new UlazSkidanjeProizvodVM()
{
Datum = x.Datum,
Id = x.Id,
Kolicina = x.Kolicina,
PlaniranaKolicina = x.PlaniranaKolicina,
Debljina = x.Proizvod.Visina.ToString(),
Sirina = x.Proizvod.Sirina.ToString(),
Duzina = x.Proizvod.Duzina.ToString(),
Klasa = x.Proizvod.Klasa.Naziv,
Naziv = x.Proizvod.Naziv
}).ToList();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet", u));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", usp));
ReportViewer1.LocalReport.ReportPath = Server.MapPath("") + "/RadniNalog.rdlc";
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
public void GetFormSaleDetail()
{
try
{
if (Request.QueryString["ChallanID"] != "" && Request.QueryString["ChallanID"] != null)
{
List <GetFormSaleDetail_Result> lstForms = db.GetFormSaleDetail("", "").Where(f => f.PurchaseDate != null).ToList();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reporting/Reports/rptAdmissionFormSale.rdlc");
ReportDataSource datasource = new ReportDataSource("DataSet1", lstForms);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
ReportViewer1.LocalReport.EnableExternalImages = true;
string imagePath = new Uri(Server.MapPath("~/assets/img/CampusConnectLogo.png")).AbsoluteUri;
ReportParameter parameter = new ReportParameter("ImagePath", imagePath);
ReportViewer1.LocalReport.SetParameters(parameter);
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
public void FillReport()
{
DashboardReports.EXJournalDocumentTotalsRpt rpt = new DashboardReports.EXJournalDocumentTotalsRpt();
string selectedServer = "";
if (this.ServerListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = "";
}
finally { }
}
rpt.Parameters["ServerName"].Value = selectedServer;
rpt.Parameters["Threshold"].Value = TCutoffTextBox.Text;
ReportViewer1.Report = rpt;
ReportViewer1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RadTabStrip1.FindTabByText("Report").Enabled = false;
}
else
{
DateTime datefroms = Convert.ToDateTime(datefrom.SelectedDate);
DateTime datetos = Convert.ToDateTime(dateto.SelectedDate);
string convertedfrom = datefroms.ToString("yyyy-MM-dd");
string convertedto = datetos.ToString("yyyy-MM-dd");
var dt = GetData(convertedfrom, convertedto);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new RptTransIn {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
}
}
protected void btnRuleCsv_Click(object sender, EventArgs e)
{
ReportViewer1.Visible = true;
var res = validatedate();
if (res == false)
{
errordiv.Visible = true;
ReportViewer1.Visible = false;
}
else
{
ReportViewer1.Visible = true;
errordiv.Visible = false;
parm.Fromdate = DateTime.ParseExact(txtFrom.Text.Trim(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy");
parm.ToDate = DateTime.ParseExact(txtTo.Text.Trim(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy");
//parm.Fromdate = fromDate.Value.ToString();
// parm.ToDate = toDate.Value.ToString();
var DataSet1 = MapSvc.getStatisticforRuleReport(parm);
ReportDataSource rds = new ReportDataSource("DataSet1", DataSet1);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = "hotels/rptRuleReport.rdlc";
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.Visible = true;
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
protected void DbInit()
{
DataTable dt = new DataTable(), dt2 = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql("打版完成日").ToString(), Conn);
myAdapter.Fill(dt); //---- 這時候執c行SQL指令。取出資料，放進 DataSet。
//SqlDataAdapter myAdapter2 = new SqlDataAdapter(selectsql("收單日").ToString(), Conn);
//myAdapter2.Fill(dt2); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt.Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("View1", dt);
//ReportDataSource source1 = new ReportDataSource("View2", dt2);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
//ReportViewer1.LocalReport.DataSources.Add(source1);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
else
{
F_ErrorShow("搜尋不到資料");
}
}
protected void DbInit()
{
if (!String.IsNullOrEmpty(MonthDDL.SelectedValue) && String.IsNullOrEmpty(YearDDL.SelectedValue))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('未選擇年度');</script>");
}
else
{
DataTable dt = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql().ToString(), Conn);
myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt.Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("Sample004", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>");
}
}
}
protected void export()
{
DataTable dt = getDataTable();
DataTable dt1 = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter("select * from ClassTable where ClassID='" + Session["classId"].ToString() + "' ", con);
sda.Fill(dt1);
DataTable dt2 = new DataTable();
sda = new SqlDataAdapter("select TName from Teacher where TId='" + TId + "' ", con);
sda.Fill(dt2);
DataTable dt3 = new DataTable();
sda = new SqlDataAdapter("select * from Course where CourseId='" + Session["courseId"].ToString() + "' ", con);
sda.Fill(dt3);
DataTable dt4 = new DataTable();
sda = new SqlDataAdapter("select * from Attendance where CourseId='" + Session["courseId"].ToString() + "' and TId='" + TId + "' and ClassId='" + Session["classId"].ToString() + "' ", con);
sda.Fill(dt4);
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report1.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + "/AttendanceSheet.rdlc";
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("StudentDS", dt));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("AttDS", dt4));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("CourseDS", dt3));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("ClassDS", dt1));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("TeacherDS", dt2));
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
string cargoCode = Request.QueryString["cargoCode"].ToString().Trim();
string cargoName = Request.QueryString["cargoName"].ToString().Trim();
string modelName = Request.QueryString["modelName"].ToString().Trim();
string specName = Request.QueryString["specName"].ToString().Trim();
string saleStatusStr = Request.QueryString["saleStatusStr"].ToString().Trim();
int saleStatus = -1;
if (!string.IsNullOrEmpty(saleStatusStr))
{
if (int.TryParse(saleStatusStr, out saleStatus) == false)
{
saleStatus = -1;
}
}
using (DAL.GoldEntities context = new DAL.GoldEntities())
{
List <DAL.proc_WebSelectEachDeptSaleAllocation_Result> resultList = context.proc_WebSelectEachDeptSaleAllocation().ToList <DAL.proc_WebSelectEachDeptSaleAllocation_Result>();
var queryResult = (from r in resultList
where r.CargoCode.Contains(cargoCode) &&
r.CargoName.Contains(cargoName) &&
r.CargoModel.Contains(modelName) &&
r.CargoSpec.Contains(specName) &&
(saleStatus >= 0 ? r.SaleStatus == saleStatus : 1 == 1)
select r).ToList();
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", queryResult);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
Microsoft.Reporting.WebForms.ReportParameter ReportParameter_CargoCode = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter_CargoCode", cargoCode);
Microsoft.Reporting.WebForms.ReportParameter ReportParameter_CargoName = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter_CargoName", cargoName);
Microsoft.Reporting.WebForms.ReportParameter ReportParameter_CargoModel = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter_CargoModel", modelName);
Microsoft.Reporting.WebForms.ReportParameter ReportParameter_CargoSpec = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter_CargoSpec", specName);
Microsoft.Reporting.WebForms.ReportParameter ReportParameter_SaleStatus = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter_SaleStatus", saleStatus >= 0 ? (saleStatus > 0?"可售":"不可售"): "");
Microsoft.Reporting.WebForms.ReportParameterCollection rpList = new Microsoft.Reporting.WebForms.ReportParameterCollection();
rpList.Add(ReportParameter_CargoCode);
rpList.Add(ReportParameter_CargoName);
rpList.Add(ReportParameter_CargoModel);
rpList.Add(ReportParameter_CargoSpec);
rpList.Add(ReportParameter_SaleStatus);
ReportViewer1.LocalReport.SetParameters(rpList);
ReportViewer1.DataBind();
}
}
}
catch (Exception ex)
{
lblGridViewMsg.Text = Utility.LogHelper.GetExceptionMsg(ex);
}
}
public void FillReport()
{
DashboardReports.TravelerHTTPsessionsRpt rpt = new DashboardReports.TravelerHTTPsessionsRpt();
string selectedServer = "";
if (this.ServerListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = "";
}
finally { }
}
rpt.Parameters["ServerName"].Value = selectedServer;
rpt.Parameters["StartDate"].Value = dtPick.FromDate;
rpt.Parameters["EndDate"].Value = dtPick.ToDate;
rpt.Parameters["Threshold"].Value = TCutoffTextBox.Text;
rpt.Parameters["ServerType"].Value = srvtype;
ReportViewer1.Report = rpt;
ReportViewer1.DataBind();
}
protected void btnbuscar_Click(object sender, EventArgs e)
{
string company, fechaini, fechafin;
company = "";
//usuario = "";
fechafin = "";
fechafin = "";
company = txtcompany.Text.ToString();
//usuario = txtUsuario.Text.ToString();
fechaini = txtfechaini.Text.ToString();
fechafin = txtfechafin.Text.ToString();
ObtenerIndicadorNivelCumplimiento(company, fechaini, fechafin);
DataTable table = ConvertListToDataTable(Indicadores);
ReportViewer1.Reset();
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Content/Report/Report1.rdlc");
ReportDataSource rds = new ReportDataSource("DataSet", table);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
private void reporte()
{
if (!IsPostBack)
{
DateTime fecha = DateTime.Now;
LocalReport localReport = ReportViewer1.LocalReport;
localReport.ReportPath = "ReportePlan.rdlc";
ReportParameter[] parametros = new ReportParameter[1];
parametros[0] = new ReportParameter("Fecha", (fecha).ToString());
ReportViewer1.LocalReport.SetParameters(parametros);
ReportViewer1.DataBind();
PlanAdapter pa = new PlanAdapter();
this.ReportViewer1.LocalReport.DataSources.Clear();
DataTable dt = new DataTable();
dt = pa.ReportePlan();
ReportDataSource rprtDTSource = new ReportDataSource("Dataset2", dt);
this.ReportViewer1.LocalReport.DataSources.Add(rprtDTSource);
this.ReportViewer1.LocalReport.Refresh();
}
}
private void Generate(string date, string CompanyCode)
{
ReportViewer1.Visible = true;
try
{
DataTable temp = new DataTable();
DataTable dt = new DataTable();
temp = GetData(date, CompanyCode);
if (temp.Rows.Count > 0)
{
ReportDataSource rptDataSource = new ReportDataSource
("MCB_DataSet_NRStatAccount", temp);
ReportViewer1.LocalReport.DataSources.Clear();
List <ReportParameter> rpParameter = new List <ReportParameter>();
rpParameter.Add(new ReportParameter("BankName", GetBankName()));
rpParameter.Add(new ReportParameter("ReportName", GetReportName()));
rpParameter.Add(new ReportParameter("Date", date));
ReportViewer1.LocalReport.DataSources.Add(rptDataSource);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("NRStatementAccountReport.rdlc");
ReportViewer1.DataBind();
ReportViewer1.LocalReport.SetParameters(rpParameter);
ReportViewer1.LocalReport.Refresh();
}
else
{
Response.Redirect("NRStatementAccountReport.aspx?IsRecord=" + "0" + "&msg=" + "No Record Found");
}
}
catch (Exception ex)
{
Response.Write("Exception is:" + ex);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
DataTable data = oRTN_Service.getDataRtnList(lblID.Text);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#printRtnModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "PrintModalScript", sb.ToString(), false);
ReportViewer1.Reset();
ReportViewer1.Visible = true;
ReportDataSource dt = new ReportDataSource("DataSet1", data);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(dt);
ReportViewer1.LocalReport.ReportPath = @"Reports\RtnList.rdlc";
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
//byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
//Response.Buffer = true;
//Response.ClearHeaders();
//Response.Clear();
//Response.ContentType = mimeType;
//Response.AddHeader("content-disposition", "inline; filename= " + lblLCSRequestNo.Text + "." + extension);
//Response.BinaryWrite(bytes);
//Response.Flush();
}
protected void submit_Click(object sender, EventArgs e)
{
DateTime datez = Convert.ToDateTime(dates.SelectedDate);
string convertedDate = datez.ToString("yyyy-MM-dd");
string selectedid = RadCmbTrans.SelectedValue;
var dt = GetData(convertedDate, selectedid);
var objectDataSource = new ObjectDataSource {
DataSource = dt
};
var report = new LabelRpt {
DataSource = objectDataSource
};
report.DataSource = objectDataSource;
var table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
table.ColumnHeadersPrintOnEveryPage = true;
table.DataSource = dt;
var clientReportSource = new InstanceReportSource {
ReportDocument = report
};
ReportViewer1.ReportSource = clientReportSource;
ReportViewer1.DataBind();
ReportViewer1.RefreshReport();
RadTabStrip1.FindTabByText("Report").Enabled = true;
RadTab tab1 = RadTabStrip1.Tabs.FindTabByText("Report");
tab1.Selected = true;
tab1.PageView.Selected = true;
}
protected void btnReporte_Click(object sender, EventArgs e)
{
gridPanel.Visible = false;
List<BusinessEntities.Curso_Reporte> Datos = new List<BusinessEntities.Curso_Reporte>();
for (int i = 0; i < gridCursos.Rows.Count; i++)
{
BusinessEntities.Curso_Reporte linea = new BusinessEntities.Curso_Reporte();
linea.ID = gridCursos.Rows[i].Cells[0].Text;
linea.Materia = gridCursos.Rows[i].Cells[1].Text;
linea.Comision = gridCursos.Rows[i].Cells[2].Text;
linea.Año = gridCursos.Rows[i].Cells[3].Text;
linea.Cupo = gridCursos.Rows[i].Cells[4].Text;
linea.Profesor = gridCursos.Rows[i].Cells[5].Text;
Datos.Add(linea);
}
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", Datos));
ReportViewer1.LocalReport.Refresh();
ReportViewer1.DataBind();
ReportViewer1.Visible = true;
ReportViewer1.ShowReportBody = true;
btnVolver_Reporte.Visible = true;
}
protected void BindSSRS()
{
try
{
ReportViewer1.ShowParameterPrompts = false;
ReportViewer1.ShowToolBar = false;
ReportViewer1.WaitMessageFont.Bold = true;
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ConfigurationManager.AppSettings["ReportServerURL"].ToString());
ReportViewer1.ServerReport.ReportPath = "/EPGM_Beneficiarly_Details";
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
IReportServerCredentials irsc = new CustomReportCredentials(ConfigurationManager.AppSettings["RSDomainUserName"].ToString(), ConfigurationManager.AppSettings["RSDomainPassword"].ToString(), ConfigurationManager.AppSettings["RSDomainName"].ToString());
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportViewer1.SizeToReportContent = true;
ReportViewer1.Width = Unit.Percentage(100);
ReportViewer1.Height = Unit.Percentage(100);
List <ReportParameter> parmList = new List <ReportParameter>();
ReportParameterInfoCollection parameters;
parameters = ReportViewer1.ServerReport.GetParameters();
for (int i = 0; i < parameters.Count; i++)
{
if (parameters[i].Name.ToLower() == "statecode")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), "52", false));
}
if (parameters[i].Name.ToLower() == "distcode")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), "12", false));
}
if (parameters[i].Name.ToLower() == "projectcode")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), " ", false));
}
if (parameters[i].Name.ToLower() == "sectorcode")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), " ", false));
}
if (parameters[i].Name.ToLower() == "centercode")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), " ", false));
}
if (parameters[i].Name.ToLower() == "whotype")
{
parmList.Add(new ReportParameter(parameters[i].Name.ToString(), "All", false));
}
}
ReportViewer1.ServerReport.SetParameters(parmList);
ReportViewer1.DataBind(); //ReportViewer1.ServerReport.Refresh();
}
catch (Exception ex)
{
lblerror.Text = ex.Message;
lblerror.ForeColor = Color.DarkRed;
}
}
protected void SearchBT_Click(object sender, EventArgs e)
{
decimal d1 = 0, d2 = 0;
if (!string.IsNullOrEmpty(StyleTB.Text.Trim()))
{
入庫應付LB.BackColor = System.Drawing.Color.White;
入庫應付LB.ForeColor = System.Drawing.Color.Black;
入庫暫估LB.BackColor = System.Drawing.Color.White;
入庫暫估LB.ForeColor = System.Drawing.Color.Black;
DataTable dt = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(DB1(), Conn);
myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt.Rows.Count > 0)
{
d1 = Convert.ToDecimal(dt.Compute("Sum(數量)", "true"));
}
DataTable dt2 = new DataTable();
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(DB2(), Conn);
myAdapter.Fill(dt2); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
if (dt2.Rows.Count > 0)
{
d2 = Convert.ToDecimal(dt2.Compute("Sum(數量)", "true"));
}
入庫應付LB.Text = d1.ToString();
入庫暫估LB.Text = d2.ToString();
if (d1 > d2)
{
入庫應付LB.BackColor = System.Drawing.Color.Red;
入庫應付LB.ForeColor = System.Drawing.Color.Yellow;
}
else if (d1 < d2)
{
入庫暫估LB.BackColor = System.Drawing.Color.Red;
入庫暫估LB.ForeColor = System.Drawing.Color.Yellow;
}
if (dt.Rows.Count > 0)
{
ReportViewer1.Visible = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource source = new ReportDataSource("DataSet1", dt);
ReportDataSource source2 = new ReportDataSource("DataSet2", dt2);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(source);
ReportViewer1.LocalReport.DataSources.Add(source2);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
}