sql.txt

来自「通过网关发手机短信」· 文本 代码 · 共 19 行

if  @object_type=N'13' and  @transaction_type =N'A'
begin
   insert txsbo..T_SMSSendList( S_ReceiveCardNo ,S_SendContent ) 
select top 1  C.Cellular ,Content=N'你的发票：'+ isnull(O.NumAtCard,'')+N' '+cast(O.docnum as nvarchar)  +N' 己开'
from OINV O Inner join  OCRD C on C.cardcode=O.cardcode  and isnull(C.Cellular,'')<>''
where    O.docentry=@list_of_cols_val_tab_del

end
else

if  @object_type=N'15' and  @transaction_type =N'A'
begin
  insert txsbo..T_SMSSendList( S_ReceiveCardNo ,S_SendContent )
  select top 1  M.Mobile,Content=N'客户:' + O.cardcode+N' '+O.cardName+N',单号是：'+cast(O.docnum as nvarchar)
   + N' 己经发出'
    from ODLN  O inner join Oslp P on O.slpcode=P.slpcode
             inner join OHEM M on P.Slpcode=M.salesprson
   where    O.docentry=@list_of_cols_val_tab_del
end