//根据主键查询 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)); } } }