產品毛利排行榜報表:在A子公司查詢時,會帶出在B子公司的商品(商品是各子公司自行設定)
select * from Systems where i_system = 'A00000000003'
select * from PubFunction where i_system = 'A00000000019'
select * from PubFunction where i_functionName like '%產品毛利排行榜%'
select * from PubFunction where i_functionNameMap like '%TFormBatchApmStrOu%'
cost
TFormReportCostItemProfit
void TFormReportCostItemProfit::PutDataToUI()
.......
" left join Item on Item.i_item = v_CostItemCostProfitDetail.i_item "
" WHERE Item.i_company = '" + GetCompanyPK() + "' "
沒有留言:
張貼留言