/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.HIS_MEASURAND_Data model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HIS_MEASURAND_Data set ");
strSql.Append("id=@id,");
strSql.Append("station_name=@station_name,");
strSql.Append("river_name=@river_name,");
strSql.Append("address=@address,");
strSql.Append("posx=@posx,");
strSql.Append("posy=@posy,");
strSql.Append("systime=@systime,");
strSql.Append("CODMn=@CODMn,");
strSql.Append("NH3_N=@NH3_N,");
strSql.Append("TP=@TP,");
strSql.Append("TN=@TN,");
strSql.Append("flow=@flow");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.BigInt, 8),
new SqlParameter("@station_name", SqlDbType.VarChar, 50),
new SqlParameter("@river_name", SqlDbType.VarChar, 50),
new SqlParameter("@address", SqlDbType.VarChar, 50),
new SqlParameter("@posx", SqlDbType.Decimal, 9),
new SqlParameter("@posy", SqlDbType.Decimal, 9),
new SqlParameter("@systime", SqlDbType.DateTime),
new SqlParameter("@CODMn", SqlDbType.Decimal, 9),
new SqlParameter("@NH3_N", SqlDbType.Decimal, 9),
new SqlParameter("@TP", SqlDbType.Decimal, 9),
new SqlParameter("@TN", SqlDbType.Decimal, 9),
new SqlParameter("@flow", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.id;
parameters[1].Value = model.station_name;
parameters[2].Value = model.river_name;
parameters[3].Value = model.address;
parameters[4].Value = model.posx;
parameters[5].Value = model.posy;
parameters[6].Value = model.systime;
parameters[7].Value = model.CODMn;
parameters[8].Value = model.NH3_N;
parameters[9].Value = model.TP;
parameters[10].Value = model.TN;
parameters[11].Value = model.flow;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Data DataRowToModel(DataRow row)
{
Maticsoft.Model.HIS_MEASURAND_Data model = new Maticsoft.Model.HIS_MEASURAND_Data();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = long.Parse(row["id"].ToString());
}
if (row["station_name"] != null)
{
model.station_name = row["station_name"].ToString();
}
if (row["river_name"] != null)
{
model.river_name = row["river_name"].ToString();
}
if (row["address"] != null)
{
model.address = row["address"].ToString();
}
if (row["posx"] != null && row["posx"].ToString() != "")
{
model.posx = decimal.Parse(row["posx"].ToString());
}
if (row["posy"] != null && row["posy"].ToString() != "")
{
model.posy = decimal.Parse(row["posy"].ToString());
}
if (row["systime"] != null && row["systime"].ToString() != "")
{
model.systime = DateTime.Parse(row["systime"].ToString());
}
if (row["CODMn"] != null && row["CODMn"].ToString() != "")
{
model.CODMn = decimal.Parse(row["CODMn"].ToString());
}
if (row["NH3_N"] != null && row["NH3_N"].ToString() != "")
{
model.NH3_N = decimal.Parse(row["NH3_N"].ToString());
}
if (row["TP"] != null && row["TP"].ToString() != "")
{
model.TP = decimal.Parse(row["TP"].ToString());
}
if (row["TN"] != null && row["TN"].ToString() != "")
{
model.TN = decimal.Parse(row["TN"].ToString());
}
if (row["flow"] != null && row["flow"].ToString() != "")
{
model.flow = decimal.Parse(row["flow"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.HIS_MEASURAND_Data model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HIS_MEASURAND_Data(");
strSql.Append("id,station_name,river_name,address,posx,posy,systime,CODMn,NH3_N,TP,TN,flow)");
strSql.Append(" values (");
strSql.Append("@id,@station_name,@river_name,@address,@posx,@posy,@systime,@CODMn,@NH3_N,@TP,@TN,@flow)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.BigInt, 8),
new SqlParameter("@station_name", SqlDbType.VarChar, 50),
new SqlParameter("@river_name", SqlDbType.VarChar, 50),
new SqlParameter("@address", SqlDbType.VarChar, 50),
new SqlParameter("@posx", SqlDbType.Decimal, 9),
new SqlParameter("@posy", SqlDbType.Decimal, 9),
new SqlParameter("@systime", SqlDbType.DateTime),
new SqlParameter("@CODMn", SqlDbType.Decimal, 9),
new SqlParameter("@NH3_N", SqlDbType.Decimal, 9),
new SqlParameter("@TP", SqlDbType.Decimal, 9),
new SqlParameter("@TN", SqlDbType.Decimal, 9),
new SqlParameter("@flow", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.id;
parameters[1].Value = model.station_name;
parameters[2].Value = model.river_name;
parameters[3].Value = model.address;
parameters[4].Value = model.posx;
parameters[5].Value = model.posy;
parameters[6].Value = model.systime;
parameters[7].Value = model.CODMn;
parameters[8].Value = model.NH3_N;
parameters[9].Value = model.TP;
parameters[10].Value = model.TN;
parameters[11].Value = model.flow;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Data GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 station_name,river_name,address,posx,posy,systime,CODMn,NH3_N,TP,TN,flow from HIS_MEASURAND_Data ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.HIS_MEASURAND_Data model = new Maticsoft.Model.HIS_MEASURAND_Data();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Data DataRowToModel(DataRow row)
{
Maticsoft.Model.HIS_MEASURAND_Data model=new Maticsoft.Model.HIS_MEASURAND_Data();
if (row != null)
{
if(row["station_name"]!=null)
{
model.station_name=row["station_name"].ToString();
}
if(row["river_name"]!=null)
{
model.river_name=row["river_name"].ToString();
}
if(row["address"]!=null)
{
model.address=row["address"].ToString();
}
if(row["posx"]!=null && row["posx"].ToString()!="")
{
model.posx=decimal.Parse(row["posx"].ToString());
}
if(row["posy"]!=null && row["posy"].ToString()!="")
{
model.posy=decimal.Parse(row["posy"].ToString());
}
if(row["systime"]!=null && row["systime"].ToString()!="")
{
model.systime=DateTime.Parse(row["systime"].ToString());
}
if(row["CODMn"]!=null && row["CODMn"].ToString()!="")
{
model.CODMn=decimal.Parse(row["CODMn"].ToString());
}
if(row["NH3_N"]!=null && row["NH3_N"].ToString()!="")
{
model.NH3_N=decimal.Parse(row["NH3_N"].ToString());
}
if(row["TP"]!=null && row["TP"].ToString()!="")
{
model.TP=decimal.Parse(row["TP"].ToString());
}
if(row["TN"]!=null && row["TN"].ToString()!="")
{
model.TN=decimal.Parse(row["TN"].ToString());
}
if(row["flow"]!=null && row["flow"].ToString()!="")
{
model.flow=decimal.Parse(row["flow"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Data GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 station_name,river_name,address,posx,posy,systime,CODMn,NH3_N,TP,TN,flow from HIS_MEASURAND_Data ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
Maticsoft.Model.HIS_MEASURAND_Data model=new Maticsoft.Model.HIS_MEASURAND_Data();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
