//更新房间信息 public void update(Model.room my) { string sql = "update room set roomabb=@roomabb,roomfee=@roomfee,roomlocation=@roomlocation Where roomname=@roomname "; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@roomname", my.Roomname)); sqlParams.Add(new SqlParameter("@roomabb", my.Roomabb)); sqlParams.Add(new SqlParameter("@roomfee", my.Roomfee)); sqlParams.Add(new SqlParameter("@roomlocation", my.Roomlocation)); co.ExecuteSql(sql, sqlParams); }
//插入房间信息 public void insert(Model.room my) { string sql = "insert into room(id,roomname,roomabb,roomfee,roomwz)values(@id,@roomname,@roomabb,@roomfee,@roomlocation)"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@id", my.Id)); sqlParams.Add(new SqlParameter("@roomname", my.Roomname)); sqlParams.Add(new SqlParameter("@roomabb", my.Roomabb)); sqlParams.Add(new SqlParameter("@roomfee", my.Roomfee)); sqlParams.Add(new SqlParameter("@roomlocation", my.Roomlocation)); co.ExecuteSql(sql, sqlParams); }
public void update(Model.room myu) { ro.update(myu); }
public void insert(Model.room myu) { ro.insert(myu); }