/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/3/11 14:44:58</remarks> public bool Update(ConfigCrosssiteEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigCrosssite_Update"); database.AddInParameter(commandWrapper, "@Id", DbType.Int32, entity.Id); database.AddInParameter(commandWrapper, "@DomainId", DbType.Int32, entity.DomainId); database.AddInParameter(commandWrapper, "@DomainName", DbType.String, entity.DomainName); database.AddInParameter(commandWrapper, "@SiteId", DbType.AnsiString, entity.SiteId); database.AddInParameter(commandWrapper, "@SiteName", DbType.String, entity.SiteName); database.AddInParameter(commandWrapper, "@ShowSiteId", DbType.String, entity.ShowSiteId); database.AddInParameter(commandWrapper, "@ShowSiteName", DbType.String, entity.ShowSiteName); database.AddInParameter(commandWrapper, "@InvalidFlag", DbType.Int32, entity.InvalidFlag); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Id = (System.Int32)database.GetParameterValue(commandWrapper, "@Id"); return(Convert.ToBoolean(results)); }
private CrossSiteCache() { try { s_lstDomains.Clear(); s_dicDomains.Clear(); s_dicSites.Clear(); s_lstSites.Clear(); ConfigCrosssiteEntity siteItem = null; var sites = ConfigCrosssiteMgr.GetAll(); var zones = AllZoneinfoMgr.GetAllForFactory(); foreach (var item in sites) { s_dicSites[item.SiteId] = item; if (!s_dicDomains.ContainsKey(item.DomainId)) { s_dicDomains[item.DomainId] = new List <string>(); } s_dicDomains[item.DomainId].Add(item.SiteId); s_lstSites.Add(item); } foreach (var item in zones) { if (s_dicSites.ContainsKey(item.ZoneName)) { continue; } siteItem = GetSiteItem(item); s_dicSites[siteItem.SiteId] = siteItem; if (!s_dicDomains.ContainsKey(siteItem.DomainId)) { s_dicDomains[siteItem.DomainId] = new List <string>(); } s_dicDomains[siteItem.DomainId].Add(siteItem.SiteId); s_lstSites.Add(siteItem); s_lstSitesName.Add(item.ZoneName); } foreach (var val in s_dicDomains.Keys) { s_lstDomains.Add(val); } this.InitFlag = true; } catch (Exception ex) { SystemlogMgr.Error("CrossSiteCache:Init", ex); this.InitFlag = false; } }
ConfigCrosssiteEntity GetSiteItem(AllZoneinfoEntity src) { if (null == src) { return(null); } var obj = new ConfigCrosssiteEntity(); obj.DomainId = ROOTDomainId; obj.DomainName = "Root"; obj.SiteId = src.ZoneName; obj.SiteName = src.CrossName; obj.ShowSiteId = src.CrossName; obj.ShowSiteName = src.CrossName; return(obj); }
/// <summary> /// 将IDataReader的当前记录读取到ConfigCrosssiteEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigCrosssiteEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigCrosssiteEntity(); obj.Id = (System.Int32)reader["Id"]; obj.DomainId = (System.Int32)reader["DomainId"]; obj.DomainName = (System.String)reader["DomainName"]; obj.SiteId = (System.String)reader["SiteId"]; obj.SiteName = (System.String)reader["SiteName"]; obj.ShowSiteId = (System.String)reader["ShowSiteId"]; obj.ShowSiteName = (System.String)reader["ShowSiteName"]; obj.InvalidFlag = (System.Int32)reader["InvalidFlag"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="id">id</param> /// <returns>ConfigCrosssiteEntity</returns> /// <remarks>2016/3/11 14:44:58</remarks> public ConfigCrosssiteEntity GetById(System.Int32 id) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigCrosssite_GetById"); database.AddInParameter(commandWrapper, "@Id", DbType.Int32, id); ConfigCrosssiteEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public bool TryGetSite(string siteId, out ConfigCrosssiteEntity cfg) { return(s_dicSites.TryGetValue(siteId, out cfg)); }
public static bool Update(ConfigCrosssiteEntity configCrosssiteEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigCrosssiteProvider(zoneId); return(provider.Update(configCrosssiteEntity, trans)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/3/11 14:44:58</remarks> public bool Update(ConfigCrosssiteEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/3/11 14:44:58</remarks> public bool Insert(ConfigCrosssiteEntity entity) { return(Insert(entity, null)); }