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