package com.connor.chint.sap2.general;

import java.awt.Rectangle;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.swing.JComboBox;

import com.connor.chint.sap2.util.SqlUtil;
import com.teamcenter.rac.util.MessageBox;

public class GeneralManagementController {
	
		private GeneralManagementDialog dialog;
		//private List<String> names =new ArrayList<String>();
		//private List<String> bpNos =new ArrayList<String>();
		
		protected Map<String, List<String>> name_BpNos = new HashMap<String, List<String>>();
		
		
		// t.cgdpmpccode like '990101%'
		private static String SQL_QUERY_ALL="select t.GoodsName,t.GoodsBpNo from ccemvw_cgd t where 1=1 and t.Goodspmpccode like '220103001'"; 			
		private static String SQL_QUERY="select t.CompanyCodeStr,t.GoodsCode,t.GoodsName,t.GoodsBpNo,t.GoodsFullInfo,t.GoodsTeRe,t.GoodsUnitCode,t.GoodsPmpcCode from ccemvw_cgd t where 1=1 and t.Goodspmpccode like '220103001'"; 	
		public GeneralManagementController(GeneralManagementDialog dialog) {
			// TODO Auto-generated constructor stub
			this.dialog = dialog;
		}
		
		public boolean checkConn()
		{
			return SqlUtil.getConnection()==null?false:true;
		}
		
		
		
		
		
		public static void main(String[] args) {
			String sss = "7ZDB002-TJSJ001";
			int index =-1;
			for(int i=sss.length()-1;i>=0;i--)
			{
				if(sss.charAt(i)>'9'||sss.charAt(i)<'0')
				{
					index = i;
					break;
				}
			}
			System.out.println("ss1:"+sss.substring(0,index+1));
			
			System.out.println("ˮ:"+sss.substring(index+1));
			
			
			
			
		}
		public void queryAll() throws SQLException
		{
			ResultSet rs = SqlUtil.read(SQL_QUERY_ALL);
			List<String> names = new ArrayList<String>();
			while(rs.next())
			{
				String name= rs.getString(1);
				String bpNo= rs.getString(2);
				if(!names.contains(name))
				{
					names.add(name);
					List<String> lists = new ArrayList<String>();
					lists.add(bpNo);
					name_BpNos.put(name, lists);
					lists = null;
				}else
				{					
					if(!name_BpNos.get(name).contains(bpNo))
					{
						name_BpNos.get(name).add(bpNo);
					}
				}
				
				
				//GenPartBean bean =new GenPartBean(dialog.gp_lists.size()+1, companyCode, goodsCode, name, bpNo, goodsFullInfo, teRe, unitCode, pmpcCode);
				//dialog.gp_lists.add(bean);
			}
			if(!name_BpNos.isEmpty())
			{
				String name_s[] = new String[names.size()];
				names.toArray(name_s);
				dialog.j_Name = new JComboBox<String>(name_s);
				dialog.j_Name.setBounds(new Rectangle(119, 43, 95, 22));
				dialog.j_Name.setEditable(true);
				System.out.println("ֵ:"+dialog.j_Name.getSelectedItem());
				System.out.println("name_s[0]:"+name_s[0]);
				List<String> bpNos = name_BpNos.get(name_s[0]);
				String bpNo_s[] = new String[bpNos.size()];
				bpNos.toArray(bpNo_s);
				dialog.j_BpNo = new JComboBox<String>(bpNo_s);	
				dialog.j_BpNo.setBounds(new Rectangle(119, 43, 95, 22));
				dialog.j_BpNo.setEditable(true);
				System.out.println("ͨü");
			}else
			{
				dialog.j_Name = new JComboBox<String>();
				dialog.j_Name.setBounds(new Rectangle(119, 43, 95, 22));
				dialog.j_Name.setEditable(true);
				dialog.j_BpNo = new JComboBox<String>();
				dialog.j_BpNo.setBounds(new Rectangle(119, 43, 95, 22));
				dialog.j_BpNo.setEditable(true);
			}		
		}
		
		//ˢ±
		public void refreshData(List<GenPartBean> beans) {

			dialog.tm_part.getDataVector().clear();
			dialog.t_part.clearSelection();
			dialog.t_part.revalidate();
			dialog.t_part.repaint();
			//beans.clear();
			for (GenPartBean b : beans) {
				dialog.tm_part.addRow(b.readData());
			}
			dialog.t_part.revalidate();
		}
		
		public void addRow(GenPartBean bean)
		{
			String bpNo = bean.getBpNo();
			if(bpNo.trim().length()==0)
			{
				return;
			}
			int index = -1;
			for(int i=bpNo.length()-1;i>=0;i--)
			{
				if(bpNo.charAt(i)>'9'||bpNo.charAt(i)<'0')
				{
					index = i;
					break;
				}
			}
			if(index ==-1)
			{
				MessageBox.post("","",MessageBox.WARNING);
				return ;
			}
			String qz = bpNo.substring(0,index+1);
			String num = bpNo.substring(index+1);
			
			
			
		}
		
		public void doQuery() throws SQLException
		{
			String bpno = (String) dialog.j_BpNo.getSelectedItem();
			String name = (String) dialog.j_Name.getSelectedItem();
			String spec = dialog.j_spec.getText();
			StringBuilder sql = new StringBuilder(SQL_QUERY);
			List<String> objs = new ArrayList<String>();
			if(bpno!=null && !bpno.equals(""))
			{
				sql.append(" and t.GoodsBpNo = ? ");
				objs.add(bpno);
			}
			if(name!=null && !name.equals(""))
			{
				sql.append(" and t.GoodsName = ? ");
				objs.add(name);
			}
			if(spec!=null && !spec.equals("") && !spec.equals("*"))
			{
				sql.append(" and t.GoodsFullInfo like ? ");
				objs.add(getRep(spec,true));
			}
			System.out.println("query_SQL:"+sql.toString());
			System.out.println(objs);
			ResultSet rs = SqlUtil.read(objs.toArray(), sql.toString());
			dialog.gp_lists.clear();
			while(rs.next())
			{
				String companyCode = rs.getString(1);
				String goodsCode= rs.getString(2);
				String name2= rs.getString(3);
				String bpNo= rs.getString(4);
				String goodsFullInfo= rs.getString(5);			
				String teRe= rs.getString(6);
				String unitCode= rs.getString(7);
				String pmpcCode= rs.getString(8);
				GenPartBean bean =new GenPartBean(dialog.gp_lists.size()+1, companyCode, goodsCode, name2, bpNo, goodsFullInfo, teRe, unitCode, pmpcCode);
				System.out.println("鵽һ");
				dialog.gp_lists.add(bean);
		}
			refreshData(dialog.gp_lists);
			objs=null;
		}
		
		public String getRep(String str,boolean flag)
		{
			StringBuilder stb = new StringBuilder();
			if(!flag)
			{
				return str.replace("*", "%");
			}
			
			if(!str.startsWith("*"))
			{
				stb.append("%");

			}
			stb.append(str.trim());
			if(!str.endsWith("*"))
			{
				stb.append("%");
			}
			str = (stb.toString()).replace("*", "%");
			return str;
		}
		
}
