sqlcode.properties

客户管理系统是一个典型的数据库开发应用程序

#--基础信息维护--#
#--对区域信息表的操作(tb_Client_qyxx)--#
#--查询的操作--
sql.qyxx.select=select *  from tb_Client_qyxx
#--删除的操作--
sql.qyxx.delete=delete from tb_Client_qyxx where qyxx_id='?'
#--插入的操作--
sql.qyxx.insert=insert into tb_Client_qyxx values('?','?','?','?','?','?')
#--以区域编号查找数据的操作--
sql.qyxx.selectOne=select * from tb_Client_qyxx where qyxx_id='?'
#--以区域编号修改区域信息--
sql.qyxx.update=update tb_Client_qyxx set qyxx_qymc='?',qyxx_qyjb='?',qyxx_zscd='?',qyxx_qygml='?',qyxx_bz='?' where qyxx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyxx.count=select MAX(id) as t from tb_Client_qyxx

#--对企业性质信息表的操作(tb_Client_qyxz)--#
#--查询的操作--
sql.qyxz.select=select * from tb_Client_qyxz
#--删除的操作--
sql.qyxz.delete=delete from tb_Client_qyxz where qyxz_id='?'
#--以企业性质编号查找数据的操作--
sql.qyxz.selectOne=select * from tb_Client_qyxz where qyxz_id='?'
#--以企业性质编号修改数据的操作--
sql.qyxz.update=update tb_Client_qyxz set qyxz_xzmc='?',qyxz_bz='?' where qyxz_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyxz.count=select MAX(id) as t from tb_Client_qyxz
#--插入的操作--
sql.qyxz.insert=insert into tb_Client_qyxz values('?','?','?')

#--对企业类型信息表的操作(tb_Client_qylx)--#
#--查询的操作--
sql.qylx.select=select * from tb_Client_qylx
#--删除的操作--
sql.qylx.delete=delete from tb_Client_qylx where qylx_id='?'
#--以企业类型编号修改数据的操作--
sql.qylx.update=update tb_Client_qylx set qylx_lxmc='?',qylx_bz='?' where qylx_id='?'
#--以企业类型编号查找数据的操作--
sql.qylx.selectOne=select * from tb_Client_qylx where qylx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qylx.count=select MAX(id) as t from tb_Client_qylx
#--插入的操作--
sql.qylx.insert=insert into tb_Client_qylx values('?','?','?')

#--对企业资信信息表的操作(tb_Client_qyzx)--#
#--查询的操作--
sql.qyzx.select=select * from tb_Client_qyzx
#--删除的操作--
sql.qyzx.delete=delete from tb_Client_qyzx where qyzx_id='?'
#--以企业资信编号修改数据的操作--
sql.qyzx.update=update tb_Client_qyzx set qyzx_zxjb='?',qyzx_bz='?' where qyzx_id='?'
#--以企业资信编号查找数据的操作--
sql.qyzx.selectOne=select * from tb_Client_qyzx where qyzx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyzx.count=select MAX(id) as t from tb_Client_qyzx
#--插入的操作--
sql.qyzx.insert=insert into tb_Client_qyzx values('?','?','?')

#--对企业资信信息表的操作(tb_Client_khjb)--#
#--查询的操作--
sql.khjb.select=select * from tb_Client_khjb
#--删除的操作--
sql.khjb.delete=delete from tb_Client_khjb where khjb_id='?'
#--以客户级别编号修改数据的操作--
sql.khjb.update=update tb_Client_khjb set khjb_jbmc='?',khjb_zdywl=?,khjb_bz='?' where khjb_id='?'
#--以客户级别编号查找数据的操作--
sql.khjb.selectOne=select * from tb_Client_khjb where khjb_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.khjb.count=select MAX(id) as t from tb_Client_khjb
#--插入的操作--
sql.khjb.insert=insert into tb_Client_khjb values('?','?',?,'?')

#--对客户满意表的操作(tb_Client_khmyd)--#
#--查询的操作--
sql.khmyd.select=select * from tb_Client_khmyd
#--删除的操作--
sql.khmyd.delete=delete from tb_Client_khmyd where khmyd_id='?'
#--以客户满意度编号修改数据的操作--
sql.khmyd.update=update tb_Client_khmyd set khmyd_myd='?',khmyd_bz='?' where khmyd_id='?'
#--以客户满意度编号查找数据的操作--
sql.khmyd.selectOne=select * from tb_Client_khmyd where khmyd_id='?'
#--查找出数据库中的流水号,以便做帐号存贮--
sql.khmyd.count=select MAX(id) as t from tb_Client_khmyd
#--插入的操作--
sql.khmyd.insert=insert into tb_Client_khmyd values('?','?','?')

