愿得一人心,白首不相离。
技术支持

outlook2010邮件设置提示530 5.7.1 client……

1、首先打开outlook2010正常填写名称、邮箱地址和密码、发件服务器、收件服务器地址等一系列信息;

2、界面如下图,然后点击“其他设置”;

 

 

3、进入“电子邮件设置”点击“发送服务器”将“我的发送服务器(SMTP)里求验证”打勾,点击“确定”即可。

Jack 2018-1-7 0评论

UOC

统计库存量

select
v_ex_currentstockquery.cWhCODE as '仓别',
v_ex_currentstockquery.cWhName as '仓库',
b.cInvCode as '物料编码',
inventory.cinvname as '存货名称',
v_ex_currentstockquery.cInvStd as '规格型号',
isnull(v_ex_currentstockquery.iQuantity,0) as '数量',
b.iNatUnitPrice as '最新价格 ',
isnull(v_ex_currentstockquery.iQuantity,0)*b.iNatUnitPrice as '合计'
 from  v_ex_currentstockquery
 left join (
 select iNatUnitPrice,PO_Podetails.cInvCode from PO_Podetails,
(select MAX(id) as id ,cInvCode from PO_Podetails
group by cInvCode)a
  where PO_Podetails.ID=a.id and
 PO_Podetails.cInvCode=a.cinvcode)
 b
 on b.cInvCode= v_ex_currentstockquery.cinvcode
  left join inventory on inventory.cinvcode=b.cinvcode
  where  v_ex_currentstockquery.cWhCode in
  ('100','101','102','103','104','105','106','107','108','120','121','122','123','124',

Jack 2018-1-7 0评论

UOC

UOC查找删除黑名单命令

SELECT *
FROM ST_BlackPerson
WHERE (Card_No = 13580) /*查询人员卡号是否在黑名单*/

delete from ST_BlackPerson
where (Card_No = 13580)  /*把在黑名单内的人员踢出,恢复卡号正常使用*/

Jack 2018-1-7 0评论