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