test/Member/CoreEntity/DAL/AccountDAL.cs

using Common.Model;
using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class AccountDAL
    {
        /// <summary>
        /// 
        /// ContactId
        /// </summary>
        /// <param name="PushAccountId"></param>
        /// <param name="BusinessId"></param>
        /// <returns></returns>
        public static string getContactor(string PushAccountId,string BusinessId)
        {
            string commandTextContact = "Select ContactId From CONTACTDOC " +
                "Where UserId=@Id and BusinessId = @BusinessId";
            string resultContact;
            Object valueContact = null;
            String ContactId = string.Empty;

            List<List<Object>> parametersContact = new List<List<Object>>();
            if (PushAccountId!=null&&BusinessId != null)
            {
                parametersContact.Add(new List<Object>() { "Id", PushAccountId });
                parametersContact.Add(new List<Object>() { "BusinessId", BusinessId });
                DataAccess.GetOneValue(commandTextContact, DataAccess.ToParameters(parametersContact), out valueContact, out resultContact);
            }
            if (valueContact != null)
            {
                ContactId = (string)valueContact;
            }
            return ContactId;
        }
        
    }
}