| | |
| | | m.list = new List<dynamic>(); |
| | | 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 * ,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"); |
| | |
| | | public ReturnDto<string> EditModel([FromBody] dynamic model) |
| | | { |
| | | Guid? guid = model.guid; //到货单主键 |
| | | string fngDesc = model.fngDesc; //备注 |
| | | string fngDesc = model.fngDesc; //异常描述 |
| | | string iqcRemark = model.iqcRemark; |
| | | string ckId=model.ckId; |
| | | string iqcXblb = model.iqcXblb; |
| | | var _outMsg = ""; |
| | | var _outSum = -1; |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | |
| | | new("@inEdtUserGuid", _userGuid), |
| | | new("@inOrderGuid", UtilityHelper.CheckGuid(guid) ? guid: DBNull.Value), |
| | | new("@fngDesc", fngDesc), |
| | | new("@ckId", ckId), |
| | | new("@iqcRemark", iqcRemark), |
| | | new("@iqcXblb", iqcXblb), |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |
| | | parameters[1].Direction = ParameterDirection.Output; |