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