乐富网交接文档.doc

乐富网交接文档一、 网站布署：乐富网是一套基于Visual Studio .NET 2.0开发的网站；功能模块如下：Loofi.ChinaCity 中国城市工具模块；Loofi.Common 工具模块（如数据操作、日志记录）；Loofi.Logic 乐富网逻辑封装模块；Loofi.Admin 后台管理项目；Loofi.Web 乐富网网站项目；布署时需要修改web.config的数据库连接字符串，如下： 二、 网站数据库：-代理用户CREATE TABLE dbo.AGENT(ID int IDENTITY(10001,1) NOT NULL,EMAIL varchar(50) NOT NULL,-电子邮件,登录名PWD varchar(50) NOT NULL,-密码NAME varchar(50) NOT NULL,-姓名CITY varchar(50) NOT NULL,-城市BANK int NOT NULL,-银行IDCORP varchar(100) NOT NULL,-公司名称ADDR varchar(100) NOT NULL,-联系地址MOBILE varchar(20) NOT NULL,-手机号码CTIME datetime NOT NULL DEFAULT (0),-申请时间SCORE int NOT NULL,-会员积分STATUS tinyint NOT NULL,-状态) ON PRIMARY-信用卡申请CREATE TABLE dbo.APPLY(ID int IDENTITY(100000,1) NOT NULL,BANKID int NOT NULL,-银行IDCREDITID int NOT NULL,-申请的信用卡IDAGENTID int,-处理的代理人IDNAME varchar(50) NOT NULL,-申卡人姓名BIRTHDAY smalldatetime NOT NULL,-申卡人出生日期MARRIAGE int NOT NULL,-婚否WORKA int NOT NULL,-WORKB int NOT NULL,-WORKC int NOT NULL,-WORKD int NOT NULL,-WORKE varchar(100) NOT NULL,-WORKF varchar(200) NOT NULL,-CITY varchar(10) NOT NULL,-单位所在城市EDU int NOT NULL,-学历HOMEA int NOT NULL,-住房类型HOMEB int NOT NULL,-居住时间MONEY int NOT NULL,-月工资CAR int NOT NULL,-是否有车HaveA int NOT NULL,-是否有本行卡HaveB int NOT NULL,-是否有他行卡SCORE int NOT NULL,-申卡人积分MOBILE varchar(50) NOT NULL,-手机号TEL varchar(50) NOT NULL,-联系电话TIME varchar(50) NOT NULL,-方便联系时间GRADE int NOT NULL,-后台推荐级别CTIME datetime NOT NULL, -申请时间ETIME datetime NOT NULL,-代理处理时间STATUS int NOT NULL-状态) ON PRIMARY-资讯表CREATE TABLE dbo.ARTICLE(ID int IDENTITY(10001,1) NOT NULL,TYPE int NOT NULL,-资讯类别TITLE varchar(50) NOT NULL,-标题SOURCE varchar(100) NOT NULL,-来源KEYWORDS varchar(255) NOT NULL,-关键词CONTENT text NOT NULL,-内容CTIME datetime NOT NULL,-发布时间STATUS tinyint NOT NULL,-状态OPERATOR int NOT NULL,-添加人) ON PRIMARY TEXTIMAGE_ON PRIMARY- 信用卡表CREATE TABLE dbo.CREDITCARD(ID int IDENTITY(10001,1) NOT NULL,BANKID int NOT NULL,-银行IDSORTID int NOT NULL,-主题IDORGANISE int NOT NULL,-发卡组织COINSORT int NOT NULL,-支持币种LEVEL int NOT NULL,-级别NAME varchar(50) NOT NULL,-信用卡名称TRAIT varchar(5000) NOT NULL,-特点SHTICK varchar(8000) NOT NULL,-特色功能CONTENT varchar(8000) NOT NULL,-信用卡简介CONDITION varchar(8000) NOT NULL,-申请条件YEARFEE1 float NOT NULL,-年费(max)YEARFEE2 float NOT NULL,-年费(min)NOFEE varchar(500) NOT NULL,-免年费规则INTEREST1 int NOT NULL,-免息期(max)INTEREST2 int NOT NULL,-免息期(min)METHOD int NOT NULL,-交易方式XYED1 float NOT NULL,-信用额度(max)XYED2 float NOT NULL,-信用额度(min)JFZC varchar(500) NOT NULL,-积分政策MMS varchar(500) NOT NULL,-短信方式TXED float NOT NULL,-提现额度TXSXFBL float NOT NULL,-提现手续费比例ZDTXSXF float NOT NULL,-最低提现手续费RX float NOT NULL,-日息ZDHKBL float NOT NULL,-最低还款比例ZDHKE float NOT NULL,-最低还款额度GSF float NOT NULL,-挂失费HKF float NOT NULL,-换卡费YJKQHSXF float NOT NULL,-溢缴取回手续费ZDYJKQHSXF float NOT NULL,-最低溢缴取回手续费JYZYTDF int NOT NULL,-ZNJBL float NOT NULL,-滞纳金比例ZDZNJ float NOT NULL,-最低滞纳金CEFBL float NOT NULL,-超额费比例ZDCXF float NOT NULL,-最低超限费BZMMHF float NOT NULL,-补制密码函费WBDW varchar(200) NOT NULL,-外币单位WHDHSXF float NOT NULL,-外汇兑换手续费JWQXSXFBL float NOT NULL,-境外取现手续费比例JWQXZDSXF varchar(200) NOT NULL,-境外取现最低手续费JWJJBKF v