zzr99
2021-12-17 e3bff146a97648a9e2b7ec988cfc1ebe4c19b372
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
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
 
namespace WebAPI.Controllers.基础资料.基础资料
{
    public class Gy_StockCheckItemBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态(新增,修改,浏览,更新单价,变更)
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public Models.ClsGy_StockCheckItemBill BillNew0 = new Models.ClsGy_StockCheckItemBill();
 
        #region 盘点方案列表
        [Route("Gy_StockCheckItemBill/Get_StockCheckItemList")]
        [HttpGet]
        public object Get_StockCheckItemList(string sWhere)
        {
            try
            {
                ds = StockCheckItemList(sWhere);
                if (ds == null)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "查询数据异常,请与管理员联系!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "返回记录成功!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "查询数据异常,请与管理员联系!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
 
        public static DataSet StockCheckItemList(string sWhere)
        {
            string sql1 = string.Format(@"select * from h_v_Gy_StockCheckItemList");
            if (sWhere == null || sWhere.Equals(""))
            {
                return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by hitemid desc", "h_v_Gy_StockCheckItemList");
            }
            else
            {
                string sql = sql1 + sWhere + "order by hitemid desc";
                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_StockCheckItemList");
            }
        }
        #endregion
 
        #region [盘点方案删除功能]
        [Route("Gy_StockCheckItemBill/set_DeleteBill")]
        [HttpGet]
        public object set_DeleteBill(string HItemID)
        {
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HItemID);
            if (lngBillKey == 0)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "单据ID为空!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            ds = oCn.RunProcReturn("select * from Gy_StockCheckItem where HItemID=" + lngBillKey, "Gy_StockCheckItem");
            if (ds != null)
            {
                oCn.RunProc("Delete from Gy_StockCheckItem where HItemID=" + lngBillKey);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "此单据不存在,请查看是否重复删除";
                objJsonResult.data = null;
                return objJsonResult;
            }
 
        }
 
        #endregion
 
