/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ShreetId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Shreet ");
strSql.Append(" where ShreetId=@ShreetId ");
SqlParameter[] parameters =
{
new SqlParameter("@ShreetId", SqlDbType.Int, 4)
};
parameters[0].Value = ShreetId;
return(SQLDBHelper.ExcuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(City model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update City set ");
strSql.Append("CityName=@CityName ");
strSql.Append(" where CityId=@CityId ");
SqlParameter[] parameters =
{
new SqlParameter("@CityName", SqlDbType.VarChar, 50),
new SqlParameter("@CityId", SqlDbType.Int, 4)
};
parameters[0].Value = model.CityName;
parameters[1].Value = model.CityId;
return(SQLDBHelper.ExcuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(City model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into City(");
strSql.Append("CityName)");
strSql.Append(" values (");
strSql.Append("@CityName)");
SqlParameter[] parameters =
{
new SqlParameter("@CityName", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.CityName;
return(SQLDBHelper.ExcuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Shreet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Shreet(");
strSql.Append("ShreetName,DistrictId)");
strSql.Append(" values (");
strSql.Append("@ShreetName,@DistrictId)");
SqlParameter[] parameters =
{
new SqlParameter("@ShreetName", SqlDbType.VarChar, 20),
new SqlParameter("@DistrictId", SqlDbType.Int, 4)
};
parameters[0].Value = model.ShreetName;
parameters[1].Value = model.DistrictId;
return(SQLDBHelper.ExcuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Shreet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Shreet set ");
strSql.Append("ShreetName=@ShreetName,");
strSql.Append("DistrictId=@DistrictId ");
strSql.Append(" where ShreetId=@ShreetId ");
SqlParameter[] parameters =
{
new SqlParameter("@ShreetName", SqlDbType.VarChar, 20),
new SqlParameter("@DistrictId", SqlDbType.Int, 4),
new SqlParameter("@ShreetId", SqlDbType.Int, 4)
};
parameters[0].Value = model.ShreetName;
parameters[1].Value = model.DistrictId;
parameters[2].Value = model.ShreetId;
return(SQLDBHelper.ExcuteSql(strSql.ToString(), parameters));
}