#--对客户银行表的操作(tb_Client_bank)--#
#--查询的操作--
sql.bank.select=select * from tb_Client_bank
#--删除的操作--
sql.bank.delete=delete from tb_Client_bank where bank_id='?'
#--以客户银行表编号修改数据的操作--
sql.bank.update=update tb_Client_bank set bank_name='?',bank_bz='?' where bank_id='?'
#--以客户银行表编号查找数据的操作--
sql.bank.selectOne=select * from tb_Client_bank where bank_id='?'
#--查找出数据库的最大流水号,以便做帐号存贮--
sql.bank.count=select MAX(id) as t from tb_Client_bank
#--插入的操作--
sql.bank.insert=insert into tb_Client_bank values('?','?','?')

#--客户信息维护--#
#--对客户信息表的操作(tb_khxx)--#
#--查询的操作--
sql.khxx.select=select * from tb_khxx
#--以客户编号去查询--
sql.khxx.selectOne=select * from tb_khxx where khxx_id='?'
#--以数据库中的记录数，查找出多少记录计算,以便做帐号存贮--
sql.khxx.count=select MAX(id) as t from tb_khxx
#--插入的操作--
sql.khxx.insert=insert into tb_khxx values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')
#--删除的操作--
sql.khxx.delete=delete from tb_khxx where khxx_id='?'
#--修改的操作--
sql.khxx.update=update tb_khxx set khxx_mc='?',khxx_qyxz='?',khxx_qylx='?',khxx_qyzx='?',khxx_qydz='?',khxx_szsf='?',khxx_szcs='?',khxx_gsyb='?',khxx_frdb='?',khxx_khyh='?',khxx_yhzh='?',khxx_nsh='?',khxx_ICcard='?',khxx_gswz='?',khxx_gsdh='?',khxx_gscz='?',khxx_lxr='?',khxx_lxrdh='?',khxx_khjb='?',khxx_bz='?' where khxx_id='?'
sql.khxx.mc=select * from tb_khxx where khxx_mc='?'

#--对业务来往表的操作(tb_Client_Cpxs)--#
#--查询的操作--
sql.khcpx.select=select * from tb_Client_Cpxs
#--删除的操作--
sql.khcpx.delete=delete from tb_Client_Cpxs where cpxs_id='?'
#--以业务来往表编号去查询--
sql.khcpx.selectOne=select * from tb_Client_Cpxs where id=?
#--修改的操作--
sql.khcpx.update=update tb_Client_cpxs set cpxs_id='?',cpxs_mc='?',cpxs_cpdj='?',cpxs_khId='?',cpxs_xsrq='?',cpxs_bz='?' where id=?
#--以数据库中的记录数，查找出多少记录计算,以便做帐号存贮--
sql.khcpx.count=select MAX(id) as t from tb_Client_Cpxs
#--插入的操作--
sql.khcpx.insert=insert into tb_Client_Cpxs values('?','?','?','?','?','?')




#--客户服务--#
#--对客户反馈表的操作(tb_Client_khfk)--#
#--查询的操作--
sql.khfk.select=select * from tb_Client_khfk
#--以客户反馈编号去查询的操作--
sql.khfk.selectOne=select * from tb_Client_khfk where khfk_id='?'
#--删除的操作--
sql.khfk.delete=delete from tb_Client_khfk where khfk_id='?'
#--修改的操作--
sql.khfk.update=update tb_Client_khfk set khfk_fkbt='?',khfk_khmc='?',khfk_fknr='?',khfk_fkrq='?',khfk_fkslr='?',khfk_khmyd='?',khfk_bz='?' where khfk_id='?'
#--插入的操作--
sql.khfk.insert=insert into tb_Client_khfk (khfk_id,khfk_fkbt,khfk_khmc,khfk_fknr,khfk_fkrq,khfk_fkslr,khfk_khmyd,khfk_bz) values('?','?','?','?','?','?','?','?')
#--查出流水号，以便做帐号存贮--
sql.khfk.count=select MAX(id) as t from tb_Client_khfk
#--根据客户满意程度去查询--
sql.khfk.myd=select * from tb_Client_khfk where khfk_khmyd='?'

#--对地区的操作(tb_Client_sfzy)的操作--#
#--显示头10条记录--
sql.sfzy.select=select top 8 * from tb_Client_sfzy
sql.sfzy.total=select count(*) as t from tb_Client_sfzy
#--省份分页的操作--
sql.sfzy.fenye=select top 8 * from tb_Client_sfzy where id>(select MAX(id) from(select top ? (id) from tb_Client_sfzy) as aaa)
sql.sfzy.selectOne=select * from tb_Client_sfzy where sfzy_sfid='?'
#--城市分页的操作--
sql.csxx.select=select top 8 * from tb_Client_csxx where csxx_sfmc='?'
#--以省份为条件去查询城市的数量--
sql.csxx.total=select count(*)as t from tb_Client_csxx where csxx_sfmc='?'
#--分页显示--
sql.csxx.fenye=select top 8 * from tb_Client_csxx where id>( select MAX(id) from (select top ? (id) from tb_Client_csxx where csxx_sfmc='?') as aaa)
#--城市查询操作--
sql.csxx.prinfSelect=select * from tb_Client_csxx where csxx_sfmc='?'



