乐达三

概述

新服务器运行当年度账套，老服务器运行往年账套

设备保修系统

触摸屏报修 http://localhost/repair/Touchscreen/TouchScreenWarranty.html

PDA维修 http://localhost/repair/Touchscreen/MaintenanceMain.html

电视机 http://localhost/repair/Touchscreen/TVshowRepair.html

VPN

VPN服务端路由器内网IP：192.168.1.1，外网IP：58.221.165.222，路由器中设置是： 登录路由器的用户名/密码是：admin/admin123 设置的VPN用户是：ntld01 -- ntld07 ，密码统一是：xdf123 大公乐达三的路由器登录账号/密码是：admin/admin 路由器内网IP：192.168.5.1 使用的VPN账号/密码是：ld301/xdf123 2021年12月8日 13:38:56 创建VPN账号 ntld08，IP地址 = 192.168.7.21，前面办公楼一台电脑使用

批量设置缸单完工

-- 2021年5月14日 09:23:18 设置缸单为完工状态
-- 在“车间任务表”中不再显示
DECLARE @incre INT
DECLARE @kh INT
SET @kh=119775

SET @incre = 0
    WHILE @incre<5 -- 循环产生23行数据
    BEGIN
        INSERT INTO G_WorkShopTaskFinished
        (B_KH) VALUES (@kh)
        SET @kh = @kh + 1
        SET @incre = @incre + 1
    END


-- 根据自增的卡号更新12位长度的卡号
UPDATE G_WorkShopTaskFinished SET B_KH12 = dbo.FillRepeat(B_KH,11,'0',0) WHERE 1=1
UPDATE G_WorkShopTaskFinished SET B_KH12 = '9' + B_KH12;


-- 将卡号批量更新为完工状态
UPDATE G_CJFlowBill SET B_Finished=1
WHERE G_CJFlowBill.B_BarCode IN (SELECT B_KH12 FROM G_WorkShopTaskFinished)

乐亿达成品仓库

删除乐亿达发货单

清理打卷正式表中的标记（不会删除数据），同时删除乐亿达生成的发货单主表和明细表 https://www.yuque.com/chanchaw/pkb/azg0xe#eQfox

更新需求

2021年12月11日 14:15:28

陈丽萍要统计客户放样后没有做大货的数据，一般中样公斤数在80以下，这里要排除回修的计划单。在制作过程中发现同一个色号有做多次中样计划的情况，但是统计发货数据时是按照色号统计的，会导致这种情况时出现发货数量重复。

select t1.b_id, t1.b_client, t1.b_date,
       case when t1.b_isyh = 0 then '染色' else '印花' end as isYH,
       t1.b_pinmingkh,
       t1.b_specification, t1.b_sehao, t1.b_color, t1.b_qty as qtyJH,
       t2.B_PS as psFH,t2.B_Qty as qtyFH
       --ROW_NUMBER() OVER (Partition By t1.B_SeHao ORDER BY t1.B_ID) as B_XHAuto
from (
         select a.B_ID,a.B_Date,a.B_Client,a.B_IsYH,a.B_PinMingKH,a.B_Specification,a.B_SeHao,a.B_Color,
                a.B_Qty
         from G_CJBill a
         where a.B_HXtype = '正常' and a.B_Qty <= 80
     ) t1
         left join (
    select d.B_Client,d.B_IsYH,d.B_PinMingKH,d.B_Specification,d.B_SeHao,d.B_Color,
           count(*) as B_PS,
           sum(b.B_Qty) as B_Qty
    from G_BillCP a
             left join G_BillDetailCP b on a.B_ID = b.B_ID
             left join G_CJFlowBill c on b.B_FCID = c.B_ID
             left join G_CJBill d on c.B_BIDCJBill = d.B_ID
    group by d.B_Client,d.B_IsYH,d.B_PinMingKH,d.B_Specification,d.B_SeHao,d.B_Color
) t2
                   on t1.B_Client = t2.B_Client
                       and t1.B_IsYH = t2.B_IsYH
                       and t1.B_PinMingKH = t2.B_PinMingKH
                       and t1.B_Specification = t2.B_Specification
                       and t1.B_SeHao = t2.B_SeHao
                       and t1.B_Color = t2.B_Color
order by t1.B_Client,t1.B_IsYH,t1.B_PinMingKH,t1.B_Specification,t1.B_SeHao,t1.B_Date;