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