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