/// <summary> /// 判断巷道是否属于回采面 /// </summary> /// <param name="tunnelType"></param> /// <returns></returns> public static bool IsStoping(TunnelTypeEnum tunnelType) { return(tunnelType == TunnelTypeEnum.STOPING_FY || tunnelType == TunnelTypeEnum.STOPING_ZY || tunnelType == TunnelTypeEnum.STOPING_QY || tunnelType == TunnelTypeEnum.STOPING_OTHER); }
public static Tunnel[] FindAllByTunnelType(TunnelTypeEnum tunnelType) { var criterion = new ICriterion[] { Restrictions.Eq("TunnelType", tunnelType) }; return(FindAll(criterion)); }
/// <summary> /// 根据tunelID,查找巷道名称。若属于回采巷道,返回工作面名称 /// </summary> /// <param name="tunelId"></param> /// <returns></returns> public static void loadTunnelNames() { tunnelNames.Clear(); string sSql = "SELECT A." + TunnelInfoDbConstNames.ID + " , A." + TunnelInfoDbConstNames.TUNNEL_NAME + " , B." + WorkingFaceDbConstNames.WORKINGFACE_NAME + " , A." + TunnelInfoDbConstNames.TUNNEL_TYPE + " FROM " + TunnelInfoDbConstNames.TABLE_NAME + " AS A, " + WorkingFaceDbConstNames.TABLE_NAME + " AS B " + "WHERE A." + TunnelInfoDbConstNames.WORKINGFACE_ID + "= B." + WorkingFaceDbConstNames.WORKINGFACE_ID; ManageDataBase db = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); DataSet ds = db.ReturnDS(sSql); DataTable dtWF = ds.Tables[0]; foreach (DataRow dr in dtWF.Rows) { TunnelTypeEnum tunnelType = (TunnelTypeEnum)Convert.ToInt32(dr[TunnelInfoDbConstNames.TUNNEL_TYPE]); try { if (!TunnelUtils.IsStoping(tunnelType)) { tunnelNames.Add(dr[TunnelInfoDbConstNames.ID], dr[WorkingFaceDbConstNames.WORKINGFACE_NAME]); } else { tunnelNames.Add(dr[TunnelInfoDbConstNames.ID], dr[WorkingFaceDbConstNames.WORKINGFACE_NAME].ToString() + " - " + dr[TunnelInfoDbConstNames.TUNNEL_NAME].ToString()); } } catch (Exception ex) { Log.Error(ex.ToString()); } } }