Exemple #1
0
        public void SetOilToDB(Oil obj)
        {
            string sql = "insert into oil_2 " +
                         "(DateTime,Time,WellDep,HangDownDeep,DepthOfTheDrillBit," +
                         "DrillDownDeep,DrillingTime,BitPressure,HangingLoad,RotationRate,Torque,KellyDown," +
                         "HookPosition,HookSpeed,StandpipePressurelog,CasingPressure,PumpStroke1,PumpStroke2," +
                         "PumpStroke3,TotalPoolSize,LayTime,MudSpill,InletFlowlog,OutletFlowlog,InletDensitylog," +
                         "OutletDensitylog,EntranceTempreture,ExitTempreture,TotalHydrocarbon,H2S,C1,C2,PWDDepth," +
                         "PWDHangDownDeep,PWD_zzyl,PWD_hkyl,PWD_hkwd,PWD_cl_ECD,PWDWellDeviation,PWDLocation,qztj," +
                         "UpturnDepth,OperatorSchema,StandpipePressure,MeasurementOfBackPressure,OutletFlow,OutletDensity," +
                         "BackPressurePumpFlow,LoopBackPressure,AdditionalBackPressure,InletFlow,FixDepth,FixPointDownDeep," +
                         "FixPointPressure,WellMouthAdjustment,FixPointPressureLoss,BoDongYL,YaHaoXZ,QiXiaZuanSD," +
                         "QiXiaZuanJSD,FixPointECD,DrillECD,DrillStringPressureDrop,DrillBitPressureDrop,EnvironmentalControlPressureLoss," +
                         "TargetBackPressure,HydrostaticPressure,State_1,State_2) " +
                         " values( '" + obj.getDateTime() + "'," + obj.getTime() + "," + obj.getWellDep() + "," + obj.getHangDownDeep() + "," + obj.getDepthOfTheDrillBit() + "," +
                         obj.getDrillDownDeep() + "," + obj.getDrillingTime() + "," + obj.getBitPressure() + "," + obj.getHangingLoad() + "," + obj.getRotationRate() + "," +
                         obj.getTorque() + "," + obj.getKellyDown() + "," + obj.getHookPosition() + "," + obj.getHookSpeed() + "," + obj.getStandpipePressurelog() + "," +
                         obj.getCasingPressure() + "," + obj.getPumpStroke1() + "," + obj.getPumpStroke2() + "," + obj.getPumpStroke3() + "," + obj.getTotalPoolSize() + "," +
                         obj.getLayTime() + "," + obj.getMudSpill() + "," + obj.getInletFlowlog() + "," + obj.getOutletFlowlog() + "," + obj.getInletDensitylog() + "," +
                         obj.getOutletDensitylog() + "," + obj.getEntranceTempreture() + "," + obj.getExitTempreture() + "," + obj.getTotalHydrocarbon() + "," + obj.getH2S() + "," +
                         obj.getC1() + "," + obj.getC2() + "," + obj.getPWDDepth() + "," + obj.getPWDHangDownDeep() + "," + obj.getPWD_zzyl() + "," +
                         obj.getPWD_hkyl() + "," + obj.getPWD_hkwd() + "," + obj.getPWD_cl_ECD() + "," + obj.getPWDWellDeviation() + "," + obj.getPWDLocation() + "," +
                         obj.getQztj() + "," + obj.getUpturnDepth() + "," + obj.getOperatorSchema() + "," + obj.getStandpipePressure() + "," + obj.getMeasurementOfBackPressure() + "," +
                         obj.getOutletFlow() + "," + obj.getOutletDensity() + "," + obj.getBackPressurePumpFlow() + "," + obj.getLoopBackPressure() + "," + obj.getAdditionalBackPressure() + "," +
                         obj.getInletFlow() + "," + obj.getFixDepth() + "," + obj.getFixPointDownDeep() + "," + obj.getFixPointPressure() + "," + obj.getWellMouthAdjustment() + "," +
                         obj.getFixPointPressureLoss() + "," + obj.getBoDongYL() + "," + obj.getYaHaoXZ() + "," + obj.getQiXiaZuanSD() + "," + obj.getQiXiaZuanJSD() + "," +
                         obj.getFixPointECD() + "," + obj.getDrillECD() + "," + obj.getDrillStringPressureDrop() + "," + obj.getDrillBitPressureDrop() + "," + obj.getEnvironmentalControlPressureLoss() + "," +
                         obj.getTargetBackPressure() + "," + obj.getHydrostaticPressure() + "," + obj.getState_1() + "," + obj.getState_2() + ")";

            MySqlCommand cmd = new MySqlCommand(sql, mc);

            cmd.ExecuteNonQuery();
        }
