singleuserserviceimpl.java

来自「移动彩信管理平台」· Java 代码 · 共 94 行

package com.my7g.zj.mobile.mms.business.service;

import java.util.List;

import com.my7g.zj.mobile.mms.business.ISingleUserService;
import com.my7g.zj.mobile.mms.mapping.TbCjdxBusinessInfo;
import com.my7g.zj.mobile.mms.mapping.TbCjdxScoreTotal;
import com.my7g.zj.mobile.mms.mapping.TbCjdxUserHistory;
import com.my7g.zj.mobile.mms.mapping.TbCjdxUserInfo;
import com.my7g.zj.mobile.mms.sys.BasicDao;

public class SingleUserServiceImpl extends BasicDao implements ISingleUserService{

	public boolean annulAccount(long mobile, short userType) {
		StringBuffer sb = new StringBuffer();
		sb.append("INSERT INTO cmpp_deliver(msg_id,service_id,msg_fmt,src_terminal_id,");
		sb.append("src_phone,msg_length,msg_content,linkid,dest_terminal_id)");
		sb.append("Values(");
		sb.append("NULL,'',0,");
		sb.append(mobile);
		sb.append(",");
		sb.append(mobile);
		sb.append(",4,convert(varbinary(255),'X_X");
		sb.append(userType);
		sb.append("'),null,null)");
		System.out.println(sb.toString());
		int flag = jdbcTemplate.update(sb.toString());
		return flag > 0;
	}

	public List<TbCjdxUserHistory> getUserInfoList(long mobile) {
		List<TbCjdxUserHistory> list = find(
				" from TbCjdxUserHistory t where t.phone = "+mobile);
		
		return list;
	}

	public TbCjdxScoreTotal getUserScore(long mobile) {
		List<TbCjdxScoreTotal> list = find(" from TbCjdxScoreTotal where mobile = "+mobile);
		TbCjdxScoreTotal info = list.isEmpty()?null:list.get(0);
		return info;
	}

	public boolean openAccount(long mobile, short userType) {
		StringBuffer sb = new StringBuffer();
		sb.append("INSERT INTO cmpp_deliver(msg_id,service_id,msg_fmt,src_terminal_id,");
		sb.append("src_phone,msg_length,msg_content,linkid,dest_terminal_id)");
		sb.append("Values(");
		sb.append("NULL,'',0,");
		sb.append(mobile);
		sb.append(",");
		sb.append(mobile);
		sb.append(",4,convert(varbinary(255),'K_K");
		sb.append(userType);
		sb.append("'),null,null)");
		System.out.println(sb.toString());
		int flag = jdbcTemplate.update(sb.toString());
		return flag > 0;
	}

	public TbCjdxUserInfo getUserInfo(long mobile) {
		System.out.println(mobile+" getUserInfo");
		List<TbCjdxUserInfo> list = find("from TbCjdxUserInfo t where t.phone = "+mobile);
		TbCjdxUserInfo info = null;
		if(!list.isEmpty()){
			info = list.get(0);
			info.setTypeId((long)getUserType(info.getTypeId()));
		}
		return info;
	}
	private int getUserType(long typeId){
		long nmasks = 0x000000FFC0000000L;
		if ((typeId & nmasks)==0)
			return 0;
		else 
			return 1;
		
	}
//	public static void main(String[] args) {
//		long i = 5000;
//		int nmasks = 0xFFFFFFF;
//		long j = i | nmasks;
//		j = j<<32;
//		j = j>>31;
//		System.out.println(j);
//	}

	public List<TbCjdxBusinessInfo> getBusinessList() {
		List<TbCjdxBusinessInfo> list = find("from TbCjdxBusinessInfo t where sequence >30 and sequence <40");
		
		return list;
	}
}