/// <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]);
}
