protected virtual SqlDataReader _QueryOwnDef(BlaDBVariantDefinition pvd, string fieldlist, string funcname)
{
var com = new SqlCommand(string.Format(_QueryString(), fieldlist, funcname), _connection.Connection);
com.CommandTimeout = 0;
pvd.PrepareSqlCommandParams(com, EntityID);
_ExpandParams(com.Parameters, pvd);
return(com.ExecuteReader());
}
protected override SqlDataReader _QueryOwnDef(BlaDBVariantDefinition pvd, string fieldlist, string funcname)
{
var com = new SqlCommand(
string.Format("select {0} from {1}(@R_SliceID, @Date, @Tolerance)", fieldlist, funcname),
_connection.Connection);
com.Parameters.AddWithValue("@R_SliceID", pvd.iLX118R);
com.Parameters.AddWithValue("@Date", pvd.Date);
com.CommandTimeout = 0;
com.Parameters.AddWithValue("@Tolerance", 30);
return(com.ExecuteReader());
}
/// <summary>
/// Odpytuje funkcję wydając wyniki w postaci wyliczenia GrWAtt_Value
/// </summary>
/// <returns></returns>
public IEnumerable <GrWAtt_Value> Ask(BlaDBVariantDefinition var)
{
var objIDindex = -1;
foreach (var row in __bind.ExecuteQuery(__commandText, _.I.GrunaTemplater.PrepareCmd(__procArgTmpl, var)))
{
if (objIDindex < 0)
{
objIDindex = DBConnectionPool.FieldIndices(new[] { __objIDField }, row).First();
}
var objID = row.GetIntNumber(objIDindex);
foreach (var att in __attsources)
{
var a = att.GetValue(objID, row);
if (a != null)
{
yield return(a);
}
}
}
//yield break;
}
public IEnumerable <SqlParameter> PrepareCmd(int argTId, BlaDBVariantDefinition var)
{
return(__tmpllist.First(a => a.Item1 == argTId).Item2
.Select(g => new SqlParameter("@p" + g.ToString(), var.Get4Params(g))));
}
public void PrepareCmd(int argTId, SqlCommand cmd, BlaDBVariantDefinition var)
{
cmd.Parameters.AddRange(__tmpllist.First(a => a.Item1 == argTId).Item2
.Select(g => new SqlParameter("@p" + g.ToString(), var.Get4Params(g))).ToArray());
}
protected override void _ExpandParams(SqlParameterCollection paramc, BlaDBVariantDefinition pvd)
{
paramc.AddWithValue("@Rej_SliceID", pvd.iLX118R);
}
public SqlDataReader Reader(DBConnectionPool pool, BlaDBVariantDefinition variantDef)
{
return(pool.ExecuteReader(
__GrunaCommand(),
_.I.GrunaTemplater.PrepareCmd(__lx7121_ArgTmpl, variantDef)));
}
public IEnumerable <IDataRecord> Query(DBConnectionPool pool, BlaDBVariantDefinition variantDef)
{
return(pool.ExecuteQuery(
__GrunaCommand(),
_.I.GrunaTemplater.PrepareCmd(__lx7121_ArgTmpl, variantDef)));
}
public static IEnumerable <GrWAtt_Value> Parse(/*byte EntityID,*/ DBConnectionPool connection,
IEnumerable <GrWAtt_Definition> defs, BlaDBVariantDefinition var, RoReporter reporter = null)
{
var attids = defs.Select(a => a.AttID).Distinct().ToArray();
if (attids.Length < 1)
{
return(Enumerable.Empty <GrWAtt_Value>());
}
var zahada = string.Join(", ", attids);
var cmd = new SqlCommand(string.Format(SQLCOMMAND_ATT, zahada), connection.Connection);
var re = cmd.ExecuteReader();
reporter?.AddInfo("Odczyt definicji funkcji wydających atrybuty");
var rer = re.Cast <IDataRecord>();
var fields = rer.Select(r => new
{
id = r["LX7110"], proc = string.Format("[{0}].[{1}]", r["Schema"], r["NazwaFunkcji"]),
procid = (int)r["LX7125"], pargtempl = (int)r["LX7121"], objectid = (string)r["ObjectID_NazwaPola"],
attsrc = new GrWAtt_VSource(r)
}).ToList();
rer = null;
re = null;
var fieldsByProcs = fields.GroupBy(q => q.procid).Select(q =>
{
var pro = q.First();
reporter?.AddInfo($"Odczyt funkcji {pro.proc} ({pro.procid})");
return(new GruFuncOrStoredProcReader(connection, pro.procid, objIDField: pro.objectid,
pargtempl: pro.pargtempl, procName: pro.proc, attsrcs: q.Select(w => w.attsrc)));
});
return(fieldsByProcs.SelectMany(t => t.Ask(var)));
//return Enumerable.Empty<GrWAtt_Value>();
}
protected virtual void _ExpandParams(SqlParameterCollection paramc, BlaDBVariantDefinition pvd)
{
}
