private void toolStripLabelPrint_Click(object sender, EventArgs e) { if (DgvHead.Rows.Count <= 0) return; if (DgvHead.SelectedRows.Count != 1) return; string TransferMoneyNo = DgvHead.SelectedRows[0].Cells["TransferMoneyNo"].Value.ToString(); string sql = "SELECT * \n" + "FROM ProductionTransferMoneyHead pth \n" + "INNER JOIN ProductionTransferMoneyDetail ptd ON pth.TransferMoneyNo = ptd.TransferMoneyNo \n" + "INNER JOIN EMPLOYER e ON pth.EmployerId = e.EmployerId \n" + "INNER JOIN ProductionPrisonWage ppw ON ptd.PwId = ppw.PwId \n" + "INNER JOIN UserLogin u ON pth.UserName = u.UserName where pth.TransferMoneyNo = '" + TransferMoneyNo + "'"; DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql); data.TableName = "TransferMoneyToJ"; Report.Production.CtrTransferMoneyJ j = new Report.Production.CtrTransferMoneyJ(); j.SetDataSource(data); j.SetParameterValue("Company", Class.DBConnString.sDb); RptProductionReq CtrV = new RptProductionReq(j); CtrV.StartPosition = FormStartPosition.CenterParent; CtrV.ShowDialog(); }
private void showReport(string strTranfNo) { string sql = "SELECT * \n" + "FROM ProductionTransferMoneyHead pth \n" + "INNER JOIN ProductionTransferMoneyDetail ptd ON pth.TransferMoneyNo = ptd.TransferMoneyNo \n" + "INNER JOIN EMPLOYER e ON pth.EmployerId = e.EmployerId \n" + "INNER JOIN ProductionPrisonWage ppw ON ptd.PwId = ppw.PwId \n" + "INNER JOIN UserLogin u ON pth.UserName = u.UserName where pth.TransferMoneyNo = '" + strTranfNo + "'"; DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql); data.TableName = "TransferMoneyToJ"; Report.Production.CtrTransferMoneyJ j = new Report.Production.CtrTransferMoneyJ(); j.SetDataSource(data); j.SetParameterValue("Company", DBConnString.sDb); RptProductionReq CtrV = new RptProductionReq(j); CtrV.StartPosition = FormStartPosition.CenterParent; CtrV.ShowDialog(); }