// DepartmanTanim public override async Task KdtL(QueryLookupProxy request, IServerStreamWriter <KdtLookupProxy> responseStream, ServerCallContext context) { KdtLookupProxy proxy; BbMsg bbMsg; List <KdtLookupProxy> proxyList = new List <KdtLookupProxy>(); await Scheduling.RunTask(() => { for (int i = 0; i < 1; i++) { foreach (var row in Db.SQL <KDT>("select r from KDT r")) { bbMsg = new BbMsg { Kd = row.Kd ?? "", Ad = row.Ad ?? "", Info = row.Info ?? "", }; proxy = new KdtLookupProxy { RowKey = row.GetObjectNo(), BB = bbMsg }; proxyList.Add(proxy); } } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
// HesapPlani public override async Task AhpL(QueryLookupProxy request, IServerStreamWriter <AhpLookupProxy> responseStream, ServerCallContext context) { AhpLookupProxy proxy; BbMsg bbMsg; List <AhpLookupProxy> proxyList = new List <AhpLookupProxy>(); await Scheduling.RunTask(() => { for (int i = 0; i < 1; i++) { foreach (var row in Db.SQL <AHP>("select r from AHP r")) { bbMsg = new BbMsg { Kd = row.Kd ?? "", Ad = row.Ad ?? "", Info = row.Info ?? "", }; proxy = new AhpLookupProxy { RowKey = row.GetObjectNo(), BB = bbMsg, HspNo = row.HspNo, P = row.P == null ? 0 : row.P.GetObjectNo(), IsW = row.IsW }; proxyList.Add(proxy); } } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
// Base Deneme public override async Task BbL(QueryLookupProxy request, IServerStreamWriter <BbLookupProxy> responseStream, ServerCallContext context) { BbLookupProxy proxy = new BbLookupProxy(); List <BbLookupProxy> proxyList = new List <BbLookupProxy>(); await Scheduling.RunTask(() => { /* * sw.Restart(); * int key = 0; * int nor = 0; * bool b = false; * BB d; * for (int i = 0; i < 1000000; i++) * { * d = Db.FromId<BB>(302); * key += d.i; * * //foreach (var row in Db.SQL<BB>("select r from BB r")) * //{ * // d = Db.FromId<BB>(302); * // //key += row.GetObjectNo(); * // //b = row.Ad == null ? true : false; * // nor++; * //} * nor++; * } * * sw.Stop(); * Console.WriteLine($"{sw.ElapsedMilliseconds} {nor:n0} {key}"); */ string srch = request.Query; bool all = string.IsNullOrEmpty(srch); for (int i = 0; i < 1; i++) { foreach (var row in Db.SQL <BB>("select r from BB r")) { if (all || srch.Contains(row.Typ)) { proxy = new BbLookupProxy { RowKey = row.GetObjectNo(), Typ = row.Typ, Kd = row.Kd ?? "", Ad = row.Ad ?? "", Info = row.Info ?? "", }; proxyList.Add(proxy); } } } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }