📄 yewuxinxi.java
字号:
while(resSet.next()){
vec.add(resSet.getString("kehuname"));
ff=1;
}
stat.close();
dbConn.close();
if(ff==1){
chuchangChoice.removeAll();//清空再添加预防组件自动扩展
chuchangChoice.add(" .");
kehuChoice.removeAll();
for(int i=0;i<vec.size();i++){
kehuChoice.add(vec.get(i).toString());
}
kehuChoice.add(" .");
}else{
JOptionPane.showMessageDialog(null,"您查询的客户不存在");
}
}catch(Exception ew){
System.out.println(ew);
JOptionPane.showMessageDialog(null,"数据库服务器是否启动");
}
}//else
}else if(e.getSource()==luruButton){//传真为空 未做检查，考虑客户可能未安装
if(chuchangTime.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择出厂时间！");
}else if(huichangTime.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择回厂时间！");
}else if(kehumingcheng.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"客户名称不允许为空");
}else if(dizhi.getText().trim().length()==0||dizhi.getText().trim().length()>25){
JOptionPane.showMessageDialog(null,"请检查客户联系地址25字内");
}else if(lianxiren.getText().trim().length()==0||lianxiren.getText().trim().length()>5){
JOptionPane.showMessageDialog(null,"请正确输入联系人姓名！5字内");
}else if(dianhua.getText().trim().length()==0||dianhua.getText().trim().length()>23){
JOptionPane.showMessageDialog(null,"请正确输入联系电话！");
}else if(beizhu.getText().trim().length()>500&&beizhu.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"备注内容不能为空且不能超过500字！");
}else if(chuanzhen.getText().trim().length()>16){
JOptionPane.showMessageDialog(null,"请正确输入传真号码16字内");
}else if(pizhu.getText().trim().length()>200){
JOptionPane.showMessageDialog(null,"批注内容超过200字");
}else if(kehumingcheng.getText().trim().length()==0||kehumingcheng.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"请正确输入客户名称！13字内");
}else if(xinghaot.getText().trim().length()>13){
JOptionPane.showMessageDialog(null,"请正确输入产品型号13字内");
}else if(qiandingrent.getText().trim().length()>4){
JOptionPane.showMessageDialog(null,"请正确输入签订人4字内");
}else if(hetongzonget.getText().trim().length()>10){
JOptionPane.showMessageDialog(null,"请正确输入合同总额");
}else if(zhifujinet.getText().trim().length()>10){
JOptionPane.showMessageDialog(null,"请正确输入支付金额");
}else if(zhifuyuet.getText().trim().length()>10){
JOptionPane.showMessageDialog(null,"请正确输入支付余额");
}else if(shoukuanrent.getText().trim().length()>4){
JOptionPane.showMessageDialog(null,"请正确输入收款人4字内");
}else if(!(chuchangTime.getText().trim().substring(0,4).equals(huichangTime.getText().trim().substring(0,4)))){
JOptionPane.showMessageDialog(null,"出厂时间回厂时间不在同一年份?");
}else if((qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&xinghaot.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入产品型号！");
}else if((xinghaot.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&qiandingrent.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入签定人！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&hetongzonget.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入合同总额！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&zhifujinet.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入支付金额！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&zhifuyuet.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入支付余额！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&shoukuanrent.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请输入收款人！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0)&&qiandingriqit.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择签订日期！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0||hetongqixiant.getText().trim().length()>0)&&zhifuriqit.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择支付日期！");
}else if((xinghaot.getText().trim().length()>0||qiandingrent.getText().trim().length()>0||hetongzonget.getText().trim().length()>0||zhifujinet.getText().trim().length()>0||zhifuyuet.getText().trim().length()>0||shoukuanrent.getText().trim().length()>0||zhifuriqit.getText().trim().length()>0||qiandingriqit.getText().trim().length()>0)&&hetongqixiant.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择合同截止日期！");
}else if(!(isNumeric(hetongzonget.getText().trim()))){
JOptionPane.showMessageDialog(null,"合同总额必须是数字(整数0-9)");
}else if(!(isNumeric(zhifujinet.getText().trim()))){
JOptionPane.showMessageDialog(null,"支付金额额必须是数字(整数0-9)");
}else if(!(isNumeric(zhifuyuet.getText().trim()))){
JOptionPane.showMessageDialog(null,"欠款余额必须是数字(整数0-9)");
}else if(!(checkDate(huichangTime.getText().trim(),"yyyy-MM-dd HH:mm:ss"))&&!name.equals("master")){
JOptionPane.showMessageDialog(null,"回厂时间格式不正确");
}else{
String m="您确定要录入该条信息吗?";
int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(ok==JOptionPane.YES_OPTION) {
//------------------连接数据库----------------------------------------------
Connection dbConn;
Statement stat;
ResultSet rss;
ResultSet rs,rshetong;
ResultSet resSet;
try {
Class.forName(Yewu.forName);
dbConn=DriverManager.getConnection(Yewu.jdbc);
//String sq="select * from yewuTab where kehuname='"+kehumingcheng.getText().trim()+"'";
StringBuffer sq=new StringBuffer();
sq.append("select * from yewuTab where kehuname='").append(kehumingcheng.getText().trim()).append("'");
stat=dbConn.createStatement();
rs=stat.executeQuery(sq.toString());//
int flg=0;
while(rs.next()){
flg++;
}
if(flg>0&&!(name.equals("master"))){//先查询yewuTab有无此客户
String ss="select yewuname from xinxiTable where huitime='"+huichangTime.getText().trim()+"'";
//---使用时再声明
rss = stat.executeQuery(ss);//再查询信息表中有无 此客户 此回厂时间的记录
if(rss.next()){//根据唯一回厂时间判定 是否重复输入
JOptionPane.showMessageDialog(null,"该信息已存在!请使用唯一回厂时间");
}else{
StringBuffer sql=new StringBuffer();
sql.append("insert into xinxitable(yewuname,kehuname,chutime,huitime,beizhu,pizhu)").append("values('").append(yewuyuan.getSelectedItem().trim()).append("','").append(kehumingcheng.getText().trim()).append("','").append(chuchang.getDate().toLocaleString().trim()).append("','").append(huichangTime.getText().trim()).append("','").append(beizhu.getText().trim()).append("','' )");
if(stat.executeUpdate(sql.toString())>0){//前面判定无此客户此时间业务信息---添加到信息表
StringBuffer lastdate=new StringBuffer();
lastdate.append("update yewuTab set lastdate='").append(huichangTime.getText().trim()).append("' where kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(lastdate.toString())>0){//更新yewuTab的lastDate
}
if(xinghaot.getText().toString().trim().length()>0){//如果合同信息有内容
StringBuffer sqler=new StringBuffer();
sqler.append("update yewuTab set hetong='1' where kehuname='").append(kehumingcheng.getText().trim()).append("'");//签订合同 修改yewuTab中的逻辑值为1
if(stat.executeUpdate(sqler.toString())>0){//
}
rshetong=stat.executeQuery("select zhifuriqi from hetongTable where yewuname='"+yewuyuan.getSelectedItem().trim()+"' and kehuname='"+kehumingcheng.getText().trim()+"' and zhifuriqi='"+zhifuriqit.getText().trim()+"'");
if(!rshetong.next()){//如果没查到此客户的支付日期 则认为是新的支付
StringBuffer sql1=new StringBuffer();
sql1.append("insert into hetongTable(yewuname,kehuname,huitime,xinghao,qiandingren,hetongzonge,zhifuyue,zhifujine,shoukuanren,qiandingriqi,zhifuriqi,hetongqixian) values('").append(yewuyuan.getSelectedItem().trim()).append("','").append(kehumingcheng.getText().trim()).append("','").append(huichangTime.getText().trim()).append("','").append(xinghaot.getText().trim()).append("','").append(qiandingrent.getText().trim()).append("','").append(hetongzonget.getText().trim()).append("','").append(zhifuyuet.getText().trim()).append("','").append(zhifujinet.getText().trim()).append("','").append(shoukuanrent.getText().trim()).append("','").append(qiandingriqit.getText().trim()).append("','").append(zhifuriqit.getText().trim()).append("','").append(hetongqixiant.getText().trim()).append("' )");
if(stat.executeUpdate(sql1.toString())>0){//插入新的合同信息
}
}
}//此处不通知用户
JOptionPane.showMessageDialog(null,"添加成功！");
}else{
JOptionPane.showMessageDialog(null,"添加失败！");
}
}
}else if(flg==0&&!(name.equals("master"))){//如果yewuTab中无此用户 则全新 3个表都需要插入
String ss="select yewuname from xinxiTable where huitime='"+huichangTime.getText().trim()+"'";
//---使用时再声明
rss = stat.executeQuery(ss);//再查询信息表中有无 此客户 此回厂时间的记录
if(rss.next()){//根据唯一回厂时间判定 是否重复输入
JOptionPane.showMessageDialog(null,"该信息已存在!请使用唯一回厂时间");
}else{
StringBuffer sqfirst=new StringBuffer();
sqfirst.append("insert into yewuTab(yewuname,kehuname,dizhi,lianxiname,dianhua,chuanzhen,lastdate,fristdate) values('").append(yewuyuan.getSelectedItem().trim()).append("','").append(kehumingcheng.getText().trim()).append("','").append(dizhi.getText().trim()).append("','").append(lianxiren.getText().trim()).append("','").append(dianhua.getText().trim()).append("','").append(chuanzhen.getText().trim()).append("','").append(huichangTime.getText().trim()).append("','").append(chuchangTime.getText().trim()).append("' )");
if(stat.executeUpdate(sqfirst.toString())>0){//添加到业务表
//新增节点默认增加到root上
DefaultMutableTreeNode parent = getSelectedNode();
model.insertNodeInto(new DefaultMutableTreeNode(kehumingcheng.getText().trim()),root, 0);
StringBuffer sql=new StringBuffer();
sql.append("insert into xinxitable(yewuname,kehuname,chutime,huitime,beizhu,pizhu)").append("values('").append(yewuyuan.getSelectedItem().trim()).append("','").append(kehumingcheng.getText().trim()).append("','").append(chuchangTime.getText().trim()).append("','").append(huichangTime.getText().trim()).append("','").append(beizhu.getText().trim()).append("','' )");
if(stat.executeUpdate(sql.toString())>0){//添加到信息表
if(xinghaot.getText().toString().trim().length()>0){//此次不用检查是否新合同
StringBuffer sql1=new StringBuffer();
sql1.append("insert into hetongTable(yewuname,kehuname,huitime,xinghao,qiandingren,hetongzonge,zhifuyue,zhifujine,shoukuanren,qiandingriqi,zhifuriqi,hetongqixian) values('").append(yewuyuan.getSelectedItem().trim()).append("','").append(kehumingcheng.getText().trim()).append("','").append(huichangTime.getText().trim()).append("','").append(xinghaot.getText().trim()).append("','").append(qiandingrent.getText().trim()).append("','").append(hetongzonget.getText().trim()).append("','").append(zhifuyuet.getText().trim()).append("','").append(zhifujinet.getText().trim()).append("','").append(shoukuanrent.getText().trim()).append("','").append(qiandingriqit.getText().trim()).append("','").append(zhifuriqit.getText().trim()).append("','").append(hetongqixiant.getText().trim()).append("' )");
if(stat.executeUpdate(sql1.toString())>0){
StringBuffer sqler=new StringBuffer();
sqler.append("update yewuTab set hetong='1' where kehuname='").append(kehumingcheng.getText().trim()).append("'");//签订合同 修改yewuTab中的逻辑值为1
if(stat.executeUpdate(sqler.toString())>0){//
}
}
}
}
JOptionPane.showMessageDialog(null,"添加成功！");
}else{
JOptionPane.showMessageDialog(null,"添加失败！");
}
}
}else{
if(pizhu.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请填写批注内容！");
}else{
String timestr="";
//--------------------当前系统时间---------------------------------------
java.util.Date currentTime =new java.util.Date();
java.text.SimpleDateFormat formatter;
formatter=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
timestr+=formatter.format(currentTime);
//-----------------------------------------------------------------------
StringBuffer sql2=new StringBuffer();
sql2.append("update xinxiTable set pizhu='").append(pizhu.getText().trim()).append("',pizhutime='").append(timestr).append("' where yewuname='").append(yewuyuan.getSelectedItem().trim()).append("' and huitime='").append(huichangTime.getText().trim()).append("'");
if(zhongdian.isSelected()==true ){
StringBuffer sql3=new StringBuffer();
sql3.append("update yewuTab set zhongdian='1' where kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql3.toString())>0){
}
}else if(zhongdian.isSelected()==false){
StringBuffer sql3=new StringBuffer();
sql3.append("update yewuTab set zhongdian='0' where kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql3.toString())>0){
}
}
if(shibaiBox.isSelected()==true){
StringBuffer sql4=new StringBuffer();
sql4.append("update yewuTab set shibai='1' where kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql4.toString())>0){
}
}else if(shibaiBox.isSelected()==false){
StringBuffer sql5=new StringBuffer();
sql5.append("update yewuTab set shibai='0' where kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql5.toString())>0){
}
}
if(zuofeiBox.isSelected()==true){
StringBuffer sql5=new StringBuffer();
sql5.append("update yewuTab set zuofei='1' where hetong='1' and kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql5.toString())>0){
}else{
JOptionPane.showMessageDialog(null,"此客户尚未签订合同！");
}
}else if(zuofeiBox.isSelected()==false){
StringBuffer sql5=new StringBuffer();
sql5.append("update yewuTab set zuofei='0' where hetong='1' and kehuname='").append(kehumingcheng.getText().trim()).append("'");
if(stat.executeUpdate(sql5.toString())>0){
}else{
//JOptionPane.showMessageDialog(null,"此客户尚未签订合同！批注失败");
}
}
if(stat.executeUpdate(sql2.toString())>0){
JOptionPane.showMessageDialog(null,"批注成功！");
if(kehuChoice.getItem(kehuChoice.getItemCount()-1).indexOf("|")!=-1){
kehuChoice.remove(kehumingcheng.getText().trim());
chuchangChoice.removeAll();
chuchangChoice.add(" .");
chuchangTime.setText(null);
huichangTime.setText(null);
kehumingcheng.setText(null);
dizhi.setText(null);
lianxiren.setText(null);
dianhua.setText(null);
chuanzhen.setText(null);
beizhu.setText(null);
pizhu.setText(null);
xinghaot.setText(null);
qiandingrent.setText(null);
hetongzonget.setText(null);
zhifujinet.setText(null);
zhifuyuet.setText(null);
shoukuanrent.setText(null);
qiandingriqit.setText(null);
zhifuriqit.setText(null);
hetongqixiant.setText(null);
}
}else
JOptionPane.showMessageDialog(null,"批注失败，请重新操作！");
}
}
stat.close();
dbConn.close(); //关闭数据库连接
}catch(Exception ee) {
ee.printStackTrace();
}
}
}//else
}else if(e.getSource()==xiugaib){
if(name.equals("master")||name.equals("root")){
if(chuchangTime.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择出厂时间！");
}else if(huichangTime.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"请选择回厂时间！");
}else if(kehumingcheng.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"客户名称不允许为空");
}else if(dizhi.getText().trim().length()==0||dizhi.getText().trim().length()>25){
JOptionPane.showMessageDialog(null,"请检查客户联系地址25字内");
}else if(lianxiren.getText().trim().length()==0||lianxiren.getText().trim().length()>5){
JOptionPane.showMessageDialog(null,"请正确输入联系人姓名！5字内");
}else if(dianhua.getText().trim().length()==0||dianhua.getText().trim().length()>23){
JOptionPane.showMessageDialog(null,"请正确输入联系电话！");
}else if(beizhu.getText().trim().length()>500&&beizhu.getText().trim().length()==0){
JOptionPane.showMessageDialog(null,"备注内容不能为空且不能超过500字！");
}else if(chuanzhen.getText().trim().length()>16){
JOptionPane.showMessageDialog(null,"请正确输入传真号码16字内");
}else if(pizhu.getText().trim().length()>200){
JOptionPane.showMessageDialog(null,"批注内容超过200字");
}else if(kehumingcheng.getText().trim().length()==0||kehumingcheng.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"请正确输入客户名称！13字内");
}else if(xinghaot.getText().trim().length()>13){
JOptionPane.showMessageDialog(null,"请正确输入产品型号13字内");
}else if(qiandingrent.getText().trim().length()>4){
JOptionPane.showMessageDialog(null,"请正确输入签订人4字内");
}else if(hetongzonget.get⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -