private void button3_Click(object sender, EventArgs e) { if (!PowerCheckCsClass.IfHasPower(LoginClass.LogID, CommFunction.GSYSNAME, sender, CommFunction.ConnectString)) { return; } if ((tbGzbdh.Text.Trim() == "") || tbGzbdh.Text == null) { return; } LYFunctionCs.frmReportView frv = new LYFunctionCs.frmReportView(); ReportDocument Rpt = new ReportDocument(); string pRptNmae = ""; pRptNmae = LYFunctionCs.LYFunctionCsClass.cmdScalar("select cm.report_file from cc_cold_chain_c cc left join cc_cold_chain_z cz on cc.pkunid=cz.unid left join cc_item_master cm on cc.size_desc=cm.size_desc and cm.season=cz.season where pkunid='" + tbGzbdh.Text + "' and cm.report_file is not null and rownum=1 ", CommFunction.ConnectString); if ((pRptNmae.Trim() == "") || (pRptNmae == null)) { pRptNmae = "Rep_CC_ITEM_TRACK.rpt"; } Rpt.Load(AppDomain.CurrentDomain.SetupInformation.ApplicationBase + pRptNmae); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = CommFunction.cfServerName; logOnInfo.ConnectionInfo.UserID = CommFunction.cfUserID; logOnInfo.ConnectionInfo.Password = CommFunction.cfPassword; Rpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo); //Rpt.Refresh(); frv.crystalReportViewer1.ReportSource = Rpt; CrystalDecisions.Shared.ParameterValues mypaVal = new CrystalDecisions.Shared.ParameterValues(); CrystalDecisions.Shared.ParameterDiscreteValue mypaDVal = new CrystalDecisions.Shared.ParameterDiscreteValue(); mypaDVal.Value = tbGzbdh.Text; mypaVal.Add(mypaDVal); Rpt.DataDefinition.ParameterFields["GZBDH"].ApplyCurrentValues(mypaVal); frv.ShowDialog(); }
private void button3_Click(object sender, EventArgs e) { if (!PowerCheckCsClass.IfHasPower(LoginClass.LogID, CommFunction.GSYSNAME, sender, CommFunction.ConnectString)) return; if ((tbUnid.Text.Trim() == "") || tbUnid.Text == null) { return; } LYFunctionCs.frmReportView frv = new LYFunctionCs.frmReportView(); ReportDocument Rpt = new ReportDocument(); string pRptNmae = ""; pRptNmae = LYFunctionCs.LYFunctionCsClass.cmdScalar("select cm.report_file from cc_cold_chain_c cc left join cc_cold_chain_z cz on cc.pkunid=cz.unid left join cc_item_master cm on cc.size_desc=cm.size_desc and cm.season=cz.season where pkunid='" + tbUnid.Text + "' and cm.report_file is not null and rownum=1 ", CommFunction.ConnectString); if ((pRptNmae.Trim() == "") || (pRptNmae == null)) pRptNmae = "Rep_CC_ITEM_TRACK.rpt"; Rpt.Load(AppDomain.CurrentDomain.SetupInformation.ApplicationBase + pRptNmae); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = CommFunction.cfServerName; logOnInfo.ConnectionInfo.UserID = CommFunction.cfUserID; logOnInfo.ConnectionInfo.Password = CommFunction.cfPassword; Rpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo); //Rpt.Refresh(); frv.crystalReportViewer1.ReportSource = Rpt; CrystalDecisions.Shared.ParameterValues mypaVal = new CrystalDecisions.Shared.ParameterValues(); CrystalDecisions.Shared.ParameterDiscreteValue mypaDVal = new CrystalDecisions.Shared.ParameterDiscreteValue(); mypaDVal.Value = tbUnid.Text; mypaVal.Add(mypaDVal); Rpt.DataDefinition.ParameterFields["GZBDH"].ApplyCurrentValues(mypaVal); frv.ShowDialog(); LYFunctionCs.LYFunctionCsClass.cmd("update cc_cold_chain_z set ifprint='1' where UNID='"+tbUnid.Text+"'", CommFunction.ConnectString); }