/// <summary>
/// 获取班次中的时间范围，返回值例：起始时间2014-03-18 08:00:00.000，结束时间2014-03-18 16:00:00.000
/// </summary>
/// <param name="strWorkTimeName"></param>
/// <param name="strDate"></param>
/// <returns></returns>
//public static string[] GetDateShiftTimes(string strWorkTimeName, string strDate)
//{
// //select WORK_TIME_FROM,WORK_TIME_TO from T_WORK_TIME where WORK_TIME_NAME ='早班'
// string[] times = null;
// StringBuilder strSql = new StringBuilder();
// strSql.Append("SELECT ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_FROM + ",");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_TO);
// strSql.Append(" FROM ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.TABLE_NAME);
// strSql.Append(" WHERE ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_NAME);
// strSql.Append(" = ");
// strSql.Append("'" + strWorkTimeName + "'");
// DataSet ds = _database.ReturnDSNotOpenAndClose(strSql.ToString());
// if (ds != null)
// {
// DataTable dt = ds.Tables[0];
// if (dt != null)
// {
// //2014-03-05 15:43:45.000
// if (dt.Rows.Count > 0)
// {
// times = new string[2];
// times[0] = strDate + " " + dt.Rows[0][LibBusiness.WorkTimeDbConstNames.WORK_TIME_FROM].ToString();
// times[1] = strDate + " " + dt.Rows[0][LibBusiness.WorkTimeDbConstNames.WORK_TIME_TO].ToString();
// }
// }
// }
// return times;
//}
/// <summary>
/// 根据tunelID,查找巷道名称。若属于回采巷道，返回工作面名称
/// </summary>
/// <param name="tunelId"></param>
/// <returns></returns>
public static string GetTunelNameByTunelID(string tunelId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
strSql.Append(TunnelInfoDbConstNames.TUNNEL_NAME + ",");
strSql.Append(TunnelInfoDbConstNames.TUNNEL_TYPE + ",");
strSql.Append(TunnelInfoDbConstNames.WORKINGFACE_ID);
strSql.Append(" FROM ");
strSql.Append(TunnelInfoDbConstNames.TABLE_NAME);
strSql.Append(" WHERE ");
strSql.Append(TunnelInfoDbConstNames.ID);
strSql.Append(" = ");
strSql.Append(tunelId);
DataTable dt =
_database.ReturnDSNotOpenAndClose(strSql.ToString()).Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
//判断是否属于回采巷道
if
(TunnelUtils.IsStoping((TunnelTypeEnum)Convert.ToInt32(dt.Rows[0][LibBusiness.TunnelInfoDbConstNames.TUNNEL_TYPE])))
{
//获取工作面名称
int workFaceId;
int.TryParse(dt.Rows[0][TunnelInfoDbConstNames.WORKINGFACE_ID].ToString(),
out workFaceId);
WorkingFace workingFace =
WorkingFace.Find(workFaceId);
if (workingFace != null)
{
return(workingFace.WorkingFaceName);
}
}
else
{
return
(dt.Rows[0][LibBusiness.TunnelInfoDbConstNames.TUNNEL_NAME].ToString());
}
}
}
return("");
}
/// <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());
}
}
}