using System;
using System.Collections.Generic;
using System.Data;
using SuperMap.RealEstate.ServiceModel;
using HWSB = SuperMap.RealEstate.HighWay.Storage.Business;
using Business = SuperMap.RealEstate.ExchangeData.Business;
using HCC = HZQR.Common.Common;
using HZQR.Common;

namespace OpenApi.Method
{
    /// <summary>
    /// 服务区接口相关方法
    /// </summary>
    public class ServerpartHelper
    {
        /// <summary>
        /// 获取服务区列表信息
        /// </summary>
        /// <param name="transaction"></param>
        /// <param name="ProvinceID">省份内码</param>
        /// <returns></returns>
        public static List<Models.ServerpartModel> GetServerpartList(Transaction transaction, string ProvinceID)
        {
            List<Models.ServerpartModel> ServerpartList = new List<Models.ServerpartModel>();

            string WhereSQL = "WHERE STATISTICS_TYPE = 1000 AND STATISTIC_TYPE = 1000 AND PROVINCE_CODE = " + ProvinceID;
            foreach (DataRow drSERVERPART in new HWSB.SERVERPART(transaction).FillDataTable(WhereSQL).Select(
                "", "SPREGIONTYPE_INDEX,SPREGIONTYPE_ID,SERVERPART_INDEX,SERVERPART_CODE"))
            {
                Models.ServerpartModel serverpartModel = new Models.ServerpartModel
                {
                    SERVERPART_ID = drSERVERPART["SERVERPART_ID"].TryParseToInt(),
                    SERVERPART_CODE = drSERVERPART["SERVERPART_CODE"].ToString(),
                    SERVERPART_NAME = drSERVERPART["SERVERPART_NAME"].ToString(),
                    SPREGIONTYPE_ID = drSERVERPART["SPREGIONTYPE_ID"].TryParseToInt(),
                    SPREGIONTYPE_NAME = drSERVERPART["SPREGIONTYPE_NAME"].ToString(),
                    ShopList = ServerpartShopHelper.GetServerpartShopList(transaction,
                        ProvinceID, drSERVERPART["SERVERPART_ID"].TryParseToInt()),
                };
                ServerpartList.Add(serverpartModel);
            }

            return ServerpartList;
        }
    }
}