| | |
| | | m.list2 = new List<dynamic>(); |
| | | System.Text.StringBuilder sb = new StringBuilder(); |
| | | sb.Append("select * from MES_QA_ITEMS_DETECT_DETAIL12 where parent_guid='" + guid + "' order by fstand asc"); |
| | | sb.Append(" select d13.*,d5.fcheck_item as fcheckItemd5,d5.ybsl from MES_QA_ITEMS_DETECT_DETAIL13 d13 left join[dbo].[MES_QA_ITEMS_DETECT_DETAIL5] d5 on d13.parent_guid = d5.guid"); |
| | | sb.Append(" where d13.parent_guid = '" + guid + "'"); |
| | | sb.Append(" order by d13.fcheck_item asc"); |
| | | sb.Append("select d13.*,d5.fcheck_item as fcheckItemd5,d5.ybsl from MES_QA_ITEMS_DETECT_DETAIL13 d13 left join[dbo].[MES_QA_ITEMS_DETECT_DETAIL5] d5 on d13.parent_guid = d5.guid"); |
| | | sb.Append("where d13.parent_guid = '" + guid + "'"); |
| | | sb.Append("order by d13.fcheck_item asc"); |
| | | try |
| | | { |
| | | DataSet dset = new DataSet(); |