| | |
| | | { |
| | | list.Clear(); |
| | | string result = ""; |
| | | var groupedModels = obj.GroupBy(m => m.erpordercode); |
| | | //var groupedModels = obj.GroupBy(m => m.erpordercode); |
| | | var groupedModels = obj.GroupBy(s => s.erpordercode).Select(g => new { erpordercode = g.Key }).ToList(); |
| | | foreach (var group in groupedModels) |
| | | { |
| | | string erpordercode = group.Key; |
| | | string erpordercode = group.erpordercode; |
| | | int count = 1; |
| | | foreach (var model in group) |
| | | foreach (var model in obj.Where(s => s.erpordercode==erpordercode).ToList()) |
| | | { |
| | | //获取当前最大工单号 |
| | | sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0) as worknumb |