/// <summary>
/// 插入掘进巷道数据
/// </summary>
/// <returns></returns>
public static bool insertTunnelHChuan(TunnelHChuanEntity tunnelHChuanEntity)
{
ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB);
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO " + TunnelHChuanDbConstNames.TABLE_NAME + " (" + TunnelHChuanDbConstNames.TUNNEL_ID1 + "," + TunnelHChuanDbConstNames.TUNNEL_ID2 + "," + TunnelHChuanDbConstNames.TUNNEL_X1 + ","
+ TunnelHChuanDbConstNames.TUNNEL_Y1 + "," + TunnelHChuanDbConstNames.TUNNEL_Z1 + "," + TunnelHChuanDbConstNames.TUNNEL_X2 + "," + TunnelHChuanDbConstNames.TUNNEL_Y2 + "," + TunnelHChuanDbConstNames.TUNNEL_Z2 + ","
+ TunnelHChuanDbConstNames.TUNNEL_AZIMUTH + "," + TunnelHCDbConstNames.TEAM_NAME_ID + "," + TunnelHCDbConstNames.START_DATE + "," + TunnelHCDbConstNames.IS_FINISH + ","
+ TunnelHCDbConstNames.STOP_DATE + "," + TunnelHCDbConstNames.WORK_STYLE + "," + TunnelHCDbConstNames.WORK_TIME + "," + TunnelHChuanDbConstNames.TUNNEL_STATE + ") VALUES(");
sb.Append(tunnelHChuanEntity.TunnelID1 + ",");
sb.Append(tunnelHChuanEntity.TunnelID2 + ",");
sb.Append(tunnelHChuanEntity.X_1 + ",");
sb.Append(tunnelHChuanEntity.Y_1 + ",");
sb.Append(tunnelHChuanEntity.Z_1 + ",");
sb.Append(tunnelHChuanEntity.X_2 + ",");
sb.Append(tunnelHChuanEntity.Y_2 + ",");
sb.Append(tunnelHChuanEntity.Z_2 + ",");
sb.Append(tunnelHChuanEntity.Azimuth + ",");
sb.Append(tunnelHChuanEntity.TeamNameID + ",'");
sb.Append(tunnelHChuanEntity.StartDate + "',");
sb.Append(tunnelHChuanEntity.IsFinish + ",'");
sb.Append(tunnelHChuanEntity.StopDate + "','");
sb.Append(tunnelHChuanEntity.WorkStyle + "','");
sb.Append(tunnelHChuanEntity.WorkTime + "','");
sb.Append(tunnelHChuanEntity.State + "')");
bool bResult = db.OperateDB(sb.ToString());
//setTunnelAsHChuan(tunnelHChuanEntity.TunnelID1);
//setTunnelAsHChuan(tunnelHChuanEntity.TunnelID2);
return(bResult);
}
private static void clearTunnelTypeOfHChuan(int tunnelHChuanID)
{
TunnelHChuanEntity tunnelHChuanEntity = selectTunnelHChuan(tunnelHChuanID);
if (tunnelHChuanEntity != null)
{
TunnelInfoBLL.clearTunnelType(tunnelHChuanEntity.TunnelID1);
TunnelInfoBLL.clearTunnelType(tunnelHChuanEntity.TunnelID2);
}
}
/// <summary>
/// 删除回采巷道数据
/// </summary>
/// <returns></returns>
public static bool deleteTunnelHChuan(TunnelHChuanEntity tunnelHChuanEntity)
{
ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB);
string sql = "DELETE FROM " + TunnelHChuanDbConstNames.TABLE_NAME + " WHERE " + TunnelHChuanDbConstNames.ID + " = " + tunnelHChuanEntity.ID;
bool bResult = db.OperateDB(sql);
if (bResult)
{
clearTunnelTypeOfHChuan(tunnelHChuanEntity.ID);
}
return(bResult);
}
private static TunnelHChuanEntity selectTunnelHChuan(int tunnelHChuanID)
{
ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB);
string sql = "SELECT * FROM " + TunnelHChuanDbConstNames.TABLE_NAME + " WHERE " + TunnelHChuanDbConstNames.ID + " = " + tunnelHChuanID;
DataSet ds = db.ReturnDS(sql);
TunnelHChuanEntity tunnelHChuanEntity = new TunnelHChuanEntity();
if (ds.Tables[0].Rows.Count > 0)
{
try
{
tunnelHChuanEntity.ID = (int)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.ID];
tunnelHChuanEntity.TunnelID1 = (int)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_ID1];
tunnelHChuanEntity.TunnelID2 = (int)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_ID2];
tunnelHChuanEntity.X_1 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_X1];
tunnelHChuanEntity.Y_1 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_Y1];
tunnelHChuanEntity.Z_1 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_Z1];
tunnelHChuanEntity.X_2 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_X2];
tunnelHChuanEntity.Y_2 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_Y2];
tunnelHChuanEntity.Z_2 = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_Z2];
tunnelHChuanEntity.Azimuth = (double)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_AZIMUTH];
tunnelHChuanEntity.TeamNameID = (int)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TEAM_NAME_ID];
tunnelHChuanEntity.StartDate = Convert.ToDateTime(ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.START_DATE]);
tunnelHChuanEntity.IsFinish = (int)ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.IS_FINISH];
tunnelHChuanEntity.StopDate = Convert.ToDateTime(ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.STOP_DATE]);
tunnelHChuanEntity.WorkStyle = ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.WORK_STYLE].ToString();
tunnelHChuanEntity.WorkTime = ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.WORK_TIME].ToString();
tunnelHChuanEntity.State = ds.Tables[0].Rows[0][TunnelHChuanDbConstNames.TUNNEL_STATE].ToString();
}
catch
{
return(null);
}
}
else
{
return(null);
}
return(tunnelHChuanEntity);
}
