/// <summary> /// 获取指定对象指定数据库类型的创建SQL执行方法 /// </summary> /// <param name="obj">对象</param> /// <param name="type">数据库类型</param> /// <returns>创建SQL执行方法</returns> public static CreateSqlDelegate GetCreateSqlFunction(ICreateSql obj, MyDbType type) { CreateSqlDelegate del = null; IDbSelector selector = GetDbSelector(type); if (selector != null) { del = selector.GetCreateSqlFunction(obj); } return del; }
/// <summary> /// 获取指定对象指定数据库类型的创建SQL执行方法 /// </summary> /// <param name="obj">对象</param> /// <param name="type">数据库类型</param> /// <returns>创建SQL执行方法</returns> public static CreateSqlDelegate GetCreateSqlFunction(ICreateSql obj, MyDbType type) { CreateSqlDelegate del = null; IDbSelector selector = GetDbSelector(type); if (selector != null) { del = selector.GetCreateSqlFunction(obj); } return(del); }
public override int Update(string sql) { using (OracleConnection oct = new OracleConnection(Constring)) { oct.Open(); ics = new UpdateOql(); using (OracleCommand ocm = new OracleCommand(sql, oct)) { return(OracleResult.SingleResult(ocm)); } } }
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 List <T> Select <T>(string sql) { using (SqlConnection sct = new SqlConnection(Constring)) { sct.Open(); ics = new SelectSql(); using (IDataReader idr = SqlTools.GetDtReader(sql, sct)) { return(SqlResult.ValueToList <T>(idr)); } } }
//根据主键查询 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 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 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)); } } }
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)); } } }
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 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)); } } }
private void FrmNormalView_Load(object sender, EventArgs e) { IGetAttribute attri = _object as IGetAttribute; if (attri != null) { this.dgvNormal.DataSource = NameAliasValue.ToDataTable(attri.GetAttributes()); } ICreateSql creatsql = _object as ICreateSql; if (creatsql != null) { CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(creatsql, _dbClass.GetClassDbType()); if (action != null) { List <CreateSqlObject> csos = action(_dbClass.GetCurrentTableSpaceName()); tbSql.Text = CreateSqlObject.ToCollectionSqls(csos); } } }
public CreateSqlDelegate GetCreateSqlFunction(ICreateSql obj) { return(obj.GetCreateMySqlSql); }
public CreateSqlDelegate GetCreateSqlFunction(ICreateSql obj) { return obj.GetCreateSqlServerSql; }
public CreateSqlDelegate GetCreateSqlFunction(ICreateSql obj) { return obj.GetCreateOracleSql; }