sellmanage.java

一个基于JAVA技术的销售信息管理系统

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import org.eclipse.swt.SWT;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Combo;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.TableItem;
import org.eclipse.swt.widgets.Text;
import org.eclipse.swt.widgets.MessageBox;
import com.swtdesigner.SWTResourceManager;


public class SellManage extends Composite {

	private Text text;
	private Combo combo_1;
	private Combo combo;
	private Table table;
	private String id;
	private String pwd;
	
	private MessageBox messageBox;
	private String name	=	"";
	private boolean lastsearch	=	true;
	private int searchstyle	=	0;
//	private MessageBox messageBox;
	/**
	 * Create the composite
	 * @param parent
	 * @param style
	 */
	public SellManage(final Composite parent, int style,final String id,final String pwd) {
		super(parent, style);
		this.id		=	id;
		this.pwd	=	pwd;
		this.setBounds(0, 0, 699, 470);
		
		table = new Table(this, SWT.MULTI | SWT.FULL_SELECTION | SWT.BORDER);
		table.setLinesVisible(true);
		table.setHeaderVisible(true);
		table.setBounds(55, 170, 602, 280);

		final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);
		newColumnTableColumn.setWidth(65);
		newColumnTableColumn.setText("销售编号");

		final TableColumn newColumnTableColumn_1 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_1.setWidth(65);
		newColumnTableColumn_1.setText("产品名称");

		final TableColumn newColumnTableColumn_2 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_2.setWidth(65);
		newColumnTableColumn_2.setText("客户姓名");

		final TableColumn newColumnTableColumn_3 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_3.setWidth(65);
		newColumnTableColumn_3.setText("销售人员");

		final TableColumn newColumnTableColumn_4 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_4.setWidth(70);
		newColumnTableColumn_4.setText("销售日期");

		final TableColumn newColumnTableColumn_5 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_5.setWidth(51);
		newColumnTableColumn_5.setText("单价");

		final TableColumn newColumnTableColumn_6 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_6.setWidth(52);
		newColumnTableColumn_6.setText("进货价");

		final TableColumn newColumnTableColumn_7 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_7.setWidth(54);
		newColumnTableColumn_7.setText("销售量");

		final TableColumn newColumnTableColumn_8 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_8.setWidth(65);
		newColumnTableColumn_8.setText("销售总额");

		final TableColumn newColumnTableColumn_9 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_9.setWidth(45);
		newColumnTableColumn_9.setText("盈利");

