47 lines
2.0 KiB
C#
47 lines
2.0 KiB
C#
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;
|
|
}
|
|
}
|
|
} |