前臺代碼：
<DataGridTextColumn Header="源工單號" Binding="{Binding SourceWorkOrder}" Width="Auto" IsReadOnly="True"/>
<DataGridTextColumn Header="合并源工單" Binding="{Binding ConsolidationSourceWorkOrder }" Width="Auto" IsReadOnly="True"/>
代碼后臺：
var result = await executeHelper.SearchAsync<string>("SELECT STUFF(( SELECT ',' + SRC_ORDER FROM V_MFT_APSProductionOrder where PATINDEX('%,' + RTRIM(PO_ID) + ',%', ',' + a.ERPWorkOrder + ',') > 0 ORDER BY PATINDEX('%,' + RTRIM(PO_ID) + ',%', ',' + a.ERPWorkOrder + ',') FOR XML PATH('')), 1, 1,'') as ConsolidationSourceWorkOrder FROM(select distinct stuff((select ',' +ERPWorkOrder from V_MFT_SizingInfo where MatId = a.MatId for xml path('')),1,1,'') as ERPWorkOrder from V_MFT_SizingInfo as a where a.MatId = '" + workOrderInfo.MATID + "') AS a", new Dictionary<string, object>());
workOrderInfo.ConsolidationSourceWorkOrder = result.FirstOrDefault();
//*/
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/56909.html
標籤：C#
上一篇：使用DataList.DataSource獲取資料出現這種問題，求大佬說一下解決的方法
下一篇：路過的大神，幫忙看看