---清除数据，重新生成台账和汇总台账。
SELECT * FROM t_ae30 a where a.aaa121='F140319' order by a.aaz030 desc;
select * from t_ae30 a where a.aaz030=100000000000204;
SELECT * FROM t_ac82 a where a.aaz030=100000000000204;
SELECT * FROM t_ac83 a where a.aaz030=100000000000204;
SELECT * FROM ae30 a where a.aaa121='F140320' order by a.aaz030 desc;
SELECT * FROM ae30 a where a.aaz030=100000000000204;
SELECT * FROM ac82 a where a.aaz030=100000000000204;
SELECT * FROM ac83 a where a.aaz220 in (SELECT aaz220 FROM ac82 a where a.aaz030=100000000000204);
SELECT * FROM base.ada1 a where a.caa101='2101';--F140320
SELECT * FROM base.ada2 a where a.cad129=2018020810000020;
SELECT * FROM base.ada3 a where a.cad130 in (SELECT cad130 FROM base.ada2 a where a.cad129=2018020810000020);
SELECT * FROM base.ada4 a where a.cad131 in (SELECT a.cad131 FROM base.ada3 a where a.cad130 in (SELECT cad130 FROM base.ada2 a where a.cad129=2018020810000020));
---删除失业台账数据。包括资金池数据。
delete from t_ae30 a where a.aaz030=100000000000204;
delete FROM t_ac82 a where a.aaz030=100000000000204;
delete FROM t_ac83 a where a.aaz030=100000000000204;
delete from ae30 a where a.aaz030=100000000000206;
delete from ac83 a where a.aaz220 in (select aaz220 from ac82 a where a.aaz030=100000000000206);
delete from ac82 a where a.aaz030=100000000000206;
delete from base.ada1 a where a.bad709=100000000000206;
delete FROM base.ada4 a where a.cad131 in (SELECT cad131 FROM base.ada3 a where a.cad130 in (SELECT cad130 FROM base.ada2 a where a.cad129=2018020810000021));
delete FROM base.ada3 a where a.cad130 in (SELECT cad130 FROM base.ada2 a where a.cad129=2018020810000021);
delete FROM base.ada2 a where a.cad129=2018020810000021;
---=======================================================================================
--=================================失业台账生成sql begin=================================
--=========================================================================================
---=====================失业正常发放t_ac82sql =
select seq_aaz220.nextval,
100000000000457,
a.aac001,
a.aab001,
a.aae140,
a.aaa027,
a.baf307,
201709,
null aae006,
null aae007,
c.bae118,
c.bae119,
c.bab007,
c.aae009,
c.aae010,
a.aab301,
c.aaz097,
c.aaz099,
null aaz159,
'1',
'1',
g.aae019 bae135,
0.0 bae136,
g.aae019 aae019,
'1',
'ac60' aae013,
'F140319',
seq_baa018.nextval,
f.aac058,
f.aac147,
f.aac003,
f.aac004,
a.aac999,
a.aab999,
a.aaz257,
'107119',
'柜台测试用户1',
sysdate,
'107119',
'柜台测试用户1',
sysdate,
'B',
'',
'0',
'3742',
'Y11'
--SELECT a.*
from ac60 a,
jc10 f,
AC63 c,
(select d.aaz257, sum(e.aae019) aae019
from ac60 d, ac61 e
where d.aaz257 = e.aaz257
and d.aae100 = '1'
and d.aae116 = '1'
and d.aae140 = '210'
and d.aae210 <= 201712
and d.aic301 >= 201712
and e.aae042 >= 201712
and d.aaa027 = '440300'
and d.baf307 = '440306'
group by d.aaz257) g
where a.aaz257 = f.aaz257
and a.aaz099 = c.aaz099
and a.aaz257 = g.aaz257;
--========================失业死亡当月t_ac82 sql =
MERGE INTO t_ac82 A
USING (SELECT c.aae019,
d.aac001,
d.aab001,
d.aae140,
d.aaa027,
d.baf307,
null aae006,
null aae007,
f.bae118,
f.bae119,
f.bab007,
f.aae009,
f.aae010,
d.aab301,
f.aaz097,
f.aaz099,
null aaz159,
'1' aae145,
e.aac058,
e.aac147,
e.aac003,
e.aac004,
e.aac999,
e.aab999,
d.aaz257
FROM AC60 d,
JC10 e,
AC77 g,
AC63 f,
(select a.aaz257, sum(aae019) aae019
from ac61 a, ac60 b
where a.aaz257 = b.aaz257
and a.aae041 >= 201709
group by a.aaz257) c
WHERE d.AAZ257 = e.AAZ257
and d.aaz099 = f.aaz099
and d.aaz257 = c.aaz257
AND d.AAE100 = '1'
and d.aae116 = '3'
and d.aae140 = '210'
and d.aaz257 = g.aaz257
and SUBSTR(g.BAA201, 0, 1) = 'Y'
and g.aae016 = '1'
and g.aae100 = '1'
and g.aaa121 = 'F140308'
and d.aic301 >= 201709
and substr(d.aaa027, 0, 4) = '440300') B
ON (a.aaz257 = b.aaz257 and a.aaz030 = 100000000000457)
WHEN MATCHED THEN
UPDATE
SET A.aae019 =
(a.aae019 + b.aae019),
a.bae135 =
(a.bae135 + b.aae019),
a.aae013 = 'ac75'
when not MATCHED then
insert
(aaz220,
aaz030,
aac001,
aab001,
aae140,
aaa027,
baf307,
aae002,
aae006,
aae007,
bae118,
bae119,
bab007,
aae009,
aae010,
aab301,
aaz097,
aaz099,
aaz159,
aae145,
aaa079,
bae135,
bae136,
aae019,
bae024,
aae013,
aaa121,
baa018,
aac058,
aac147,
aac003,
aac004,
aac999,
aab999,
aaz257,
aae011,
bae125,
aae036,
aae012,
aae014,
aae015,
aaa028,
aaz010,
aae016,
aaz002,
baa201)
values
(seq_aaz220.nextval,
100000000000457,
b.aac001,
b.aab001,
b.aae140,
b.aaa027,
b.baf307,
201709,
b.aae006,
b.aae007,
b.bae118,
b.bae119,
b.bab007,
b.aae009,
b.aae010,
b.aab301,
b.aaz097,
b.aaz099,
b.aaz159,
b.aae145,
'1',
b.aae019,
0.0,
b.aae019,
'1',
'ac75',
'F140319',
seq_baa018.nextval,
b.aac058,
b.aac147,
b.aac003,
b.aac004,
b.aac999,
b.aab999,
b.aaz257,
'107119',
'柜台测试用户1',
sysdate,
'107119',
'柜台测试用户1',
sysdate,
'B',
'',
'0',
'3742',
'Y11')
--=======================保存(从ac61生成)t_ac83sql =
insert into t_ac83
(aaz219,
aaz220,
aaa027,
aac001,
aaa036,
aaa038,
aaa085,
aaa088,
aae140,
aae002,
aae003,
aae019,
bae134,
aae013,
baz057,
baa018,
aaz030,
bad709,
bae023,
bad305,
bae118)
(select seq_aaz219.nextval,
a.aaz220,
a.aaa027,
a.aac001,
b.aaa036,
c.aaa038,
'1',
'1',
a.aae140,
201709,
201709,
b.aae019,
b.bae134,
'ac60',
100000,
seq_baa018.nextval,
100000000000457,
'',
'4',
'',
a.bae118
from t_ac82 a, ac61 b, aa17 c
where a.aaz257 = b.aaz257
and b.aaa036 = c.aaa036
and a.aaz030 = 100000000000457
and b.aae042 >= 201709)
---=============================失业补发t_ac82 sql =
MERGE INTO t_ac82 A
USING (SELECT c.aae019,
d.aac001,
d.aab001,
d.aae140,
d.aaa027,
d.baf307,
null aae006,
null aae007,
f.bae118,
f.bae119,
f.bab007,
f.aae009,
f.aae010,
d.aab301,
f.aaz097,
f.aaz099,
null aaz159,
'1' aae145,
e.aac058,
e.aac147,
e.aac003,
e.aac004,
e.aac999,
e.aab999,
d.aaz257
FROM AC60 d,
JC10 e,
AC63 f,
(select aaz257, sum(aae019) aae019
from ac75
where aae016 = '1'
and substr(baa201, 0, 1) = 'Y'
and nvl(aaz220, 0) = 0
and aaa078 = '1'
and baz057 = 100000
and aae140 = '210'
and baf307 = '440303'
and aaa027 = '440300'
group by aaz257) c
WHERE c.AAZ257 = d.AAZ257
AND d.AAZ257 = e.AAZ257
and d.aaz099 = f.aaz099
and d.aae100 = '1'
and d.aae140 = '210') B
ON (a.aaz257 = b.aaz257 and a.aaz030 = 100000000000457)
WHEN MATCHED THEN
UPDATE
SET A.aae019 =
(a.aae019 + b.aae019),
a.bae135 =
(a.bae135 + b.aae019),
a.aae013 = 'ac75'
when not MATCHED then
insert
(aaz220,
aaz030,
aac001,
aab001,
aae140,
aaa027,
baf307,
aae002,
aae006,
aae007,
bae118,
bae119,
bab007,
aae009,
aae010,
aab301,
aaz097,
aaz099,
aaz159,
aae145,
aaa079,
bae135,
bae136,
aae019,
bae024,
aae013,
aaa121,
baa018,
aac058,
aac147,
aac003,
aac004,
aac999,
aab999,
aaz257,
aae011,
bae125,
aae036,
aae012,
aae014,
aae015,
aaa028,
aaz010,
aae016,
aaz002,
baa201)
values
(seq_aaz220.nextval,
100000000000457,
b.aac001,
b.aab001,
b.aae140,
b.aaa027,
b.baf307,
201709,
b.aae006,
b.aae007,
b.bae118,
b.bae119,
b.bab007,
b.aae009,
b.aae010,
b.aab301,
b.aaz097,
b.aaz099,
b.aaz159,
b.aae145,
'1',
b.aae019,
0.0,
b.aae019,
'1',
'ac75',
'F140319',
seq_baa018.nextval,
b.aac058,
b.aac147,
b.aac003,
b.aac004,
b.aac999,
b.aab999,
b.aaz257,
'107119',
'柜台测试用户1',
sysdate,
'107119',
'柜台测试用户1',
sysdate,
'B',
'',
'0',
'3742',
'Y11')
--======================失业补发保存(从ac76生成)t_ac83sql =
insert into t_ac83
(aaz219,
aaz220,
aaa027,
aac001,
aaa036,
aaa038,
aaa085,
aaa088,
aae140,
aae002,
aae003,
aae019,
bae134,
aae013,
baz057,
baa018,
aaz030,
bad709,
bae023,
bad305,
bae118)
(select seq_aaz219.nextval,
h.aaz220,
c.aaa027,
c.aac001,
g.aaa036,
i.aaa038,
'1',
'2',
c.aae140,
'201709',
g.aae003,
g.aae129,
g.bae134,
'ac75',
'100000',
seq_baa018.nextval,
'100000000000457',
'',
'4',
'',
h.bae118
FROM AC75 c, AC60 d, JC10 e, AC63 f, ac76 g, t_ac82 h, aa17 i
WHERE c.AAZ257 = d.AAZ257
AND d.AAZ257 = e.AAZ257
and d.aaz099 = f.aaz099
and c.aaz166 = g.aaz166
and d.aac001 = h.aac001
and g.aaa036 = i.aaa036
and d.aae100 = '1'
AND c.AAE016 = '1'
AND SUBSTR(c.BAA201, 0, 1) = 'Y'
AND NVL(c.AAZ220, 0) = 0
and c.aaa078 = '1'
and d.aae140 = '210'
and c.baf307 = '440303'
and c.aaa027 = '440300'
and h.aaz030 = 100000000000457)
--======================失业发放失败保存t_ac82 sql =
MERGE INTO t_ac82 A
USING (SELECT c.aae019,
d.aac001,
d.aab001,
d.aae140,
d.aaa027,
d.baf307,
null aae006,
null aae007,
f.bae118,
f.bae119,
f.bab007,
f.aae009,
f.aae010,
d.aab301,
f.aaz097,
f.aaz099,
null aaz159,
'1' aae145,
e.aac058,
e.aac147,
e.aac003,
e.aac004,
e.aac999,
e.aab999,
d.aaz257
FROM AC60 d,
JC10 e,
AC63 f,
(select a.aac001, sum(a.aae019) aae019
from ac82 a
where a.bae023 = 'F'
group by a.aac001) c
WHERE c.aac001 = d.aac001
AND d.AAZ257 = e.AAZ257
and d.aaz099 = f.aaz099
and d.aae100 = '1'
and d.aae140 = '210'
and d.aaa027 = '440300'
and d.baf307 = '440303') B
ON (a.aaz257 = b.aaz257 and a.aaz030 = 100000000000457)
WHEN MATCHED THEN
UPDATE
SET A.aae019 =
(a.aae019 + b.aae019),
a.bae135 =
(a.bae135 + b.aae019),
a.aae013 = 'ac75'
when not MATCHED then
insert
(aaz220,
aaz030,
aac001,
aab001,
aae140,
aaa027,
baf307,
aae002,
aae006,
aae007,
bae118,
bae119,
bab007,
aae009,
aae010,
aab301,
aaz097,
aaz099,
aaz159,
aae145,
aaa079,
bae135,
bae136,
aae019,
bae024,
aae013,
aaa121,
baa018,
aac058,
aac147,
aac003,
aac004,
aac999,
aab999,
aaz257,
aae011,
bae125,
aae036,
aae012,
aae014,
aae015,
aaa028,
aaz010,
aae016,
aaz002,
baa201)
values
(seq_aaz220.nextval,
100000000000457,
b.aac001,
b.aab001,
b.aae140,
b.aaa027,
b.baf307,
201709,
b.aae006,
b.aae007,
b.bae118,
b.bae119,
b.bab007,
b.aae009,
b.aae010,
b.aab301,
b.aaz097,
b.aaz099,
b.aaz159,
b.aae145,
'1',
b.aae019,
0.0,
b.aae019,
'1',
'ac75',
'F140319',
seq_baa018.nextval,
b.aac058,
b.aac147,
b.aac003,
b.aac004,
b.aac999,
b.aab999,
b.aaz257,
'107119',
'柜台测试用户1',
sysdate,
'107119',
'柜台测试用户1',
sysdate,
'B',
'',
'0',
'3742',
'Y11')
--================失业发放失败t_ac83sql =
insert into t_ac83
(aaz219,
aaz220,
aaa027,
aac001,
aaa036,
aaa038,
aaa085,
aaa088,
aae140,
aae002,
aae003,
aae019,
bae134,
aae013,
baz057,
baa018,
aaz030,
bad709,
bae023,
bad305,
bae118)
(select seq_aaz219.nextval,
h.aaz220,
d.aaa027,
d.aac001,
g.aaa036,
g.aaa038,
'1',
'2',
d.aae140,
'201709',
g.aae003,
g.aae019,
g.bae134,
'',
'100000',
seq_baa018.nextval,
'100000000000457',
'',
'4',
'',
h.bae118
FROM ac82 c, AC60 d, JC10 e, ac63 f, ac83 g, t_ac82 h
WHERE c.aac001 = d.aac001
AND d.AAZ257 = e.AAZ257
and d.aaz099 = f.aaz099
and c.aaz220 = g.aaz220
and d.aac001 = h.aac001
and d.aae100 = '1'
AND c.bae023 = 'F'
AND SUBSTR(c.BAA201, -1, 1) = '1'
and d.aae140 = '210'
and d.baf307 = '440303'
and d.aaa027 = '440300'
and h.aaz030 = 100000000000457)
--=====================失业保存az26sql =
insert into az26 (aaz222, aaz220, aaz221, aaz002) (SELECT SEQ_aaz222.Nextval, c.aaz220, g.aaz220 aaz221, g.aaz002 FROM AC60 d, JC10 e, ac63 f, ac82 c, t_ac82 g WHERE c.aac001 = d.aac001 AND d.AAZ257 = e.AAZ257 and d.aaz099 = f.aaz099 and c.aac001 = g.aac001 and d.aae100 = '1' and c.bae023 = 'F' and d.aae140 = ? and g.aaz030 = ?)
--============失业保存ac82bae023 sql =
update ac83 set bae023 = '5' where aaz220 in (SELECT aaz220 FROM AC60 d, JC10 e, ac63 f, ac82 c WHERE c.aac001 = d.aac001 AND d.AAZ257 = e.AAZ257 and d.aaz099 = f.aaz099 and d.aae100 = '1' and d.aae140 = ? and d.aaa027 = ? and c.bae023 = 'F')
--============失业保存ac82bae023 sql =
update ac82 set bae023 = '5' where aaz220 in (SELECT aaz220 FROM AC60 d, JC10 e, ac63 f, ac82 c WHERE c.aac001 = d.aac001 AND d.AAZ257 = e.AAZ257 and d.aaz099 = f.aaz099 and d.aae100 = '1' and d.aae140 = ? and d.aaa027 = ? and c.bae023 = 'F')
---=======================================================================================
--=================================失业台账生成sql end =================================
--=========================================================================================
--保存ada2sql =
insert into ada2 (cad130, cad129, cad213, cab101, aae008, aaf036, aae010, aae009, cae801, cae800, caz126, aab299, bab038, aaa039, cad093, aae002, caa101, aae058, caz170, cad042, cad097, aae072, cad101, aae011, aae036, cad206, aaz198) (select to_char(sysdate, 'yyyyMMdd') || SEQ_CAD130.nextval, 2018020710000019, '3', a.aac001, a.bae118, (select aaa103 from szdy.aa10 where aaa100 = 'BAE118' and aaa102 = a.bae118), a.aae010, a.aae009, a.aac003, a.aac147, a.baf307, '', '01', '2', '0', a.aae002, a.aaa121, a.aae019, '0', '', '0', a.aaz220, (select count(*) from szdy.ac83 where aaz220 = a.aaz220), '107119', sysdate, sysdate, '440300' from szdy.ac82 a where aaz030 = ?)
--17:45:15,972 ERROR PublicInfoMgrBSImpl:4590 - 保存ada3sql =
insert into base.ada3 (cad131, cad130, caa101, aae058, caz168, caz170, caz173, aaa039, cad103, cad097, aae576, aae011, aae036, aaz198) (select to_char(sysdate, 'yyyyMMdd') || SEQ_CAD131.nextval, e.* from (select d.cad130, d.bad305 caa101, abs(sum(decode(d.aaa088, 3, -d.aae019, d.aae019))) aae058, abs(sum(decode(d.aaa088, 3, -d.aae019, d.aae019))) caz168, 0 caz170, abs(sum(decode(d.aaa088, 3, -d.aae019, 0))) caz173, d.aaa039, count(*) cad103, '0' cad097, '' aae576, '107119' aae011, sysdate aae036, '440300' aaz198 from (select b.cad130, c.bad305, c.aae019, c.aaa088, decode(c.aaa088, 3, 1, 2) aaa039 from szdy.ac82 a, ada2 b, szdy.ac83 c where a.aaz220 = b.aae072 and a.aaz220 = c.aaz220 and a.aaz030 = ?) d group by d.cad130, d.bad305, d.aaa039) e)
--17:45:16,051 ERROR PublicInfoMgrBSImpl:4690 - 保存ada4sql =
insert into ada4 (cad131, aae140, cad164, aab180, aac027, bke107, bcc334, aae011, aae036, aaz198) (select b.cad131, a.aae140, a.aaa036, sum(a.aae019), '21', '', '', '107119', sysdate, '440300' from szdy.ac83 a, ada3 b, szdy.ac82 c, ada2 d where c.aaz220 = d.aae072 and a.aaz220 = c.aaz220 and b.cad130 = d.cad130 and a.bad305 = b.caa101 and c.aaz030 = ? group by a.aae140, a.aaa036, a.bad305, b.cad131)
--17:45:16,196 ERROR PublicInfoMgrBSImpl:4729 - 保存ada1sql =
insert into ada1 (cad129, bad709, caa101, cad210, cad098, cad208, cad209, aae058, cad100, aae011, aae036, cad135, cad132) (select 2018020710000019, '100000000000188', 'F140320', '0', '0', '2', '1', sum(a.aae058), count(*), '107119', sysdate, '0', '1' from ada2 a where a.cad129 = ?)
相关推荐
特殊学生台账管理系统 特殊学生台账是学校管理中一个非常重要的组成部分，旨在对特殊学生的信息进行收集、记录和跟踪，确保学校能够更好地照顾和支持这些学生。下面是对特殊学生台账的详细解释和分析： 一、特殊...
在本项目中，"利用pycharm PYQT设计实现的台账管理系统"是一个基于Python集成开发环境PyCharm和GUI库PyQt构建的应用程序。这个系统旨在帮助用户管理和操作各种类型的台账，提供了一系列的功能来满足台账的日常管理...
EXCEL中利用VBA编写台账查询
【信息系统管理台账详解】 在IT行业中，信息系统管理台账是一个至关重要的工具，用于系统化地记录、跟踪和管理组织内部的所有信息系统。这样的台账有助于确保信息系统的有效运行，支持决策制定，并符合法规要求。...
酒店原料台账范本-酒店原料台账.xlsx
Access数据库系统能够帮助企业实现材料的精细化管理，包括材料的入库、出库记录，库存情况的实时更新，以及自动生成物资台账。通过对数据的录入和分析，可有效避免库存积压或短缺，提高物资周转效率。 2. **材料...
在IT行业中，批量合同生成是一项常见且高效的工作需求，尤其对于法律事务所、企业法务部门等处理大量合同文档的场景。"批量合同生成器，批量word生成"这个工具正解决了这个问题，它允许用户通过Excel表格输入数据，...
《铁路护路工作台账》的编制，正是为了解决铁路沿线安全隐患、提升治安防控水平而实施的一项重要举措。 一、《铁路护路工作台账》的重要性与作用 铁路沿线乡镇通过制定和实施《铁路护路工作台账》，旨在对铁路安全...
该系统集成了多种功能，包括数据录入、存储、查询、分析及报告生成，帮助铁路部门实现台账信息的标准化、数字化管理。 铁路台账，作为铁路运营的重要组成部分，记录了各种设备设施的运行状态、维护历史、故障信息等...
### 周转材料管理台账知识点解析 #### 一、周转材料管理台账概述 周转材料在建筑施工等项目中扮演着重要角色，合理管理和控制这些材料对于提高项目的经济效益至关重要。周转材料管理台账作为一种有效的管理工具，...
根据提供的文件信息，我们可以生成以下知识点： 一、企业安全生产管理台账的重要性 企业安全生产管理台账是企业安全生产管理的重要组成部分，对企业的安全生产管理起着至关重要的作用。《中华人民共和国安全生产法...
涉密信息系统台账是针对涉及国家秘密或企业敏感信息的计算机设备和网络系统进行详细记录的管理工具，旨在确保信息安全和合规性。对于XXXXXXX公司来说，建立这样的台账至关重要，因为它可以帮助公司跟踪、管理和保护...
学校领导巡课查课台账 学校领导巡课查课台账是学校领导对教学活动的监管和指导的重要工具。以下是相关知识点： 一、教学质量监管 学校领导巡课查课台账的主要目的是对教学质量进行监管和改进。通过巡课查课台账，...
计量仪表台账管理，完全自主开发系统，调用少量中间件管理。
水利工程工程质量缺陷台账 水利工程工程质量缺陷台账是 Construction Quality Defect Record（水利工程质量缺陷记录）的缩写，用于记录和跟踪水利工程项目中的质量缺陷信息。本文档旨在详细介绍水利工程工程质量...
下面是根据提供的文件信息生成的相关知识点： 廉政风险防范管理工作台账 廉政风险防范管理工作台账是指个人或组织对廉政风险的识别、评估、防范和管理的过程。该工作台账旨在记录和跟踪个人或组织中的廉政风险点、...
《涉密计算机管理台账》是针对企业内部对涉密计算机设备进行有效管理和监控的重要文档，旨在确保信息安全，防止敏感信息泄露。这份文档通常由特定的责任人制定，包括制表人和审核人，以确保信息的准确性和完整性。...
非涉密计算机及其配套设备管理台账,,,,,,,,, 科室：,,,,,,,,登记时间：, 序号,责任人,"安装 日期","计算机 品牌","硬盘物理 序列号","操作 系统",IP地址,MAC地址,配套设备,"配套设 备型号" ,,,,,,,,1, ,,,,,,,,2, ,,...
本文将详细介绍设备台账的建立和管理，包括设备台账的依据与要求、设备台账的用途与功用、设备台账的分类与建立、设备台账的管理与更新等方面。 设备台账的依据与要求 设备台账的建立和管理应符合中华人民共和国...
在此背景下，"学校(幼儿园)消防安全管理台账登记表"应运而生，成为提高校园消防安全管理效能的重要工具。 台账的建立首先从记录学校的基本信息入手，包括但不限于学校负责人、分管安全的领导信息及其联系方式，以及...