Пример #1
0
 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());
     }
 }
Пример #2
0
 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());
     }
 }