| | |
| | | public string? id { get; set; } |
| | | |
| | | public string? SearchValue { get; set; } |
| | | public string? statusUser { get; set; } //用户编码 |
| | | } |
| | |
| | | |
| | | var query = db |
| | | .Queryable<QsQaItemXj, Womdaa, MesLine, |
| | | MesItems, SysUser,Womcaa>((s, a, c, b, us,ca) => |
| | | MesItems, SysUser,Womcaa,SysDepartment>((s, a, c, b, us,ca,d) => |
| | | new JoinQueryInfos( |
| | | JoinType.Inner, s.BillNo == a.Daa001, |
| | | JoinType.Left, a.Daa015 == c.LineNo, |
| | | JoinType.Left, s.ItemId == b.Id, |
| | | JoinType.Left, us.Fcode == s.CreateBy, |
| | | JoinType.Left, ca.Caa020 == a.Daa021 |
| | | JoinType.Left, ca.Caa020 == a.Daa021, |
| | | JoinType.Left, d.Departmentcode == c.Departmentcode |
| | | ) |
| | | ) |
| | | //.WhereIF(lineNo != null && lineNo.Length > 0, |
| | |
| | | }); |
| | | } |
| | | } |
| | | //RetrieveDrawings 调取图纸 |
| | | [HttpGet("OpenDrawingsGet")] |
| | | public IActionResult OpenDrawingsGet(string fileId, string fName) |
| | | { |
| | | try |
| | | { |
| | | var resultInfos = wdd.SendRequest("Download", fileId); |
| | | |
| | | return File(resultInfos, "application/octet-stream", fName); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return StatusCode(500, new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = null |
| | | }); |
| | | } |
| | | } |
| | | } |