sql.myd=select count('?')as t from tb_Client_khfk


#--实现客户反馈满意程度分析--#
sql.khfk.mydAnthor=select  khfk_khmyd as myd, count(*) as t from tb_Client_khfk group by khfk_khmyd
sql.khfk.number=select count(*) as t from tb_Client_khfk




#--操作员的操作--#
#--操作员登陆--
sql.user.check=select * from tb_user where user_name='?'
#--修改操作员密码--
sql.user.updatePassword=update tb_user set user_mm='?' where user_id='?'
#--查询授权的操作--
sql.user.selectUser_bs=select * from tb_user where user_bs='?'
#--修改授权的操作--
sql.user.updateSelectRight=update tb_user set menu_jcxx='?',menu_khxx='?',menu_khfw='?',menu_xxcx='?',menu_fzgj='?',menu_sjgl='?' where user_id='?'
#--帐号唯一性的操作--
sql.user.countID=select MAX(id) as t from tb_user
#--添加管理员信息操作--
sql.user.insert=insert into tb_user values('?','?','?','0','0','0','0','0','0','0','0')
#--删除管理员信息操作--
sql.user.delete=delete from tb_user where user_id='?'

#--操作员工作备忘的操作--#
#--操作员查询工作备忘记录--
sql.userGzbw.select=select * from tb_Client_gzbw where gzbw_manager='?'
#--帐号唯一性的操作--
sql.userGzbw.countID=select MAX(id) as t from tb_Client_gzbw
#--插入操作--
sql.userGzbw.insert=insert into tb_Client_gzbw values('?','?','?','?','?','?')
#--删除操作--
sql.userGzbw.delete=delete from tb_Client_gzbw where id=?
#--单独查询操作--
sql.userGzbw.selectOne=select * from tb_Client_gzbw  where id=?
#--修改操作--
sql.userGzbw.update=update tb_Client_gzbw set gzbw_bt='?',gzbw_nr='?',gzbw_bz='?',gzbw_jsrq='?'  where id=?

#--联系人信息的操作--#
#--联系人信息全部查询--
sql.lxrxx.select=select * from tb_Client_lxrxx
#--唯一查询--
sql.lxrxx.countID=select MAX(id) as t from tb_Client_lxrxx
#--插入操作--
sql.lxrxx.insert=insert into tb_Client_lxrxx values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')
#--删除操作--
sql.lxrxx.delete=delete from tb_Client_lxrxx where id=?
#--单独查询操作--
sql.lxrxx.selectOne=select * from tb_Client_lxrxx where id=?
#--修改操作--
sql.lxrxx.update=update tb_Client_lxrxx set lxrxx_id='?',lxrxx_qymc='?',lxrxx_xm='?',lxrxx_xb='?',lxrxx_csny='?',lxrxx_nl='?',lxrxx_zw='?',lxrxx_bgdh='?',lxrxx_Email='?',lxrxx_sj='?',lxrxx_grjj='?',lxrxx_djrq='?',lxrxx_xxdjr='?',lxrxx_bs='?',lxrxx_bz='?' where id=?

#--客户投诉的操作--#
#--全部查询操作--
sql.khts.select=select * from tb_Client_khts
#--插入操作--
sql.khts.insert=insert into tb_Client_khts values('?','?','?','?','?','?','?','?','?','?')
#--唯一查询--
sql.khts.countID=select MAX(id) as t from tb_Client_khts
#--单独查询操作--
sql.khts.selectOne=select * from tb_Client_khts where id=?
#--修改操作--
sql.khts.update=update tb_Client_khts set khts_id='?',khts_qymc='?',khts_tsr='?',khts_tszt='?',khts_tsnr='?',khts_tsrq='?',khts_clbf='?',khts_khmyd='?',khts_tsslr='?',khts_bz='?' where id=?
#--删除操作--
sql.khts.delete=delete from tb_Client_khts where id=?
#--删除受理操作--
sql.khts.deleteSl=update tb_Client_khts set khts_clbf='?',khts_khmyd='?',khts_tsslr='?' where id=?
#--图形分析--
sql.khts.pricture=select  khts_khmyd as myd, count(*) as t from tb_Client_khts group by khts_khmyd