//根据主键查询
public override T Select <T>(object Value)
{
using (SqlConnection sct = new SqlConnection(Constring))
{
sct.Open();
ics = new SelectSql();
using (IDataReader reader = SqlTools.GetDtReader(ics.CreateSql <T>(Value), sct))
{
return(SqlResult.ValueToModel <T>(reader));
}
}
}
public override int Insert <T>(T t)
{
using (SqlConnection sct = new SqlConnection(Constring))
{
sct.Open();
ics = new InsertSql();
using (SqlCommand scmd = new SqlCommand(ics.CreateSql <T>(t), sct))
{
return(SqlResult.Result(scmd));
}
}
}
public override int Delete <T>(Expression <Func <T, bool> > express)
{
using (SqlConnection sct = new SqlConnection(Constring))
{
sct.Open();
ics = new DeleteSql();
using (SqlCommand scmd = new SqlCommand(ics.CreateSql <T>(express), sct))
{
return(SqlResult.Result(scmd));
}
}
}
/// <summary>
/// 无参
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public override List <T> Select <T>()
{
using (SqlConnection sct = new SqlConnection(Constring))
{
sct.Open();
ics = new SelectSql();
using (IDataReader idr = SqlTools.GetDtReader(ics.CreateSql <T>(), sct))
{
return(SqlResult.ValueToList <T>(idr));
}
}
}
public override int Insert <T>(T t)
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new InsertOql();
using (OracleCommand ocm = new OracleCommand(ics.CreateSql <T>(t), oct))
{
return(OracleResult.SingleResult(ocm));
}
}
}
public override int Delete <T>(object Value)
{
using (SqlConnection sct = new SqlConnection(Constring))
{
sct.Open();
ics = new DeleteSql();
using (SqlCommand scmd = new SqlCommand(ics.CreateSql <T>(Value), sct))
{
return(SqlResult.Result(scmd));
}
}
}
//根据主键查询
public override T Select <T>(object Value)
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new SelectOql();
using (IDataReader reader = OracleSql.GetDtReader(ics.CreateSql <T>(Value), oct))
{
return(OracleResult.ValueToModel <T>(reader));
}
}
}
/// <summary>
/// 无参
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public override List <T> Select <T>()
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new SelectOql();
using (IDataReader idr = OracleSql.GetDtReader(ics.CreateSql <T>(), oct))
{
return(OracleResult.ValueToList <T>(idr));
}
}
}
public override int Delete <T>(Expression <Func <T, bool> > express)
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new DeleteOql();
using (OracleCommand ocm = new OracleCommand(ics.CreateSql <T>(express), oct))
{
return(OracleResult.SingleResult(ocm));
}
}
}
public override int Delete <T>(List <T> t)
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new DeleteOql();
using (OracleCommand ocm = new OracleCommand(ics.CreateSql <T>(t), oct))
{
return(OracleResult.ManyResult(ocm));
}
}
}
public override int Delete <T>(object Value)
{
using (OracleConnection oct = new OracleConnection(Constring))
{
oct.Open();
ics = new DeleteOql();
using (OracleCommand ocm = new OracleCommand(ics.CreateSql <T>(Value), oct))
{
return(OracleResult.SingleResult(ocm));
}
}
}
