| | |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据设备带出项目 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetItemByEquipFile")] |
| | | [HttpGet] |
| | | public object GetItemByEquipFile(int EquipProjectID,string Type) |
| | | { |
| | | if (EquipProjectID <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "产品器具未选择"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | try |
| | | { |
| | | string HView = ""; |
| | | switch (Type) |
| | | { |
| | | case "DJ": |
| | | HView = "h_v_Sb_GetDotCheckItemList"; |
| | | break; |
| | | case "BY": |
| | | HView = "h_v_Sb_GetMaintainItemList"; |
| | | break; |
| | | default: |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "设备模块类型错误!"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID); |
| | | ds = oCN.RunProcReturn(sql, HView); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败,查无数据" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 查询各类设备单据列表(设备点检,设备维修,设备保养......) |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetEquipmentBillsList")] |
| | | [HttpGet] |
| | | public object GetEquipmentBillsList(string sWhere, string Type) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | string HView = ""; |
| | | switch (Type) |
| | | { |
| | | case "DJ": |
| | | HView = "h_v_Sb_EquipDotCheckBillList"; |
| | | break; |
| | | case "BY": |
| | | HView = "h_v_Sb_EquipMaintainBillList"; |
| | | break; |
| | | case "WX": |
| | | HView = "h_v_Sb_EquipRepairCheckBillList"; |
| | | break; |
| | | default: |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "设备模块类型错误!"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql = string.Format(@"select * from " + HView + " where 1 = 1 "); |
| | | ds = oCN.RunProcReturn(sql, HView); |
| | | //添加列名 |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败,查无数据" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | objjson.list = columnNameList; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | objjson.list = columnNameList; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据设备点检规程显示设备点检程项目 |
| | | /// </summary> |