private void FRM_ErWeiMaWangDianDaYin_Load(object sender, EventArgs e) { DS_WuLiu myDS_WuLiu = new DS_WuLiu(); myDS_WuLiu.Tables["BaoBiao_网点二维码"].Merge(dtErWeiMa); CRP_ErWeiMaWangDianDaYin myCRP_ErWeiMaWangDianDaYin = new CRP_ErWeiMaWangDianDaYin(); myCRP_ErWeiMaWangDianDaYin.SetDataSource(myDS_WuLiu); crystalReportViewer1.ReportSource = myCRP_ErWeiMaWangDianDaYin; }
private void FRM_YuanGongGongZuoZhengDaYin_Load(object sender, EventArgs e) { BLL物流管理系统.报表统计.FRM_YuanGongGongZuoZheng.FRM_YuanGongGongZuoZhengClient myFRM_YuanGongGongZuoZhengClient = new BLL物流管理系统.报表统计.FRM_YuanGongGongZuoZheng.FRM_YuanGongGongZuoZhengClient(); DataTable dtDingDan = myFRM_YuanGongGongZuoZhengClient.FRM_YuanGongGongZuoZhengDaYin_Load_ChaXunYuanGong().Tables[0]; DS_WuLiu myDS_WuLiu = new DS_WuLiu(); myDS_WuLiu.Tables["BaoBiao_员工表"].Merge(dtDingDan); CRP_YuanGongGongZuoZhengDaYin myCRP_YuanGongGongZuoZhengDaYin = new CRP_YuanGongGongZuoZhengDaYin(); myCRP_YuanGongGongZuoZhengDaYin.SetDataSource(myDS_WuLiu); crystalReportViewer1.ReportSource = myCRP_YuanGongGongZuoZhengDaYin; }
private void FRM_ShenHeHuoPinTongJi_Load(object sender, EventArgs e) { BLL物流管理系统.报表统计.FRM_ShenHeHuoPinTongJi.FRM_ShenHeHuoPinTongJiClient myFRM_ShenHeHuoPinTongJiClient = new BLL物流管理系统.报表统计.FRM_ShenHeHuoPinTongJi.FRM_ShenHeHuoPinTongJiClient(); DataTable dtDingDan = myFRM_ShenHeHuoPinTongJiClient.FRM_ShenHeHuoPinTongJi_Load_ChaXunHuiZong().Tables[0]; DS_WuLiu myDS_WuLiu = new DS_WuLiu(); myDS_WuLiu.Tables["BaoBiao_审核货品统计"].Merge(dtDingDan); CRP_ShenHeHuoPinTongJi myCRP_ShenHeHuoPinTongJi = new CRP_ShenHeHuoPinTongJi(); myCRP_ShenHeHuoPinTongJi.SetDataSource(myDS_WuLiu); crystalReportViewer1.ReportSource = myCRP_ShenHeHuoPinTongJi; }
private void FRM_YuFenTuoYunFangTongJi_Load(object sender, EventArgs e) { BLL物流管理系统.报表统计.FRM_YeWuYuanYeJi.FRM_YeWuYuanYeJiClient myFRM_YeWuYuanYeJiClient = new BLL物流管理系统.报表统计.FRM_YeWuYuanYeJi.FRM_YeWuYuanYeJiClient(); DataTable dtDingDan = myFRM_YeWuYuanYeJiClient.FRM_YeWuYuanYeJi_Load_ChaXunDingDan().Tables[0]; DS_WuLiu myDS_WuLiu = new DS_WuLiu(); myDS_WuLiu.Tables["BaoBiao_订单报表"].Merge(dtDingDan); CRP_YueFenTuoYunFangTongJi myCRP_YueFenTuoYunFangTongJi = new CRP_YueFenTuoYunFangTongJi(); myCRP_YueFenTuoYunFangTongJi.SetDataSource(myDS_WuLiu); crystalReportViewer1.ReportSource = myCRP_YueFenTuoYunFangTongJi; }
private void FRM_DingDanBaoBiao_Load(object sender, EventArgs e) { BLL物流管理系统.报表统计.FRM_DingDanBaoBiao.FRM_DingDanBaoBiaoClient myFRM_DingDanBaoBiaoClient = new BLL物流管理系统.报表统计.FRM_DingDanBaoBiao.FRM_DingDanBaoBiaoClient(); //实例化BLL对象 DataTable dtDingDan = myFRM_DingDanBaoBiaoClient.FRM_DingDanBaoBiao_Load_ChaXunDingDan(strDingDanID).Tables[0]; //根据货运单ID查询货运单信息 DS_WuLiu myDS_WuLiu = new DS_WuLiu(); //实例化物流数据集 myDS_WuLiu.Tables["BaoBiao_订单报表"].Merge(dtDingDan); //把数据集中名为“BaoBiao_订单报表”与查询得到的dtDingDan合并 DataTable dtMingXi = myFRM_DingDanBaoBiaoClient.FRM_DingDanBaoBiao_Load_ChaXunMingXi(strDingDanID).Tables[0]; //根据货运单ID查询货运单明细信息 myDS_WuLiu.Tables["BaoBiao_订单报表明细"].Merge(dtMingXi); //把数据集中名为“BaoBiao_订单报表明细”与查询得到的dtMingXi合并 CRP_DingDanBaoBiao myCRP_DingDanBaoBiao = new CRP_DingDanBaoBiao(); //实例化报表对象 myCRP_DingDanBaoBiao.SetDataSource(myDS_WuLiu); //设定报表的数据源为数据集对象 crystalReportViewer1.ReportSource = myCRP_DingDanBaoBiao; //指定水晶报表视图控件的报表源为报表对象 }
private void FRM_ErWeiMaDanHaoDaYin_Load(object sender, EventArgs e) { DS_WuLiu myDS_WuLiu = new DS_WuLiu(); //DataTable dtER1 = dtErWeiMa.Clone(); //DataTable dtER2 = dtErWeiMa.Clone(); int intBan = 0; if (dtErWeiMa.Rows.Count % 2 == 0) { intBan = dtErWeiMa.Rows.Count / 2; } else { intBan = (dtErWeiMa.Rows.Count / 2) + 1; } DataTable dtER1 = myDS_WuLiu.Tables["BaoBiao_单据二维码"].Clone(); for (int i = 0; i < intBan; i++) { dtER1.Rows.Add(); } for (int i = 0; i < dtErWeiMa.Rows.Count; i++) { if (i < intBan) { dtER1.Rows[i]["单据编号"] = dtErWeiMa.Rows[i]["单据编号"]; dtER1.Rows[i]["二维码"] = dtErWeiMa.Rows[i]["二维码"]; } else { dtER1.Rows[i - intBan]["单据编号1"] = dtErWeiMa.Rows[i]["单据编号"]; dtER1.Rows[i - intBan]["二维码1"] = dtErWeiMa.Rows[i]["二维码"]; } } myDS_WuLiu.Tables["BaoBiao_单据二维码"].Merge(dtER1); //myDS_WuLiu.Tables["BaoBiao_单据二维码1"].Merge(dtErWeiMa); //myDS_WuLiu.Tables["BaoBiao_单据二维码2"].Merge(dtER2); CRP_ErWeiMaDanHaoDaYin myCRP_ErWeiMaDanHaoDaYin = new CRP_ErWeiMaDanHaoDaYin(); myCRP_ErWeiMaDanHaoDaYin.SetDataSource(myDS_WuLiu); crystalReportViewer1.ReportSource = myCRP_ErWeiMaDanHaoDaYin; }