using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Linq;
using System.Text;
using Common;
using Model;
using Oracle.ManagedDataAccess.Client;

namespace Dao
{
    /// <summary>
    /// 客户产品操作类
    /// </summary>
    public class GwClientProductDao
    {
        private static GwClientProductDao _instance;
        public static GwClientProductDao Instance
        {
            get {
                if (_instance == null)
                {
                    _instance = new GwClientProductDao();
                }
                return _instance;
            }
        }

        /// <summary>
        /// 添加账户默认产品记录
        /// </summary>
        /// <param name="gcp"></param>
        /// <returns></returns>
        public bool Add(GwClientProduct gcp)
        {
            return OracleHelper.ExecuteSql("insert into GW_Client_Product(id,client_id,product_id,sp_id,ACTIVATE_STATUS) values(:id,:client_id,:product_id,:sp_id,:ACTIVATE_STATUS)",
                OracleHelper.Connection, new OracleParameter(":id", (object)gcp.Id), new OracleParameter(":client_id", (object)gcp.ClientId), 
                new OracleParameter(":product_id", gcp.ProductId),new OracleParameter(":sp_id",gcp.SpId),
                new OracleParameter(":ACTIVATE_STATUS", gcp.ActivateStatus)) > 0;
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="gcp"></param>
        /// <returns></returns>
        public bool Update(GwClientProduct gcp)
        {
            return OracleHelper.ExecuteSql("update GW_Client_Product set product_id=:product_id,client_id=:client_id where sp_id=:sp_id ", 
                OracleHelper.Connection, new OracleParameter(":product_id", gcp.ProductId), new OracleParameter(":sp_id", gcp.SpId),
                new OracleParameter(":client_id",gcp.ClientId)
                ) > 0;
        }

        /// <summary>
        /// 查找账号是否存在
        /// </summary>
        /// <param name="spid"></param>
        /// <returns></returns>
        public bool FindBySp(string spid)
        {
            using (OracleDataReader oracleDataReader = OracleHelper.ExecuteReader(string.Format("select * from GW_Client_Product where SP_ID=:SP_ID"), OracleHelper.Connection, new OracleParameter(":SP_ID", spid)))
            {
                if (oracleDataReader.Read())
                    return true;
            }
            return false;
        }
        


    }
}