/// <summary> /// 获取产品库存信息表 /// </summary> /// <returns></returns> public IList <kdt_style_kucun_procResult> GetProductInfos(string searchT, string searchV, int page, out int total) { using (dataContext = new DataClassesDataContext()) { #region //return (from q in dataContext.kucun_kdt_view // group q by new { q.Com_nm, q.Sty_no } into g // select new StyleInfo // { // Style_Name=g.Key.Com_nm, // Style_No = g.Key.Sty_no, // Count = g.Sum(p => p.Com_qu) // }).OrderBy(p=>p.Style_No).Skip(0).Take(10).ToList(); #endregion IMultipleResults query = null; switch (searchT) { case "1": //按款式查询 query = dataContext.kdt_style_kucun_proc2(searchV, string.Empty, 0, 1, page); break; case "2": //按名称查询 query = dataContext.kdt_style_kucun_proc2(string.Empty, searchV, 0, 2, page); break; case "3": //按库存数查询 query = dataContext.kdt_style_kucun_proc2(string.Empty, string.Empty, Convert.ToDecimal(searchV), 3, page); break; default: //查询所有 query = dataContext.kdt_style_kucun_proc2(string.Empty, string.Empty, 0, 4, page); break; } var kucun = query.GetResult <kdt_style_kucun_procResult>().ToList(); if (page == 1) { HttpContext.Current.Cache.Remove("total"); } if (HttpContext.Current.Cache["total"] == null) { total = query.GetResult <int>().FirstOrDefault(); HttpContext.Current.Cache["total"] = total; } else { total = (int)HttpContext.Current.Cache["total"]; } return(kucun); //.Skip((page-1)*10).Take(10).ToList(); } }
/// <summary> /// Loads the data. /// </summary> /// <param name="userName">Name of the user.</param> /// <param name="password">The password.</param> /// <param name="windowsUserName">Name of the windows user.</param> private void LoadData(string userName, string password, string windowsUserName) { IMultipleResults multipleResults = GetData(userName, password, windowsUserName); IList <User> users = multipleResults.GetResult <User>().ToList(); if (users.Count > 0) { User = users[0]; _authorizationInfo = multipleResults.GetResult <AuthorizationInfo>().ToList(); } }
public void Test_Batch_Queries() { using (var db = new TrackerDataContext { Log = Console.Out }) { var q1 = from u in db.User select u; var q2 = from ur in db.UserRole select ur; IMultipleResults results = db.ExecuteQuery(q1, q2); List <User> users = results.GetResult <User>().ToList(); List <UserRole> roles = results.GetResult <UserRole>().ToList(); } }
public IEnumerable <AuthorizationInfo> GetAuthorizationInfo(string username, string password) { IMultipleResults multipleResults = GetData(username, password, ""); IEnumerable <AuthorizationInfo> authorizationInfo = null; IList <User> users = multipleResults.GetResult <User>().ToList(); if (users != null && users.Count > 0) { User = users[0]; authorizationInfo = multipleResults.GetResult <AuthorizationInfo>().ToList(); } return(authorizationInfo); }
//検索処理 private List <tblPedictionCall> SearchData(string pageIndex, string pageSize, string pageTotal, DateTime dtST, DateTime dtEnd, string dateType, string vSkillIDs, string vSkillAgregationIDs) { AppLog.WriteLog("CallReportController SearchData start"); List <tblPedictionCall> result = new List <tblPedictionCall>(); try { int currentPageIndex = m_CurPageIndex; int currentPageSize = m_CurrentPageSize; int.TryParse(pageIndex, out currentPageIndex); int.TryParse(pageSize, out currentPageSize); int isByAggregation = 0; m_CurPageIndex = currentPageIndex; m_CurrentPageSize = currentPageSize; string strSortField = GetSortField(m_SortField); string strSort = AppFunction.GetSortDefine(m_Sort); ViewBag.vTenantID = this.TenantID; ViewBag.vTenantSpeciaFlag = this.TenantSpecialFlag; if (ViewBag.RadioChecked == "byAgregation") { isByAggregation = 1; } //ページを再計算する CalcPage(pageTotal); AppLog.WriteLog("CallReportController SearchData db excute start"); using (WFMDBDataContext db = new WFMDBDataContext()) { IMultipleResults results = db.uspWFMRptOfRealAndPredictionInboundCall(m_CurPageIndex, m_CurrentPageSize, strSortField, strSort, this.TenantID, dtST, dtEnd, dateType, isByAggregation, vSkillIDs, vSkillAgregationIDs); result = results.GetResult <tblPedictionCall>().ToList(); tblDataPaged tblPage = results.GetResult <tblDataPaged>().FirstOrDefault(); m_TotalRowCount = tblPage.TotalRowCount; m_CurPageIndex = tblPage.CurPageIndex; m_TotlePageCount = tblPage.TotalPageCount; } } catch (Exception ex) { AppLog.WriteLog(ex.Message + ex.StackTrace); } return(result); }
public void LinqToSqlStoredProc03_2() { IMultipleResults result = DB.WholeOrPartialCustomersSet(2); IEnumerable <PartialCustomersSetResult> shape2 = result.GetResult <PartialCustomersSetResult> (); TestExecutor.Execute(shape2, MethodBase.GetCurrentMethod()); }
void CallMultiple() { // <Snippet5> Northwnd db = new Northwnd(@"c:\northwnd.mdf"); // Assign the results of the procedure with an argument // of (1) to local variable 'result'. IMultipleResults result = db.VariableResultShapes(1); // Iterate through the list and write results (the company names) // to the console. foreach (VariableResultShapesResult1 compName in result.GetResult <VariableResultShapesResult1>()) { Console.WriteLine(compName.CompanyName); } // Pause to view company names; press Enter to continue. Console.ReadLine(); // Assign the results of the procedure with an argument // of (2) to local variable 'result'. IMultipleResults result2 = db.VariableResultShapes(2); // Iterate through the list and write results (the order IDs) // to the console. foreach (VariableResultShapesResult2 ord in result2.GetResult <VariableResultShapesResult2>()) { Console.WriteLine(ord.OrderID); } // </Snippet5> }
/// <summary> /// Sets the underling value after the query has been executed. /// </summary> /// <param name="result">The <see cref="IMultipleResults"/> to get the result from.</param> protected virtual void SetResult(IMultipleResults result) { _isLoaded = true; List <T> resultList = null; try { var resultSet = result.GetResult <T>(); resultList = resultSet != null?resultSet.ToList() : new List <T>(); _result = resultList; } catch (Exception ex) { Exception = ex; } if (_cacheSettings == null || resultList == null) { return; } // cache the result string key = GetKey(); QueryResultCache.SetResultCache(key, _cacheSettings, resultList); }
public int SendEmailWithOutTemplate(string fromAddress, string fromAddressName, string toAddress, string bccAddress, string ccAddress, string subject, string body) { int mailQId = 0; try { using (MailQDataContext mailqContextWithOutTemplate = new MailQDataContext()) { IMultipleResults results = mailqContextWithOutTemplate.SendEmailWithOutTemplate( Sitecore.Configuration.Settings.GetSetting(FROM_ADDRESS_KEYNAME) , Sitecore.Configuration.Settings.GetSetting(FROM_KEYNAME) , bccAddress , ccAddress , toAddress , subject , body , HTML_CONTENT ); MailQID mailQ = results.GetResult <MailQID>().FirstOrDefault(); if (mailQ != null) { mailQId = mailQ.Value; } } } catch (Exception ex) { Log.Error(String.Format("Genworth.SitecoreExt.MailSender: SendEmailWithOutTemplate failed due to {0}", ex.Message), this); throw; } return(mailQId); }
public void LinqToSqlStoredProc04_2() { IMultipleResults result = DB.GetCustomerAndOrders("SEVES"); IEnumerable <OrdersResultSet> orders = result.GetResult <OrdersResultSet> (); TestExecutor.Execute(orders, MethodBase.GetCurrentMethod()); }
void method7seq() { // <Snippet7> Northwnd db = new Northwnd(@"c:\northwnd.mdf"); IMultipleResults sprocResults = db.MultipleResultTypesSequentially(); // First read products. foreach (Product prod in sprocResults.GetResult <Product>()) { Console.WriteLine(prod.ProductID); } // Next read customers. foreach (Customer cust in sprocResults.GetResult <Customer>()) { Console.WriteLine(cust.CustomerID); } // </Snippet7> }
//検索処理 private List <tblCallDetailV3> SearchData(string pageIndex, string pageSize, string pageTotal, DateTime dtST, DateTime dtEnd, string vCalleeid, string vCallerid, int skillID, int isessionprofileid, int iConntype, int iCompletedCall, int iQueCall, int iHasTransfer, int iHasACD, int iGroupID) { AppLog.WriteLog(string.Format("CallDetailController SearchData paramter is pageIndex:{0},pageSize:{1},pageTotal:{2},dtST:{3},dtEnd:{4},vCalleeid:{5},skillID:{6},groupid:{7}", pageIndex, pageSize, pageTotal, dtST.ToString(AppConst.Const_Format_YMDHMS) , dtEnd.ToString(AppConst.Const_Format_YMDHMS), vCalleeid, skillID.ToString(), iGroupID.ToString())); List <tblCallDetailV3> result = new List <tblCallDetailV3>(); int currentPageIndex = m_CurPageIndex; int currentPageSize = m_CurrentPageSize; int.TryParse(pageIndex, out currentPageIndex); int.TryParse(pageSize, out currentPageSize); m_CurPageIndex = currentPageIndex; m_CurrentPageSize = currentPageSize; string strSortField = GetSortField(m_SortField); string strSort = AppFunction.GetSortDefine(m_Sort); ViewBag.vTenantID = this.TenantID; ViewBag.vTenantSpeciaFlag = this.TenantSpecialFlag; //ページを再計算する CalcPage(pageTotal); using (WFMDBDataContext db = new WFMDBDataContext(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["SpecialConnection"].ConnectionString, DBServer))) { IMultipleResults results = db.uspWFMGetCallDetailV3(m_CurPageIndex, m_CurrentPageSize, strSortField, strSort, this.TenantID, dtST.ToString(AppConst.Const_Format_YMDHMS), dtEnd.ToString(AppConst.Const_Format_YMDHMS), skillID, vCalleeid, vCallerid, isessionprofileid, iConntype, iCompletedCall, iQueCall, iHasTransfer, iHasACD, iGroupID); result = results.GetResult <tblCallDetailV3>().ToList(); tblDataPaged tblPage = results.GetResult <tblDataPaged>().FirstOrDefault(); m_TotalRowCount = tblPage.TotalRowCount; m_CurPageIndex = tblPage.CurPageIndex; m_TotlePageCount = tblPage.TotalPageCount; } return(result); }
//検索処理 private List <tblAgentWeekShift> SearchData(string pageIndex, string pageSize, string pageTotal, DateTime currentDate, string vAgentID) { List <tblAgentWeekShift> result = new List <tblAgentWeekShift>(); int currentPageIndex = m_CurPageIndex; int currentPageSize = m_CurrentPageSize; int.TryParse(pageIndex, out currentPageIndex); int.TryParse(pageSize, out currentPageSize); m_CurPageIndex = currentPageIndex; m_CurrentPageSize = currentPageSize; string strSortField = GetSortField(m_SortField); string strSort = AppFunction.GetSortDefine(m_Sort); ViewBag.vTenantID = this.TenantID; ViewBag.vTenantSpeciaFlag = this.TenantSpecialFlag; ViewBag.currentDate = currentDate.ToString(AppConst.Const_Format_YMD); //ページを再計算する CalcPage(pageTotal); using (WFMDBDataContext db = new WFMDBDataContext()) { IMultipleResults results = db.uspWFMSearchShiftAgentPaged(m_CurPageIndex, m_CurrentPageSize, strSortField, strSort, this.TenantID, currentDate, this.TenantSpecialFlag, vAgentID); result = results.GetResult <tblAgentWeekShift>().ToList(); tblDataPaged tblPage = results.GetResult <tblDataPaged>().FirstOrDefault(); m_TotalRowCount = tblPage.TotalRowCount; m_CurPageIndex = tblPage.CurPageIndex; m_TotlePageCount = tblPage.TotalPageCount; } return(result); }
//検索処理 private List <tblAgentDetailV3> SearchData(string pageIndex, string pageSize, string pageTotal, DateTime dtST, DateTime dtEnd, string vLogin, int iAgentStatus) { List <tblAgentDetailV3> result = new List <tblAgentDetailV3>(); int currentPageIndex = m_CurPageIndex; int currentPageSize = m_CurrentPageSize; int.TryParse(pageIndex, out currentPageIndex); int.TryParse(pageSize, out currentPageSize); m_CurPageIndex = currentPageIndex; m_CurrentPageSize = currentPageSize; string strSortField = GetSortField(m_SortField); string strSort = AppFunction.GetSortDefine(m_Sort); ViewBag.vTenantID = this.TenantID; ViewBag.vTenantSpeciaFlag = this.TenantSpecialFlag; //ページを再計算する CalcPage(pageTotal); using (WFMDBDataContext db = new WFMDBDataContext(string.Format(System.Configuration.ConfigurationManager.ConnectionStrings["SpecialConnection"].ConnectionString, DBServer))) { IMultipleResults results = db.uspWFMGetAgentDetailV3(m_CurPageIndex, m_CurrentPageSize, strSortField, strSort, this.TenantID, dtST.ToString(AppConst.Const_Format_YMDHMS), dtEnd.ToString(AppConst.Const_Format_YMDHMS), vLogin, iAgentStatus); result = results.GetResult <tblAgentDetailV3>().ToList(); tblDataPaged tblPage = results.GetResult <tblDataPaged>().FirstOrDefault(); m_TotalRowCount = tblPage.TotalRowCount; m_CurPageIndex = tblPage.CurPageIndex; m_TotlePageCount = tblPage.TotalPageCount; } return(result); }
static void Main(string[] args) { AdventureWorks dc = new AdventureWorks(@"Data Source=(local);Initial Catalog=AdventureWorks2012;User Id=sa;Password=saadmin;"); #region Consulta com uma tabela (Consulta manual - via código) var result = from pc in dc.ProductCategories orderby pc.Name select pc; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.ProductCategories.OrderBy(pc => pc.Name); foreach (var item in result) { Console.WriteLine(item.Name); } #endregion Console.WriteLine("-------------------------------------------------"); #region Consulta com relacionamento chave primária/chave estrangeira (Consulta manual - via código) var result2 = from pc in dc.ProductCategories orderby pc.Name select new { Nome = pc.Name, SubCategorias = pc.ProductSubcategories }; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.ProductCategories.OrderBy(pc => pc.Name).Select(pc => new {Nome = pc.Name, SubCategorias = pc.ProductSubcategories }); foreach (var item in result2) { Console.WriteLine("******************************"); Console.WriteLine("Subcategorias de {0}:", item.Nome); foreach (var sub in item.SubCategorias) { Console.WriteLine("{0}", sub.Name); } Console.WriteLine("******************************"); Console.WriteLine(""); } #endregion Console.WriteLine("-------------------------------------------------"); #region Consulta (via ferramenta) AdventureWorksByToolDataContext dc2 = new AdventureWorksByToolDataContext(); // Retorna o comando SQL dc2.Log = Console.Out; var result3 = from pc in dc2.ProductCategories orderby pc.Name select pc; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.ProductCategories.OrderBy(pc => pc.Name); foreach (var item in result3) { Console.WriteLine(item.Name); } #endregion #region Inclusão, alteração, deleção e consulta int op = 1; while (op != 0) { Console.Clear(); Console.WriteLine("Dentre as alternativas abaixo:"); Console.WriteLine("1 - Consultar"); Console.WriteLine("2 - Incluir"); Console.WriteLine("3 - Alterar"); Console.WriteLine("4 - Excluir"); Console.WriteLine("0 - Sair"); Console.WriteLine("Selecione uma opcao:"); if (!Int32.TryParse(Console.ReadLine().ToString(), out op)) { op = -1; } switch (op) { case 1: RealizarConsulta(); break; case 2: RealizarInclusao(); break; case 3: RealizarAlteracao(); break; case 4: RealizarExclusao(); break; case 0: Console.WriteLine("Bye!"); break; default: Console.WriteLine("Opcao invalida!\n\n"); Console.ReadKey(); break; } } #endregion #region Lidando com procedures (via código) IMultipleResults resultProcedure = dc.GetCategory(1); Console.WriteLine("Categorias:"); foreach (var item in resultProcedure.GetResult <CodeFirst.ProductCategory>()) { Console.WriteLine("{0} - {1}", item.ProductCategoryID, item.Name); } #endregion Console.WriteLine("-------------------------------------------------"); #region Lidando com procedures (via ferramenta) AdventureWorksByToolDataContext dcFerramenta = new AdventureWorksByToolDataContext(); var resultProcedureFerramenta = from pc in dcFerramenta.usp_GetCategory(1) orderby pc.Name select pc; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.usp_GetCategory(1).OrderBy(pc => pc.Name); Console.WriteLine("Categorias:"); foreach (var item in result) { Console.WriteLine("{0} - {1}", item.ProductCategoryID, item.Name); } #endregion Console.WriteLine("-------------------------------------------------"); #region Lidando com functions (via código) var resultFunction = from p in dc.FindSubcategories("bike") orderby p.Name descending select new { p.Name, p.ProductSubcategoryID, MaxPrice = dc.MaxPriceBySubcategory(p.ProductSubcategoryID) }; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.FindSubcategories("bike").OrderByDescending(pc => pc.Name).Select(p => new { p.Name, p.ProductSubcategoryID, MaxPrice = dc.MaxPriceBySubcategory(p.ProductSubcategoryID) }); Console.WriteLine("Subcategorias com bike no nome:"); foreach (var item in resultFunction) { Console.WriteLine("{0} - {1} - {2}", item.ProductSubcategoryID, item.Name, item.MaxPrice.GetValueOrDefault(0).ToString("C")); } #endregion Console.WriteLine("-------------------------------------------------"); #region Lidando com functions (via ferramenta) AdventureWorksByToolDataContext dcFunction = new AdventureWorksByToolDataContext(); var resultFunction2 = from pc in dcFunction.FindProductSubcategoriesByName("Shorts") orderby pc.Name select new { pc.Name, pc.ProductSubcategoryID, MaxPrice = dcFunction.GetMaxPriceBySubcategory(pc.ProductSubcategoryID) }; //Em sintaxe de método ficaria da seguinte forma: //var result = dc.FindProductSubcategoriesByName("Shorts").OrderByDescending(pc => pc.Name).Select(p => new { p.Name, p.ProductSubcategoryID, MaxPrice = dc.GetMaxPriceBySubcategory(p.ProductSubcategoryID) }); Console.WriteLine("Subcategorias com shorts no nome:"); foreach (var item in resultFunction2) { Console.WriteLine("{0} - {1} - {2}", item.ProductSubcategoryID, item.Name, item.MaxPrice.GetValueOrDefault(0).ToString("C")); } #endregion Console.WriteLine("-------------------------------------------------"); #region Consultas compiladas AdventureWorksByToolDataContext dcComplida = new AdventureWorksByToolDataContext(); Table <ProductSubcategory> ProductSubcategories = dcComplida.GetTable <ProductSubcategory>(); var query = CompiledQuery.Compile( (DataContext context, string filterName) => from p in ProductSubcategories where p.Name.Contains(filterName) select new { p.Name, p.ProductSubcategoryID }); Console.WriteLine("Subcategorias com Bike no nome:"); foreach (var item in query(dc, "Bike")) { Console.WriteLine("{0} - {1}", item.ProductSubcategoryID, item.Name); } Console.WriteLine("\n\nSubcategorias com Shorts no nome:"); foreach (var item in query(dc, "Shorts")) { Console.WriteLine("{0} - {1}", item.ProductSubcategoryID, item.Name); } #endregion Console.WriteLine("-------------------------------------------------"); #region Executando consultas diretas AdventureWorksByToolDataContext dcDiretas = new AdventureWorksByToolDataContext(); var resultDiretas = dcDiretas.ExecuteQuery <ProductSubcategory>(@"SELECT TOP(50)PERCENT ProductSubcategoryID, Name, rowguid, ModifiedDate FROM Production.ProductSubcategory"); Console.WriteLine("50% das subcategorias cadastradas:"); foreach (var item in resultDiretas) { Console.WriteLine("{0} - {1}", item.ProductSubcategoryID, item.Name); } #endregion Console.WriteLine("-------------------------------------------------"); Console.ReadKey(); }
public static List <MetricValue.Extend> MetricValuesForCalculation(int ActGen, out List <Bll.MetricValue.Extend> _OutputValues) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); //http://omaralzabir.com/linq_to_sql_solve_transaction_deadlock_and_query_timeout_problem_using_uncommitted_reads/ // WITH (NOLOCK) int OldTimeOut = dc.CommandTimeout; dc.CommandTimeout = 600; IQueryable <MetricValue> metricValue = from mv in dc.MetricValue join m in dc.Metric on new { mv.InstanceId, mv.MetricID } equals new { m.InstanceId, m.MetricID } where mv.Status == true && mv.IsCalc == true && m.Generation == (ActGen - 1) select mv; foreach (MetricValue mv in metricValue) { mv.InProcess = true; mv.IsCalc = false; } dc.SubmitChanges(); IMultipleResults results = dc.Sp_SelectOutputMetricValues(ActGen); _OutputValues = results.GetResult <Sp_SelectOutputMetricValuesResult1>() .Select(r => new Extend { // metric InstanceId = (Guid)r.InstanceId, MetricID = (Guid)r.MetricID, FrequencyID = (int)r.FrequencyID, MetricInputUnitOfMeasureID = r.MetricInputUnitOfMeasureID, MetricUnitOfMeasureID = r.MetricUnitOfMeasureID, RelatedFormulaID = r.MetricFormulaID, VariableFormula = r.VariableFormula, // value MetricValueID = (Guid)r.MetricValueID, OrgLocationID = (Guid)r.OrgLocationID, Date = (DateTime)r.Date }) //.OrderBy(r=>r.Date) .ToList(); List <MetricValue.Extend> _InputValues = results.GetResult <Sp_SelectOutputMetricValuesResult2>() .Select(r => new Extend { // metric MetricID = (Guid)r.MetricID, Variable = r.Variable, MetricInputUnitOfMeasureID = r.MetricInputUnitOfMeasureID, MetricUnitOfMeasureID = r.MetricUnitOfMeasureID, RelatedFormulaID = r.MetricFormulaID, // value MetricValueID = (Guid)r.MetricValueID, OrgLocationID = (Guid)r.OrgLocationID, Date = (DateTime)r.Date, Value = r.Value, MissedCalc = (bool)r.MissedCalc, ConvertedValue = r.ConvertedValue, InputUnitOfMeasureID = r.ValueInputUnitOfMeasureID, UnitOfMeasureID = r.ValueUnitOfMeasureID, RelatedOrgLocationUoMRecordID = r.MetricOrgLocationUoMID, OrgLocationUnitOfMeasureID = r.OrgLocationUnitOfMeasureID }) //.OrderBy(r => r.Date) //??? .ToList(); dc.CommandTimeout = OldTimeOut; return(_InputValues); //========================= /*Guid? _CurMetricID = null; * Guid? _CurOrgLocationID = null; * bool start = true; * foreach (MetricValue.Extend me in _OutputValues) * { * if (start) * { * _CurMetricID = me.MetricID; * _CurOrgLocationID = me.OrgLocationID; * } * me.UnitOfMeasureID = me.MetricUnitOfMeasureID; * Guid? DefUoM = me.RelatedOrgLocationUoMRecordID == null ? me.MetricInputUnitOfMeasureID : me.OrgLocationUnitOfMeasureID; * List<MetricValue.Extend> _RelatedInputValues = _InputValues.FindAll(r => (r.RelatedFormulaID == me.RelatedFormulaID) && (r.Date == me.Date) && (r.OrgLocationID == me.OrgLocationID)); * if (_RelatedInputValues.Count == 0) * me.InputUnitOfMeasureID = DefUoM; * bool IsSameInputUoMs = true; * bool IsSameOutputUoMs = true; * for (int i = 0; i < _RelatedInputValues.Count - 1; i++) * { * Guid? CurInputUoM = _RelatedInputValues[i].InputUnitOfMeasureID; * Guid? CurOutputUoM = _RelatedInputValues[i].UnitOfMeasureID; * for (int j = i + 1; j < _RelatedInputValues.Count; j++) * { * if (CurInputUoM != _RelatedInputValues[j].InputUnitOfMeasureID) * IsSameInputUoMs = false; * if (CurOutputUoM != _RelatedInputValues[j].UnitOfMeasureID) * IsSameOutputUoMs = false; * } * } * if (IsSameInputUoMs) * me.InputUnitOfMeasureID = _RelatedInputValues[0].InputUnitOfMeasureID; * else * if (IsSameOutputUoMs) * me.InputUnitOfMeasureID = _RelatedInputValues[0].UnitOfMeasureID; * else * me.InputUnitOfMeasureID = DefUoM; * * if ((_CurMetricID != me.MetricID) || (_CurOrgLocationID != me.OrgLocationID) || start) * { * UpdateMetricOrgLocationUoM(me.InstanceId, me.MetricID, me.OrgLocationID, me.InputUnitOfMeasureID); * _CurMetricID = me.MetricID; * _CurOrgLocationID = me.OrgLocationID; * } * start = false; * } */ }
public void Consume(IMultipleResults resultSets) { IEnumerable <QueryMapMultiDepthResult> resultSet = resultSets.GetResult <QueryMapMultiDepthResult>(); while (resultSet != null) { foreach (var queryMapResult in resultSet) { if (queryMapResult.Level != null) { if (queryMapResult.NodeUid.HasValue && queryMapResult.NodeUid != Guid.Empty) { /// The QueryMap procedure returns ALL nodes by following relationships to max depth meaning some nodes are repeated in some of the levels multiple nodes may connect to them. if (!Nodes.ContainsKey(queryMapResult.NodeUid.Value)) { /// TODO: Need to consider copying the NodeOriginalId. QueryMapNode node = new QueryMapNode(); node.NodeUid = queryMapResult.NodeUid.Value; node.DomainUid = queryMapResult.DomainUid.Value; node.NodeTypeUid = queryMapResult.NodeTypeUid; Nodes[queryMapResult.NodeUid.Value] = node; } } } else if (queryMapResult.MetadataId != null) { if (queryMapResult.MetadataId.HasValue && queryMapResult.MetadataId != Guid.Empty) { QueryMapMetadata metadatum = new QueryMapMetadata(); metadatum.MetadataId = queryMapResult.MetadataId.Value; metadatum.NodeUid = queryMapResult.NodeUid; metadatum.RelationshipUid = queryMapResult.RelationshipUid; metadatum.DescriptorTypeUid = queryMapResult.DescriptorTypeUid; metadatum.MetadataTypeUid = queryMapResult.MetadataTypeUid; metadatum.MetadataName = queryMapResult.MetadataName; metadatum.MetadataValue = queryMapResult.MetadataValue; Metadata.Add(metadatum); } } else if (queryMapResult.DescriptorUid != null) { if (queryMapResult.DescriptorUid.HasValue && queryMapResult.DescriptorUid != Guid.Empty) { QueryMapDescriptor descriptor = new QueryMapDescriptor(); descriptor.DescriptorUid = queryMapResult.DescriptorUid.Value; descriptor.NodeUid = queryMapResult.NodeUid; descriptor.RelationshipUid = queryMapResult.RelationshipUid; descriptor.DescriptorTypeUid = queryMapResult.DescriptorTypeUid; Descriptors.Add(descriptor); } } else { if (queryMapResult.RelationshipUid.HasValue && queryMapResult.RelationshipUid != Guid.Empty) { /// TODO: Need to consider copying the RelationshipOriginalId. QueryMapRelationship relationship = new QueryMapRelationship(); relationship.RelationshipUid = queryMapResult.RelationshipUid.Value; relationship.DomainUid = queryMapResult.DomainUid.Value; relationship.RelationshipTypeUid = queryMapResult.RelationshipTypeUid; Relationships[relationship.RelationshipUid] = relationship; } } } resultSet = resultSets.GetResult <QueryMapMultiDepthResult>(); } }
public void Consume(IMultipleResults resultSets) { IEnumerable<QueryMapMultiDepthResult> resultSet = resultSets.GetResult<QueryMapMultiDepthResult>(); while (resultSet != null) { foreach (var queryMapResult in resultSet) { if (queryMapResult.Level != null) { if (queryMapResult.NodeUid.HasValue && queryMapResult.NodeUid != Guid.Empty) { /// The QueryMap procedure returns ALL nodes by following relationships to max depth meaning some nodes are repeated in some of the levels multiple nodes may connect to them. if (!Nodes.ContainsKey(queryMapResult.NodeUid.Value)) { /// TODO: Need to consider copying the NodeOriginalId. QueryMapNode node = new QueryMapNode(); node.NodeUid = queryMapResult.NodeUid.Value; node.DomainUid = queryMapResult.DomainUid.Value; node.NodeTypeUid = queryMapResult.NodeTypeUid; Nodes[queryMapResult.NodeUid.Value] = node; } } } else if (queryMapResult.MetadataId != null) { if (queryMapResult.MetadataId.HasValue && queryMapResult.MetadataId != Guid.Empty) { QueryMapMetadata metadatum = new QueryMapMetadata(); metadatum.MetadataId = queryMapResult.MetadataId.Value; metadatum.NodeUid = queryMapResult.NodeUid; metadatum.RelationshipUid = queryMapResult.RelationshipUid; metadatum.DescriptorTypeUid = queryMapResult.DescriptorTypeUid; metadatum.MetadataTypeUid = queryMapResult.MetadataTypeUid; metadatum.MetadataName = queryMapResult.MetadataName; metadatum.MetadataValue = queryMapResult.MetadataValue; Metadata.Add(metadatum); } } else if (queryMapResult.DescriptorUid != null) { if (queryMapResult.DescriptorUid.HasValue && queryMapResult.DescriptorUid != Guid.Empty) { QueryMapDescriptor descriptor = new QueryMapDescriptor(); descriptor.DescriptorUid = queryMapResult.DescriptorUid.Value; descriptor.NodeUid = queryMapResult.NodeUid; descriptor.RelationshipUid = queryMapResult.RelationshipUid; descriptor.DescriptorTypeUid = queryMapResult.DescriptorTypeUid; Descriptors.Add(descriptor); } } else { if (queryMapResult.RelationshipUid.HasValue && queryMapResult.RelationshipUid != Guid.Empty) { /// TODO: Need to consider copying the RelationshipOriginalId. QueryMapRelationship relationship = new QueryMapRelationship(); relationship.RelationshipUid = queryMapResult.RelationshipUid.Value; relationship.DomainUid = queryMapResult.DomainUid.Value; relationship.RelationshipTypeUid = queryMapResult.RelationshipTypeUid; Relationships[relationship.RelationshipUid] = relationship; } } } resultSet = resultSets.GetResult<QueryMapMultiDepthResult>(); } }
public QueryMapResultSet(IMultipleResults queryMapResultSets) { var queryMapResultSet = queryMapResultSets.GetResult <QueryMapMultiDepthResult>(); while (queryMapResultSet != null) { foreach (var queryMapResult in queryMapResultSet) { if (queryMapResult.Level != null) { if (queryMapResult.NodeUid.HasValue && queryMapResult.NodeUid != Guid.Empty) { /// Make sure that we aren't displaying a domain node. if (queryMapResult.NodeTypeUid.HasValue && queryMapResult.NodeTypeUid != new Guid("263754C2-2F31-4D21-B9C4-6509E00A5E94")) { /// The QueryMap procedure returns ALL nodes by following relationships to max depth meaning some nodes are repeated in some of the levels multiple nodes may connect to them. if (!Nodes.ContainsKey(queryMapResult.NodeUid.Value)) { /// TODO: Need to consider if we require the NodeOriginalId. QueryMapNode node = new QueryMapNode(queryMapResult); Nodes[queryMapResult.NodeUid.Value] = node; } } } } else if (queryMapResult.MetadataId != null) { if (queryMapResult.MetadataId.HasValue && queryMapResult.MetadataId != Guid.Empty) { QueryMapMetadata metadatum = new QueryMapMetadata(queryMapResult); if (metadatum.NodeUid.HasValue) { if (Nodes.ContainsKey(metadatum.NodeUid.Value)) { Nodes[metadatum.NodeUid.Value].AddMetadata(metadatum); } } Metadata.Add(metadatum); } } else if (queryMapResult.DescriptorUid != null) { if (queryMapResult.DescriptorUid.HasValue && queryMapResult.DescriptorUid != Guid.Empty) { QueryMapDescriptor descriptor = new QueryMapDescriptor(queryMapResult); Descriptors.Add(descriptor); AddDescriptorByNode(descriptor); AddDescriptorByRelationship(descriptor); } } else { if (queryMapResult.RelationshipUid.HasValue && queryMapResult.RelationshipUid != Guid.Empty) { /// TODO: Need to consider if we require the RelationshipOriginalId. QueryMapRelationship relationship = new QueryMapRelationship(queryMapResult); Relationships[relationship.RelationshipUid] = relationship; } } } queryMapResultSet = queryMapResultSets.GetResult <QueryMapMultiDepthResult>(); } }
public QueryMapResultSet(IMultipleResults queryMapResultSets) { var queryMapResultSet = queryMapResultSets.GetResult<QueryMapMultiDepthResult>(); while (queryMapResultSet != null) { foreach (var queryMapResult in queryMapResultSet) { if (queryMapResult.Level != null) { if (queryMapResult.NodeUid.HasValue && queryMapResult.NodeUid != Guid.Empty) { /// Make sure that we aren't displaying a domain node. if (queryMapResult.NodeTypeUid.HasValue && queryMapResult.NodeTypeUid != new Guid("263754C2-2F31-4D21-B9C4-6509E00A5E94")) { /// The QueryMap procedure returns ALL nodes by following relationships to max depth meaning some nodes are repeated in some of the levels multiple nodes may connect to them. if (!Nodes.ContainsKey(queryMapResult.NodeUid.Value)) { /// TODO: Need to consider if we require the NodeOriginalId. QueryMapNode node = new QueryMapNode(queryMapResult); Nodes[queryMapResult.NodeUid.Value] = node; } } } } else if (queryMapResult.MetadataId != null) { if (queryMapResult.MetadataId.HasValue && queryMapResult.MetadataId != Guid.Empty) { QueryMapMetadata metadatum = new QueryMapMetadata(queryMapResult); if (metadatum.NodeUid.HasValue) { if (Nodes.ContainsKey(metadatum.NodeUid.Value)) { Nodes[metadatum.NodeUid.Value].AddMetadata(metadatum); } } Metadata.Add(metadatum); } } else if (queryMapResult.DescriptorUid != null) { if (queryMapResult.DescriptorUid.HasValue && queryMapResult.DescriptorUid != Guid.Empty) { QueryMapDescriptor descriptor = new QueryMapDescriptor(queryMapResult); Descriptors.Add(descriptor); AddDescriptorByNode(descriptor); AddDescriptorByRelationship(descriptor); } } else { if (queryMapResult.RelationshipUid.HasValue && queryMapResult.RelationshipUid != Guid.Empty) { /// TODO: Need to consider if we require the RelationshipOriginalId. QueryMapRelationship relationship = new QueryMapRelationship(queryMapResult); Relationships[relationship.RelationshipUid] = relationship; } } } queryMapResultSet = queryMapResultSets.GetResult<QueryMapMultiDepthResult>(); } }