/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public virtual object Delete()
{
if (Synch.Equals("UFOper"))
{
sqlOper = new UFOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
if (bNoCase)
{
sqlOper.Delete(); //清除旧记录
}
if (bSaveOper)
{
return(sqlOper.Insert());
}
else
{
return(1);
}
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.Delete());
}
else
{
sqlOper = new OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.Delete());
}
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public virtual StringBuilder CreateUpdateSql()
{
if (Synch.Equals("UFOper"))
{
sqlOper = new UFOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateUpdateSql());
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
throw new NotImplementedException();
}
else
{
sqlOper = new OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
throw new NotImplementedException();
}
}
public virtual object ExecSql(string sql)
{
if (Synch.Equals("UFOper"))
{
sqlOper = new UFOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.ExecSql(sql));
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.ExecSql(sql));
}
else
{
sqlOper = new OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.ExecSql(sql));
}
}
/// <summary>
/// 组织批量删除SQL语句
/// </summary>
/// <returns></returns>
public virtual StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
sqlOper = new UFOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
else
{
sqlOper = new OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
}