		final Button button = new Button(this, SWT.NONE);
		button.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				AddSell addSell = new AddSell(parent.getShell(),id,pwd);
				addSell.open();
				table.clearAll();
				table.removeAll();
			}
		});
		button.setText("添加销售信息");
		button.setBounds(55, 70, 85, 22);

		final Button button_1 = new Button(this, SWT.NONE);
		button_1.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				if(table.getSelectionIndices().length>1)
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
					messageBox.setMessage("只能选择 1 条查询记录");
					messageBox.setText("修改销售信息");
					messageBox.open();
				}
				else
					if(table.getSelectionIndices().length<1)
					{
						messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
						messageBox.setMessage("请选择 1 条查询记录");
						messageBox.setText("修改销售信息");
						messageBox.open();
					}
					else
					{
						TableItem temp = table.getItems()[table.getSelectionIndex()];
						int sid	=	Integer.parseInt(temp.getText(0));
						
						EditSell editSell = new EditSell(parent.getShell(),id,pwd,sid);
						editSell.open();

						searchSell(searchstyle,name,lastsearch);
					}
			}
		});
		button_1.setText("修改销售信息");
		button_1.setBounds(146, 70, 85, 22);

		final Button button_2 = new Button(this, SWT.NONE);
		button_2.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				
				if(table.getSelectionIndices().length<1)
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
					messageBox.setMessage("请选择至少 1 条查询记录");
					messageBox.setText("删除客户信息");
					messageBox.open();
				}
				else
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_QUESTION|SWT.OK|SWT.CANCEL);
					messageBox.setMessage("确定要删除这 " + table.getSelectionIndices().length + " 条记录吗？");
					messageBox.setText("删除确认");
					if(messageBox.open() == SWT.OK)
					{
						String del_id = "";
						for(int i = 0; i < table.getSelectionIndices().length;)
						{
							TableItem temp = table.getItems()[table.getSelectionIndices()[i]];
							del_id	=	del_id + "'" +temp.getText(0) + "'";
							i++;
							if(i < table.getSelectionIndices().length)
								del_id = del_id + ",";
							
						}
						
						delSell(del_id);
						
						searchSell(searchstyle,name,lastsearch);
						
						messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
						messageBox.setMessage("成功删除 " + table.getSelectionIndices().length + " 条记录");
						messageBox.setText("删除");
						messageBox.open();

					}
				}
			}
		});
		button_2.setText("删除销售信息");
		button_2.setBounds(237, 70, 85, 22);

		final Label label = new Label(this, SWT.SEPARATOR | SWT.HORIZONTAL);
		label.setBounds(0, 45, 700, 2);

		text = new Text(this, SWT.BORDER);
		text.setBounds(275, 128, 102, 20);

		final Label label_5 = new Label(this, SWT.RIGHT);
		label_5.setText("请输入工作人员姓名");
		label_5.setBounds(146, 131, 119, 17);

		label_5.setVisible(false);
		text.setVisible(false);
		
		combo = new Combo(this, SWT.READ_ONLY);
		combo.setItems(new String[] {"按产品名称", "按客户姓名", "按工作人员姓名"});
		combo.setBounds(275, 105, 102, 20);
		combo.addSelectionListener(new SelectionAdapter(){
			public void widgetSelected(final SelectionEvent e) {
				
				if(combo.getSelectionIndex() == 0)
					label_5.setText("请输入产品名称");
				else
					if(combo.getSelectionIndex() == 1)
						label_5.setText("请输入客户姓名");
					else
						if(combo.getSelectionIndex() == 2)
							label_5.setText("请输入工作人员姓名");
				label_5.setVisible(true);
				text.setVisible(true);
			}
		});

		final Label label_1 = new Label(this, SWT.NONE);
		label_1.setFont(SWTResourceManager.getFont("宋体", 11, SWT.NONE));
		label_1.setText("查询销售情况：");
		label_1.setBounds(55, 108, 102, 17);

		combo_1 = new Combo(this, SWT.READ_ONLY);
		combo_1.setItems(new String[] {"精确查询", "模糊查询"});
		combo_1.setBounds(455, 105, 85, 20);

		final Label label_2 = new Label(this, SWT.NONE);
		label_2.setAlignment(SWT.RIGHT);
		label_2.setFont(SWTResourceManager.getFont("宋体", 11, SWT.NONE));
		label_2.setText("请选择查询字段");
		label_2.setBounds(145, 108, 120, 17);

		final Label label_3 = new Label(this, SWT.NONE);
		label_3.setFont(SWTResourceManager.getFont("宋体", 11, SWT.NONE));
		label_3.setAlignment(SWT.RIGHT);
		label_3.setText("查询方式");
		label_3.setBounds(383, 108, 64, 17);

		final Button button_6 = new Button(this, SWT.NONE);
		button_6.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				if((combo.getSelectionIndex() == 0 ||combo.getSelectionIndex() == 1 || combo.getSelectionIndex() == 2)
						&& (combo_1.getSelectionIndex() == 0 ||combo_1.getSelectionIndex() == 1))
				{
					table.clearAll();
					table.removeAll();
					
					searchstyle	=	combo.getSelectionIndex();
					name = text.getText();
					lastsearch	=	(combo_1.getSelectionIndex() == 0);
					searchSell(searchstyle,name,lastsearch);

					messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
					messageBox.setMessage("共找到 " + table.getItemCount() + " 条记录");
					messageBox.setText("查询销售信息");
					messageBox.open();
				}
				else
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
					messageBox.setMessage("请选择[查询字段] 与 [查询方式]");
					messageBox.setText("查询销售信息");
					messageBox.open();
				}
			}
		});
		button_6.setText("查  询");
		button_6.setBounds(557, 104, 85, 22);

		final Label label_4 = new Label(this, SWT.NONE);
		label_4.setFont(SWTResourceManager.getFont("经典行楷繁", 22, SWT.NONE));
		label_4.setAlignment(SWT.CENTER);
		label_4.setText("销售信息管理平台");
		label_4.setBounds(0, 10, 700, 29);

		//
		
	}

	public void searchSell(int style,String name,boolean exact){//sql
		Connection con;
		try{
			table.clearAll();
			table.removeAll();
			DBCon dbc = new DBCon();
			con = DriverManager.getConnection(dbc.url,id,pwd);
			CallableStatement cs = con.prepareCall("{call dbo.sp_SearchSell(?,?,?)}");
			ResultSet rs;
			cs.setInt(1, style);
			if(exact)
				cs.setInt(2, 0);
			else
				cs.setInt(2, 1);
			cs.setString(3, name);
			cs.execute();
			rs = cs.getResultSet();
			while( rs.next())
			{
				new TableItem(table, SWT.BORDER);
				table.getItem(table.getItemCount()-1).setText(new String[]{rs.getString("ID"),rs.getString("ProductName"),
						rs.getString("CustomerName"),rs.getString("StaffName"),rs.getString("SellDateTime"),rs.getString("Price"),
						rs.getString("Cost"),rs.getString("SellCount"),rs.getString("TotalPrice"),rs.getString("Gain")});
			}
			dbc.dbClose(con,rs);
		}
		catch(Exception e){
			
			e.printStackTrace();
		}
	}


	public void delSell(String s_id){
		Connection con;
		try{
			DBCon dbc = new DBCon();
			con = DriverManager.getConnection(dbc.url,id,pwd);
			CallableStatement cs = con.prepareCall("{call dbo.sp_DelSell(?)}");
			cs.setString(1, s_id);
			cs.execute();
			dbc.dbClose(con);
		}
		catch(Exception e){
			
			e.printStackTrace();
		}
	}
}