using System;
using System.Collections.Generic;
using System.Data;
using SuperMap.RealEstate.ServiceModel;
using Business = SuperMap.RealEstate.BasicArchives.Storage.Business;

namespace GSYWApi.Helper
{
    /// <summary>
    /// 服务区站点相关方法
    /// </summary>
    public class SERVERPARTHelper
    {
        #region 获取服务区站点列表
        /// <summary>
        /// 获取服务区站点列表
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="TotalCount">总数据量</param>
        /// <param name="PageIndex">查询页码</param>
        /// <param name="PageSize">每页显示行数</param>
        /// <param name="SERVERPART_NAME">服务区名称</param>
        /// <param name="SPREGIONTYPE_NAME">区域名称</param>
        /// <param name="SortStr">排序字段</param>
        /// <returns></returns>
        public static List<Model.SERVERPARTModel> GetSERVERPARTList(Transaction transaction, ref int TotalCount,
            int PageIndex = 1, int PageSize = 10, string SERVERPART_NAME = "", string SPREGIONTYPE_NAME = "", string SortStr = "")
        {
            List<Model.SERVERPARTModel> SERVERPARTList = new List<Model.SERVERPARTModel>();

            string WhereSQL = "", RowFilterSQL = "";
            //搜索服务区名称
            if (!string.IsNullOrWhiteSpace(SERVERPART_NAME))
            {
                RowFilterSQL += (RowFilterSQL == "" ? "" : " and ") + "SERVERPART_NAME like '%" + SERVERPART_NAME + "%'";
            }
            //搜索区域名称
            if (!string.IsNullOrWhiteSpace(SPREGIONTYPE_NAME))
            {
                RowFilterSQL += (RowFilterSQL == "" ? "" : " and ") + "SPREGIONTYPE_NAME like '%" + SPREGIONTYPE_NAME + "%'";
            }

            DataTable dtSERVERPART = new Business.SERVERPART(transaction).FillDataTable(WhereSQL);
            if (RowFilterSQL != "")
            {
                dtSERVERPART.DefaultView.RowFilter = RowFilterSQL;
            }
            //排序：
            dtSERVERPART.DefaultView.Sort = SortStr;
            dtSERVERPART = dtSERVERPART.DefaultView.ToTable();
            //获取查询结果总记录条数
            TotalCount = dtSERVERPART.Rows.Count;
            //根据传入的页码和每页显示条数返回结果
            dtSERVERPART = CommonHelper.GetDataTableWithPageSize(dtSERVERPART, PageSize, PageIndex);

            foreach (DataRow drSERVERPART in dtSERVERPART.Rows)
            {
                Model.SERVERPARTModel serverpartModel = new Model.SERVERPARTModel();

                serverpartModel.SERVERPART_ID = drSERVERPART["SERVERPART_ID"].TryParseToInt();    //内码
                serverpartModel.SERVERPART_NAME = drSERVERPART["SERVERPART_NAME"].ToString();    //服务区名称
                serverpartModel.SERVERPART_ADDRESS = drSERVERPART["SERVERPART_ADDRESS"].ToString();    //服务区地址
                serverpartModel.SERVERPART_INDEX = drSERVERPART["SERVERPART_INDEX"].TryParseToInt();    //服务区索引
                serverpartModel.EXPRESSWAY_NAME = drSERVERPART["EXPRESSWAY_NAME"].ToString();    //服务区所在高速路
                serverpartModel.SELLERCOUNT = drSERVERPART["SELLERCOUNT"].TryParseToLong();    //商家服务数
                serverpartModel.MACHINECOUNT = drSERVERPART["MACHINECOUNT"].ToString();    //收银机信息
                serverpartModel.WAREHOUSEINFO = drSERVERPART["WAREHOUSEINFO"].ToString();    //仓库信息
                serverpartModel.SERVERPART_AREA = drSERVERPART["SERVERPART_AREA"].TryParseToDouble();    //服务区面积
                serverpartModel.SERVERPART_X = drSERVERPART["SERVERPART_X"].TryParseToDouble();    //服务区坐标X
                serverpartModel.SERVERPART_Y = drSERVERPART["SERVERPART_Y"].TryParseToDouble();    //服务区坐标Y
                serverpartModel.SERVERPART_TEL = drSERVERPART["SERVERPART_TEL"].ToString();    //服务区电话号码
                serverpartModel.SERVERPART_INFO = drSERVERPART["SERVERPART_INFO"].ToString();    //服务区说明
                serverpartModel.PROVINCE_CODE = drSERVERPART["PROVINCE_CODE"].TryParseToInt();    //省份编码
                serverpartModel.CITY_CODE = drSERVERPART["CITY_CODE"].TryParseToInt();    //城市编码
                serverpartModel.COUNTY_CODE = drSERVERPART["COUNTY_CODE"].TryParseToInt();    //区县编码
                serverpartModel.SERVERPART_CODE = drSERVERPART["SERVERPART_CODE"].ToString();    //服务区编码
                serverpartModel.FIELDENUM_ID = drSERVERPART["FIELDENUM_ID"].TryParseToInt();    //枚举内码
                serverpartModel.SERVERPART_IPADDRESS = drSERVERPART["SERVERPART_IPADDRESS"].ToString();    //服务区IP地址描述
                serverpartModel.SERVERPART_TYPE = drSERVERPART["SERVERPART_TYPE"].TryParseToInt();    //服务区类型
                serverpartModel.DAYINCAR = drSERVERPART["DAYINCAR"].TryParseToDouble();    //日均入区车辆
                serverpartModel.HKBL = drSERVERPART["HKBL"].ToString();    //入区车辆客货比例
                serverpartModel.STARTDATE = drSERVERPART["STARTDATE"].TryParseToDateTime();    //开业时间
                serverpartModel.OWNEDCOMPANY = drSERVERPART["OWNEDCOMPANY"].ToString();    //所属公司
                serverpartModel.FLOORAREA = drSERVERPART["FLOORAREA"].TryParseToDouble();    //占地面积
                serverpartModel.BUSINESSAREA = drSERVERPART["BUSINESSAREA"].TryParseToDouble();    //经营面积
                serverpartModel.SHAREAREA = drSERVERPART["SHAREAREA"].TryParseToDouble();    //公共区域面积
                serverpartModel.TOTALPARKING = drSERVERPART["TOTALPARKING"].TryParseToInt();    //车位数
                serverpartModel.MANAGERCOMPANY = drSERVERPART["MANAGERCOMPANY"].ToString();    //管理公司
                serverpartModel.SHORTNAME = drSERVERPART["SHORTNAME"].ToString();    //服务区简称
                serverpartModel.REGIONTYPE_ID = drSERVERPART["REGIONTYPE_ID"].TryParseToInt();    //附属管辖内码
                serverpartModel.STATISTIC_TYPE = drSERVERPART["STATISTIC_TYPE"].TryParseToShort();    //统计类型(1000：正式，2000：测试，3000：替代)
                serverpartModel.PROVINCE_NAME = drSERVERPART["PROVINCE_NAME"].ToString();    //省份名称
                serverpartModel.SPREGIONTYPE_ID = drSERVERPART["SPREGIONTYPE_ID"].TryParseToInt();    //归属区域内码
                serverpartModel.SPREGIONTYPE_NAME = drSERVERPART["SPREGIONTYPE_NAME"].ToString();    //归属区域名字
                serverpartModel.SPREGIONTYPE_INDEX = drSERVERPART["SPREGIONTYPE_INDEX"].TryParseToInt();    //归属区域索引
                serverpartModel.REGIONTYPE_NAME = drSERVERPART["REGIONTYPE_NAME"].ToString();    //附属管辖名称
                serverpartModel.STATISTICS_TYPE = drSERVERPART["STATISTICS_TYPE"].ToString();    //站点类型(服务区、加油站、单位部门)
                serverpartModel.STAFF_ID = drSERVERPART["STAFF_ID"].TryParseToInt();    //操作员内码
                serverpartModel.STAFF_NAME = drSERVERPART["STAFF_NAME"].ToString();    //操作人员
                serverpartModel.OPERATE_DATE = drSERVERPART["OPERATE_DATE"].TryParseToDateTime();    //操作时间
                serverpartModel.SERVERPART_DESC = drSERVERPART["SERVERPART_DESC"].ToString();    //服务区介绍

                SERVERPARTList.Add(serverpartModel);
            }

            return SERVERPARTList;
        }
        #endregion

