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