1

builder.AppendLine(" INSERT /*+append*/ INTO {0} (FPRODUCTID,FCOMPLETEHOUR,FCOMPLETEQTY,FISCURPERIOD) \n");
builder.AppendLine(" select TMP.FPRODUCTID,SUM(TMP.FCOMPLETEHOUR) AS FCOMPLETEHOUR,SUM(TMP.FCOMPLETEQTY) AS FCOMPLETEQTY,{1} AS FISCURPERIOD \n");
builder.AppendFormat(" FROM ( \n", new object[0]);
builder.AppendFormat(" select productDime.FPRODUCTID,0 AS FCOMPLETEHOUR, \n", new object[0]);
builder.AppendFormat(" SUM(masResult.FQUALIFIEDINQTY)+SUM(masResult.FDYSINQTY)+SUM(masResult.FWASTEINQTY) AS FCOMPLETEQTY \n", new object[0]);
builder.AppendFormat(" FROM V_CB_PROORDERINFO product \n", new object[0]);
builder.AppendFormat(" INNER JOIN V_CB_CostCalExpense masResult ON product.FID = masResult.FID \n", new object[0]);
builder.AppendFormat(" INNER JOIN T_CB_PROORDERDIME productDime ON product.FProductDimeId = productDime.FProductDimeId \n", new object[0]);
builder.AppendFormat(" INNER JOIN T_HS_OUTACCTG acctg ON product.FACCTGID = acctg.FId \n", new object[0]);
builder.AppendFormat(" {0} ", this.GetCurrFilterString());
builder.AppendFormat(" group by productDime.FPRODUCTID \n", new object[0]);
builder.AppendFormat(" UNION ALL \n", new object[0]);
builder.AppendFormat(" select productDime.FPRODUCTID,SUM(masResult.FCURRINPUTQTY) AS FCOMPLETEHOUR,0 AS FCOMPLETEQTY \n", new object[0]);
builder.AppendFormat(" FROM V_CB_PROORDERINFO product \n", new object[0]);
builder.AppendFormat(" INNER JOIN V_CB_CostMatterial masResult ON product.FID = masResult.FID \n", new object[0]);
builder.AppendFormat(" INNER JOIN T_CB_PROORDERDIME productDime ON product.FProductDimeId = productDime.FProductDimeId \n", new object[0]);
builder.AppendFormat(" INNER JOIN T_HS_OUTACCTG acctg ON product.FACCTGID = acctg.FId \n", new object[0]);
builder.AppendFormat(" {0} ", this.GetDiffFilterString());
builder.AppendFormat(" AND masResult.FEXPTYPE='{0}' \n", 9);
builder.AppendFormat(" group by productDime.FPRODUCTID) TMP \n", new object[0]);
builder.AppendFormat(" group by TMP.FPRODUCTID \n", new object[0]);
List paramList = new List {