| | |
| | | var sqlParams = new List<SugarParameter> { }; |
| | | |
| | | var sql2 = new StringBuilder(@" |
| | | SELECT NAME,line_no FROM MES_WORKSHOP_LINE WHERE isAgv = 1 ORDER BY line_no"); |
| | | SELECT NAME,line_no,agvPostion FROM MES_WORKSHOP_LINE WHERE isAgv = 1 ORDER BY line_no"); |
| | | |
| | | |
| | | var XtItem = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams); |
| | |
| | | { |
| | | new("@pi_user", SqlDbType.NVarChar, 100) { Value = query.userAccount }, |
| | | new("@pi_xtNum", SqlDbType.NVarChar, 100) { Value = query.XtNum }, |
| | | new("@in1", SqlDbType.NVarChar, 100) { Value = query.AgvDw }, |
| | | new("@outMsg", SqlDbType.NVarChar, 2500) { Direction = ParameterDirection.Output }, |
| | | new("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output } |
| | | }; |