public int UpdateObject(Db_objects marker)
{
int res = 0;
res = this.ExecuteSQL("update db_objects set address=@address, [identity]=@identity where objectId=@objectId", marker);
return(res);
}
public Db_objects GetObjectByIdentity(string identity)
{
Db_objects marker = null;
marker = this.GetItemData <Db_objects>(sql_objects_select + " where [identity]=@identity_", new { identity_ = identity });
return(marker);
}
public Db_objects GetObjectById(int id)
{
Db_objects marker = null;
marker = this.GetItemData <Db_objects>(sql_objects_select + " where objectId=@id_", new { id_ = id });
return(marker);
}
public int InsertObject(Db_objects marker)
{
int res = this.GetItemData <int>("insert into db_objects (address, [identity]) values(@address,@identity); SELECT SCOPE_IDENTITY();", marker);
return(res);
}
