/// <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;
}
