195 lines
9.6 KiB
C#
195 lines
9.6 KiB
C#
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
|
|
}
|
|
}
|