| | |
|---|
| | | code = "300"; |
|---|
| | | Message = "物料清单模板(母件信息)不符合规范,请检查列名字段数"; |
|---|
| | | } |
|---|
| | | else if (excelTable[1].Columns.Count != 9) |
|---|
| | | else if (excelTable[1].Columns.Count != 10) |
|---|
| | | { |
|---|
| | | code = "300"; |
|---|
| | | Message = "物料清单模板(子件信息)不符合规范,请检查列名字段数"; |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //车间判断 |
|---|
| | | for (int m = 0; m < excelTable[1].Rows.Count; m++) |
|---|
| | | for (int m = 0; m < excelTable[2].Rows.Count; m++) |
|---|
| | | { |
|---|
| | | if (excelTable[1].Rows[m][6].ToString().Trim() != null && excelTable[1].Rows[m][6].ToString().Trim() != "") |
|---|
| | | if (excelTable[2].Rows[m][6].ToString().Trim() != null && excelTable[2].Rows[m][6].ToString().Trim() != "") |
|---|
| | | { |
|---|
| | | sql = @"select * from TOrganization where org_name=@code and description='W'"; |
|---|
| | | dynamicParams.Add("@code", excelTable[1].Rows[m][6].ToString().Trim()); |
|---|
| | | dynamicParams.Add("@code", excelTable[2].Rows[m][6].ToString().Trim()); |
|---|
| | | dt = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | if (dt.Rows.Count<=0) |
|---|
| | | { |
|---|
| | | ExcelErro erro = new ExcelErro(); |
|---|
| | | erro.RoeNumber = "/"; |
|---|
| | | erro.ErrorField = "{生产车间}"; |
|---|
| | | erro.ErrorCont = "设备表:{生产车间}字段" + excelTable[1].Rows[m][6].ToString().Trim() + "不存在"; |
|---|
| | | erro.ErrorCont = "设备表:{生产车间}字段" + excelTable[2].Rows[m][6].ToString().Trim() + "不存在"; |
|---|
| | | list.Add(erro); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | { |
|---|
| | | StuCode = "200"; |
|---|
| | | message = "数据验证成功"; |
|---|
| | | count = excelTable[0].Rows.Count + excelTable[1].Rows.Count; |
|---|
| | | count = excelTable[0].Rows.Count + excelTable[1].Rows.Count+excelTable[2].Rows.Count; |
|---|
| | | } |
|---|
| | | return list; |
|---|
| | | } |
|---|
