private string MakeSQLDR(well anywell) { string str = "DELETE FROM RodString WHERE well_name='"; str = str + anywell.well_name + "'"; return(str); }
private string MakeSQLTA(well anywell) { string str = "UPDATE TubeAnchor SET update_datetime='"; DateTime now = DateTime.Now; str = str + now.ToString() + "', pos_from_top="; str = str + anywell.pump_set_depth; str = str + " WHERE well_name ='"; str = str + anywell.well_name + "'"; return(str); }
private string MakeSQLTS(well anywell) { string str = "UPDATE TubeString SET update_datetime='"; DateTime now = DateTime.Now; str = str + now.ToString() + "', step_length="; str = str + anywell.pump_set_depth; str = str + " WHERE well_name ='"; str = str + anywell.well_name + "'"; return(str); }
private string MakeSQLB(well anywell) { string str = "UPDATE SRPProdStatic SET update_datetime='"; DateTime now = DateTime.Now; str = str + now.ToShortDateString() + "', pump_nom_diam="; str = str + anywell.pump_nom_diam + ","; str = str + "pump_set_depth=" + anywell.pump_set_depth; str = str + " WHERE well_name ='"; str = str + anywell.well_name + "'"; return(str); }
private string MakeSQLA(well anywell) { double[] gas_facor = new double[2]; gas_facor = Get_gas_oil_factor(); string str = "INSERT INTO SRPProdDynamic(well_name,update_datetime,water_content,gas_oil_ratio,oil_pressure,casing_pressure,dfl,pu_working_para1,pu_working_para2,pu_working_para3,adjust_factor)VALUES('"; DateTime now = DateTime.Now; str = str + anywell.well_name + "','"; str = str + now.ToShortDateString() + " " + now.ToLongTimeString() + "',"; str = str + anywell.water_content + "," + gas_facor[0].ToString().Trim() + ","; str = str + anywell.oil_pressure + ",0,"; str = str + anywell.dfl + ",0,0,0," + gas_facor[1].ToString().Trim() + ")"; return(str); }
private string MakeSQLIR(well anywell) { string str = null; string str2 = null; string str3 = null; str = "INSERT INTO RodString(well_name,update_datetime,step_index_from_top,spec,material_grade,every_length,step_length)VALUES('"; str = str + anywell.well_name + "','"; DateTime now = DateTime.Now; str = str + now.ToString() + "',1,'"; str = str + anywell.first_rod_nom + "','钢D',0,"; str = str + anywell.first_rod_length + ")"; if (oilWell.second_rod_length == "" || oilWell.second_rod_nom == "") { return(str); } else { str2 = "INSERT INTO RodString(well_name,update_datetime,step_index_from_top,spec,material_grade,every_length,step_length)VALUES('"; str2 = str2 + anywell.well_name + "','"; str2 = str2 + now.ToString() + "',2,'"; str2 = str2 + anywell.second_rod_nom + "','钢D',0,"; str2 = str2 + anywell.second_rod_length + ")"; str = str + ";" + str2; } if (oilWell.three_rod_nom == "" || oilWell.three_rod_length == "") { return(str); } else { str3 = "INSERT INTO RodString(well_name,update_datetime,step_index_from_top,spec,material_grade,every_length,step_length)VALUES('"; str3 = str3 + anywell.well_name + "','"; str3 = str3 + now.ToString() + "',3,'"; str3 = str3 + anywell.three_rod_nom + "','钢D',0,"; str3 = str3 + anywell.three_rod_length + ")"; str = str + ";" + str3; return(str); } } //存在多级组合,用多条语句,采用分号连接多条SQL语句
} //存在多级组合,用多条语句,采用分号连接多条SQL语句 private string MakeSQLQ(well anywell) { string str = @"SELECT count(*) FROM SRPProdStatic WHERE well_name='" + anywell.well_name + "'"; return(str); }
public OilWell(SqlConnection sqlConnection, well onewell) { conn = sqlConnection; oilWell = onewell; }