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