/// <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; } }