更新时间:2023-02-01 20:57:32
;
olecmd.Connection = oleconn;
oleconn.Open();
OleDbDataReader reader = olecmd.ExecuteReader();
List< PrintInfo> prints = new List< PrintInfo> ();
PrintInfo print = null ;
while (reader.Read( ))
{
print = new PrintInfo();
print.Certificate = reader.GetValue( 4 )。ToString();
print.Schema = reader.GetValue( 3 )。ToString();
print.Name = reader.GetValue( 0 )。ToString();
print.Address = reader.GetValue( 1 )。ToString();
print.Mobile = reader.GetValue( 2 )。ToString();
print.Product = reader.GetValue( 5 )。ToString();
print.Brand = reader.GetValue( 6 )。ToString();
print.Sno = reader.GetValue( 7 )。ToString();
print.FromDate = reader.GetValue( 8 )。ToString();
print.ToDate = reader.GetValue( 9 )。ToString();
prints.Add(print);
}
返回打印;
}
// 此处的呼叫方法
private void LastSolution()
{
StringBuilder sb = new StringBuilder();
List< PrintInfo> prints = ExcelData.GetDataFromExcel();
foreach ( var print in 打印)
{
lblCertificate.Text = print.Certificate;
lblAddress.Text = print.Address;
lblBrand.Text = print.Brand;
lblFrom.Text = print.FromDate;
lblMobile.Text = print.Mobile;
lblName.Text = print.Name;
lblProduct.Text = print.Product;
lblScheme.Text = print.Schema;
lblSNo.Text = print.Sno;
lblTo.Text = print.ToDate;
/// 在Loop
中编写打印代码ClientScript.RegisterClientScriptBlock( this .GetType(), key , window.print(), true );
"; olecmd.Connection = oleconn; oleconn.Open(); OleDbDataReader reader = olecmd.ExecuteReader(); List<PrintInfo> prints = new List<PrintInfo>(); PrintInfo print = null; while (reader.Read()) { print = new PrintInfo(); print.Certificate = reader.GetValue(4).ToString(); print.Schema = reader.GetValue(3).ToString(); print.Name = reader.GetValue(0).ToString(); print.Address = reader.GetValue(1).ToString(); print.Mobile = reader.GetValue(2).ToString(); print.Product = reader.GetValue(5).ToString(); print.Brand = reader.GetValue(6).ToString(); print.Sno = reader.GetValue(7).ToString(); print.FromDate = reader.GetValue(8).ToString(); print.ToDate = reader.GetValue(9).ToString(); prints.Add(print); } return prints; } // Calling method here private void LastSolution() { StringBuilder sb = new StringBuilder(); List<PrintInfo> prints = ExcelData.GetDataFromExcel(); foreach (var print in prints) { lblCertificate.Text = print.Certificate; lblAddress.Text = print.Address; lblBrand.Text = print.Brand; lblFrom.Text = print.FromDate; lblMobile.Text = print.Mobile; lblName.Text = print.Name; lblProduct.Text = print.Product; lblScheme.Text = print.Schema; lblSNo.Text = print.Sno; lblTo.Text = print.ToDate; ///Write Print Code Here within Loop ClientScript.RegisterClientScriptBlock(this.GetType(), "key","window.print()", true);
你没有显示完整的代码,这些代码应该显示你是怎么做的,但显然你没有做任何事情来在循环内打印。-SA
You don't show complete code which should show how you do it, but apparently, you are not doing anything for printing inside the loop.—SA