| | |
|---|
| | | m.list = new List<dynamic>(); |
|---|
| | | m.list2 = new List<dynamic>(); |
|---|
| | | StringBuilder sb = new StringBuilder(); |
|---|
| | | sb.Append("select * from MES_QA_ITEMS_DETECT_DETAIL12 where parent_guid='" + guid + "' order by fstand asc"); |
|---|
| | | sb.Append("select * ,cj.USER_NAME as createByName " + |
|---|
| | | " from MES_QA_ITEMS_DETECT_DETAIL12 a " + |
|---|
| | | " left join SYS_USER cj on cj.ACCOUNT=a.create_by " + |
|---|
| | | " 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"); |
|---|
