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