Exemple #2
0
        public Oil GetOilFromDB(int id)
        {
            string sql = "SELECT id,DateTime,Time,WellDep,HangDownDeep,DepthOfTheDrillBit," +
                         "DrillDownDeep,DrillingTime,BitPressure,HangingLoad,RotationRate,Torque,KellyDown," +
                         "HookPosition,HookSpeed,StandpipePressurelog,CasingPressure,PumpStroke1,PumpStroke2," +
                         "PumpStroke3,TotalPoolSize,LayTime,MudSpill,InletFlowlog,OutletFlowlog,InletDensitylog," +
                         "OutletDensitylog,EntranceTempreture,ExitTempreture,TotalHydrocarbon,H2S,C1,C2,PWDDepth," +
                         "PWDHangDownDeep,PWD_zzyl,PWD_hkyl,PWD_hkwd,PWD_cl_ECD,PWDWellDeviation,PWDLocation,qztj," +
                         "UpturnDepth,OperatorSchema,StandpipePressure,MeasurementOfBackPressure,OutletFlow,OutletDensity," +
                         "BackPressurePumpFlow,LoopBackPressure,AdditionalBackPressure,InletFlow,FixDepth,FixPointDownDeep," +
                         "FixPointPressure,WellMouthAdjustment,FixPointPressureLoss,BoDongYL,YaHaoXZ,QiXiaZuanSD," +
                         "QiXiaZuanJSD,FixPointECD,DrillECD,DrillStringPressureDrop,DrillBitPressureDrop,EnvironmentalControlPressureLoss," +
                         "TargetBackPressure,HydrostaticPressure,State_1,State_2 from oil_2 where id = " + id;
            MySqlCommand cmd = new MySqlCommand(sql, mc);

            MySqlDataReader rdr = cmd.ExecuteReader();
            Oil             obj = new Oil();

            while (rdr.Read())
            {
                obj.setDateTime((String)rdr[1]);
                obj.setTime((Double)rdr[2]);
                obj.setWellDep((Double)rdr[3]);
                obj.setHangDownDeep((Double)rdr[4]);
                obj.setDepthOfTheDrillBit((Double)rdr[5]);
                obj.setDrillDownDeep((Double)rdr[6]);
                obj.setDrillingTime((Double)rdr[7]);
                obj.setBitPressure((Double)rdr[8]);
                obj.setHangingLoad((Double)rdr[9]);
                obj.setRotationRate((Double)rdr[10]);
                obj.setTorque((Double)rdr[11]);
                obj.setKellyDown((Double)rdr[12]);
                obj.setHookPosition((Double)rdr[13]);
                obj.setHookSpeed((Double)rdr[14]);
                obj.setStandpipePressurelog((Double)rdr[15]);
                obj.setCasingPressure((Double)rdr[16]);
                obj.setPumpStroke1((Double)rdr[17]);
                obj.setPumpStroke2((Double)rdr[18]);
                obj.setPumpStroke3((Double)rdr[19]);
                obj.setTotalPoolSize((Double)rdr[20]);
                obj.setLayTime((Double)rdr[21]);
                obj.setMudSpill((Double)rdr[22]);
                obj.setInletFlowlog((Double)rdr[23]);
                obj.setOutletFlowlog((Double)rdr[24]);
                obj.setInletDensitylog((Double)rdr[25]);
                obj.setOutletDensitylog((Double)rdr[26]);
                obj.setEntranceTempreture((Double)rdr[27]);
                obj.setExitTempreture((Double)rdr[28]);
                obj.setTotalHydrocarbon((Double)rdr[29]);
                obj.setH2S((Double)rdr[30]);
                obj.setC1((Double)rdr[31]);
                obj.setC2((Double)rdr[32]);
                obj.setPWDDepth((Double)rdr[33]);
                obj.setPWDHangDownDeep((Double)rdr[34]);
                obj.setPWD_zzyl((Double)rdr[35]);
                obj.setPWD_hkyl((Double)rdr[36]);
                obj.setPWD_hkwd((Double)rdr[37]);
                obj.setPWD_cl_ECD((Double)rdr[38]);
                obj.setPWDWellDeviation((Double)rdr[39]);
                obj.setPWDLocation((Double)rdr[40]);
                obj.setQztj((Double)rdr[41]);
                obj.setUpturnDepth((Double)rdr[42]);
                obj.setOperatorSchema((Double)rdr[43]);
                obj.setStandpipePressure((Double)rdr[44]);
                obj.setMeasurementOfBackPressure((Double)rdr[45]);
                obj.setOutletFlow((Double)rdr[46]);
                obj.setOutletDensity((Double)rdr[47]);
                obj.setBackPressurePumpFlow((Double)rdr[48]);
                obj.setLoopBackPressure((Double)rdr[49]);
                obj.setAdditionalBackPressure((Double)rdr[50]);
                obj.setInletFlow((Double)rdr[51]);
                obj.setFixDepth((Double)rdr[52]);
                obj.setFixPointDownDeep((Double)rdr[53]);
                obj.setFixPointPressure((Double)rdr[54]);
                obj.setWellMouthAdjustment((Double)rdr[55]);
                obj.setFixPointPressureLoss((Double)rdr[56]);
                obj.setBoDongYL((Double)rdr[57]);
                obj.setYaHaoXZ((Double)rdr[58]);
                obj.setQiXiaZuanSD((Double)rdr[59]);
                obj.setQiXiaZuanJSD((Double)rdr[60]);
                obj.setFixPointECD((Double)rdr[61]);
                obj.setDrillECD((Double)rdr[62]);
                obj.setDrillStringPressureDrop((Double)rdr[63]);
                obj.setDrillBitPressureDrop((Double)rdr[64]);
                obj.setEnvironmentalControlPressureLoss((Double)rdr[65]);
                obj.setTargetBackPressure((Double)rdr[66]);
                obj.setHydrostaticPressure((Double)rdr[67]);
                obj.setState_1((Double)rdr[68]);
                obj.setState_2((Double)rdr[69]);
            }
            rdr.Close();
            return(obj);
        }