public override void SetOnCmd(NrdoCommand cmd)
{
for (var i = 0; i < cache.identity.paramNames.Count; i++)
{
parameters[i].SetParameter(cmd, cache.identity.paramNames[i]);
}
}
public override void SetOnCmd(NrdoCommand cmd)
{
if (setParameterValues != null)
{
setParameterValues(cmd);
}
}
private void setSubParams(NrdoCommand cmd, Identifier parent, Identifier child)
{
cmd.SetString("ptype", "varchar", parent.ObjectType.Name);
cmd.SetString("pname", "varchar", parent.Name);
cmd.SetString("type", "varchar", child.ObjectType.Name);
cmd.SetString("name", "varchar", child.Name);
}
protected abstract void setDataOnCmd(NrdoCommand cmd);
protected abstract void setPkeyOnCmd(NrdoCommand cmd);
// float -> dbtype Single, IDataType Float
public static void SetFloatParameter <T>(this T dbobject, NrdoCommand cmd, string name, string dbType, float?value)
where T : DBObject <T>
{
cmd.SetFloat(name, dbType, value);
}
// long -> Int64
public static void SetLongParameter <T>(this T dbobject, NrdoCommand cmd, string name, string dbType, long?value)
where T : DBObject <T>
{
cmd.SetLong(name, dbType, value);
}
// char -> dbtype StringFixedLength, IDataType Char
public static void SetCharParameter <T>(this T dbobject, NrdoCommand cmd, string name, string dbType, char value)
where T : DBObject <T>
{
cmd.SetChar(name, dbType, value);
}
// DateTime -> DateTime
public static void SetDateTimeParameter <T>(this T dbobject, NrdoCommand cmd, string name, string dbType, DateTime?value)
where T : DBObject <T>
{
cmd.SetDateTime(name, dbType, value);
}
// decimal -> dbtype (if sqltype = $dbmoneytype$ then Currency else Decimal), IDataType Decimal
public static void SetDecimalParameter <T>(this T dbobject, NrdoCommand cmd, string name, string dbType, decimal?value)
where T : DBObject <T>
{
cmd.SetDecimal(name, dbType, value);
}
public override void SetOnCmd(NrdoCommand cmd) => throw new NotImplementedException();
public abstract void SetOnCmd(NrdoCommand cmd);
protected override void setPkeyOnCmd(NrdoCommand cmd)
{
throw new NotImplementedException();
}
public void SetParameter(NrdoCommand cmd, string name)
{
cmd.SetParameter(name, dbType, len, value);
}
public override void SetOnCmd(NrdoCommand cmd)
{
}
private void setRootParams(NrdoCommand cmd, Identifier identifier)
{
cmd.SetString("type", "varchar", identifier.ObjectType.Name);
cmd.SetString("name", "varchar", identifier.Name);
}