464 lines
26 KiB
C#
464 lines
26 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Threading.Tasks;
|
|
using SuperMap.RealEstate.CoreFrameWork;
|
|
using Newtonsoft.Json.Linq;
|
|
|
|
namespace SuperMap.RealEstate.ExchangeData.Modules.VideoManage
|
|
{
|
|
public partial class PLAYERSHOWINFO : System.Web.UI.Page
|
|
{
|
|
public int _VIDEO_IP = -1;
|
|
public string _EXCEPTIONTYPE;
|
|
public string _EXCEPTION_DATE;
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
if (IsPostBack) return;
|
|
|
|
ServiceModel.Transaction _Transaction = new ServiceModel.Transaction();
|
|
|
|
try
|
|
{
|
|
string SQLString, _SERVERPARTCODE = "", _SHOPCODE = "", _MACHINECODE = "", _SERVERPART_ID = "",
|
|
_ABNORMALITY_CODE = "", _ABNORMALITY_PCODE = "", _ABNORMALITY_START = "";
|
|
if (!string.IsNullOrWhiteSpace(Request["jsonstring"]))
|
|
{
|
|
#region 详细信息
|
|
JObject keyValuePairs = JObject.Parse(Request["jsonstring"]);
|
|
if (keyValuePairs["SERVERPARTCODE"] != null && keyValuePairs["SERVERPARTCODE"].ToString() != "")
|
|
{
|
|
_SERVERPARTCODE = keyValuePairs["SERVERPARTCODE"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["SHOPCODE"] != null && keyValuePairs["SHOPCODE"].ToString() != "")
|
|
{
|
|
_SHOPCODE = keyValuePairs["SHOPCODE"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["MACHINECODE"] != null && keyValuePairs["MACHINECODE"].ToString() != "")
|
|
{
|
|
_MACHINECODE = keyValuePairs["MACHINECODE"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["SERVERPART_ID"] != null && keyValuePairs["SERVERPART_ID"].ToString() != "")
|
|
{
|
|
_SERVERPART_ID = keyValuePairs["SERVERPART_ID"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["SERVERPARTNAME"] != null && keyValuePairs["SERVERPARTNAME"].ToString() != "")
|
|
{
|
|
SERVERPARTNAME.InnerText = keyValuePairs["SERVERPARTNAME"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["SHOPNAME"] != null && keyValuePairs["SHOPNAME"].ToString() != "")
|
|
{
|
|
SHOPNAME.InnerText = keyValuePairs["SHOPNAME"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["WORKERNAME"] != null && keyValuePairs["WORKERNAME"].ToString() != "")
|
|
{
|
|
WORKERNAME.InnerText = keyValuePairs["WORKERNAME"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["EXCEPTIONCOUNT"] != null && keyValuePairs["EXCEPTIONCOUNT"].ToString() != "")
|
|
{
|
|
EXCEPTIONCOUNT.InnerText = keyValuePairs["EXCEPTIONCOUNT"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["EXCEPTIONAMOUNT"] != null && keyValuePairs["EXCEPTIONAMOUNT"].ToString() != "")
|
|
{
|
|
EXCEPTIONAMOUNT.InnerText = keyValuePairs["EXCEPTIONAMOUNT"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["COMMODITY_NAME"] != null && keyValuePairs["COMMODITY_NAME"].ToString() != "")
|
|
{
|
|
COMMODITY_NAME.InnerText = keyValuePairs["COMMODITY_NAME"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["COMMODITY_BARCODE"] != null && keyValuePairs["COMMODITY_BARCODE"].ToString() != "")
|
|
{
|
|
COMMODITY_BARCODE.InnerText = keyValuePairs["COMMODITY_BARCODE"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["COMMODITY_RETAILPRICE"] != null && keyValuePairs["COMMODITY_RETAILPRICE"].ToString() != "")
|
|
{
|
|
COMMODITY_RETAILPRICE.InnerText = keyValuePairs["COMMODITY_RETAILPRICE"].ToString().ToDecrypt();
|
|
}
|
|
if (keyValuePairs["EXCEPTION_DATE"] != null && keyValuePairs["EXCEPTION_DATE"].ToString() != "")
|
|
{
|
|
_EXCEPTION_DATE = keyValuePairs["EXCEPTION_DATE"].ToString().ToDecrypt();
|
|
EXCEPTION_DATE.InnerText = _EXCEPTION_DATE;
|
|
EXCEPTIONDATE.Value = _EXCEPTION_DATE;
|
|
if (keyValuePairs["ABNORMALITY_START"] != null && keyValuePairs["ABNORMALITY_START"].ToString() != "")
|
|
{
|
|
_ABNORMALITY_START = keyValuePairs["ABNORMALITY_START"].ToString();
|
|
starttime.Value = Convert.ToDateTime(_ABNORMALITY_START).AddSeconds(-90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
else
|
|
{
|
|
starttime.Value = Convert.ToDateTime(_EXCEPTION_DATE).AddSeconds(-90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
endtime.Value = Convert.ToDateTime(_EXCEPTION_DATE).AddSeconds(90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
|
|
if (keyValuePairs["EXCEPTIONTYPE"] != null && keyValuePairs["EXCEPTIONTYPE"].ToString() != "")
|
|
{
|
|
_EXCEPTIONTYPE = keyValuePairs["EXCEPTIONTYPE"].ToString().ToDecrypt();
|
|
EXCEPTIONTYPE.InnerText = _EXCEPTIONTYPE;
|
|
}
|
|
if (keyValuePairs["VIDEO_IP"] != null && keyValuePairs["VIDEO_IP"].ToString() != "")
|
|
{
|
|
_VIDEO_IP = keyValuePairs["VIDEO_IP"].ToString().ToDecryptInt32();
|
|
}
|
|
if (keyValuePairs["ABNORMALITY_CODE"] != null && keyValuePairs["ABNORMALITY_CODE"].ToString() != "")
|
|
{
|
|
_ABNORMALITY_CODE = keyValuePairs["ABNORMALITY_CODE"].ToString();
|
|
}
|
|
if (keyValuePairs["ABNORMALITY_PCODE"] != null && keyValuePairs["ABNORMALITY_PCODE"].ToString() != "")
|
|
{
|
|
_ABNORMALITY_PCODE = keyValuePairs["ABNORMALITY_PCODE"].ToString();
|
|
}
|
|
#endregion
|
|
}
|
|
else
|
|
{
|
|
#region 详细信息
|
|
if (!string.IsNullOrEmpty(Request["SERVERPARTCODE"]))
|
|
{
|
|
_SERVERPARTCODE = Request["SERVERPARTCODE"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["SHOPCODE"]))
|
|
{
|
|
_SHOPCODE = Request["SHOPCODE"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["MACHINECODE"]))
|
|
{
|
|
_MACHINECODE = Request["MACHINECODE"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["SERVERPART_ID"]))
|
|
{
|
|
_SERVERPART_ID = Request["SERVERPART_ID"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["SERVERPARTNAME"]))
|
|
{
|
|
SERVERPARTNAME.InnerText = Request["SERVERPARTNAME"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["SHOPNAME"]))
|
|
{
|
|
SHOPNAME.InnerText = Request["SHOPNAME"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["WORKERNAME"]))
|
|
{
|
|
WORKERNAME.InnerText = Request["WORKERNAME"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["EXCEPTIONCOUNT"]))
|
|
{
|
|
EXCEPTIONCOUNT.InnerText = Request["EXCEPTIONCOUNT"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["EXCEPTIONAMOUNT"]))
|
|
{
|
|
EXCEPTIONAMOUNT.InnerText = Request["EXCEPTIONAMOUNT"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["COMMODITY_NAME"]))
|
|
{
|
|
COMMODITY_NAME.InnerText = Request["COMMODITY_NAME"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["COMMODITY_BARCODE"]))
|
|
{
|
|
COMMODITY_BARCODE.InnerText = Request["COMMODITY_BARCODE"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["COMMODITY_RETAILPRICE"]))
|
|
{
|
|
COMMODITY_RETAILPRICE.InnerText = Request["COMMODITY_RETAILPRICE"].ToDecrypt();
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["EXCEPTION_DATE"]))
|
|
{
|
|
_EXCEPTION_DATE = Request["EXCEPTION_DATE"].ToDecrypt();
|
|
EXCEPTION_DATE.InnerText = _EXCEPTION_DATE;
|
|
EXCEPTIONDATE.Value = _EXCEPTION_DATE;
|
|
if (!string.IsNullOrWhiteSpace(Request["ABNORMALITY_START"]))
|
|
{
|
|
_ABNORMALITY_START = Request["ABNORMALITY_START"];
|
|
starttime.Value = Convert.ToDateTime(_ABNORMALITY_START).AddSeconds(-90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
else
|
|
{
|
|
starttime.Value = Convert.ToDateTime(_EXCEPTION_DATE).AddSeconds(-90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
endtime.Value = Convert.ToDateTime(_EXCEPTION_DATE).AddSeconds(90).ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
|
|
if (!string.IsNullOrEmpty(Request["EXCEPTIONTYPE"]))
|
|
{
|
|
_EXCEPTIONTYPE = Request["EXCEPTIONTYPE"].ToDecrypt();
|
|
EXCEPTIONTYPE.InnerText = _EXCEPTIONTYPE;
|
|
}
|
|
if (!string.IsNullOrEmpty(Request["VIDEO_IP"]))
|
|
{
|
|
_VIDEO_IP = Convert.ToInt32(Request["VIDEO_IP"].ToDecrypt());
|
|
}
|
|
_ABNORMALITY_CODE = Request["ABNORMALITY_CODE"];
|
|
_ABNORMALITY_PCODE = Request["ABNORMALITY_PCODE"];
|
|
#endregion
|
|
}
|
|
|
|
if (_VIDEO_IP == -1 && !string.IsNullOrWhiteSpace(_SERVERPARTCODE) &&
|
|
!string.IsNullOrWhiteSpace(_SHOPCODE) && !string.IsNullOrWhiteSpace(_MACHINECODE))
|
|
{
|
|
if (!string.IsNullOrWhiteSpace(_ABNORMALITY_CODE))
|
|
{
|
|
#region 异步查询商品明细
|
|
Task task = Task.Factory.StartNew(() =>
|
|
{
|
|
ServiceModel.Transaction transaction = new ServiceModel.Transaction();
|
|
|
|
SQLString = string.Format(@"SELECT
|
|
WMSYS.WM_CONCAT(COMMODITY_NAME || '(数量:' || COMMODITY_COUNT || ',单价:' || COMMODITY_PRICE || ')') AS DETILS,
|
|
NVL(SUM(CASE WHEN ABNORMALITY_STATE = 1 THEN COMMODITY_COUNT ELSE 0 END),0) AS EXCOUNT,
|
|
NVL(SUM(CASE WHEN ABNORMALITY_STATE = 1 THEN TOTALAMOUNT ELSE 0 END),0) AS EXAMOUNT,ABNORMALITY_CODE
|
|
FROM HIGHWAY_EXCHANGE.T_ABNORMALITYDETAIL_{0} A
|
|
WHERE ABNORMALITY_CODE = '{1}' GROUP BY ABNORMALITY_CODE", _SERVERPARTCODE,
|
|
!string.IsNullOrWhiteSpace(_ABNORMALITY_PCODE) ? _ABNORMALITY_PCODE : _ABNORMALITY_CODE);
|
|
DataTable AbnormalDetilsTable = new Business.ABNORMALITY(transaction).ExecuteDataTable(SQLString);
|
|
//解析异常稽核明细数据
|
|
switch (DictionaryHelper.GetFieldEnumValue("EXCEPTION_TYPE", _EXCEPTIONTYPE, _Transaction))
|
|
{
|
|
case "1060":
|
|
COMMODITY_NAME.InnerText = "商品单清操作时间:" + _ABNORMALITY_START;
|
|
break;
|
|
case "1020":
|
|
case "1011":
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "清除商品:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
case "1050":
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "商品明细:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
case "3010":
|
|
case "3020":
|
|
case "3990":
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "商品明细:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
case "2010":
|
|
case "2011":
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "重打单号交易时间:" + _ABNORMALITY_START +
|
|
",商品明细:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
case "1099":
|
|
COMMODITY_NAME.InnerText = "挂单时间:" + _ABNORMALITY_START + ",商品清除时间:" + _EXCEPTION_DATE.ToDecrypt();
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText += "\r\n" + ",商品明细:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
case "3030":
|
|
case "3050":
|
|
case "3060":
|
|
case "3040":
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "改价商品:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
default:
|
|
if (AbnormalDetilsTable.Rows.Count > 0)
|
|
{
|
|
COMMODITY_NAME.InnerText = "商品明细:" + AbnormalDetilsTable.Rows[0]["DETILS"].ToString();
|
|
}
|
|
break;
|
|
}
|
|
//释放资源
|
|
transaction.Dispose();
|
|
transaction.Release();
|
|
});
|
|
#endregion
|
|
}
|
|
Business.EXTRANET _EXTRANET = new Business.EXTRANET(_Transaction);
|
|
_EXTRANET.AddSearchParameter("SERVERPART_ID", _SERVERPART_ID);
|
|
if (_EXTRANET.Search())
|
|
{
|
|
#region 绑定稽核录像信息
|
|
EXTRANET_ID.Value = _EXTRANET.EXTRANET_ID_Encrypt;
|
|
//初始化登录IP、用户名、密码
|
|
loginip.Value = _EXTRANET.EXTRANET_IP;
|
|
username.Value = _EXTRANET.LOGUSERNAME;
|
|
password.Value = _EXTRANET.LOGPASSWORD;
|
|
|
|
loginip1.Value = _EXTRANET.EXTRANET_IP;
|
|
username1.Value = _EXTRANET.LOGUSERNAME;
|
|
password1.Value = _EXTRANET.LOGPASSWORD;
|
|
|
|
DataTable _DataTable = new Business.SHOPVIDEO(_Transaction).ExecuteDataTable(
|
|
"SELECT * FROM HIGHWAY_EXCHANGE.V_SHOPVIDEO WHERE SERVERPARTCODE = '" + _SERVERPARTCODE +
|
|
"' AND SHOPCODE = '" + _SHOPCODE + "'");
|
|
//稽核录像
|
|
if (_DataTable.Select("VEDIO_TYPE = 2000 AND MACHINECODE = '" + _MACHINECODE + "'").Length > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Select("VEDIO_TYPE = 2000 AND MACHINECODE = '" + _MACHINECODE + "'")[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
_VIDEO_IP = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ? -1 :
|
|
int.Parse(_DataRow["VIDEO_IP"].ToString());
|
|
SHOPVIDEO_ID.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
else
|
|
{
|
|
|
|
if (_DataTable.Select("VEDIO_TYPE = 2000").Length > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Select("VEDIO_TYPE = 2000")[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
_VIDEO_IP = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ? -1 :
|
|
int.Parse(_DataRow["VIDEO_IP"].ToString());
|
|
SHOPVIDEO_ID.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
else if (_DataTable.Rows.Count > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Rows[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
_VIDEO_IP = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ? -1 :
|
|
int.Parse(_DataRow["VIDEO_IP"].ToString());
|
|
SHOPVIDEO_ID.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
}
|
|
|
|
//全景录像
|
|
if (_DataTable.Select("VEDIO_TYPE = 1000 AND MACHINECODE = '" + _MACHINECODE + "'").Length > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Select("VEDIO_TYPE = 1000 AND MACHINECODE = '" + _MACHINECODE + "'")[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username1.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password1.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port1.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport1.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
VIDEO_IP.Value = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ?
|
|
"-1" : _DataRow["VIDEO_IP"].ToString();
|
|
SHOPVIDEO_ID1.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
else
|
|
{
|
|
if (_DataTable.Select("VEDIO_TYPE = 1000").Length > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Select("VEDIO_TYPE = 1000")[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username1.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password1.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port1.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport1.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
VIDEO_IP.Value = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ?
|
|
"-1" : _DataRow["VIDEO_IP"].ToString();
|
|
SHOPVIDEO_ID1.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
else
|
|
{
|
|
if (_DataTable.Rows.Count > 0)
|
|
{
|
|
DataRow _DataRow = _DataTable.Rows[0];
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGUSERNAME"].ToString()))
|
|
{
|
|
username1.Value = _DataRow["LOGUSERNAME"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGPASSWORD"].ToString()))
|
|
{
|
|
password1.Value = _DataRow["LOGPASSWORD"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["LOGINPORT"].ToString()))
|
|
{
|
|
port1.Value = _DataRow["LOGINPORT"].ToString();
|
|
}
|
|
if (!string.IsNullOrEmpty(_DataRow["VIDEOPORT"].ToString()))
|
|
{
|
|
deviceport1.Value = _DataRow["VIDEOPORT"].ToString();
|
|
}
|
|
VIDEO_IP.Value = string.IsNullOrEmpty(_DataRow["VIDEO_IP"].ToString()) ?
|
|
"0" : _DataRow["VIDEO_IP"].ToString();
|
|
SHOPVIDEO_ID1.Value = _DataRow["SHOPVIDEO_ID"].ToString();
|
|
}
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
}
|
|
else
|
|
{
|
|
VIDEO_IP.Value = _VIDEO_IP.ToString();
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
SuperMap.RealEstate.Utility.ErrorLogHelper.Write(ex);
|
|
}
|
|
finally
|
|
{
|
|
_Transaction.Dispose();
|
|
_Transaction.Release();
|
|
}
|
|
}
|
|
}
|
|
} |