307 lines
19 KiB
C#
307 lines
19 KiB
C#
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
|
||
}
|
||
}
|