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 + ".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 + ".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()); } }