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

namespace Dao
{
    public class GwClientCertificationDao
    {
        /// <summary>
        /// 插入
        /// </summary>

        public bool Insert(GwClientCertification item)
        {
            return OracleHelper.ExecuteSql("INSERT INTO GW_CLIENT_CERTIFICATION(CLIENT_ID,CERTIFICATE_PATH,CLIENT_CLASSES,AUDIT_STATUS,CERTIFICATION_TIME,OPERATOR,UPLOAD_TIME,REMARK)" +
                " VALUES(:CLIENTID,:CERTIFICATE_PATH,:CLIENT_CLASSES,:AUDIT_STATUS,:CERTIFICATION_TIME,:OPERATOR,:UPLOAD_TIME,:REMARK)",
                OracleHelper.Connection, new OracleParameter(":CLIENTID", (object)item.Client_ID), new OracleParameter(":CERTIFICATE_PATH", (object)item.Certificate_Path), 
                new OracleParameter(":CLIENT_CLASSES", (object)item.Client_Classes), new OracleParameter(":AUDIT_STATUS", (object)item.Audit_Status), new OracleParameter(":CERTIFICATION_TIME", (object)item.Certification_Time),
                new OracleParameter(":OPERATOR", (object)item.Operator), new OracleParameter(":REMARK", (object)item.Remark), new OracleParameter(":UPLOAD_TIME", (object)item.Upload_Time)) > 0;
        }

        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="clientID"></param>
        /// <returns></returns>
        //public GwClient Get(string clientID)
        //{
        //    GwClient o = new GwClient();
        //    if (string.IsNullOrEmpty(clientID) || string.Equals("0", clientID))
        //        return o;
        //    using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from GW_CLIENT where CLIENT_ID=:CLIENT_ID"), OracleHelper.Connection, new OracleParameter(":CLIENT_ID", (object)clientID)))
        //    {
        //        if (((DbDataReader)reader).Read())
        //        {
        //            this.ReadInfo(reader, o);
        //            return o;
        //        }
        //    }
        //    return o;
        //}

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        //public bool Update(GwClient item)
        //{
        //    return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET CLIENT_ID=:CLIENT_ID,CLIENT_NAME=:CLIENTNAME,TELEPHONE=:TELEPHONE,ADDRESS=:ADDRESS,COMPANY=:COMPANY,REMARK=:REMARK,PASSWORD=:PASSWORD,AGENT=:AGENT,PERMISSION_DATA=:PERMISSION_DATA,CREATE_TIME=SYSDATE WHERE ID=:Id", OracleHelper.Connection, new OracleParameter(":Id", (object)item.Id), new OracleParameter(":CLIENT_ID", (object)item.ClientID), new OracleParameter(":CLIENTNAME", (object)item.ClientName), new OracleParameter(":TELEPHONE", (object)item.Telephone), new OracleParameter(":ADDRESS", (object)item.Address), new OracleParameter(":COMPANY", (object)item.Company), new OracleParameter(":REMARK", (object)item.Remark), new OracleParameter(":PASSWORD", (object)item.Password), new OracleParameter(":AGENT", (object)item.Agent), new OracleParameter(":PERMISSION_DATA", (object)item.PermissionData)) > 0;
        //}

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="clientID"></param>
        /// <returns></returns>
        //public bool Delete(string clientID)
        //{
        //    if (string.IsNullOrEmpty(clientID) || string.Equals("0", clientID))
        //        return false;
        //    return OracleHelper.ExecuteSql(string.Format("delete from GW_CLIENT where CLIENT_ID=:CLIENT_ID"), OracleHelper.Connection, new OracleParameter(":CLIENT_ID", (object)clientID)) > 0;
        //}



        private bool ReadInfo(OracleDataReader reader, GwClientCertification o)
        {
            OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
            o.Id = oracleReaderWrapper.GetInt("ID", 0);
            o.Client_ID = oracleReaderWrapper.GetString("CLIENT_ID", "");
            o.Certificate_Path = oracleReaderWrapper.GetString("Certificate_Path", "");
            o.Client_Classes = oracleReaderWrapper.GetInt("Client_Classes", 0);
            o.Audit_Status = oracleReaderWrapper.GetInt("Audit_Status", 0);
            o.Certification_Time = oracleReaderWrapper.GetDateTime("Certification_Time");
            o.Operator = oracleReaderWrapper.GetString("Operator", "");
            o.Upload_Time = oracleReaderWrapper.GetDateTime("Upload_Time");
            o.Remark = oracleReaderWrapper.GetString("Remark", "");
            return true;
        }
    }
}