/// <summary>
/// 往PressureYield中插入一条数据
/// </summary>
/// <param name="ge">PressureYield实例</param>
/// <returns>受影响的行数</returns>
public static int Insert(Entity.PressureYield py)
{
//获取当前井号
string wellid = Entity.Well.well_num;
string sql = "insert into PressureYield(Hours,Well_Num,Pressure,Gas,Water) values (";
sql += py.hours + ",";
sql += "'" + wellid + "',";
sql += py.yield + ",";
sql += py.gas + ",";
sql += py.water + ")";
int result = Access.AccessHelper.Insert(sql);
return(result);
}
/// <summary>
/// 修改PressureYield中的一条数据
/// </summary>
/// <param name="ge">GeologicalEvaluation实例</param>
/// <param name="depth">数据的主键</param>
/// <returns>受影响的行数</returns>
public static int Update(Entity.PressureYield py, double hours)
{
//获取当前井号
string wellid = Entity.Well.well_num;
string sql = "update PressureYield set ";
sql += "Hour=" + py.hours;
sql += ",Pressure=" + py.yield;
sql += ",Gas=" + py.gas;
sql += ",Water=" + py.water;
sql += " where Hours=" + hours + ",Well_Num='" + wellid + "'";
int result = Access.AccessHelper.Update(sql);
return(result);
}