2025-07-11日提交

Tjiny

7 天以前 6d40f7c8b19efc612f824ee7e778d5be9f8382f5

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
using System.Collections.Generic;
using HH.WCS.Mobox3.RiDong.models;
 
namespace HH.WCS.Mobox3.RiDong.generalMethod;
 
/// <summary>
/// 出入库记录表
/// </summary>
public static class OnOffShelvesMethod
{
    /// <summary>
    /// 创建出入库记录
    /// </summary>
    /// <param name="task"></param>
    /// <returns></returns>
    public static bool CreateRKOnOffShelves(Task task)
    {
        var result = false;
        
        var cntritem = AdoSqlMethod<CntrItemDetail>.QueryList(p => p.S_CNTR_CODE == task.S_CNTR_CODE);
 
        if (cntritem.Count > 0)
        {
            var onOffShelvesList = new List<OnOffShelves>();
 
            foreach (var item in cntritem)
            {
                var onOffShelves = new OnOffShelves();
 
                onOffShelves.S_LOC_CODE = task.S_END_LOC;
                onOffShelves.S_CNTR_CODE = task.S_CNTR_CODE;
                onOffShelves.S_ITEM_CODE = item.S_ITEM_CODE.Trim();
                onOffShelves.S_ITEM_NAME = item.S_ITEM_NAME;
                onOffShelves.S_MATERIAL_TYPE = item.S_EXT_ATTR1;
                
                onOffShelves.S_OP_TYPE = "上架";
                onOffShelves.F_QTY = item.F_QTY;
                
                onOffShelvesList.Add(onOffShelves);
                
            }
 
            if (onOffShelvesList.Count > 0)
            {
                AdoSqlMethod<OnOffShelves>.AddList(onOffShelvesList);
                result = true;
            }
        }
        return result;
    }
    
    
    /// <summary>
    /// 创建出入库记录
    /// </summary>
    /// <param name="task"></param>
    /// <returns></returns>
    public static bool CreateCKOnOffShelves(Task task)
    {
        var result = false;
        
        var cntritem = AdoSqlMethod<CntrItemDetail>.QueryList(p => p.S_CNTR_CODE == task.S_CNTR_CODE);
 
        if (cntritem.Count > 0)
        {
            var onOffShelvesList = new List<OnOffShelves>();
 
            foreach (var item in cntritem)
            {
                if (item.F_ALLOC_QTY > 0)
                {
                    var onOffShelves = new OnOffShelves();
 
                    onOffShelves.S_LOC_CODE = task.S_START_LOC;
                    onOffShelves.S_CNTR_CODE = task.S_CNTR_CODE;
                    onOffShelves.S_ITEM_CODE = item.S_ITEM_CODE.Trim();
                    onOffShelves.S_ITEM_NAME = item.S_ITEM_NAME;
                    onOffShelves.S_MATERIAL_TYPE = item.S_EXT_ATTR1;
                
                    onOffShelves.S_OP_TYPE = "下架";
                    onOffShelves.F_QTY = item.F_ALLOC_QTY;
                
                    onOffShelvesList.Add(onOffShelves);
                }
            }
 
            if (onOffShelvesList.Count > 0)
            {
                AdoSqlMethod<OnOffShelves>.AddList(onOffShelvesList);
                result = true;
            }
        }
        return result;
    }
}