public void rmReport()
{
string planningDate = dateTimePickerHead.Value.ToString("yyyyMMdd");
productCategory = cmbProductGroup.Text.Substring(3, 10);
rptViewer rptViewer = new rptViewer();
DataSet dsGeneral = new DataSet();
RMTransfer objRpt = new RMTransfer();
//rptRM objRpt = new rptRM();
string strSql = "select * from RM_View where trandate='" + planningDate + "' and category='" + productCategory + "'";
dsGeneral = dataProvider.getDataSet(strSql, "RM_View", "TCPL");
objRpt.SetDataSource(dsGeneral);
objRpt.VerifyDatabase();
rptViewer.crystalReportViewer.ReportSource = objRpt;
rptViewer.Refresh();
rptViewer.Show();
}
public void rmReport()
{
string planningDate = dateTimePickerHead.Value.ToString("yyyyMMdd");
productCategory = cmbProductGroup.Text.Substring(3, 10);
rptViewer rptViewer = new rptViewer();
DataSet dsGeneral = new DataSet();
RMTransfer objRpt = new RMTransfer();
//string strSql = "select * from RM_View where trandate='" + planningDate + "' and category='" + productCategory + "'";
string strSql = "select *, ISNULL((select sum(extcost) from ICADED where ITEMNO = T_PCTRN.ITEMNO " +
"and rtrim(MANITEMNO) = T_PCTRN.TRANDATE and COMMENTS = 'RMT-" + productCategory + "'),'0') " +
"as TRANCOST, ISNULL((select sum(extcost) from ICADED where ITEMNO = T_PCTRN.ITEMNO and rtrim(MANITEMNO) = T_PCTRN.TRANDATE and COMMENTS = 'RMR-" + productCategory + "'),'0') " +
"as RTNCOST from T_PCTRN where TRANDATE = '" + planningDate + "' and ITEMTYPE = 'RM' and ITEMNO <> '15502-05' AND CATEGORY = '" + productCategory + "' ORDER BY ITEMNO";
//dsGeneral = dataProvider.getDataSet(strSql, "RM_View", "TCPL");
dsGeneral = dataProvider.getDataSet(strSql, "T_PCTRN", "TCPL");
objRpt.SetDataSource(dsGeneral);
objRpt.VerifyDatabase();
rptViewer.crystalReportViewer.ReportSource = objRpt;
rptViewer.Refresh();
rptViewer.Show();
}
