| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 设备节拍根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetEqiupMaterWorkTimeDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetEqiupMaterWorkTimeDb(HID); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "不存在设备节拍数据" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; |
| | | } |
| | | public static DataSet GetEqiupMaterWorkTimeDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EqiupMaterWorkTimes where HItemID= " + HID + " ", "h_v_Sb_EqiupMaterWorkTimes"); |
| | | return dataSet; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 管径根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_PiPeDetail(string HID) |