using System;
using System.Collections.Generic;
using System.Data;
using SuperMap.RealEstate.ServiceModel;
using Business = SuperMap.RealEstate.ExchangeData.Business;
using HZQR.Common;

namespace EShang.Common.GeneralMethod
{
    /// <summary>
    /// 服务区监控录像信息表相关方法
    /// </summary>
    public class EXTRANETDETAILHelper
    {
        #region 获取服务区监控录像信息表列表
        /// <summary>
        /// 获取服务区监控录像信息表列表
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="TotalCount">查询结果总数</param>
        /// <param name="searchModel">查询条件对象</param>
        public static List<Model.EXTRANETDETAILModel> GetEXTRANETDETAILList(Transaction transaction,
            ref int TotalCount, Model.SearchModel<Model.EXTRANETDETAILModel> searchModel)
        {
            List<Model.EXTRANETDETAILModel> EXTRANETDETAILList = new List<Model.EXTRANETDETAILModel>();

            string WhereSQL = "", RowFilterSQL = "";
            if (searchModel.SearchParameter != null)
            {
                WhereSQL = OperationDataHelper<Model.EXTRANETDETAILModel>.GetWhereSQL(searchModel.SearchParameter, searchModel.QueryType);
                if (WhereSQL != "")
                {
                    WhereSQL = "WHERE " + WhereSQL;
                }
            }

            DataTable dtEXTRANETDETAIL = new Business.EXTRANETDETAIL(transaction).FillDataTable(WhereSQL);
            //增加组合查询条件
            if (searchModel.keyWord != null && !string.IsNullOrWhiteSpace(searchModel.keyWord.Key))
            {
                foreach (string KeyName in searchModel.keyWord.Key.Split(','))
                {
                    RowFilterSQL += (RowFilterSQL == "" ? "" : " or ") +
                        KeyName + " like '%" + searchModel.keyWord.Value + "%'";
                }
            }
            if (RowFilterSQL != "")
            {
                dtEXTRANETDETAIL.DefaultView.RowFilter = RowFilterSQL;
            }
            //排序：
            dtEXTRANETDETAIL.DefaultView.Sort = searchModel.SortStr;
            dtEXTRANETDETAIL = dtEXTRANETDETAIL.DefaultView.ToTable();
            //获取查询结果总记录条数
            TotalCount = dtEXTRANETDETAIL.Rows.Count;
            //根据传入的页码和每页显示条数返回结果
            dtEXTRANETDETAIL = CommonHelper.GetDataTableWithPageSize(dtEXTRANETDETAIL, searchModel.PageSize, searchModel.PageIndex);

            foreach (DataRow drEXTRANETDETAIL in dtEXTRANETDETAIL.Rows)
            {
                Model.EXTRANETDETAILModel extranetdetailModel = new Model.EXTRANETDETAILModel();

                extranetdetailModel.VIDEO_PUBLICIP = drEXTRANETDETAIL["VIDEO_PUBLICIP"].ToString();    //录像机公网IP
                extranetdetailModel.VIDEO_INTRANETIP = drEXTRANETDETAIL["VIDEO_INTRANETIP"].ToString();    //录像机内网IP
                extranetdetailModel.EXTRANETDETAIL_ID = drEXTRANETDETAIL["EXTRANETDETAIL_ID"].TryParseToInt();    //内码
                extranetdetailModel.EXTRANET_ID = drEXTRANETDETAIL["EXTRANET_ID"].TryParseToInt();    //服务区网络信息内码
                extranetdetailModel.VEDIO_TYPE = drEXTRANETDETAIL["VEDIO_TYPE"].TryParseToInt();    //录像类型
                extranetdetailModel.VIDEOIP = drEXTRANETDETAIL["VIDEOIP"].ToString();    //硬盘录像机地址
                extranetdetailModel.VIDEOPORT = drEXTRANETDETAIL["VIDEOPORT"].ToString();    //硬盘录像机端口
                extranetdetailModel.LOGUSERNAME = drEXTRANETDETAIL["LOGUSERNAME"].ToString();    //登录用户
                extranetdetailModel.LOGPASSWORD = drEXTRANETDETAIL["LOGPASSWORD"].ToString();    //登录密码
                extranetdetailModel.LOGINPORT = drEXTRANETDETAIL["LOGINPORT"].ToString();    //登录端口号
                extranetdetailModel.EXTRANETDETAIL_DESC = drEXTRANETDETAIL["EXTRANETDETAIL_DESC"].ToString();    //备注

                EXTRANETDETAILList.Add(extranetdetailModel);
            }

            return EXTRANETDETAILList;
        }
        #endregion

