public virtual int RowCount()
{
string cmtext = query.RowCount();
using (CommanderBase commander = DBContext.CreateCommander())
{
var o = commander.Scaller(cmtext);
if (o != null)
{
return(Convert.ToInt32(o));
}
else
{
return(0);
}
}
}
public virtual int Insert(T t)
{
string cmtext = query.Insert();
using (CommanderBase commander = DBContext.CreateCommander())
{
var p = commander.SetParametrs(t);
var id = commander.Scaller(cmtext, p);
if (id != null)
{
return(Convert.ToInt32(id));
}
else
{
return(0);
}
}
}
public virtual (int, bool) Insert <M>(M t, DbTransaction transaction = null) where M : class, new()
{
string cmtext = query.Insert <M>();
using (CommanderBase commander = DBContext.CreateCommander())
{
var p = commander.SetParametrs(t);
var(id, b) = commander.Scaller(cmtext, parameters: p, transaction: transaction);
if (b && id != null)
{
return(Convert.ToInt32(id), b);
}
else
{
return(0, b);
}
}
}
public virtual int RowCountWithSrc(string srcClm, string srcValue)
{
string cmtext = query.RowCountWithSrc(srcClm);
using (CommanderBase commander = DBContext.CreateCommander())
{
var o = commander.Scaller(cmtext, new List <DbParameter>()
{
commander.SetParametr(srcClm, srcValue)
});
if (o != null)
{
return(Convert.ToInt32(o));
}
else
{
return(0);
}
}
}