servicemanage.java

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

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

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.MessageBox;
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 com.swtdesigner.SWTResourceManager;


public class ServiceManage 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 sellIDstr	=	new String();//
	private String name	=	"";
	private boolean lastsearch	=	false;
	private int searchstyle	=	0;
	private String[] sertype	=new String[] {"咨询", "维修", "更换", "投诉"};
	/**
	 * Create the composite
	 * @param parent
	 * @param style
	 */
	public ServiceManage(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(70);
		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(65);
		newColumnTableColumn_4.setText("服务类型");

		final TableColumn newColumnTableColumn_5 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_5.setWidth(133);
		newColumnTableColumn_5.setText("详细情况");

		final TableColumn newColumnTableColumn_7 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_7.setWidth(55);
		newColumnTableColumn_7.setText("已完成");

		final TableColumn newColumnTableColumn_6 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_6.setWidth(79);
		newColumnTableColumn_6.setText("客户满意度");

		final Button button = new Button(this, SWT.NONE);
		button.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				AddService addService = new AddService(parent.getShell(),id,pwd);
				addService.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));
						
						getSellID(sID);

						System.out.println(sellIDstr);
						String staffName	=	temp.getText(3);
						
						int type	=	0;
						for(int i = 0;i < sertype.length;i++)
							if(sertype[i].equals(temp.getText(4)))
							{
								type	=	i;
							}
						
						String descrip	=	temp.getText(5);

						EditService editService;
						boolean completed;
						if(temp.getText(6).equals("是"))
						{
							completed = true;
							int satisfy	=	Integer.parseInt(temp.getText(7));
							editService = new EditService(parent.getShell(),id,pwd,sID,sellIDstr,staffName,
									type,completed,satisfy,descrip);
						}
						else 
							{
								completed = false;
								editService = new EditService(parent.getShell(),id,pwd,sID,sellIDstr,staffName,
										type,completed,descrip);
							}
						
						editService.open();

						searchService(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 + ",";
							
						}
						delService(del_id);

						searchService(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);

		final Label label_5 = new Label(this, SWT.RIGHT);
		label_5.setBounds(146, 131, 104, 17);
		
		combo = new Combo(this, SWT.READ_ONLY);
		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("请输入客户姓名");
						else
							if(combo.getSelectionIndex() == 3)
								label_5.setText("请输入工作人员姓名");
				
				label_5.setVisible(true);
				text.setVisible(true);
			}
		});
		combo.setItems(new String[] {"按售后编号", "按产品名称", "按客户姓名", "按工作人员姓名"});
		combo.setBounds(260, 105, 109, 20);

		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, 80, 17);

		combo_1 = new Combo(this, SWT.READ_ONLY);
		combo_1.setItems(new String[] {"精确查询", "模糊查询"});
		combo_1.setBounds(460, 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(130, 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(380, 108, 66, 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.getSelectionIndex() == 3) && (combo_1.getSelectionIndex() == 0 ||combo_1.getSelectionIndex() == 1))
				{
					table.clearAll();
					table.removeAll();
					
					searchstyle	=	combo.getSelectionIndex();
					name = text.getText();
					lastsearch	=	(combo_1.getSelectionIndex() == 0);
					searchService(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(565, 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);
		this.setVisible(true);

		text = new Text(this, SWT.BORDER);
		text.setBounds(260, 128, 109, 20);

		//
		
	}


	public void getSellID(int sID){//sql
		Connection con;
		Statement stmt;
		try{
			DBCon dbc = new DBCon();
			con = DriverManager.getConnection(dbc.url,id,pwd);
			stmt = con.createStatement();
			String query = "select SellID from Service where ID = "+sID+";";
			ResultSet rs = stmt.executeQuery(query);
			while( rs.next()){
				
				sellIDstr = new String(rs.getString("SellID"));

			}
			dbc.dbClose(con,rs);
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public void searchService(int style,String name,boolean exact){//sql
		Connection con;
		String done	=	"是";
		try{
			table.clearAll();
			table.removeAll();
			DBCon dbc = new DBCon();
			con = DriverManager.getConnection(dbc.url,id,pwd);
			CallableStatement cs = con.prepareCall("{call dbo.sp_SearchService(?,?,?)}");
			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())
			{
				if(rs.getString("Completed").equals("1"))
					done	=	"是";
				else
					done	=	"否";
				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"),sertype[Integer.parseInt(rs.getString("Type"))],rs.getString("Description"),
						done,rs.getString("Satisfy")});
			}
			dbc.dbClose(con,rs);
		}
		catch(Exception e){
			
			e.printStackTrace();
		}
	}

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