package com.wgh.dao;

import java.lang.*;
import java.io.*;
import BestMail.smssend;
import java.sql.*;
import java.util.*;

import com.wgh.actionForm.PersonnelForm;
import com.wgh.actionForm.SendLetterForm;
import com.wgh.core.ConnDB;

public class SendLetterDAO {
	private ConnDB conn=new ConnDB();
	private smssend smssendinformation = null;
	// 發送短信
	public String sendLetter(SendLetterForm s) {
		String ret = "";
		String device="";
		String baud="";
		String sn="";
		String info="";
		String sendnum="";
		String flag="";
		try {
			String sql_p="SELECT top 1 * FROM tb_parameter";
			ResultSet rs=conn.executeQuery(sql_p);
			if(rs.next()){
				device=rs.getString(2);
				baud=rs.getString(3);
				sn=rs.getString(4);
				info=s.getContent();
				sendnum=s.getToMan();
				System.out.println("SN:"+sn+"***********"+info);
				flag=mySend(device,baud,sn,info,sendnum);//發送短信
				if(flag.equals("ok")){
		            String sql = "INSERT INTO tb_shortLetter (toMan,content,fromMan) values('" +s.getToMan() +"','"+s.getContent()+"','"+s.getFromMan()+"')";
		            int r= conn.executeUpdate(sql);
		            System.out.println("添加短信發送歷史記錄的SQL：" + sql);
		            if(r==0){
		            	ret="添加短信發送歷史記錄失?。?quot;;
		            }else{
		            	ret="ok";
		            }
				}else{
					ret=flag;
				}				
			}else{
				ret="發送短信失?。?quot;;
			}
		} catch (Exception e) {
			System.out.println("發送短信產生的錯誤：" + e.getMessage());
			ret = "發送短信失??！";
		}finally{
			conn.close();
		}
		return ret;
	}
	
	// 初始化GSM Modem設備
	public boolean getConnectionModem(String device,String baud,String sn) {
		smssendinformation = new smssend();
		boolean connection = true;
		if (!smssendinformation.GSMModemInitNew(device, baud, null, "GSM",
			false, sn)) {
			System.out.println("初始化GSM Modem 設備失敗："
					+ smssendinformation.GSMModemGetErrorMsg());
			connection = false;
		}
		return connection;	
	}
	// 發送手機短信的方法
	public String mySend(String device,String baud,String sn,String info, String sendnum) {
		boolean flag = false;
		String rtn="";
		flag=this.getConnectionModem(device,baud,sn);

		if(flag){
			byte[] sendtest = smssendinformation.getUNIByteArray(info); // 轉化為UNICOCE		
			//實現群發
			String[] arrSendnum=sendnum.split(",");
			for(int i=0;i<arrSendnum.length;i++){
				if (!smssendinformation.GSMModemSMSsend(null, 8, sendtest, arrSendnum[i],false)) {
					System.out.println("發送短信失?。?quot;
							+ smssendinformation.GSMModemGetErrorMsg());
					rtn =rtn+"向"+arrSendnum[i]+"發送短信失敗!<br>原因是："+smssendinformation.GSMModemGetErrorMsg()+"<br>";
				}
			}
		}else{
			rtn="初始化GSM Modem設備失?。?quot;;
		}
		if(rtn.equals("")){
			rtn="ok";
		}
		closeConnection();		//關閉連接
		return rtn;
	}
	// 關閉連接的方法
	public void closeConnection() {
		if (smssendinformation != null) {
			smssendinformation.GSMModemRelease();
			System.out.println("關閉成功?。?！");
		}

	}	
    //查詢方法
    public List query(){
    	List personnelList = new ArrayList();
        SendLetterForm s = null;
        String sql = "SELECT * FROM tb_shortLetter";
        ResultSet rs = conn.executeQuery(sql);
        String ss="";
        try {
            while (rs.next()) {
                s = new SendLetterForm();
                s.setID(rs.getInt(1));
                s.setToMan(rs.getString(2));
                s.setContent(rs.getString(3));
                s.setFromMan(rs.getString(4));
                ss=rs.getString(5);
                 s.setSendTime(java.text.DateFormat.getDateTimeInstance().parse(ss));//將String型字符串轉換成java.util.Date型
                personnelList.add(s);
            }
        } catch (Exception ex) {
        	System.out.println(ex.getMessage());
        }
        return personnelList;
    }
    //接收短信
    public List getLetter(){
    	List list=new ArrayList();
		String device="";
		String baud="";
		String sn="";
		try {
			String sql_p="SELECT top 1 * FROM tb_parameter";
			ResultSet rs=conn.executeQuery(sql_p);
			if(rs.next()){
				device=rs.getString(2);
				baud=rs.getString(3);
				sn=rs.getString(4);
				list=myGet(device,baud,sn);//接收短信
			}else{
				System.out.println("接收短信失敗");
			}
		} catch (Exception e) {
			System.out.println("接收短信產生的錯誤：" + e.getMessage());
		}finally{
			conn.close();
		}
    	return list;
    }
    //接收短信的方法
    public List myGet(String device,String baud,String sn) {
		boolean flag = false;
		flag=this.getConnectionModem(device,baud,sn);
		List list=new ArrayList();
		if(flag){
			String[] allmsg = smssendinformation.GSMModemSMSReadAll(1);
	        // 讀出的每一條信息由三部分組成：電話號碼#編碼#文本內容
	        for (int kk = 0; allmsg != null && kk < allmsg.length; kk++) {
	        	if (allmsg[kk] == null) continue;
	        	String[] tmp = allmsg[kk].split("#");
	        	if (tmp == null || tmp.length != 3) continue;
	        	//獲取數據
	        	String codeflg = tmp[1];	//編碼
	        	String recvtext = tmp[2];	//短信內容
	        	if (recvtext != null && codeflg.equalsIgnoreCase("8")){
	        		recvtext = smssendinformation.HexToBuf(recvtext);//得到Java的短信文本字符串
	        	}
	        	tmp[2]=recvtext;
	        	System.out.println("短信內容："+recvtext);
	        	list.add(tmp);
	        } 
		}
		closeConnection();		//關閉連接
		return list;
	}
}