UserInfo.java

package coolbuy360.logic;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import coolbuy360.logic.ConstantsSetting;
import coolbuy360.service.CommandResult;
import android.content.Context;

public class UserInfo {
	
	private static UserInfo userInfo;
	
	/**
	 * ˽�й��캯������֤����ģʽ
	 * 
	 * @param context
	 */
	private UserInfo() {

	}

	/**
	 * ��ȡ��������
	 * 
	 * @param context
	 * @return
	 */

	public static UserInfo getUserInfoInstance() {
		if (userInfo == null) {
			userInfo = new UserInfo();
		}
		return userInfo;
	}

	/**
	 * ����memberId��ѯ��Ա��ϸ��Ϣ������һ����¼
	 * 
	 * @param memberId��Աid
	 * @return
	 */
	public List<Map<String, String>> getUserInfo(int memberId) {
		String strQL = ConstantsSetting.QLGetUserInfo;
		strQL = String.format(strQL, memberId);
		return ConstantsSetting.qLGetList(0, 0, strQL, null);
	}
	
//	update Table set a=1,b=2,c=$c$ where id=1 and id=2 or name=$name$ and name^���� ģ����ѯ 
//	public static String QLSetUserInfo=" UPDATE [DrugCenter].[dbo].[USR_Member] SET "
//				+"USR_Member.MemberName='%1$s' "
//				+",USR_Member.Email='%2$s'"
//				+",USR_Member.Mobile='%3$s'"
//				+",USR_Member.Sex='%4$s'"
//				+",USR_Member.Job='%5$s'"
//				+",USR_Member.HC='%6$s'"
//				+",USR_Member.Income='%7$s'"
//				+",USR_Member.BuyWay='%8$s'"
//				+",USR_Member.FamilyAddress='%9$s'"
//				+",USR_Member.IdCardNum='%10$s'"
//				+",USR_Member.Birthday='%11$s'"
//				+",USR_Member.Telephone='%12$s'"
//				+",USR_Member.EducationLevel='%13$s'"
//				+",USR_Member.CommonHospital='%14$s'" 
//				+"where UserName='%15$s'  " ;
	
	/***
	 * ִ�и����û���ϸ��Ϣ(map��������)		
	 */
	public  Boolean updateUserInfo(Map<String,String> userInfoMap)
	{
		String strQL=ConstantsSetting.QLSetUserInfo;
		Map<String, String> postValue=new HashMap<String, String>();
		if(!userInfoMap.isEmpty())
		{
//			strQL=String .format(strQL,userInfoMap.get("membername"), userInfoMap.get("email"),userInfoMap.get("mobile"),userInfoMap.get("sex"),
//					userInfoMap.get("job"),userInfoMap.get("hc"),userInfoMap.get("income"),userInfoMap.get("buyway"),userInfoMap.get("familyaddress"),
//					userInfoMap.get("idcardnum"),userInfoMap.get("birthday"),userInfoMap.get("telephone"),userInfoMap.get("educationlevel"),
//					userInfoMap.get("commonhospital"),userInfoMap.get("username")
//			)
			postValue=userInfoMap;			
		}		
		return ConstantsSetting.qlUpdate(strQL, postValue);
	}
	
