/// <summary>
/// 修改安全厂商管理信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpadteSec(SecurityOrg sec)
{
string sql = "";
try
{
sql = "UPDATE SecurityOrg SET SECURITY_SOFTWARE_ORGNAME = @SECURITY_SOFTWARE_ORGNAME,SECURITY_SOFTWARE_ORGCODE = @SECURITY_SOFTWARE_ORGCODE,SECURITY_SOFTWARE_ORG_ADDRESS = @SECURITY_SOFTWARE_ORG_ADDRESS,CONTACTOR = @CONTACTOR,CONTACTOR_TEL = @CONTACTOR_TEL,CONTACTOR_MAIL = @CONTACTOR_MAIL WHERE ID=@Id ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@SECURITY_SOFTWARE_ORGNAME", sec.SECURITY_SOFTWARE_ORGNAME),
new SqlParameter("@SECURITY_SOFTWARE_ORGCODE", sec.SECURITY_SOFTWARE_ORGCODE),
new SqlParameter("@SECURITY_SOFTWARE_ORG_ADDRESS", sec.SECURITY_SOFTWARE_ORG_ADDRESS),
new SqlParameter("@CONTACTOR", sec.CONTACTOR),
new SqlParameter("@CONTACTOR_TEL", sec.CONTACTOR_TEL),
new SqlParameter("@CONTACTOR_MAIL", sec.CONTACTOR_MAIL),
new SqlParameter("@Id", sec.ID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "HBHtmlDAL.UpadteSec(SecurityOrg sec)" },
{ "SQL", sql }
});
throw ex;
}
}
/// <summary>
/// 添加安全厂商管理信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertOrg(SecurityOrg sec)
{
string sql = "";
try
{
sql = "INSERT INTO SecurityOrg(SECURITY_SOFTWARE_ORGNAME,SECURITY_SOFTWARE_ORGCODE,SECURITY_SOFTWARE_ORG_ADDRESS,CONTACTOR,CONTACTOR_TEL,CONTACTOR_MAIL,CreateTime)VALUES(@SECURITY_SOFTWARE_ORGNAME,@SECURITY_SOFTWARE_ORGCODE,@SECURITY_SOFTWARE_ORG_ADDRESS,@CONTACTOR,@CONTACTOR_TEL,@CONTACTOR_MAIL,getdate())";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@SECURITY_SOFTWARE_ORGNAME", sec.SECURITY_SOFTWARE_ORGNAME),
new SqlParameter("@SECURITY_SOFTWARE_ORGCODE", sec.SECURITY_SOFTWARE_ORGCODE),
new SqlParameter("@SECURITY_SOFTWARE_ORG_ADDRESS", sec.SECURITY_SOFTWARE_ORG_ADDRESS),
new SqlParameter("@CONTACTOR", sec.CONTACTOR),
new SqlParameter("@CONTACTOR_TEL", sec.CONTACTOR_TEL),
new SqlParameter("@CONTACTOR_MAIL", sec.CONTACTOR_MAIL)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "HBHtmlDAL.InsertOrg(SecurityOrg sec)" },
{ "SQL", sql }
});
throw ex;
}
}
/// <summary>
/// 获取安全厂商管理详细信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public SecurityOrg GetSecId(int Id)
{
string sql = "";
try
{
sql = "SELECT *,(SELECT count(0) FROM TermianlNetworkLog tnl WHERE tnl.SecId = so.id AND tnl.NETWORK_APP = '24' GROUP BY tnl.SecId) IMEINum,(SELECT count(0) FROM TermianlNetworkLog tnl WHERE tnl.SecId = so.id AND tnl.NETWORK_APP = '25' GROUP BY tnl.SecId) IMSINum,(SELECT COUNT(0) FROM TermianlNetworkLog tnl WHERE tnl.SecId = so.ID AND tnl.NETWORK_APP NOT IN(24, 25)) virtualNum,(SELECT count(0) FROM TermianlNetworkLog tnl WHERE tnl.SecId = so.id GROUP BY tnl.SecId) MACNum FROM SecurityOrg so WHERE SO.ID = @Id";
//DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.DBConnStr, CommandType.Text, sql, new SqlParameter("@Id", Id));
SecurityOrg model = SqlHelper.ExecuteModel <SecurityOrg>(sql, new SqlParameter("@Id", Id));
//return new DataSetConvert(ds).Get_SingleModel<SecurityOrg>();
return(model);
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "HBHtmlDAL.GetSecId(int Id)" },
{ "SQL", sql }
});
throw ex;
}
}
