Create Procedure [dbo].[SJJH_UpdateClztbyByBWBH]
    (
    @bwbh varchar(20)
    )
    AS
    Begin
    --set nocount on
    update t_shouli set clzt = '' where yxtywlsh in(@bwbh);
    update t_chengban set clzt = '' where yxtywlsh in(@bwbh);
    update t_shenhe set clzt = '' where yxtywlsh in(@bwbh);
    update t_pizhun set clzt = '' where yxtywlsh in(@bwbh);
    update t_bianjie set clzt = '' where yxtywlsh in(@bwbh);
    END

int i =  db.ExecuteNonQuery(dbcmd);
return i;