zhao
2021-07-19 8347f2fbddbd25369359dcb2da1233ac48a19fdc
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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
@{
    ViewBag.Title = "Check";
    Layout = "~/Views/Shared/_LayoutVue.cshtml";
}
 
<style>
    .el-table .warning-row {
        background: #ffc5c5;
    }
 
    .el-table .success-row {
        background: #c4ffc1;
    }
 
    .el-tabs__header {
        margin: 0px;
    }
</style>
 
<el-container id="idMain">
    <el-card class="box-card">
        <template>
            <el-tabs tab-position="tabPosition">
                <el-tab-pane label="按盘点明细汇总">
                    <div style="margin:0px 10px 3px 10px">
                        <el-form label-width="90px" v-bind:model="formData" class="demo-ruleForm" v-bind:inline="true">
                            <el-form-item label="仓库名:">
                                <hh-select-url v-model="formData.stockCode"
                                               url="/Basic/Common/StockList"
                                               valuefield="CN_S_STOCK_CODE"
                                               textfield="CN_S_STOCK_NAME"
                                               datafield="Data">
                                </hh-select-url>
                            </el-form-item>
                            <el-form-item label="货位:">
                                <el-input v-model="formData.locationCode" size="mini"></el-input>
                            </el-form-item>
                            <el-form-item label="业务号:">
                                <el-input v-model="formData.opNo" size="mini"></el-input>
                            </el-form-item>
                            <el-form-item>
                                <el-button style="margin-top:2px;" size="mini" type="primary" v-on:click="search">查 询</el-button>
                            </el-form-item>
                        </el-form>
                        <el-row>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盘点物料数:<span style="color:red">{{data.checkTotal.CN_F_QUANTITY}}</span></div>
                            </el-col>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盈亏数量:<span style="color:red">{{data.checkTotal.CN_F_CHECK_QTY}}</span></div>
                            </el-col>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盈亏金额:<span style="color:red">¥{{data.checkTotal.Money}}</span></div>
                            </el-col>
                        </el-row>
                    </div>
                    <hh-table v-bind:coloptions="cols1"
                              v-bind:paging="true"
                              v-bind:check="false"
                              v-bind:where="where"
                              v-bind:rowno="true"
                              v-bind:rowstyle="tableRowClassName"
                              dh="145"
                              url="@Url.Action("GetCheckDtl")"
                              ref="checklist"></hh-table>
 
                </el-tab-pane>
                <el-tab-pane label="按物料汇总">
                    <div style="margin:0px 10px 3px 10px">
                        <el-form label-width="90px" v-bind:model="formData2" class="demo-ruleForm" v-bind:inline="true">
                            <el-form-item label="仓库名:">
                                <hh-select-url v-model="formData2.stockCode"
                                               url="/Basic/Common/StockList"
                                               valuefield="CN_S_STOCK_CODE"
                                               textfield="CN_S_STOCK_NAME"
                                               datafield="Data">
                                </hh-select-url>
                            </el-form-item>
                            <el-form-item label="物料编码:">
                                <el-input v-model="formData2.itemCode" size="mini"></el-input>
                            </el-form-item>
                            <el-form-item label="物料名称:">
                                <el-input v-model="formData2.itemName" size="mini"></el-input>
                            </el-form-item>
                            <el-form-item label="规格型号:">
                                <el-input v-model="formData2.itemModel" size="mini"></el-input>
                            </el-form-item>
                            <el-form-item>
                                <el-button style="margin-top:2px;" size="mini" type="primary" v-on:click="search2">查 询</el-button>
                            </el-form-item>
                        </el-form>
                        <el-row>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盘点物料数:<span style="color:red">{{data.itemTotal.CN_F_QUANTITY}}</span></div>
                            </el-col>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盈亏数量:<span style="color:red">{{data.itemTotal.CN_F_CHECK_QTY}}</span></div>
                            </el-col>
                            <el-col v-bind:span="8">
                                <div style="font-size:16px">盈亏金额:<span style="color:red">¥{{data.itemTotal.Money}}</span></div>
                            </el-col>
                        </el-row>
                    </div>
                    <hh-table v-bind:coloptions="cols2"
                              v-bind:paging="true"
                              v-bind:check="false"
                              v-bind:where="where"
                              v-bind:rowno="true"
                              v-bind:rowstyle="tableRowClassName"
                              dh="145"
                              url="@Url.Action("GetItemCheckDtl")"
                              ref="itemlist"></hh-table>
                </el-tab-pane>
            </el-tabs>
        </template>
    </el-card>
</el-container>
 
