34,593
社区成员
发帖
与我相关
我的任务
分享
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='置疑的数据库名'
Go
sp_dboption '置疑的数据库名', 'single user', 'true'
Go
DBCC CHECKDB('置疑的数据库名')
Go
update sysdatabases set status =28 where name='置疑的数据库名'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption '置疑的数据库名', 'single user', 'false'
Go
select s.f_bmbm_ly as 领用部门,s.f_bmbm_fc as 发出部门,n.f_bmbm_dy as 台帐对应部门,'----',
s.f_ckbm_ly as 领用仓库,s.f_ckbm_fc as 发出仓库,n.f_ckbm_dy as 台帐对应仓库 from tbhj_kctz n
left outer join tbnote_xhzb s on n.f_djhm=s.f_djhm
where substring(n.f_djhm,3,3)='414'
update tbhj_kctz set f_bmbm_dy=case when s.f_bmbm_ly='' then s.f_bmbm_fc else s.f_bmbm_ly end,
f_ckbm_dy=case when s.f_ckbm_ly='' then s.f_ckbm_fc else s.f_ckbm_ly end
from tbnote_xhzb s where tbhj_kctz.f_djhm=s.f_djhm
and substring(tbhj_kctz.f_djhm,3,3)='414'
insert into tbNote(f_djlxbm,f_djlxmc,f_zbmc,f_cbmc) VALUES ('157','预估订单内部评审表','tbsc_ygddpszb','tbsc_ygddpscb')
insert into tbNote(f_djlxbm,f_djlxmc,f_zbmc,f_cbmc) VALUES ('158','生产令','tbsc_lzb','tbsc_lcb')
create table tbsc_ygddpszb --预估订单内部评审主表
(
f_zq varchar(6) Not Null, --帐期
f_djhm varchar(17) Not Null, --单据号码
f_zdrq varchar(8) Not Null, --制单日期
f_rzrq varchar(8) Not Null, --入帐日期
f_ddh varchar(30) Not Null default '', --手工单号
f_xsfp varchar(30) Not Null default '', --形式发票
f_bmbm varchar(15) Not Null default '', --部门编码
f_khbm varchar(15) Not Null default '', --客户编码
f_khdh varchar(30) Not Null default '', --客户单号
f_jdrq varchar(8) Not Null default '', --接单日期
f_kgrq varchar(8) not null default '', --开工日期
f_jhrq varchar(8) Not Null default '', --交货日期
f_ygbm_jd varchar(15) Not Null default '', --接单人编码
f_ygbm_ywy varchar(15) Not Null default '', --业务员
f_ygbm_zd varchar(15) Not Null default '', --制单人编码
f_ygbm_sp varchar(15) Not Null default '', --审批人编码
f_spyj varchar(3000) Not Null default '', --审批意见
f_ygbm_sh varchar(15) Not Null default '', --审核人编码
f_shrq varchar(8) Not Null default '', --审核日期
f_djbz varchar(255) Not Null default '', --单据备注
f_zfbz int Not Null default 0, --作废标志(0未作废1已作废)
Constraint tbsc_ygddpszb_key Primary Key(f_djhm)
)
create table tbsc_ygddpscb --预估订单内部评审从表
(
f_djhm varchar(17) Not Null, --单据号码
f_dnxh int Not Null, --单内序号
f_chbm varchar(30) Not Null, --存货编码
f_dwxh int Not Null, --单位序号
f_chsl float Not Null, --数量
f_dtcl varchar(55) Not Null default '', --灯体材料
f_dtys varchar(55) Not Null default '', --灯体颜色
f_xs float Not Null default 0, --箱数
f_jsyq varchar(255) Not Null default '', --技术要求
f_bzyq varchar(255) Not Null default '', --包装/标贴要求
f_yybm varchar(15) Not Null default '', --原因编码
f_cbbz varchar(255) Not Null default '', --备注
Constraint tbsc_ygddpscb_key Primary Key(f_djhm,f_dnxh)
)
create table tbsc_lzb --生产令主表
(
f_zq varchar(6) Not Null, --帐期
f_djhm varchar(17) Not Null, --单据号码
f_zdrq varchar(8) Not Null, --制单日期
f_rzrq varchar(8) Not Null, --入帐日期
f_sclbh varchar(30) Not Null, --生产令编号
f_khbm varchar(15) Not Null, --客户编码
f_khdh varchar(50) Not Null default '', --客户代号
f_tzrq varchar(8) Not Null, --通知日期
f_ygbm_ywzg varchar(15) Not Null, --业务主管编码
f_ygbm_gdy varchar(15) Not Null, --跟单员编码
f_ygbm_zd varchar(15) Not Null, --制单人编码
f_ygbm_sp varchar(15) Not Null, --审批人编码
f_spyj varchar(1000) Not Null, --审批意见
f_ygbm_sh varchar(15) Not Null, --审核人编码
f_shrq varchar(8) Not Null default '', --审核日期
f_djbz varchar(100) Not Null default '', --备注
f_zfbz int Not Null default 0, --作废标志(0未作废1已作废)
constraint tbsc_lzb_key primary key (f_djhm)
)
create table tbsc_lcb --生产令从表
(
f_djhm varchar(17) Not Null, --单据号码
f_dnxh int Not Null, --单内序号
f_chbm varchar(30) Not Null, --存货编码
f_dwxh int Not Null, --单位序号
f_sl float Not Null default 0, --数量
f_xs float Not Null default 0, --箱数
f_jhrq varchar(8) Not Null default '', --交货日期
f_khxh varchar(30) Not Null default '', --顾客型号
f_bzyq varchar(60) Not Null default '', --包装标贴要求
f_dtcl varchar(55) Not Null default '', --灯体材料
f_dtys varchar(55) Not Null default '', --灯体颜色
f_bomsy varchar(255) Not Null default '', --BOM表事宜
f_jsyq varchar(255) Not Null default '', --技术要求
f_wxzm varchar(100) Not Null default '', --外箱正唛
f_wxcm varchar(100) Not Null default '', --外箱侧唛
f_nhzm varchar(100) Not Null default '', --内盒正唛
f_nhcm varchar(100) Not Null default '', --内盒侧唛
f_cbbz varchar(100) Not Null default '', --从表备注
f_ddpsh varchar(17) Not Null default '', --订单号
f_ddpshh int Not Null default 0, --订单行号
constraint tbsc_lcb_key primary key (f_djhm,f_dnxh)
)
insert into tbNote(f_djlxbm,f_djlxmc,f_zbmc,f_cbmc) VALUES ('157','预估订单内部评审表','tbsc_ddpszb','tbsc_ddpscb')
insert into tbNote(f_djlxbm,f_djlxmc,f_zbmc,f_cbmc) VALUES ('158','生产令','tbsc_sclzb','tbsc_sclcb')
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ,F_MENU,f_dllname,f_formname) VALUES ('001000','预估订单内部评审表',2,0,1,'Ddps.dll','TDdpscxForm')
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001','预估订单内部评审表编制',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001001','预估订单内部评审表查看',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001002','预估订单内部评审表编辑',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001003','预估订单内部评审表删单',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001004','预估订单内部评审表审核',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001005','预估订单内部评审表反审',4,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001005001','预估订单内部评审表反审本月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001005002','预估订单内部评审表反审上月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001005003','预估订单内部评审表反审往月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001006','预估订单内部评审表单据选项设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001007','预估订单内部评审表单据参数设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000001008','预估订单内部评审表审批',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002','预估订单内部评审表查询',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002001','预估订单内部评审表查询',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002002','预估订单内部评审表查询方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002003','预估订单内部评审表查询方案删除',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002004','预估订单内部评审表查询格式方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001000002005','预估订单内部评审表查询格式方案删除',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ,F_MENU,f_dllname,f_formname) VALUES ('001058','生产令',2,0,1,'Scl.dll','TSclcxForm')
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001','生产令编制',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001001','生产令查看',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001002','生产令编辑',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001003','生产令删单',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001004','生产令审核',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001005','生产令反审',4,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001005001','生产令反审本月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001005002','生产令反审上月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001005003','生产令反审往月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001006','生产令单据选项设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001007','生产令单据参数设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058001008','生产令审批',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002','生产令查询',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002001','生产令查询',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002002','生产令查询方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002003','生产令查询方案删除',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002004','生产令查询格式方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001058002005','生产令查询格式方案删除',4,1)
create table tbsc_ddpszb --预估订单内部评审主表
(
f_zq varchar(6) Not Null, --帐期
f_djhm varchar(17) Not Null, --单据号码
f_zdrq varchar(8) Not Null, --制单日期
f_rzrq varchar(8) Not Null, --入帐日期
f_ddh varchar(30) Not Null default '', --手工单号
f_xsfp varchar(30) Not Null default '', --形式发票
f_bmbm varchar(15) Not Null default '', --部门编码
f_khbm varchar(15) Not Null default '', --客户编码
f_khdh varchar(30) Not Null default '', --客户单号
f_jdrq varchar(8) Not Null default '', --接单日期
f_kgrq varchar(8) not null default '', --开工日期
f_jhrq varchar(8) Not Null default '', --交货日期
f_ygbm_jd varchar(15) Not Null default '', --接单人编码
f_ygbm_ywy varchar(15) Not Null default '', --业务员
f_ygbm_zd varchar(15) Not Null default '', --制单人编码
f_ygbm_sp varchar(15) Not Null default '', --审批人编码
f_spyj varchar(3000) Not Null default '', --审批意见
f_ygbm_sh varchar(15) Not Null default '', --审核人编码
f_shrq varchar(8) Not Null default '', --审核日期
f_djbz varchar(255) Not Null default '', --单据备注
f_zfbz int Not Null default 0, --作废标志(0未作废1已作废)
Constraint tbsc_ddpszb_key Primary Key(f_djhm)
)
create table tbsc_ddpscb --预估订单内部评审从表
(
f_djhm varchar(17) Not Null, --单据号码
f_dnxh int Not Null, --单内序号
f_chbm varchar(30) Not Null, --存货编码
f_dwxh int Not Null, --单位序号
f_chsl float Not Null, --数量
f_dtcl varchar(55) Not Null default '', --灯体材料
f_dtys varchar(55) Not Null default '', --灯体颜色
f_xs float Not Null default 0, --箱数
f_jsyq varchar(255) Not Null default '', --技术要求
f_bzyq varchar(255) Not Null default '', --包装/标贴要求
f_yybm varchar(15) Not Null default '', --原因编码
f_cbbz varchar(255) Not Null default '', --备注
Constraint tbsc_ddpscb_key Primary Key(f_djhm,f_dnxh)
)
create table tbsc_sclzb --生产令主表
(
f_zq varchar(6) Not Null, --帐期
f_djhm varchar(17) Not Null, --单据号码
f_zdrq varchar(8) Not Null, --制单日期
f_rzrq varchar(8) Not Null, --入帐日期
f_sclbh varchar(30) Not Null, --生产令编号
f_khbm varchar(15) Not Null, --客户编码
f_khdh varchar(50) Not Null default '', --客户代号
f_tzrq varchar(8) Not Null, --通知日期
f_ygbm_ywzg varchar(15) Not Null, --业务主管编码
f_ygbm_gdy varchar(15) Not Null, --跟单员编码
f_ygbm_zd varchar(15) Not Null, --制单人编码
f_ygbm_sp varchar(15) Not Null, --审批人编码
f_spyj varchar(1000) Not Null, --审批意见
f_ygbm_sh varchar(15) Not Null, --审核人编码
f_shrq varchar(8) Not Null default '', --审核日期
f_djbz varchar(100) Not Null default '', --备注
f_zfbz int Not Null default 0, --作废标志(0未作废1已作废)
constraint tbsc_sclzb_key primary key (f_djhm)
)
create table tbsc_sclcb --生产令从表
(
f_djhm varchar(17) Not Null, --单据号码
f_dnxh int Not Null, --单内序号
f_chbm varchar(30) Not Null, --存货编码
f_dwxh int Not Null, --单位序号
f_sl float Not Null default 0, --数量
f_xs float Not Null default 0, --箱数
f_jhrq varchar(8) Not Null default '', --交货日期
f_khxh varchar(30) Not Null default '', --顾客型号
f_bzyq varchar(60) Not Null default '', --包装标贴要求
f_dtcl varchar(55) Not Null default '', --灯体材料
f_dtys varchar(55) Not Null default '', --灯体颜色
f_bomsy varchar(255) Not Null default '', --BOM表事宜
f_jsyq varchar(255) Not Null default '', --技术要求
f_wxzm varchar(100) Not Null default '', --外箱正唛
f_wxcm varchar(100) Not Null default '', --外箱侧唛
f_nhzm varchar(100) Not Null default '', --内盒正唛
f_nhcm varchar(100) Not Null default '', --内盒侧唛
f_cbbz varchar(100) Not Null default '', --从表备注
f_ddpsh varchar(17) Not Null default '', --订单号
f_ddpshh int Not Null default 0, --订单行号
constraint tbsc_sclcb_key primary key (f_djhm,f_dnxh)
)
alter table tbbom_cpjgcb add
f_dwxh int Not Null default 0 --单位序号
insert into tbNote(f_djlxbm,f_djlxmc,f_zbmc,f_cbmc) VALUES ('431','BOM','tbbom_cpjgzb','tbbom_cpjgcb')
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ,F_MENU,f_dllname,f_formname) VALUES ('001070','BOM',2,0,1,'Bom.dll','TBomcxForm')
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001','BOM编制',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001001','BOM查看',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001002','BOM编辑',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001003','BOM删单',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001004','BOM审核',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001005','BOM反审',4,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001005001','BOM反审本月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001005002','BOM反审上月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001005003','BOM反审往月单据',5,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001006','BOM单据选项设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001007','BOM单据参数设置',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070001008','BOM审批',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002','BOM查询',3,0)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002001','BOM查询',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002002','BOM查询方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002003','BOM查询方案删除',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002004','BOM查询格式方案新增',4,1)
INSERT INTO TBDA_QX(F_QXBM,F_QXMC,F_JB,F_MJ) VALUES ('001070002005','BOM查询格式方案删除',4,1)
create table tbbom_cpjgzb --产品结构主表
(
f_zq varchar(6) Not Null, --帐期
f_djhm varchar(17) Not Null, --单据号码
f_zdrq varchar(8) Not Null, --制单日期
f_rzrq varchar(8) Not Null, --入帐日期
f_bombh varchar(30) not null, --编号
f_chbm_n varchar(30) Not Null, --主件编码
f_khbm varchar(15) not null default '',--客户编码
f_bompl float not null, --批量
f_bomrq varchar(8) not null, --日期
f_ygbm_zd varchar(15) Not Null, --制单人编码
f_ygbm_sp varchar(15) Not Null, --审批人编码
f_spyj varchar(1000) Not Null, --审批意见
f_ygbm_sh varchar(15) Not Null, --审核人编码
f_shrq varchar(8) Not Null default '',--审核日期
f_djbz varchar(60) Not Null, --单据备注
f_zfbz int Not Null default 0, --作废标志(0未作废1已作废)
)
CREATE INDEX index_bom_djhm ON tbbom_cpjgzb (f_djhm)
CREATE INDEX index_bom_bh ON tbbom_cpjgzb (f_bombh)
CREATE UNIQUE CLUSTERED INDEX index_bom_ch ON tbbom_cpjgzb(f_chbm_n)
create table tbbom_cpjgcb --产品结构从表
(
f_djhm varchar(17) Not Null, --单据号码
f_dnxh int Not Null, --单内序号
f_bombh varchar(30) not null, --编号
f_chbm_n varchar(30) Not Null, --主件编码
f_fl int not null default 0, --分类109
f_j int not null default 1, --阶
f_chbm_s varchar(30) Not Null, --子件编码
f_chbm_p varchar(30) Not Null default '',--父件编码
f_zcl float not null, --组成量
f_ds int not null default 1, --底数
f_shl float not null default 0, --损耗率
f_gysbm varchar(15) not null default '',--供应商编码
f_chbm_xp varchar(30) not null default '',--选配货物编码(替代件)
f_cbbz varchar(255) not null default '',--备注
)
CREATE INDEX index_bom_djhm_cb ON tbbom_cpjgcb (f_djhm,f_dnxh)
CREATE UNIQUE CLUSTERED INDEX index_bom_tree ON tbbom_cpjgcb(f_bombh,f_chbm_n,f_chbm_s)
alter table tbda_jhgxjcdezb add
f_chbm_zzcpdl varchar(30) not null default '' --最终成品货物编码(大类)
alter table tbda_jhgxjcdecb add
f_chbm_zzcpdl varchar(30) not null default '' --最终成品货物编码(大类)
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000306'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000307'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000308'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000309'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000310'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000311'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000177'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000178'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000180'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000181'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000182'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000184'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000191'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000192'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000194'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000195'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000196'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000197'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000199'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000205'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000208'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000210'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000212'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000214'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000215'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000216'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000217'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000219'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000228'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000241'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000242'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000249'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000250'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000257'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000313'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000314'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000315'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000316'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000317'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000320'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000322'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000325'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000327'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000328'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000337'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000343'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000345'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000346'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000347'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000348'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000349'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000350'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000351'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000353'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000357'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000364'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000366'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000367'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000368'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000369'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000370'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000371'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000372'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000374'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000375'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000379'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000385'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000386'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000388'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000389'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000391'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000393'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000405'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000408'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000409'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000416'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000422'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000423'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000424'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000429'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000436'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000442'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000444'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000460'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000486'
update tbnote_fhzb set f_tdbz=1 where f_djhm='AA3370710-0000490'