	/**
	 * �����û�����ϸ��Ϣ������������
	 * @param memberName
	 *        ����
	 * @param Sex
	 *         �Ա�
	 * @param IdCardNum
	 *        ���֤��
	 * @param Birthday
	 *        ��������  
	 * @param Mobile
	 *        �ֻ�
	 * @param TelePhone
	 *        �绰����
	 * @param Email 
	 *        ����
	 * @param FamilyAddress
	 *        ��ͥסַ
	 * @param EducationLevel
	 *         �������
	 * @param Job
	 *        ����
	 * @param HC
	 *        �Ƿ�ҽ����ȡֵΪ ��1���� 2���� 3��
	 * @param Income
	 *        ҽ��֧��
	 * @param BuyWay
	 *        ����;��
	 * @param CommonHospital
	 *        ��ѡҽԺ
	 *@param userName
	 *       �û�����Ψһ��־����
	 * @return
	 */
	public Boolean updateUserInfo2(Context context, String memberName,String Sex,String IdCardNum,String Birthday,String Mobile,String TelePhone, String Email, String FamilyAddress,
			String EducationLevel, String Job,String HC,String Income,String BuyWay,String CommonHospital,String memberid)
	{	
		//String strQL=ConstantsSetting.QLSetUserInfo;
		Map<String, String> postValue=new HashMap<String, String>();	
		String QLSetUserInfo=" UPDATE USR_Member SET "
			+"MemberName=$membername$ "
			+",Email=$email$"
			+",Mobile=$mobile$"
			+",Sex=$sex$"
			+",Job=$job$"
			+",HC=$hc$"
			+",Income=$income$"
			+",BuyWay=$buyway$"
			+",FamilyAddress=$familyaddress$"
			+",IdCardNum=$idcardnum$";	
		if(!Birthday.equals(""))
		{
			QLSetUserInfo=QLSetUserInfo+",Birthday=$birthday$";
			postValue.put("birthday", Birthday);
		}
		QLSetUserInfo=QLSetUserInfo	+",Telephone=$telephone$"
			+",EducationLevel=$educationlevel$"
			+",CommonHospital=$commonhospital$" 
			+"  where MemberID=$memberid$  " ;			
		postValue.put("membername", memberName);
		postValue.put("sex", Sex);
		postValue.put("idcardnum", IdCardNum);	
		postValue.put("mobile", Mobile);
		postValue.put("telephone", TelePhone);
		postValue.put("email", Email);
		postValue.put("familyaddress", FamilyAddress);
		postValue.put("educationlevel", EducationLevel);
		postValue.put("job", Job);
		postValue.put("hc", HC);
		postValue.put("income", Income);
		postValue.put("buyway", BuyWay);
		postValue.put("commonhospital", CommonHospital);
		postValue.put("memberid", memberid);
		Boolean resultBoolean = ConstantsSetting.qlUpdate(QLSetUserInfo, postValue);
		// �����³ɹ�������±��ػ������ݡ�
		if (resultBoolean) {
			try {
				User iuser = new User(context);
				iuser.setValue("MemberName", memberName);
				iuser.setValue("Email", Email);
				iuser.setValue("Mobile", Mobile);
				iuser.setValue("Sex", Sex);
				iuser.setValue("Job", Job);
				iuser.setValue("HC", HC);
				iuser.setValue("Income", Income);
				iuser.setValue("BuyWay", BuyWay);
				iuser.setValue("FamilyAddress", FamilyAddress);
				iuser.setValue("IdCardNum", IdCardNum);
				iuser.setValue("Birthday", Birthday);
				iuser.setValue("Telephone", TelePhone);
				iuser.setValue("EducationLevel", EducationLevel);
				iuser.setValue("CommonHospital", CommonHospital);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				return resultBoolean;
			}
		}
		return resultBoolean;
	}
	
	/**
	 * �����û�����ϸ��Ϣ������������
	 * @param memberName
	 *        ����
	 * @param Sex
	 *         �Ա�
	 * @param IdCardNum
	 *        ���֤��
	 * @param Birthday
	 *        ��������  
	 * @param Mobile
	 *        �ֻ�
	 * @param TelePhone
	 *        �绰����
	 * @param Email 
	 *        ����
	 * @param FamilyAddress
	 *        ��ͥסַ
	 * @param EducationLevel
	 *         �������
	 * @param Job
	 *        ����
	 * @param HC
	 *        �Ƿ�ҽ����ȡֵΪ ��1���� 2���� 3��
	 * @param Income
	 *        ҽ��֧��
	 * @param BuyWay
	 *        ����;��
	 * @param CommonHospital
	 *        ��ѡҽԺ
	 *@param userName
	 *       �û�����Ψһ��־����
	 * @return
	 */
	public CommandResult updateUserInfo(Context context, String memberName,String Sex,String IdCardNum,String Birthday,String Mobile,String TelePhone, String Email, String FamilyAddress,
			String EducationLevel, String Job,String HC,String Income,String BuyWay,String CommonHospital,String memberid) {
		String strQL="plugin DrugCenter.Logic.V1 Member Update("
			+"$membername$"
			+",$email$"
			+",$mobile$"
			+",$sex$"
			+",$job$"
			+",$hc$"
			+",$income$"
			+",$buyway$"
			+",$familyaddress$"
			+",$idcardnum$"	
			+",$birthday$"
			+",$telephone$"
			+",$educationlevel$"
			+",$commonhospital$" 
			+",$memberid$)";		

		Map<String, String> postValue = new HashMap<String, String>();
		postValue.put("birthday", Birthday);
		postValue.put("membername", memberName);
		postValue.put("sex", Sex);
		postValue.put("idcardnum", IdCardNum);	
		postValue.put("mobile", Mobile);
		postValue.put("telephone", TelePhone);
		postValue.put("email", Email);
		postValue.put("familyaddress", FamilyAddress);
		postValue.put("educationlevel", EducationLevel);
		postValue.put("job", Job);
		postValue.put("hc", HC);
		postValue.put("income", Income);
		postValue.put("buyway", BuyWay);
		postValue.put("commonhospital", CommonHospital);
		postValue.put("memberid", memberid);
		
		List<Map<String, String>> result = ConstantsSetting.qLGetList(0, 0,
				strQL, postValue);
		if (result != null && result.size() > 0) {
			Map<String, String> values = result.get(0);
			CommandResult commandResult = new CommandResult(
					values.get("result"), values.get("message"));
			commandResult.setOriginalResult(values);
			return commandResult;
		}
		CommandResult commandResult = new CommandResult("false", "δ֪����");
		return commandResult;
	}
}