        #region 获取服务区站点明细
        public static Model.SERVERPARTModel GetSERVERPARTDetail(Transaction transaction, int SERVERPARTId)
        {
            Model.SERVERPARTModel serverpartModel = new Model.SERVERPARTModel();

            Business.SERVERPART _SERVERPART = new Business.SERVERPART(transaction);
            _SERVERPART.SERVERPART_ID = SERVERPARTId;
            if (_SERVERPART.Select())
            {
                serverpartModel.SERVERPART_ID = _SERVERPART.SERVERPART_ID;    //内码
                serverpartModel.SERVERPART_NAME = _SERVERPART.SERVERPART_NAME;    //服务区名称
                serverpartModel.SERVERPART_ADDRESS = _SERVERPART.SERVERPART_ADDRESS;    //服务区地址
                serverpartModel.SERVERPART_INDEX = _SERVERPART.SERVERPART_INDEX;    //服务区索引
                serverpartModel.EXPRESSWAY_NAME = _SERVERPART.EXPRESSWAY_NAME;    //服务区所在高速路
                serverpartModel.SELLERCOUNT = _SERVERPART.SELLERCOUNT;    //商家服务数
                serverpartModel.MACHINECOUNT = _SERVERPART.MACHINECOUNT;    //收银机信息
                serverpartModel.WAREHOUSEINFO = _SERVERPART.WAREHOUSEINFO;    //仓库信息
                serverpartModel.SERVERPART_AREA = _SERVERPART.SERVERPART_AREA;    //服务区面积
                serverpartModel.SERVERPART_X = _SERVERPART.SERVERPART_X;    //服务区坐标X
                serverpartModel.SERVERPART_Y = _SERVERPART.SERVERPART_Y;    //服务区坐标Y
                serverpartModel.SERVERPART_TEL = _SERVERPART.SERVERPART_TEL;    //服务区电话号码
                serverpartModel.SERVERPART_INFO = _SERVERPART.SERVERPART_INFO;    //服务区说明
                serverpartModel.PROVINCE_CODE = _SERVERPART.PROVINCE_CODE;    //省份编码
                serverpartModel.CITY_CODE = _SERVERPART.CITY_CODE;    //城市编码
                serverpartModel.COUNTY_CODE = _SERVERPART.COUNTY_CODE;    //区县编码
                serverpartModel.SERVERPART_CODE = _SERVERPART.SERVERPART_CODE;    //服务区编码
                serverpartModel.FIELDENUM_ID = _SERVERPART.FIELDENUM_ID;    //枚举内码
                serverpartModel.SERVERPART_IPADDRESS = _SERVERPART.SERVERPART_IPADDRESS;    //服务区IP地址描述
                serverpartModel.SERVERPART_TYPE = _SERVERPART.SERVERPART_TYPE;    //服务区类型
                serverpartModel.DAYINCAR = _SERVERPART.DAYINCAR;    //日均入区车辆
                serverpartModel.HKBL = _SERVERPART.HKBL;    //入区车辆客货比例
                serverpartModel.STARTDATE = _SERVERPART.STARTDATE;    //开业时间
                serverpartModel.OWNEDCOMPANY = _SERVERPART.OWNEDCOMPANY;    //所属公司
                serverpartModel.FLOORAREA = _SERVERPART.FLOORAREA;    //占地面积
                serverpartModel.BUSINESSAREA = _SERVERPART.BUSINESSAREA;    //经营面积
                serverpartModel.SHAREAREA = _SERVERPART.SHAREAREA;    //公共区域面积
                serverpartModel.TOTALPARKING = _SERVERPART.TOTALPARKING;    //车位数
                serverpartModel.MANAGERCOMPANY = _SERVERPART.MANAGERCOMPANY;    //管理公司
                serverpartModel.SHORTNAME = _SERVERPART.SHORTNAME;    //服务区简称
                serverpartModel.REGIONTYPE_ID = _SERVERPART.REGIONTYPE_ID;    //附属管辖内码
                serverpartModel.STATISTIC_TYPE = _SERVERPART.STATISTIC_TYPE;    //统计类型(1000：正式，2000：测试，3000：替代)
                serverpartModel.PROVINCE_NAME = _SERVERPART.PROVINCE_NAME;    //省份名称
                serverpartModel.SPREGIONTYPE_ID = _SERVERPART.SPREGIONTYPE_ID;    //归属区域内码
                serverpartModel.SPREGIONTYPE_NAME = _SERVERPART.SPREGIONTYPE_NAME;    //归属区域名字
                serverpartModel.SPREGIONTYPE_INDEX = _SERVERPART.SPREGIONTYPE_INDEX;    //归属区域索引
                serverpartModel.REGIONTYPE_NAME = _SERVERPART.REGIONTYPE_NAME;    //附属管辖名称
                serverpartModel.STATISTICS_TYPE = _SERVERPART.STATISTICS_TYPE;    //站点类型(服务区、加油站、单位部门)
                serverpartModel.STAFF_ID = _SERVERPART.STAFF_ID;    //操作员内码
                serverpartModel.STAFF_NAME = _SERVERPART.STAFF_NAME;    //操作人员
                serverpartModel.OPERATE_DATE = _SERVERPART.OPERATE_DATE;    //操作时间
                serverpartModel.SERVERPART_DESC = _SERVERPART.SERVERPART_DESC;    //服务区介绍
            }

            return serverpartModel;
        }
        #endregion