        #region 获取服务区监控录像信息表明细
        /// <summary>
        /// 获取服务区监控录像信息表明细
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="EXTRANETDETAILId">服务区监控录像信息表内码</param>
        public static Model.EXTRANETDETAILModel GetEXTRANETDETAILDetail(Transaction transaction, int EXTRANETDETAILId)
        {
            Model.EXTRANETDETAILModel extranetdetailModel = new Model.EXTRANETDETAILModel();

            Business.EXTRANETDETAIL _EXTRANETDETAIL = new Business.EXTRANETDETAIL(transaction);
            _EXTRANETDETAIL.EXTRANETDETAIL_ID = EXTRANETDETAILId;
            if (_EXTRANETDETAIL.Select())
            {
                extranetdetailModel.VIDEO_PUBLICIP = _EXTRANETDETAIL.VIDEO_PUBLICIP;    //录像机公网IP
                extranetdetailModel.VIDEO_INTRANETIP = _EXTRANETDETAIL.VIDEO_INTRANETIP;    //录像机内网IP
                extranetdetailModel.EXTRANETDETAIL_ID = _EXTRANETDETAIL.EXTRANETDETAIL_ID;    //内码
                extranetdetailModel.EXTRANET_ID = _EXTRANETDETAIL.EXTRANET_ID;    //服务区网络信息内码
                extranetdetailModel.VEDIO_TYPE = _EXTRANETDETAIL.VEDIO_TYPE;    //录像类型
                extranetdetailModel.VIDEOIP = _EXTRANETDETAIL.VIDEOIP;    //硬盘录像机地址
                extranetdetailModel.VIDEOPORT = _EXTRANETDETAIL.VIDEOPORT;    //硬盘录像机端口
                extranetdetailModel.LOGUSERNAME = _EXTRANETDETAIL.LOGUSERNAME;    //登录用户
                extranetdetailModel.LOGPASSWORD = _EXTRANETDETAIL.LOGPASSWORD;    //登录密码
                extranetdetailModel.LOGINPORT = _EXTRANETDETAIL.LOGINPORT;    //登录端口号
                extranetdetailModel.EXTRANETDETAIL_DESC = _EXTRANETDETAIL.EXTRANETDETAIL_DESC;    //备注
            }

            return extranetdetailModel;
        }
        #endregion

        #region 同步服务区监控录像信息表
        /// <summary>
        /// 赋值服务区监控录像信息表数据对象
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="extranetdetailModel">服务区监控录像信息表数据对象</param>
        public static bool SynchroEXTRANETDETAIL(Transaction transaction, Model.EXTRANETDETAILModel extranetdetailModel)
        {
            bool SynchroFlag = true;

            Business.EXTRANETDETAIL _EXTRANETDETAIL = new Business.EXTRANETDETAIL(transaction);
            if (extranetdetailModel.EXTRANETDETAIL_ID != null)
            {
                _EXTRANETDETAIL.EXTRANETDETAIL_ID = extranetdetailModel.EXTRANETDETAIL_ID;
                if (_EXTRANETDETAIL.Select())
                {
                    SynchroModelToObject(_EXTRANETDETAIL, extranetdetailModel);
                    _EXTRANETDETAIL.Update();
                }
                else
                {
                    SynchroFlag = false;
                }
            }
            else
            {
                SynchroModelToObject(_EXTRANETDETAIL, extranetdetailModel);
                _EXTRANETDETAIL.Insert();
            }

            return SynchroFlag;
        }

        #region 赋值服务区监控录像信息表数据对象
        /// <summary>
        /// 赋值服务区监控录像信息表数据对象
        /// </summary>
        /// <param name="_EXTRANETDETAIL"></param>
        /// <param name="extranetdetailModel"></param>
        public static void SynchroModelToObject(Business.EXTRANETDETAIL _EXTRANETDETAIL, Model.EXTRANETDETAILModel extranetdetailModel)
        {
            _EXTRANETDETAIL.VIDEO_PUBLICIP = extranetdetailModel.VIDEO_PUBLICIP;    //录像机公网IP
            _EXTRANETDETAIL.VIDEO_INTRANETIP = extranetdetailModel.VIDEO_INTRANETIP;    //录像机内网IP
            _EXTRANETDETAIL.EXTRANET_ID = extranetdetailModel.EXTRANET_ID;    //服务区网络信息内码
            _EXTRANETDETAIL.VEDIO_TYPE = extranetdetailModel.VEDIO_TYPE;    //录像类型
            _EXTRANETDETAIL.VIDEOIP = extranetdetailModel.VIDEOIP;    //硬盘录像机地址
            _EXTRANETDETAIL.VIDEOPORT = extranetdetailModel.VIDEOPORT;    //硬盘录像机端口
            _EXTRANETDETAIL.LOGUSERNAME = extranetdetailModel.LOGUSERNAME;    //登录用户
            _EXTRANETDETAIL.LOGPASSWORD = extranetdetailModel.LOGPASSWORD;    //登录密码
            _EXTRANETDETAIL.LOGINPORT = extranetdetailModel.LOGINPORT;    //登录端口号
            _EXTRANETDETAIL.EXTRANETDETAIL_DESC = extranetdetailModel.EXTRANETDETAIL_DESC;    //备注
        }
        #endregion

        #endregion

        #region 删除服务区监控录像信息表
        /// <summary>
        /// 删除服务区监控录像信息表
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="EXTRANETDETAILId">服务区监控录像信息表内码</param>
        public static bool DeleteEXTRANETDETAIL(Transaction transaction, int? EXTRANETDETAILId)
        {
            bool DeleteFlag = false;

            if (EXTRANETDETAILId != null)
            {
                Business.EXTRANETDETAIL _EXTRANETDETAIL = new Business.EXTRANETDETAIL(transaction);
                _EXTRANETDETAIL.EXTRANETDETAIL_ID = EXTRANETDETAILId;
                if (_EXTRANETDETAIL.Select())
                {
                    _EXTRANETDETAIL.EXTRANETDETAIL_STATE = 0;
                    DeleteFlag = _EXTRANETDETAIL.Update();
                }
            }

            return DeleteFlag;
        }
        #endregion
    }
}