private void FrmPrint_Load(object sender, EventArgs e)
{
var sql = "SELECT a.*,c.Dept FROM udstr a LEFT JOIN dbo.udone b ON b.sgdhao=a.sgdhao " +
"LEFT JOIN DZDJ.dbo.TB_Dept c ON c.ID=b.DeptId " +
$"WHERE zling='{SqlHelper.ProcCardNo}' AND DeptId='{SqlHelper.DeptId}' ORDER BY a.gxone,a.gxtwo";
SqlHelper.FillDataset(SqlHelper.GetConnection(), CommandType.Text, sql, _ds, new [] { "sql" });
//var cr = new cncCryst();
cncCryst1.Load(Application.StartupPath + "cncCryst.rpt");
cncCryst1.SetDataSource(_ds.Tables[0]);
//cr.SetParameterValue("procCardNo", SqlHelper.ProcCardNo);
//cr.SetParameterValue("DeptId", SqlHelper.DeptId);
//cr.ReportDocument.ParameterFields["Parm"].CurrentValues.AddValue(
crystalReportViewer1.ReportSource = cncCryst1;
}