        #region 同步服务区站点
        /// <summary>
        /// 同步服务区站点
        /// </summary>
        /// <param name="transaction"></param>
        /// <param name="serverpartModel"></param>
        /// <returns></returns>
        public static bool SynchroSERVERPART(Transaction transaction, Model.SERVERPARTModel serverpartModel)
        {
            bool SynchroFlag = true;

            Business.SERVERPART _SERVERPART = new Business.SERVERPART(transaction);
            if (serverpartModel.SERVERPART_ID != null)
            {
                _SERVERPART.SERVERPART_ID = serverpartModel.SERVERPART_ID;
                if (_SERVERPART.Select())
                {
                    SynchroModelToObject(_SERVERPART, serverpartModel);
                    _SERVERPART.Update();
                }
                else
                {
                    SynchroFlag = false;
                }
            }
            else
            {
                SynchroModelToObject(_SERVERPART, serverpartModel);
                _SERVERPART.Insert();
            }

            return SynchroFlag;
        }

        #region 赋值服务区站点数据对象
        /// <summary>
        /// 赋值服务区站点数据对象
        /// </summary>
        /// <param name="_SERVERPART"></param>
        /// <param name="serverpartModel"></param>
        public static void SynchroModelToObject(Business.SERVERPART _SERVERPART, Model.SERVERPARTModel serverpartModel)
        {
            _SERVERPART.SERVERPART_NAME = serverpartModel.SERVERPART_NAME;    //服务区名称
            _SERVERPART.SERVERPART_ADDRESS = serverpartModel.SERVERPART_ADDRESS;    //服务区地址
            _SERVERPART.SERVERPART_INDEX = serverpartModel.SERVERPART_INDEX;    //服务区索引
            _SERVERPART.EXPRESSWAY_NAME = serverpartModel.EXPRESSWAY_NAME;    //服务区所在高速路
            _SERVERPART.SELLERCOUNT = serverpartModel.SELLERCOUNT;    //商家服务数
            _SERVERPART.MACHINECOUNT = serverpartModel.MACHINECOUNT;    //收银机信息
            _SERVERPART.WAREHOUSEINFO = serverpartModel.WAREHOUSEINFO;    //仓库信息
            _SERVERPART.SERVERPART_AREA = serverpartModel.SERVERPART_AREA;    //服务区面积
            _SERVERPART.SERVERPART_X = serverpartModel.SERVERPART_X;    //服务区坐标X
            _SERVERPART.SERVERPART_Y = serverpartModel.SERVERPART_Y;    //服务区坐标Y
            _SERVERPART.SERVERPART_TEL = serverpartModel.SERVERPART_TEL;    //服务区电话号码
            _SERVERPART.SERVERPART_INFO = serverpartModel.SERVERPART_INFO;    //服务区说明
            _SERVERPART.PROVINCE_CODE = serverpartModel.PROVINCE_CODE;    //省份编码
            _SERVERPART.CITY_CODE = serverpartModel.CITY_CODE;    //城市编码
            _SERVERPART.COUNTY_CODE = serverpartModel.COUNTY_CODE;    //区县编码
            _SERVERPART.SERVERPART_CODE = serverpartModel.SERVERPART_CODE;    //服务区编码
            _SERVERPART.FIELDENUM_ID = serverpartModel.FIELDENUM_ID;    //枚举内码
            _SERVERPART.SERVERPART_IPADDRESS = serverpartModel.SERVERPART_IPADDRESS;    //服务区IP地址描述
            _SERVERPART.SERVERPART_TYPE = serverpartModel.SERVERPART_TYPE;    //服务区类型
            _SERVERPART.DAYINCAR = serverpartModel.DAYINCAR;    //日均入区车辆
            _SERVERPART.HKBL = serverpartModel.HKBL;    //入区车辆客货比例
            _SERVERPART.STARTDATE = serverpartModel.STARTDATE;    //开业时间
            _SERVERPART.OWNEDCOMPANY = serverpartModel.OWNEDCOMPANY;    //所属公司
            _SERVERPART.FLOORAREA = serverpartModel.FLOORAREA;    //占地面积
            _SERVERPART.BUSINESSAREA = serverpartModel.BUSINESSAREA;    //经营面积
            _SERVERPART.SHAREAREA = serverpartModel.SHAREAREA;    //公共区域面积
            _SERVERPART.TOTALPARKING = serverpartModel.TOTALPARKING;    //车位数
            _SERVERPART.MANAGERCOMPANY = serverpartModel.MANAGERCOMPANY;    //管理公司
            _SERVERPART.SHORTNAME = serverpartModel.SHORTNAME;    //服务区简称
            _SERVERPART.REGIONTYPE_ID = serverpartModel.REGIONTYPE_ID;    //附属管辖内码
            _SERVERPART.STATISTIC_TYPE = serverpartModel.STATISTIC_TYPE;    //统计类型(1000：正式，2000：测试，3000：替代)
            _SERVERPART.PROVINCE_NAME = serverpartModel.PROVINCE_NAME;    //省份名称
            _SERVERPART.SPREGIONTYPE_ID = serverpartModel.SPREGIONTYPE_ID;    //归属区域内码
            _SERVERPART.SPREGIONTYPE_NAME = serverpartModel.SPREGIONTYPE_NAME;    //归属区域名字
            _SERVERPART.SPREGIONTYPE_INDEX = serverpartModel.SPREGIONTYPE_INDEX;    //归属区域索引
            _SERVERPART.REGIONTYPE_NAME = serverpartModel.REGIONTYPE_NAME;    //附属管辖名称
            _SERVERPART.STATISTICS_TYPE = serverpartModel.STATISTICS_TYPE;    //站点类型(服务区、加油站、单位部门)
            _SERVERPART.STAFF_ID = serverpartModel.STAFF_ID;    //操作员内码
            _SERVERPART.STAFF_NAME = serverpartModel.STAFF_NAME;    //操作人员
            _SERVERPART.OPERATE_DATE = serverpartModel.OPERATE_DATE;    //操作时间
            _SERVERPART.SERVERPART_DESC = serverpartModel.SERVERPART_DESC;    //服务区介绍
        }
        #endregion

