/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public override object Delete()
{
if (Synch.Equals("UFOper"))
{
sqlOper = new UFOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
if (bNoCase)
{
sqlOper.Delete(); //清除旧记录
}
if (bSaveOper)
{
return(this.Insert());
}
else
{
return(1);
}
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.Update());
}
else
{
sqlOper = new OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.Update());
}
}
public override StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
string sql = " DELETE FROM " + oracleTableName + " WHERE " + oracleTableName + ".id in( select id from MES_CQ_bom_bom with(nolock) where bomid ='" + bomId + "') ";
return(new StringBuilder(sql));
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
else
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
}
public override StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
string sql = "DELETE FROM " + oracleTableName + " WHERE " + oracleTableName + ".MoCode in( select h.mocode from mom_orderdetail d with(nolock) inner join mom_order h with(nolock) on h.moid = d.moid where d.moid =" + Convert.ToString(_moid) + " and d.modid =" + Convert.ToString(_modid) + ") ";
return(new StringBuilder(sql));
}
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());
}
}
public override StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
string sql = " DELETE FROM " + oracleTableName + " WHERE " + oracleTableName + ".dhcode ='" + _ccode + "' ";
return(new StringBuilder(sql));
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
else
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
}
public override StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
string sql = " DELETE FROM " + oracleTableName + " WHERE " + oracleTableName + ".cAVDID in( select autoid from " + ufTableName + " sb with(nolock) INNER JOIN AssemVouch sh WITH(NOLOCK) ON sh.id = sb.id where sh.cVouchType = '13' AND sh.cAVCode ='" + _cAVCode + "') ";
return(new StringBuilder(sql));
}
else if (Synch.Equals("LinkOper"))
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.LinkOper(oraLinkName, ufConnStr, ufTableName, ufPriKey, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
else
{
sqlOper = new U8.Interface.Bus.Event.SyncAdapter.Biz.OracleOper(oraConnStr, oracleTableName, oraclePriKey, l, lst);
return(sqlOper.CreateDeleteString());
}
}
public override StringBuilder CreateDeleteString()
{
if (Synch.Equals("UFOper"))
{
string sql = "DELETE FROM " + oracleTableName + " WHERE " + oraclePriKey + "=" + Convert.ToString(_PRoutingId) + " ";
return(new StringBuilder(sql));
}
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());
}
}