private void btnPreviewReport_Click(object sender, EventArgs e)
{
dsReport ds = new dsReport();
DataSet dsSP = bllReports.GetSalesInvoice(this.txtInvoiceNumber.Text.Trim());
try
{
foreach (DataRow dr in dsSP.Tables[0].Rows)
{
ds.Tables["SalesParentInfo"].ImportRow(dr);
}
foreach (DataRow dr in dsSP.Tables[1].Rows)
{
ds.Tables["SalesChildInfo"].ImportRow(dr);
}
foreach (DataRow dr in bllCompanyInfo.getById(1).Rows)
{
ds.Tables["CompanyInfo"].ImportRow(dr);
}
rptSalesInvoice_Large rptTest = new Report.rptSalesInvoice_Large();
rptTest.SetDataSource(ds);
//rptTest.PrintToPrinter(1, false, 0, 0);
frmRptv obj = new frmRptv();
obj.SetReportDataSource = rptTest;
obj.ShowDialog();
}
catch
{ }
}
public override global::System.Data.DataSet Clone()
{
dsReport cln = ((dsReport)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (rdbAttendance.Checked)
{
try
{
rptAttendance AttendanceReport = new rptAttendance();
dsReport ds = new dsReport();
dsReportTableAdapters.vAttendanceListTableAdapter taEmployee = new dsReportTableAdapters.vAttendanceListTableAdapter();
if (cmbEmployee.SelectedIndex == -1)
{
taEmployee.Fill(ds.vAttendanceList, 0, dtpStart.Text, dtpEnd.Text);
}
else
{
taEmployee.Fill(ds.vAttendanceList, Convert.ToInt32(cmbEmployee.SelectedValue), dtpStart.Text, dtpEnd.Text);
}
AttendanceReport.SetDataSource(ds);
Cursor = Cursors.WaitCursor;
this.crystalReportViewer1.ReportSource = AttendanceReport;
this.crystalReportViewer1.RefreshReport();
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
try
{
rptSalaryList SalaryReport = new rptSalaryList();
dsReport ds = new dsReport();
dsReportTableAdapters.rSalaryListTableAdapter taSalary = new dsReportTableAdapters.rSalaryListTableAdapter();
if (cmbEmployee.SelectedIndex == -1)
{
taSalary.Fill(ds.rSalaryList, dtpStart.Text, dtpEnd.Text, 0);
}
else
{
taSalary.Fill(ds.rSalaryList, dtpStart.Text, dtpEnd.Text, Convert.ToInt32(cmbEmployee.SelectedValue));
}
SalaryReport.SetDataSource(ds);
Cursor = Cursors.WaitCursor;
this.crystalReportViewer1.ReportSource = SalaryReport;
this.crystalReportViewer1.RefreshReport();
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
dsReport ds = new dsReport();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
static ReportsView()
{
dsReport = new dsReport();
reportServiceTableAdapter daReportService = new reportServiceTableAdapter();
reportSaleTableAdapter daReportSale = new reportSaleTableAdapter();
try
{
daReportService.Fill(dsReport.reportService);
daReportSale.Fill(dsReport.reportSale);
}
catch { }
}
private void ReportViewer_Load(object sender, EventArgs e)
{
try
{
EmployeeList EmployeReport = new EmployeeList();
dsReport ds = new dsReport();
dsReportTableAdapters.rEmployeeListTableAdapter taEmployee = new dsReportTableAdapters.rEmployeeListTableAdapter();
taEmployee.Fill(ds.rEmployeeList);
EmployeReport.SetDataSource(ds);
Cursor = Cursors.WaitCursor;
this.crystalReportViewer1.ReportSource = EmployeReport;
this.crystalReportViewer1.RefreshReport();
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//lấy dữ liệu từ cookie
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SQLConn"].ToString();// "server='NgoQuangLua-PC'; uid=sa;pwd=sa; Database='QL'; trusted_connection=true;";
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
HttpCookie Cookie = Request.Cookies["BaoCaoID"];
HttpCookie Cookie1 = Request.Cookies["TuNgay"];
HttpCookie Cookie2 = Request.Cookies["DenNgay"];
if (Cookie["Data"] == "1")//báo cáo kế hoạch
{
IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
DateTime TuNgay = DateTime.ParseExact(Cookie1["Data"], "dd/MM/yyyy", theCultureInfo);
DateTime DenNgay = DateTime.ParseExact(Cookie2["Data"], "dd/MM/yyyy", theCultureInfo);
rptKeHoachTrienKhai oReport = new rptKeHoachTrienKhai();
dsReport oDs=new dsReport();
SqlCommand ocm=new SqlCommand();
ocm.Connection=sqlConnection;
ocm.CommandText = "select b.TenDoiTac,a.So_Luong SoLuong,(c.DiaChi +' '+ c.Tel) ThongTinLienHe,a.NgayLap ThoiGianDuKien,SYSDATETIME() ThoiGianTrienKhai,SYSDATETIME() ThoiGianHoanThanh,c.TenDayDu PhuTrachTrienKhai,a.TinhTrang,'' GhiChu from KeHoachNhapXuat a,DoiTac b,NhanVien c where a.DoiTac_Id=b.DoiTac_Id and a.NhanVien_Lap_Id=c.NhanVien_Id and a.NgayLap>='"+ TuNgay +"' and a.NgayLap<='"+ DenNgay +"'";
SqlDataAdapter oAdap=new SqlDataAdapter(ocm);
oAdap.Fill(oDs.KeHoachNhapXuat);
oReport.SetDataSource(oDs);
rptviewer.ReportSource = oReport;
}
else if (Cookie["Data"] == "2")//Nhật ký cài đặt phần mềm
{
IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
DateTime TuNgay = DateTime.ParseExact(Cookie1["Data"], "dd/MM/yyyy", theCultureInfo);
DateTime DenNgay = DateTime.ParseExact(Cookie2["Data"], "dd/MM/yyyy", theCultureInfo);
rptNhatKyCaiDatPM oReport = new rptNhatKyCaiDatPM();
dsReport oDs = new dsReport();
SqlCommand ocm = new SqlCommand();
ocm.Connection = sqlConnection;
ocm.CommandText = "select a.NgayLap,a.NguoiPheDuyet,a.NguoiLap,b.TenDoiTac,a.So_Luong,d.Ma_Serial,d.Ma_MAC,d.Ma_DLK,d.Dien_Giai,c.PhieuXuat_Id as gr from KeHoachNhapXuat a,DoiTac b,PhieuXuat c,ThongTinThietBi d where a.DoiTac_Id=b.DoiTac_Id and a.KeHoachNhapXuat_Id=c.KeHoachNhapXuat_Id and c.PhieuXuat_Id=d.PhieuXuat_Id";
SqlDataAdapter oAdap = new SqlDataAdapter(ocm);
oAdap.Fill(oDs.NhatKyCaiDatPM);
oReport.SetDataSource(oDs);
rptviewer.ReportSource = oReport;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (_SelctedInvoice == "")
{
XtraMessageBox.Show("You have not select any invoice.", "Information");
}
else
{
string SalesReturn = bllReportUtility.ReportData("Select IsNull(SalesReturn,0) from SalesParentInfo where InvoiceNo='" + _SelctedInvoice + "'").Rows[0][0].ToString();
dsReport ds = new dsReport();
DataSet dsSP = bllReports.GetSalesInvoice(_SelctedInvoice);
try
{
foreach (DataRow dr in dsSP.Tables[0].Rows)
{
ds.Tables["SalesParentInfo"].ImportRow(dr);
}
foreach (DataRow dr in dsSP.Tables[1].Rows)
{
ds.Tables["SalesChildInfo"].ImportRow(dr);
}
foreach (DataRow dr in bllCompanyInfo.getById(1).Rows)
{
ds.Tables["CompanyInfo"].ImportRow(dr);
}
rptSalesInvoice_Large rptTest = new Report.rptSalesInvoice_Large();
rptTest.SetDataSource(ds);
rptTest.SetParameterValue("SalesReturn", bllUtility.Val(SalesReturn));
//rptTest.PrintToPrinter(1, false, 0, 0);
frmRptv obj = new frmRptv();
obj.SetReportDataSource = rptTest;
obj.ShowDialog();
}
catch
{ }
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
dsReport ds = new dsReport();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "dtReportDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void butdy_Click(object sender, EventArgs e)
{
if (chkBrmx.Checked)
{
MessageBox.Show("暂未提供打印病人明细固定格式！");
return;
}
FrmReportView rv;
ParameterEx[] parameters;
//查询条件
string rq = "";
if (rbFsrq.Checked)
{
rq = rbFsrq.Text + ":" + this.dtp1.Value.ToString() + " 到 " + this.dtp2.Value.ToString();
}
else if (rbJsrq.Checked)
{
rq = rbJsrq.Text + ":" + this.dtp1.Value.ToString() + " 到 " + this.dtp2.Value.ToString();
}
else
{
rq = rbDqzy.Text + ":" + this.dtp2.Value.ToString();
}
string ks = "";
if (rbKdks.Checked)
{
ks = "统计科室类型:" + rbKdks.Text;
}
else if (rbBrks.Checked)
{
ks = "统计科室类型:" + rbBrks.Text;
}
else if (rbZxks.Checked)
{
ks = "统计科室类型:" + rbZxks.Text;
}
else if (rbJsks.Checked)//Add By Tany 2012-03-06
{
ks = "统计科室类型:" + rbJsks.Text;
}
string swhere = ks;
DataTable jsbrTb = (DataTable)dataGridView1.DataSource;
if (rbKj.Checked && !chkBrmx.Checked)
{
if (jsbrTb != null && jsbrTb.Rows.Count > 0)
{
parameters = new ParameterEx[4];
parameters[0].Text = "报表标题";
parameters[0].Value = Constant.HospitalName + "住院科室收入统计报表（二）";
parameters[2].Text = "时间段";
parameters[2].Value = rq;
parameters[1].Text = "制表人";
parameters[1].Value = FrmMdiMain.CurrentUser.Name;
parameters[3].Text = "其他参数";
parameters[3].Value = swhere;
dsReport ds = new dsReport();
DataTable dsTb = ds.Tables["dtJzjsbrmx"];
DataTable xmTb = FrmMdiMain.Database.GetDataTable("select * from jc_zykj_xm order by sort_id");
string d = "";
string s = "";
for (int j = 0; j < jsbrTb.Rows.Count; j++)
{
DataRow dr = dsTb.NewRow();
dr["住院号"] = "";
dr["病人姓名"] = "";
dr["票据号"] = 0;
dr["冲帐标志"] = "";
dr["住院科室"] = jsbrTb.Rows[j]["科室"];
dr["结算时间"] = "";
dr["结算类型"] = "";
dr["操作员"] = "";
dr["合计"] = jsbrTb.Rows[j]["合计"];
for (int i = 0; i < xmTb.Rows.Count; i++)
{
d = "d" + Convert.ToString(i + 1);
s = "s" + Convert.ToString(i + 1);
dr[d] = jsbrTb.Rows[j][xmTb.Rows[i]["item_name"].ToString().Trim()];
dr[s] = xmTb.Rows[i]["item_name"].ToString().Trim();
}
dsTb.Rows.Add(dr);
}
rv = new FrmReportView(dsTb, Constant.ApplicationDirectory + "\\report\\ZYGL_科室收入统计.rpt", parameters, false);
rv.Show();
}
}
else//Modify By Tany 2012-01-11 改成自由列
{
if (jsbrTb != null && jsbrTb.Rows.Count > 0)
{
parameters = new ParameterEx[4];
parameters[0].Text = "报表标题";
parameters[0].Value = Constant.HospitalName + "住院科室收入统计";
parameters[2].Text = "时间段";
parameters[2].Value = rq;
parameters[1].Text = "制表人";
parameters[1].Value = FrmMdiMain.CurrentUser.Name;
parameters[3].Text = "其他参数";
parameters[3].Value = swhere;
dsReport ds = new dsReport();
DataTable dsTb = ds.Tables["dtJzjsbrmx"];
//DataTable xmTb = FrmMdiMain.Database.GetDataTable("select * from jc_zykj_xm order by sort_id");
string d = "";
string s = "";
for (int j = 0; j < jsbrTb.Rows.Count; j++)
{
for (int i = 2; i < jsbrTb.Columns.Count; i++)
{
DataRow dr = dsTb.NewRow();
dr["住院号"] = "";
dr["病人姓名"] = "";
dr["票据号"] = 0;
dr["冲帐标志"] = "";
dr["住院科室"] = jsbrTb.Rows[j]["科室"];
dr["结算时间"] = "";
dr["结算类型"] = "";
dr["操作员"] = "";
dr["合计"] = jsbrTb.Rows[j]["合计"];
d = "d1";
s = "s1";
//Modify By Tany 2012-03-08
if (chkPbxs.Checked && Convert.ToDecimal(Convertor.IsNull(jsbrTb.Rows[j][i], "0")) == 0)
{
continue;
}
dr[d] = jsbrTb.Rows[j][i];
dr[s] = jsbrTb.Columns[i].ToString().Trim();
dsTb.Rows.Add(dr);
}
}
rv = new FrmReportView(dsTb, Constant.ApplicationDirectory + "\\report\\ZYGL_科室收入统计动态.rpt", parameters, false);
rv.Show();
}
}
}
private void butdy_Click(object sender, EventArgs e)
{
FrmReportView rv;
ParameterEx[] parameters;
//Modify By Tany 2010-03-09 如果条件为全部，则不显示条件
//查询条件
string rq = (rbJkrq.Checked ? rbJkrq.Text : rbSfrq.Text) + ":" + this.dtp1.Value.ToString() + " 到 " + this.dtp2.Value.ToString();
string sfy = cmbuser.Text.Trim() == "全部" ? "" : ("收费员:" + cmbuser.Text.Trim());
string ks = cmbDept.Text.Trim() == "全部" ? "" : ("科室:" + cmbDept.Text.Trim());
string brlx = cmbBrlx.Text.Trim() == "全部" ? "" : ("病人类型:" + cmbBrlx.Text.Trim());
string jslx = cmbJslx.Text.Trim() == "全部" ? "" : ("结算类型:" + cmbJslx.Text.Trim());
string yblx = "";
if (Convert.ToInt32(this.cmbJslx.SelectedValue) == 1)
{
yblx = cmbYblx.Text.Trim() == "全部" ? "" : ("医保类型:" + cmbYblx.Text.Trim());
}
string jsfs = "结算方式:";//-1=全部0=中途结算1=正式结算2=欠费结算
if (rbZcjs.Checked)
{
jsfs += rbZcjs.Text;
}
else if (rbZtjs.Checked)
{
jsfs += rbZtjs.Text;
}
else if (rbQfjs.Checked)
{
jsfs += rbQfjs.Text;
}
else
{
jsfs = "";
}
string swhere = sfy + " " + ks + " " + brlx + " " + jslx + " " + yblx + " " + jsfs;
if (rbJsxx.Checked)
{
DataTable jsTb = (DataTable)dataGridView1.DataSource;
if (jsTb != null && jsTb.Rows.Count > 0)
{
parameters = new ParameterEx[4];
parameters[1].Text = "报表标题";
parameters[1].Value = Constant.HospitalName + "出纳交账报表（一）";
parameters[2].Text = "时间段";
parameters[2].Value = rq;
parameters[0].Text = "制表人";
parameters[0].Value = FrmMdiMain.CurrentUser.Name;
parameters[3].Text = "其他参数";
parameters[3].Value = swhere;
rv = new FrmReportView(jsTb, Constant.ApplicationDirectory + "\\report\\ZYGL_病人结算统计.rpt", parameters, false);
rv.Show();
}
}
else
{
DataTable jsbrTb = (DataTable)dataGridView1.DataSource;
if (jsbrTb != null && jsbrTb.Rows.Count > 0)
{
parameters = new ParameterEx[4];
parameters[0].Text = "报表标题";
parameters[0].Value = Constant.HospitalName + "住院结算统计报表";
parameters[2].Text = "时间段";
parameters[2].Value = rq;
parameters[1].Text = "制表人";
parameters[1].Value = FrmMdiMain.CurrentUser.Name;
parameters[3].Text = "其他参数";
parameters[3].Value = swhere;
dsReport ds = new dsReport();
DataTable dsTb = ds.Tables["dtJzjsbrmx"];
DataTable xmTb = FrmMdiMain.Database.GetDataTable("select * from jc_zykj_xm order by sort_id");
string d = "";
string s = "";
for (int j = 0; j < jsbrTb.Rows.Count; j++)
{
DataRow dr = dsTb.NewRow();
dr["住院号"] = jsbrTb.Rows[j]["住院号"];
dr["病人姓名"] = jsbrTb.Rows[j]["病人姓名"];
dr["票据号"] = jsbrTb.Rows[j]["票据号"];
dr["冲帐标志"] = jsbrTb.Rows[j]["冲帐标志"];
dr["住院科室"] = jsbrTb.Rows[j]["住院科室"];
dr["结算时间"] = jsbrTb.Rows[j]["结算时间"];
dr["结算类型"] = jsbrTb.Rows[j]["结算类型"];
dr["操作员"] = jsbrTb.Rows[j]["操作员"];
dr["合计"] = jsbrTb.Rows[j]["合计"];
for (int i = 0; i < xmTb.Rows.Count; i++)
{
d = "d" + Convert.ToString(i + 1);
s = "s" + Convert.ToString(i + 1);
dr[d] = jsbrTb.Rows[j][xmTb.Rows[i]["item_name"].ToString().Trim()];
dr[s] = xmTb.Rows[i]["item_name"].ToString().Trim();
}
dsTb.Rows.Add(dr);
}
rv = new FrmReportView(dsTb, Constant.ApplicationDirectory + "\\report\\ZYGL_病人结算明细统计.rpt", parameters, false);
rv.Show();
}
}
}
private void printReport(string rpt)
{
string path = string.Empty;
string pathImg = string.Empty;
string virtualPath = string.Empty;
string RptFileName = string.Empty;
string TemplatePath = string.Empty;
bool withDet = true;
object obj;
int id = 0;
dsReport ds = new dsReport();
switch (rpt)
{
case "entradaAlm":
obj = (Entrada)Session["SEntrada"];
if (obj == null)
{
id = Convert.ToInt32(Request["_key"].ToString());
withDet = Convert.ToBoolean(Request["_wdet"].ToString());
obj = EntradaCtrl.EntradaGetAllDataById(id);
}
RptFileName = ((Entrada)obj).Folio + ((Entrada)obj).Folio_indice + ".pdf";
path = HttpContext.Current.Server.MapPath("~/rpt/entradasAlm/") + RptFileName;
//pathImg = HttpContext.Current.Server.MapPath("~/images/logo.jpg");
if (((Entrada)obj).IsActive)
{
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/ealm.rpt");
}
else
{
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/ealmCan.rpt");
}
string TemplatePathTarima = HttpContext.Current.Server.MapPath("~/rpt/TemplatePallet.pdf");
DocEntrada.getEntradaAlm(path, TemplatePath, TemplatePathTarima, (Entrada)obj, ds, withDet);
//this.getRpt(path, TemplatePath, (Entrada)obj, ds);
//ReportDocument reporte = new ReportDocument();
//reporte.Load(HttpContext.Current.Server.MapPath("~/report/Almacen/EntradaAlm.rpt"));
//reporte.SetParameterValue("direccion_bodega", "Luisa 208, col. Nativitas, Benito Juárez. C.P. 03500. México, CDMX");
////reporte.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Test");
//reporte.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path);
////VisorCR.ReportSource = reporte;
ShowPdf(path);
break;
case "remision":
id = Convert.ToInt32(Request["_key"].ToString());
Tarima_almacen_remision o = AlmacenCtrl.tarimaRemisionGetAllInfoById(id);
RptFileName = o.Folio + ".pdf";
path = HttpContext.Current.Server.MapPath("~/rpt/remisionAlm/") + RptFileName;
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/ralm.rpt");
ControlRptAlmacen.getRemision(path, TemplatePath, ds, o);
ShowPdf(path);
break;
case "carga":
id = Convert.ToInt32(Request["_key"].ToString());
Tarima_almacen_carga oTAC = AlmacenCtrl.CargaRpt(id);
RptFileName = oTAC.Folio_orden_carga + ".pdf";
path = HttpContext.Current.Server.MapPath("~/rpt/cargaAlm/") + RptFileName;
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/Carga.rpt");
ControlRptAlmacen.getCarga(path, TemplatePath, ds, oTAC);
ShowPdf(path);
break;
case "salidaAlm":
id = Convert.ToInt32(Request["_key"].ToString());
obj = SalidaCtrl.SalidaGetAllDataById(id);
RptFileName = ((Salida)obj).Folio + ((Salida)obj).Folio_indice + ".pdf";
path = HttpContext.Current.Server.MapPath("~/rpt/salidasAlm/") + RptFileName;
AlmacenCtrl.CargaSetSalida(((Salida)obj));
//pathImg = HttpContext.Current.Server.MapPath("~/images/logo.jpg");
if (((Salida)obj).IsActive)
{
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/salm.rpt");
}
else
{
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/salmCan.rpt");
}
DocSalida.getSalidaAlm(path, TemplatePath, (Salida)obj, ds);
ShowPdf(path);
break;
case "salidaAlmXls":
id = Convert.ToInt32(Request["_key"].ToString());
obj = SalidaCtrl.SalidaGetAllDataById(id);
RptFileName = ((Salida)obj).Folio + ((Salida)obj).Folio_indice + ".xls";
path = HttpContext.Current.Server.MapPath("~/rpt/salidasAlm/") + RptFileName;
AlmacenCtrl.CargaSetSalida(((Salida)obj));
if (((Salida)obj).IsActive)
{
TemplatePath = HttpContext.Current.Server.MapPath("~/report/Almacen/salm.rpt");
DocSalida.getSalidaAlmXls(path, TemplatePath, (Salida)obj, ds);
}
ShowXls(path, RptFileName);
break;
}
}
private void FrmMain_OnPassTestNumber(string TestNumber)
{
TestData = TestNumber;
string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
string path = (System.IO.Path.GetDirectoryName(executable));
AppDomain.CurrentDomain.SetData("Data Directory", path);
dsReport ds = new dsReport();
string test = "SELECT * FROM tblTest WHERE TestNumber = @testnumber";
string excitation = "SELECT * FROM tblExcitation WHERE TestNumber = @testnumber";
string ipf = "SELECT * FROM tblIPF WHERE TestNumber = @testnumber";
string bushing = "SELECT * FROM tblBushing WHERE TestNumber = @testnumber";
string ttr = "SELECT * FROM tblTTR WHERE TestNumber = @testnumber";
string winding = "SELECT * FROM tblWinding WHERE TestNumber = @testnumber";
string dielectric = "SELECT * FROM tblDielectric WHERE TestNumber = @testnumber";
string oilpf = "SELECT * FROM tblOilPF WHERE TestNumber = @testnumber";
try
{
using (SqlConnection con = new SqlConnection(constring))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(test, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Test"]);
}
}
using (SqlCommand cmd = new SqlCommand(excitation, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Excitation"]);
}
}
using (SqlCommand cmd = new SqlCommand(ipf, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["IPF"]);
}
}
using (SqlCommand cmd = new SqlCommand(bushing, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Bushing"]);
}
}
using (SqlCommand cmd = new SqlCommand(ttr, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["TTR"]);
}
}
using (SqlCommand cmd = new SqlCommand(winding, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Winding"]);
}
}
using (SqlCommand cmd = new SqlCommand(dielectric, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["Dielectric"]);
}
}
using (SqlCommand cmd = new SqlCommand(oilpf, con))
{
cmd.Parameters.AddWithValue("@testnumber", TestData);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds.Tables["OilPF"]);
}
}
con.Close();
}
CrystalReport11.SetDataSource(ds);
crystalReportViewer1.ReportSource = CrystalReport11;
crystalReportViewer1.Refresh();
}
finally
{
frmMain.OnPassTestNumber -= FrmMain_OnPassTestNumber;
}
}
