/// <summary> /// 按小时查询设备效率比例值 /// </summary> /// <param name="StartTime"></param> /// <param name="EndTime"></param> /// <returns></returns> public DataTable QueryEquipmentPerformancebyHour(DateTime StartTime, DateTime EndTime) { // 查询设备ID string SQL = "SELECT DISTINCT B.ID FROM TB_QMS_ProgramList A,TB_Assembly_Builder B " + "WHERE A.Code ='" + this.programName + "' AND B.Code =SUBSTRING(A.Name,0, CHARINDEX('---',A.Name)) " + "AND B.IsEnable =1 AND B.ModuleID ='e42e041b-12a5-4b92-b8c1-257a2adb2e63'"; DataTable dt = CDBConnection._GetGrdInfo(SQL); string EquipmentID = dt.Rows[0][0].ToString(); SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@startTime", StartTime), new SqlParameter("@endTime", EndTime), new SqlParameter("@equipmentId ", EquipmentID) }; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataSet(CDBConnection._GetDBConn(), CommandType.StoredProcedure, "status_min_proportion_byHour", parameter); return(ds.Tables[0]); }