        #endregion

        #region 删除服务区站点
        public static bool DeleteSERVERPART(Transaction transaction, int? SERVERPARTId)
        {
            bool DeleteFlag = false;

            if (SERVERPARTId != null)
            {
                Business.SERVERPART _SERVERPART = new Business.SERVERPART(transaction);
                _SERVERPART.SERVERPART_ID = SERVERPARTId;
                if (_SERVERPART.Select())
                {
                    _SERVERPART.Delete();
                    DeleteFlag = true;
                }
            }

            return DeleteFlag;
        }
        #endregion

        #region 绑定服务区下拉框
        /// <summary>
        /// 绑定服务区下拉框
        /// </summary>
        /// <param name="transaction">事务管理器</param>
        /// <param name="ServerpartCodes">服务区编码集合</param>
        /// <returns></returns>
        public static List<Models.CommonModel> GetServerpartDDL(Transaction transaction, string ServerpartCodes = "")
        {
            List<Models.CommonModel> ServerpartList = new List<Models.CommonModel>();

            string WhereSQL = "";
            //查询枚举有效状态
            if (!string.IsNullOrWhiteSpace(ServerpartCodes))
            {
                WhereSQL = "WHERE SERVERPART_CODE IN ('" + ServerpartCodes.Replace(",", "','") + "')";
            }

            foreach (DataRow drServerpart in new Business.SERVERPART(transaction).FillDataTable(
                WhereSQL).Select("", "SERVERPART_INDEX,SERVERPART_CODE"))
            {
                Models.CommonModel commonModel = new Models.CommonModel();
                commonModel.label = drServerpart["SERVERPART_NAME"].ToString();
                commonModel.value = drServerpart["SERVERPART_ID"].ToString();
                ServerpartList.Add(commonModel);
            }

            return ServerpartList;
        }
        #endregion
    }
}