public Loc_NetBarInfo GetNetBarModelById(int id)
{
string sql = "SELECT nbi.*,so.SECURITY_SOFTWARE_ORGNAME,so.SECURITY_SOFTWARE_ORGCODE FROM NetBarInfo AS nbi LEFT JOIN SecurityOrg AS so ON nbi.SecId=so.ID WHERE nbi.ID=@id";
Loc_NetBarInfo ds = SqlHelper.ExecuteModel <Loc_NetBarInfo>(SqlHelper.DBConnStr, sql, new SqlParameter("@id", id));
//DataSetConvert convert = new DataSetConvert(ds);
return(ds);
}
/// <summary>
/// 获取缓存中场所对象信息
/// </summary>
/// <param name="keyword"></param>
/// <returns></returns>
public static Loc_NetBarInfo GetLocaInfoByNetBar_ID(int NETBAR_ID, string Lname)
{
Loc_NetBarInfo loca = GetLocaInfoByNetBar_ID_Two(NETBAR_ID, Lname);
if (loca == null)
{
return(GetLocaInfoByNetBar_ID_Two(NETBAR_ID, Lname));
}
return(loca);
}
/// <summary>
/// 根据ID或者场所名称获取场所详细信息
/// </summary>
/// <param name="id"></param>
/// <param name="TableKey"></param>
/// <returns></returns>
public Loc_NetBarInfo GetLocaByIdOrName(int id, string locaName)
{
string sql = "SELECT top 1 nbi.* FROM NetBarInfo nbi where ";
sql += id > 0 ? "nbi.ID=@key" : "nbi.PLACE_NAME=@key";
//DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.DBConnStr, CommandType.Text, sql, new SqlParameter("@key", (id > 0 ? id.ToString() : locaName)));
//return new DataSetConvert(ds).Get_SingleModel<Loc_NetBarInfo>();
Loc_NetBarInfo nbi = SqlHelper.ExecuteModel <Loc_NetBarInfo>(SqlHelper.DBConnStr, sql, new SqlParameter("@key", (id > 0 ? id.ToString() : locaName)));
return(nbi);
}
public bool UpdateLoca(Loc_NetBarInfo loca, bool isTrue)
{
//,ACSSES_IP = @ACSSES_IP
string sql = "if EXISTS(select * from NetBarInfo where APNum=1 and id=@ID)BEGIN update DevInfo set LONGITUDE=@LONGITUDE,LATITUDE=@LATITUDE WHERE NETBAR_ID=@ID AND APTYPE=1 END; UPDATE NetBarInfo SET NETBAR_WACODE = @NETBAR_WACODE,PLACE_NAME = @PLACE_NAME,SITE_ADDRESS = @SITE_ADDRESS,LONGITUDE = @LONGITUDE,LATITUDE = @LATITUDE,NETSITE_TYPE = @NETSITE_TYPE,BUSINESS_NATURE = @BUSINESS_NATURE,LAW_PRINCIPAL_NAME = @LAW_PRINCIPAL_NAME,LAW_PRINCIPAL_CERTIFICATE_TYPE = @LAW_PRINCIPAL_CERTIFICATE_TYPE,LAW_PRINCIPAL_CERTIFICATE_ID = @LAW_PRINCIPAL_CERTIFICATE_ID,RELATIONSHIP_ACCOUNT = @RELATIONSHIP_ACCOUNT,START_TIME = @START_TIME,END_TIME = @END_TIME,ACCESS_TYPE = @ACCESS_TYPE,OPERATOR_NET = @OPERATOR_NET,CODE_ALLOCATION_ORGANIZATION = @CODE_ALLOCATION_ORGANIZATION,";
if (isTrue)
{
sql += "Statis = @Statis,";
}
sql += "Service_code = @Service_code,ProID = @ProID,CityID = @CityID,Aid = @Aid,Pid = @Pid,[Sid] = @Sid,SecId = @SecId,Verified = @Verified,IsUpdate_NETBAR_WACODE=@IsUpdate_NETBAR_WACODE WHERE ID=@ID; update DevInfo set NETBAR_WACODE=@NETBAR_WACODE where NETBAR_ID=@ID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@NETBAR_WACODE", loca.NETBAR_WACODE),
new SqlParameter("@PLACE_NAME", loca.PLACE_NAME),
new SqlParameter("@SITE_ADDRESS", loca.SITE_ADDRESS),
new SqlParameter("@LONGITUDE", loca.LONGITUDE),
new SqlParameter("@LATITUDE", loca.LATITUDE),
new SqlParameter("@NETSITE_TYPE", loca.NETSITE_TYPE),
new SqlParameter("@BUSINESS_NATURE", loca.BUSINESS_NATURE),
new SqlParameter("@LAW_PRINCIPAL_NAME", loca.LAW_PRINCIPAL_NAME),
new SqlParameter("@LAW_PRINCIPAL_CERTIFICATE_TYPE", loca.LAW_PRINCIPAL_CERTIFICATE_TYPE),
new SqlParameter("@LAW_PRINCIPAL_CERTIFICATE_ID", loca.LAW_PRINCIPAL_CERTIFICATE_ID),
new SqlParameter("@RELATIONSHIP_ACCOUNT", loca.RELATIONSHIP_ACCOUNT),
new SqlParameter("@START_TIME", loca.START_TIME),
new SqlParameter("@END_TIME", loca.END_TIME),
new SqlParameter("@ACCESS_TYPE", loca.ACCESS_TYPE),
new SqlParameter("@OPERATOR_NET", loca.OPERATOR_NET),
//new SqlParameter("@ACSSES_IP",loca.ACSSES_IP),
new SqlParameter("@Service_code", loca.Service_code),
new SqlParameter("@ProID", loca.ProID),
new SqlParameter("@CityID", loca.CityID),
new SqlParameter("@Aid", loca.Aid),
new SqlParameter("@Pid", loca.Pid),
new SqlParameter("@Sid", loca.Sid),
new SqlParameter("@SecId", loca.SecId),
new SqlParameter("@Statis", loca.Statis),
new SqlParameter("@Verified", loca.Verified),
new SqlParameter("@ID", loca.ID),
new SqlParameter("@IsUpdate_NETBAR_WACODE", loca.IsUpdate_NETBAR_WACODE),
new SqlParameter("@CODE_ALLOCATION_ORGANIZATION", loca.CODE_ALLOCATION_ORGANIZATION)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param) > 0);
}
public int InsertLocation(Loc_NetBarInfo loca)
{
string sql = "INSERT INTO NetBarInfo(NETBAR_WACODE,PLACE_NAME,SITE_ADDRESS,LONGITUDE,LATITUDE,NETSITE_TYPE,BUSINESS_NATURE,LAW_PRINCIPAL_NAME,LAW_PRINCIPAL_CERTIFICATE_TYPE,LAW_PRINCIPAL_CERTIFICATE_ID,RELATIONSHIP_ACCOUNT,START_TIME,END_TIME,ACCESS_TYPE,OPERATOR_NET,Statis,Valid,Createtime,Verified,Service_code,ProID,CityID,Aid,Pid,[Sid],SecId,CODE_ALLOCATION_ORGANIZATION)VALUES(@NETBAR_WACODE,@PLACE_NAME,@SITE_ADDRESS,@LONGITUDE,@LATITUDE,@NETSITE_TYPE,@BUSINESS_NATURE,@LAW_PRINCIPAL_NAME,@LAW_PRINCIPAL_CERTIFICATE_TYPE,@LAW_PRINCIPAL_CERTIFICATE_ID,@RELATIONSHIP_ACCOUNT,@START_TIME,@END_TIME,@ACCESS_TYPE,@OPERATOR_NET,@Statis,@Valid,@Createtime,@Verified,@Service_code,@ProID,@CityID,@Aid,@Pid,@Sid,@SecId,@CODE_ALLOCATION_ORGANIZATION); SELECT SCOPE_IDENTITY();";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@NETBAR_WACODE", loca.NETBAR_WACODE),
new SqlParameter("@PLACE_NAME", loca.PLACE_NAME),
new SqlParameter("@SITE_ADDRESS", loca.SITE_ADDRESS),
new SqlParameter("@LONGITUDE", loca.LONGITUDE),
new SqlParameter("@LATITUDE", loca.LATITUDE),
new SqlParameter("@NETSITE_TYPE", loca.NETSITE_TYPE),
new SqlParameter("@BUSINESS_NATURE", loca.BUSINESS_NATURE),
new SqlParameter("@LAW_PRINCIPAL_NAME", loca.LAW_PRINCIPAL_NAME),
new SqlParameter("@LAW_PRINCIPAL_CERTIFICATE_TYPE", loca.LAW_PRINCIPAL_CERTIFICATE_TYPE),
new SqlParameter("@LAW_PRINCIPAL_CERTIFICATE_ID", loca.LAW_PRINCIPAL_CERTIFICATE_ID),
new SqlParameter("@RELATIONSHIP_ACCOUNT", loca.RELATIONSHIP_ACCOUNT),
new SqlParameter("@START_TIME", loca.START_TIME),
new SqlParameter("@END_TIME", loca.END_TIME),
new SqlParameter("@ACCESS_TYPE", loca.ACCESS_TYPE),
new SqlParameter("@OPERATOR_NET", loca.OPERATOR_NET),
//new SqlParameter("@ACSSES_IP",loca.ACSSES_IP),
new SqlParameter("@Statis", loca.Statis),
new SqlParameter("@Valid", loca.Valid),
new SqlParameter("@Createtime", loca.Createtime),
new SqlParameter("@Verified", loca.Verified),
new SqlParameter("@Service_code", loca.Service_code),
new SqlParameter("@ProID", loca.ProID),
new SqlParameter("@CityID", loca.CityID),
new SqlParameter("@Aid", loca.Aid),
new SqlParameter("@Pid", loca.Pid),
new SqlParameter("@Sid", loca.Sid),
new SqlParameter("@SecId", loca.SecId),
new SqlParameter("@CODE_ALLOCATION_ORGANIZATION", loca.CODE_ALLOCATION_ORGANIZATION)
};
int LocalId = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.DBConnStr, CommandType.Text, sql, para));
return(LocalId);
}
/// <summary>
///MAC分析调用Java
/// </summary>
/// <param name="ids">设备id</param>
/// <param name="txtStartTimes">开始时间</param>
/// <param name="txtEndTimes">结束时间</param>
/// <param name="keys">碰撞次数/Mac地址</param>
/// <param name="type">类别：1碰撞、2伴随、3出现设备、4消失设备</param>
/// <returns></returns>
public List <Collision> GetJavaData(string ids, string txtStartTimes, string txtEndTimes, string keys, string type)
{
string CacheType = string.Empty;
UserInfo dbUser = (UserInfo)HttpContext.Current.Session["userinfo"];
java.InnerChannel.OperationTimeout = new TimeSpan(0, 10, 0);
ids = ids.Substring(ids.Length - 1, 1) == "_" ? ids.Substring(0, ids.Length - 1) : ids;
txtStartTimes = txtStartTimes == "NaN_" ? "0": txtStartTimes.Substring(txtStartTimes.Length - 1, 1) == "_" ? txtStartTimes.Substring(0, txtStartTimes.Length - 1) : txtStartTimes;
txtEndTimes = txtEndTimes == "NaN_" ? "4099776775" : txtEndTimes.Substring(txtEndTimes.Length - 1, 1) == "_" ? txtEndTimes.Substring(0, txtEndTimes.Length - 1) : txtEndTimes;
List <Collision> clList = new List <Collision>();
var argjson = "";
switch (type)
{
case "1":
var arg = new
{
size = keys,
devIds = ids,
startTime = txtStartTimes,
endTime = txtEndTimes,
};
argjson = Newtonsoft.Json.JsonConvert.SerializeObject(arg);
argjson = java.collisionAnalysisMAC(argjson);
CacheType = "pz";
break;
case "2":
var arg2 = new
{
mac = keys,
devIds = ids,
startTime = txtStartTimes,
endTime = txtEndTimes
};
argjson = Newtonsoft.Json.JsonConvert.SerializeObject(arg2);
argjson = java.accompanyAnalysisMAC(argjson);
CacheType = "bs";
break;
case "3":
var arg3 = new
{
devIds = ids,
startTime = txtStartTimes,
endTime = txtEndTimes,
};
argjson = Newtonsoft.Json.JsonConvert.SerializeObject(arg3);
argjson = java.appearDevMAC(argjson);
CacheType = "cx";
break;
case "4":
var arg4 = new
{
devIds = ids,
startTime = txtStartTimes,
endTime = txtEndTimes,
};
argjson = Newtonsoft.Json.JsonConvert.SerializeObject(arg4);
argjson = java.disappearDevMAC(argjson);
CacheType = "xs";
break;
default: break;
}
HttpContext.Current.Cache.Insert(CacheType + "ids" + dbUser.ID, ids, null, DateTime.Now.AddHours(5), TimeSpan.Zero);
HttpContext.Current.Cache.Insert(CacheType + "txtStartTimes" + dbUser.ID, txtStartTimes, null, DateTime.Now.AddHours(5), TimeSpan.Zero);
HttpContext.Current.Cache.Insert(CacheType + "txtEndTimes" + dbUser.ID, txtEndTimes, null, DateTime.Now.AddHours(5), TimeSpan.Zero);
HttpContext.Current.Cache.Insert(CacheType + "keys" + dbUser.ID, keys, null, DateTime.Now.AddHours(5), TimeSpan.Zero);
var Json = Newtonsoft.Json.Linq.JObject.Parse(argjson);
if (Json["state"].ToString() == "1")
{
return(clList);
}
else
{
switch (type)
{
case "1":
clList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Collision> >(Json["collisionAnalysisMACResult"].ToString());
break;
case "2":
clList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Collision> >(Json["accompanyAnalysisMACResult"].ToString());
break;
default:
string relult = type == "3" ? "appearDevMACResult" : "disappearDevMACResult";
clList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Collision> >(Json["" + relult + ""].ToString());
if ((List <Loc_NetBarInfo>)System.Web.HttpContext.Current.Cache["ShowCacheLoca"] == null)
{
WebCommon.GetCacheLoca();
}
List <Loc_NetBarInfo> netlist = (List <Loc_NetBarInfo>)System.Web.HttpContext.Current.Cache["ShowCacheLoca"];
//获取设备缓存
if ((List <Loc_DevInfo>)System.Web.HttpContext.Current.Cache["CacheMacAll"] == null)
{
WebCommon.GetCacheMacAllList();
}
List <Loc_DevInfo> delist = (List <Loc_DevInfo>)System.Web.HttpContext.Current.Cache["CacheMacAll"];
for (int i = 0; i < clList.Count; i++)
{
Loc_DevInfo dev = delist.Find(a => a.ID.Equals(clList[i].DevAP_ID));
if (dev != null)
{
Loc_NetBarInfo loc = netlist.Find(a => a.ID == (dev.NETBAR_ID));
if (loc != null)
{
clList[i].PLACE_NAME = loc.PLACE_NAME;
clList[i].APName = dev.APName;
}
}
// clList[i].CAPTURE_TIME = Szcert.Audit.CommonBase.ChangeValueBase.RefAuditTime(Convert.ToInt64(clList[i].CAPTURE_TIME));
clList[i].CAPTURE_TIME = HCZZ.Common.ChangeValue.RefAuditTime(Convert.ToInt64(clList[i].CAPTURE_TIME));
}
break;
}
//HttpContext.Current.Cache.Insert("MACAnalyzeDate", clList, null, DateTime.Now.AddHours(5), TimeSpan.Zero);
return(clList);
}
}
