|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
using Infrastructure;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using WebRepository;
namespace WebApp
{
/// <summary>
/// 盘点单主表
/// </summary>
public partial class CyclecountHeaderApp
{
private IUnitWork _unitWork;
|
|
19
|
public IRepository<CyclecountHeader> _app;
|
|
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
private static IHostingEnvironment _hostingEnvironment;
ExcelHelper imp = new ExcelHelper(_hostingEnvironment);
public CyclecountHeaderApp(IUnitWork unitWork, IRepository<CyclecountHeader> repository, IHostingEnvironment hostingEnvironment)
{
_unitWork = unitWork;
_app = repository;
_hostingEnvironment = hostingEnvironment;
}
public CyclecountHeaderApp SetLoginInfo(LoginInfo loginInfo)
{
_app._loginInfo = loginInfo;
return this;
}
public TableData Load(PageReq pageRequest, CyclecountHeader entity)
{
return _app.Load(pageRequest, entity);
}
public void Ins(CyclecountHeader entity)
{
|
|
43
|
entity.Code = entity.Code.Insert(0, TaskNo.盘点);
|
|
44
|
entity.Status = ReceiptHeaderStatus.新建;
|
|
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
|
entity.UploadTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ffff"));
_app.Add(entity);
}
public void Upd(CyclecountHeader entity)
{
_app.Update(entity);
}
public void DelByIds(int[] ids)
{
_app.Delete(u => ids.Contains(u.Id.Value));
}
public CyclecountHeader FindSingle(Expression<Func<CyclecountHeader, bool>> exp)
{
return _app.FindSingle(exp);
}
public IQueryable<CyclecountHeader> Find(Expression<Func<CyclecountHeader, bool>> exp)
{
return _app.Find(exp);
}
public Response ImportIn(IFormFile excelfile)
{
Response result = new Infrastructure.Response();
List<CyclecountHeader> exp = imp.ConvertToModel<CyclecountHeader>(excelfile);
string sErrorMsg = "";
for (int i = 0; i < exp.Count; i++)
{
try
{
CyclecountHeader e = exp[i];
e.Id = null;
_app.Add(e);
}
catch (Exception ex)
{
sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>";
result.Message = sErrorMsg;
break;
}
}
if (sErrorMsg.Equals(string.Empty))
{
if (exp.Count == 0)
{
sErrorMsg += "没有发现有效数据, 请确定模板是否正确, 或是否有填充数据!";
result.Message = sErrorMsg;
}
else
{
result.Message = "导入完成";
}
}
else
{
result.Status = false;
result.Message = result.Message;
}
return result;
}
public TableData ExportData(CyclecountHeader entity)
{
return _app.ExportData(entity);
}
public TableData Query(CyclecountHeader entity)
{
var result = new TableData();
var data = _app.Find(EntityToExpression<CyclecountHeader>.GetExpressions(entity));
GetData(data, result);
result.count = data.Count();
return result;
}
public void GetData(IQueryable<CyclecountHeader> data, TableData result, PageReq pageRequest = null)
{
_app.GetData(data, result, pageRequest);
}
|
|
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
|
/// <summary>
/// 手动删除盘点单数据
/// </summary>
/// <param name="receiptHeaders">盘点单数据组</param>
/// <returns></returns>
public TableData DelHeader(List<CyclecountHeader> CyclecountHeaders)
{
TableData tab = new TableData();
tab.code = 200;
List<CyclecountDetail> CyclecountDetails = new List<CyclecountDetail>();
try
{
foreach (CyclecountHeader CyclecountHeader in CyclecountHeaders)
{
if (CyclecountHeader.Status == ReceiptHeaderStatus.回传)
{
CyclecountDetails = _unitWork.Find<CyclecountDetail>(n => n.Code == CyclecountHeader.Code).ToList();
foreach (CyclecountDetail CyclecountDetail in CyclecountDetails)
{
_unitWork.Delete(CyclecountDetail);
}
_unitWork.Delete(CyclecountHeader);
}
else
{
tab.code = 300;
|
|
157
|
tab.msg = "盘点单状态不允许删除";
|
|
158
159
160
161
162
163
164
165
166
167
|
}
}
}
catch (Exception ex)
{
tab.code = 300;
tab.msg += ex.Message;
}
return tab;
}
|
|
168
169
170
|
}
}
|