先把代码贴出来吧
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
InPrintCrystalReport cr = new InPrintCrystalReport();
string connString = @"Server=Localhost;database=store;uid=sa;pwd=123";
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string sql = null;
if (jy.value1 == "货物编号")
{
sql = "select inID,inSto.MID,name,type,unit,price,inNum,inDate,endDate,saver,manufacturer,provider from material,inSto where inSto.MID = material.MID and material.MID in ( '" + jy.value + " ')";
}
else if (jy.value1 == "货物名称")
{
sql = "select * from material,inSto where material.MID = inSto.MID and material.name='" + jy.value + "'";
}
else
sql = "select * from material,inSto where material.MID = inSto.MID and material.class='" + jy.value + "'";
SqlDataAdapter adp = new SqlDataAdapter(sql, conn);
DataSet2 ds = new DataSet2();
ds.Clear();
adp.Fill(ds, "material");
adp.Fill(ds, "inSto");
string reportPath = "";
reportPath = "InPrintCrystalReport.rpt";
cr.Load(reportPath);
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
}
打印的时候,假如查询出来是1条记录,报表就只显示一条,假如查询出的是3条记录,报表则显示3*3=9条记录,这个怎么办啊,我折腾一下午了.....
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
InPrintCrystalReport cr = new InPrintCrystalReport();
string connString = @"Server=Localhost;database=store;uid=sa;pwd=123";
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string sql = null;
if (jy.value1 == "货物编号")
{
sql = "select inID,inSto.MID,name,type,unit,price,inNum,inDate,endDate,saver,manufacturer,provider from material,inSto where inSto.MID = material.MID and material.MID in ( '" + jy.value + " ')";
}
else if (jy.value1 == "货物名称")
{
sql = "select * from material,inSto where material.MID = inSto.MID and material.name='" + jy.value + "'";
}
else
sql = "select * from material,inSto where material.MID = inSto.MID and material.class='" + jy.value + "'";
SqlDataAdapter adp = new SqlDataAdapter(sql, conn);
DataSet2 ds = new DataSet2();
ds.Clear();
adp.Fill(ds, "material");
adp.Fill(ds, "inSto");
string reportPath = "";
reportPath = "InPrintCrystalReport.rpt";
cr.Load(reportPath);
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
}
打印的时候,假如查询出来是1条记录,报表就只显示一条,假如查询出的是3条记录,报表则显示3*3=9条记录,这个怎么办啊,我折腾一下午了.....
入库表单应该是一次就一个,一个入库表单可以有多种材料这样吧。我做的仓库系统就这样做的。
在做ERP?