        #region [编辑显示表头]
        [Route("Gy_StockCheckItemBill/GetStockCheckItemByID")]
        [HttpGet]
        public object GetStockCheckItemByID(string HID)
        {
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HID);
            if (lngBillKey == 0)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "单据ID为空!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            ds = oCn.RunProcReturn("select * from Gy_StockCheckItem where HItemID=" + lngBillKey, "Gy_ConkReason");
            if (ds != null)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "此单据不存在";
                objJsonResult.data = null;
                return objJsonResult;
            }
 
        }
 
        #endregion
 
        #region 保存盘点方案
        [Route("Gy_StockCheckItemBill/SaveGy_StockCheckItem")]
        [HttpPost]
        public object SaveGy_StockCheckItem([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg2 = _value.ToString();
            string[] sArray = msg2.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg1 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();//当前人
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            ListModels oListModels = new ListModels();
            try
            {
                Models.ClsGy_StockCheckItemBill oBill = new Models.ClsGy_StockCheckItemBill();
                List<Models.ClsGy_StockCheckItemBill> lsmain = new List<Models.ClsGy_StockCheckItemBill>();
                msg1 = msg1.Replace("\\", "");
                msg1 = msg1.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Gy_StockCheckItem(msg1);
                foreach (Models.ClsGy_StockCheckItemBill oItem in lsmain)
                {
                    if (oItem.HNumber.Trim() == "")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败!代码不能为空!";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    if (oItem.HName.Trim() == "")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败!名称不能为空!";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    //得到短代码
                    string sShortNumber;
                    sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
                    if (sShortNumber.Trim() == "")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败!短代码为空!";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    oItem.HShortNumber = sShortNumber;//短代码
                    oItem.HEndFlag = true;//末级标志
                    oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
                    oBill = oItem;
                }
 
                //保存
                //保存完毕后处理
                if (oBill.HItemID == 0)
                {
                    oCn.RunProc("Insert into Gy_StockCheckItem " +
                    " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                    ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HEndDate,HOrgID) " +
                    " Values('" + oBill.HNumber + "','" + oBill.HName + "','" + oBill.HHelpCode + "','" + oBill.HShortNumber + "'," + oBill.HParentID.ToString() +
                    "," + oBill.HLevel.ToString() + "," + Convert.ToString(oBill.HEndFlag ? 1 : 0) + "," + Convert.ToString(oBill.HStopflag ? 1 : 0) + ",'" + oBill.HRemark +
                    "','" + oBill.HUseFlag + "',getdate(),'" + msg3 + "','" + oBill.HEndDate.ToString() + "'," + oBill.HOrgID.ToString()+
                    ")", ref DBUtility.ClsPub.sExeReturnInfo);
                    //修改上级为非末级代码
                    oCn.RunProc("Update Gy_StockCheckItem set HEndflag=0 where HItemID=" + oBill.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
 
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功!";
                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    oCN.RunProc("UpDate Gy_StockCheckItem set  " +
                    " HNumber='" + oBill.HNumber + "'" +  //固定赋值===============
                    ",HName='" + oBill.HName + "'" +
                    ",HShortNumber='" + oBill.HShortNumber + "'" +
                    ",HHelpCode='" + oBill.HHelpCode + "'" +
                    ",HUseFlag='" + oBill.HUseFlag + "'" +
                    ",HRemark='" + oBill.HRemark + "'" +
                    ",HEndDate='" + oBill.HEndDate + "'" +
                    ",HModifyTime=getdate()" +
                    ",HModifyEmp='" + msg3 + "'" +
                    ",HStopflag=" + Convert.ToString(oBill.HStopflag ? 1 : 0) +
                    " where HItemID=" + oBill.HItemID.ToString());
 
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "修改成功!";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败!" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        #endregion
 
        #region 盘点分析列表
        [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")]
        [HttpGet]
        public object Get_InventoryAnalysisList(string sWhere)
        {
            DataSet ds;
            List<object> list = new List<object>();
            List<object> list1 = new List<object>();
            List<object> list2 = new List<object>();
            List<object> list3 = new List<object>();
            List<object> list4 = new List<object>();
            List<object> list5 = new List<object>();
            List<object> list6 = new List<object>();
            List<object> list7 = new List<object>();
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                string sql;
                if (sWhere != null&&sWhere!="")
                {
                     sql = string.Format(@"select k.HBarCode 条码,s.HName 盘点方案,
                        case when k.HCorrespondentTypeID=1 then '供应商' when k.HCorrespondentTypeID=2 then '客户' when k.HCorrespondentTypeID=4 then '仓库' end 实际位置类型,
                        case when k.HCorrespondentTypeID=1 then p.HName when  k.HCorrespondentTypeID=2 then c.HName when k.HCorrespondentTypeID=4 then w.HName end 实际位置,
                        case when m.HNowSupTypeID=1 then '供应商' when m.HNowSupTypeID=2 then '客户' when m.HNowSupTypeID=4 then '仓库' end 账面位置类型,
                        case when m.HNowSupTypeID=1 then p1.HName when  m.HNowSupTypeID=2 then c1.HName when m.HNowSupTypeID=4 then w1.HName end 账面位置
                        from Sc_MouldStockBillMain_Temp k 
                        left join Gy_MouldFileMain m on k.HBarCode=m.HBarCode
                        left join Gy_StockCheckItem s on k.HSourceInterID=s.HItemID 
                        left join Gy_Supplier p on k.HCorrespondentID=p.HItemID
                        left join Gy_Supplier p1 on m.HNowSupTypeID=p1.HItemID
                        left join Gy_Customer c on k.HCorrespondentID=c.HItemID
                        left join Gy_Customer c1 on m.HNowSupTypeID=c1.HItemID
                        left join Gy_Warehouse w on k.HSourceInterID=w.HItemID
                        left join Gy_Warehouse w1 on m.HNowSupTypeID=w1.HItemID
                        where (select  HEndDate from Gy_StockCheckItem where Hitemid=(select top 1 HSourceInterID from Sc_MouldStockBillMain_Temp WHERE HSourceInterID=0))<getdate()");
                }
                else
                {
                     sql = string.Format(@"select k.HBarCode 条码,s.HName 盘点方案,
                        case when k.HCorrespondentTypeID=1 then '供应商' when k.HCorrespondentTypeID=2 then '客户' when k.HCorrespondentTypeID=4 then '仓库' end 实际位置类型,
                        case when k.HCorrespondentTypeID=1 then p.HName when  k.HCorrespondentTypeID=2 then c.HName when k.HCorrespondentTypeID=4 then w.HName end 实际位置,
                        case when m.HNowSupTypeID=1 then '供应商' when m.HNowSupTypeID=2 then '客户' when m.HNowSupTypeID=4 then '仓库' end 账面位置类型,
                        case when m.HNowSupTypeID=1 then p1.HName when  m.HNowSupTypeID=2 then c1.HName when m.HNowSupTypeID=4 then w1.HName end 账面位置
                        from Sc_MouldStockBillMain_Temp k 
                        left join Gy_MouldFileMain m on k.HBarCode=m.HBarCode
                        left join Gy_StockCheckItem s on k.HSourceInterID=s.HItemID 
                        left join Gy_Supplier p on k.HCorrespondentID=p.HItemID
                        left join Gy_Supplier p1 on m.HNowSupTypeID=p1.HItemID
                        left join Gy_Customer c on k.HCorrespondentID=c.HItemID
                        left join Gy_Customer c1 on m.HNowSupTypeID=c1.HItemID
                        left join Gy_Warehouse w on k.HSourceInterID=w.HItemID
                        left join Gy_Warehouse w1 on m.HNowSupTypeID=w1.HItemID");
                }
                ds = oCN.RunProcReturn(sql, "Sc_MouldStockBillMain_Temp");
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0) 
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        if (dr["实际位置类型"].ToString()== dr["账面位置类型"].ToString()&& dr["实际位置类型"].ToString()=="供应商")
                        {
                            //正常
                            if (dr["实际位置"].ToString() == dr["账面位置"].ToString())
                            {
                                list1.Add(dr);
                            }
                            //盘盈  实物在A供应商,但是在账面上没有这个台车
                            if (dr["实际位置"].ToString() !=""|| dr["实际位置"].ToString() != null && dr["账面位置"].ToString()==""|| dr["账面位置"].ToString() == null)
                            {
                                list5.Add(dr);
                            }
                            //盘亏  A供应商没有这个台车,但是在账面上有这个台车
                            if (dr["实际位置"].ToString() == "" || dr["实际位置"].ToString() == null && dr["账面位置"].ToString() != "" || dr["账面位置"].ToString() != null)
                            {
                                list6.Add(dr);
                            }
                            //先做领用退库单,再做领用出库单  台车在A供应商/客户,但是账面上台车在B供应商/客户
                            if (dr["实际位置类型"].ToString()=="客户"&& dr["实际位置"].ToString() != dr["实际位置"].ToString())
                            {
                                list4.Add(dr);
                            }
                            //出库
                            if (dr["实际位置类型"].ToString() == "供应商" && dr["账面位置类型"].ToString() == "仓库")
                            {
                                list3.Add(dr);
                            }
                        }
                        if (dr["实际位置类型"].ToString() == dr["账面位置类型"].ToString() && dr["实际位置类型"].ToString() == "客户")
                        {
                            //正常
                            if (dr["实际位置"].ToString() == dr["账面位置"].ToString())
                            {
                                list1.Add(dr);
                            }
                            //盘盈  实物在A供应商,但是在账面上没有这个台车
                            if (dr["实际位置"].ToString() != "" || dr["实际位置"].ToString() != null && dr["账面位置"].ToString() == "" || dr["账面位置"].ToString() == null)
                            {
                                list5.Add(dr);
                            }
                            //盘亏  A供应商没有这个台车,但是在账面上有这个台车
                            if (dr["实际位置"].ToString() == "" || dr["实际位置"].ToString() == null && dr["账面位置"].ToString() != "" || dr["账面位置"].ToString() != null)
                            {
                                list6.Add(dr);
                            }
                            //出库
                            if (dr["实际位置类型"].ToString() == "客户" && dr["账面位置类型"].ToString() == "仓库")
                            {
                                list3.Add(dr);
                            }
                            //先做领用退库单,再做领用出库单  台车在A供应商/客户,但是账面上台车在B供应商/客户
                            if (dr["实际位置类型"].ToString() == "供应商" && dr["实际位置"].ToString() != dr["实际位置"].ToString())
                            {
                                list4.Add(dr);
                            }
                        }
                        if (dr["实际位置类型"].ToString() == dr["账面位置类型"].ToString() && dr["实际位置类型"].ToString() == "仓库")
                        {
                            //正常
                            if (dr["实际位置"].ToString() == dr["账面位置"].ToString())
                            {
                                list1.Add(dr);
                            }
                            //盘盈  实物在A供应商,但是在账面上没有这个台车
                            if (dr["实际位置"].ToString() != "" || dr["实际位置"].ToString() != null && dr["账面位置"].ToString() == "" || dr["账面位置"].ToString() == null)
                            {
                                list5.Add(dr);
                            }
                            //盘亏  A供应商没有这个台车,但是在账面上有这个台车
                            if (dr["实际位置"].ToString() == "" || dr["实际位置"].ToString() == null && dr["账面位置"].ToString() != "" || dr["账面位置"].ToString() != null)
                            {
                                list6.Add(dr);
                            }
                            //退库
                            if (dr["账面位置类型"].ToString()=="供应商"|| dr["账面位置类型"].ToString() == "客户")
                            {
                                list7.Add(dr);
                            }
                            //调拨
                            if (dr["实际位置"].ToString() != dr["账面位置"].ToString())
                            {
                                list2.Add(dr);
                            }
                        }
                    }
                    list.Add(list1);
                    list.Add(list2);
                    list.Add(list3);
                    list.Add(list4);
                    list.Add(list5);
                    list.Add(list6);
                    list.Add(list7);
                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取信息成功!";
                objJsonResult.list = list;
                return objJsonResult;
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "查询数据异常,请与管理员联系!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}