@section scripts{
    <script>
        new Vue({
            el: '#idMain',
            data: {
                formData: {
                    stockCode: "",
                    locationCode: "",
                    opNo: ""
                },
                formData2: {
                    stockCode: "",
                    itemCode: "",
                    itemName: "",
                    itemModel: ""
                },
                data: {
                    checkTotal: {},
                    itemTotal: {}
                },
                where: {},
                cols1: [
                    { f: "CN_S_STOCK_CODE", n: "仓库", w: 80 },
                    { f: "CN_S_LOCATION_CODE", n: "货位", w: 120 },
                    { f: "CN_S_TRAY_CODE", n: "托盘", w: 100 },
                    { f: "CN_S_ITEM_CODE", n: "物料编码", w: 150 },
                    { f: "CN_S_ITEM_NAME", n: "物料名称", w: 150 },
                    { f: "CN_S_MODEL", n: "规格型号", w: 150 },
                    { f: "CN_S_PRODUCTION_BATCH", n: "生产批次"},
                    { f: "CN_S_ITEM_STATE", n: "物料状态", w: 80 },
                    { f: "CN_F_QUANTITY", n: "数量", w: 80 },
                    { f: "CN_F_CHECK_QTY", n: "盘点数量", w: 80 },
                    {
                        f: "SHIFTING_QTY", n: "盈亏数量", w: 60
                        , format: function (row, column) {
                            return row.CN_F_CHECK_QTY - row.CN_F_QUANTITY;
                        }
                    },
                    { f: "CN_S_MEASURE_UNIT", n: "单位", w: 60 },
                    { f: "CN_S_CREATOR_BY", n: "作业人", w: 80 },
                    { f: "CN_T_CREATE", n: "作业时间", w: 120 }
                ],
                cols2: [
                    { f: "CN_S_STOCK_CODE", n: "仓库", w: 80 },
                    { f: "CN_S_ITEM_CODE", n: "物料编码", w: 150 },
                    { f: "CN_S_ITEM_NAME", n: "物料名称", w: 150 },
                    { f: "CN_S_MODEL", n: "规格型号", w: 150 },
                    { f: "CN_S_PRODUCTION_BATCH", n: "生产批次" },
                    { f: "CN_S_ITEM_STATE", n: "物料状态", w: 80 },
                    { f: "CN_F_QUANTITY", n: "数量", w: 80 },
                    { f: "CN_F_CHECK_QTY", n: "盘点数量", w: 80 },
                    {
                        f: "SHIFTING_QTY", n: "盈亏数量", w: 60
                        , format: function (row, column) {
                            return row.CN_F_CHECK_QTY - row.CN_F_QUANTITY;
                        }
                    },
                    { f: "CN_S_MEASURE_UNIT", n: "单位",w: 60}
                ]
            },
            mounted: function () {
                var $this = this;
                this.loadData();
                this.loadData2();
            },
            watch: {
                //stockCode: function () {
                //    this.loadValue();
                //}
            },
            methods: {
                search: function () {
                  
 
                    this.$refs.checklist.loadData(this.formData);
                    this.loadData();
                },
                search2: function () {
                    this.$refs.itemlist.loadData(this.formData2);
                    this.loadData2();
                },
                loadData: function () {
                    var $this = this;
                    ajaxManage({
                        url: "@Url.Action("GetCheckDtlTotal")",
                        data: $this.formData,
                        success: function (result) {
                            if (result.Success) {
                                if (result.Data != null)
                                    $this.data.checkTotal = result.Data;
                                else
                                    $this.data.checkTotal = {
                                        CN_F_QUANTITY: 0,
                                        CN_F_CHECK_QTY: 0,
                                        Money: 0
                                    }
                            }
                            else {
                                wms.error(result.Msg);
                            }
                        }
                    });
                },
                loadData2: function () {
                    var $this = this;
                    ajaxManage({
                        url: "@Url.Action("GetCheckDtlTotal")",
                        data: $this.formData2,
                        success: function (result) {
                            if (result.Success) {
                                if (result.Data != null)
                                    $this.data.itemTotal = result.Data;
                                else
                                    $this.data.itemTotal = {
                                        CN_F_QUANTITY: 0,
                                        CN_F_CHECK_QTY: 0,
                                        Money: 0
                                    }
                            }
                            else {
                                wms.error(result.Msg);
                            }
                        }
                    });
                },
                tableRowClassName: function (data, rowIndex) {
                    if (data.row.type === '-') {
                        return 'warning-row';
                    } else if (data.row.type === '+') {
                        return 'success-row';
                    }
                    return '';
                }
            }
        });
    </script>
}