public List <ConfigParaServiceMap> GetValidDomainConfigParaServiceMap(ConfigParaKeyValue configParaKeyValue)
{
var collection = new NDbParameterCollection();
string sqlStr = string.Format(@"SELECT * from ConfigParaServiceMap WHERE ID in (select sid from ConfigParaValidDomain WHERE cid={0}cid)", this._dbAccess.ParaSign);
collection.Add("cid", configParaKeyValue.ID);
return(this._dbAccess.QueryT <ConfigParaServiceMap>(sqlStr, collection));
}
public List <ConfigParaKeyValue> GetConfigParaKeyValueByServiceId(int serviceID)
{
string sqlStr = string.Format(@"SELECT * FROM ConfigParaKeyValue WHERE ID in (SELECT CID FROM ConfigParaValidDomain WHERE SID={0}SID)", this._dbAccess.ParaSign);
var collection = new NDbParameterCollection();
collection.Add("SID", serviceID);
var items = this._dbAccess.Query <ConfigParaKeyValue>(sqlStr, collection);
this.UpdateConfigParaGroup(items);
return(items);
}
public List <ConfigParaServiceMap3> GetConfigParaServiceMap(int id)
{
string sqlStr = string.Format("SELECT * FROM ConfigParaServiceMap WHERE ID IN (SELECT SID from ConfigParaValidDomain WHERE CID={0}CID)", this._dbAccess.ParaSign);
NDbParameterCollection collection = new NDbParameterCollection();
collection.Add("CID", id);
var validServiceDic = this._dbAccess.QueryT <ConfigParaServiceMap>(sqlStr, collection).ToDictionary((tmpItem) => { return(tmpItem.ID); });
var allServcieMap = this._dbAccess.QueryT <ConfigParaServiceMap>();
List <ConfigParaServiceMap3> items = new List <ConfigParaServiceMap3>();
foreach (var servcieMap in allServcieMap)
{
items.Add(new ConfigParaServiceMap3(servcieMap, validServiceDic.ContainsKey(servcieMap.ID)));
}
return(items);
}
