修改单据重复显示问题，增加工单源单id关联

yl

2024-03-29 9c634fd767aec36ef97c3a814bf7a29c67d20ee1

 VueWebApi/Tools/ImportExcelData.cs

@@ -27,7 +27,7 @@
                return Message;

            }
            else if (excelTable[0].Columns.Count != 9)
            else if (excelTable[0].Columns.Count != 10)
            {
                code = "300";
                Message = "用户清单模板不符合规范,请检查列名字段数";
@@ -85,6 +85,12 @@
            {
                code = "300";
                Message = "用户清单模板：表头信息不符合规范,第9列应为{工资类型}";
                return Message;
            }
            else if (excelTable[0].Columns[9].ColumnName != "班组编码")
            {
                code = "300";
                Message = "用户清单模板：表头信息不符合规范,第10列应为{班组编码}";
                return Message;
            }
            else
@@ -1855,6 +1861,20 @@
                        list.Add(erro);
                    }
                }
                if (excelTable.Rows[k][9].ToString().Trim() != null && excelTable.Rows[k][9].ToString().Trim() != "")
                {
                    sql = @"select *  from TGroup where group_code=@group_code";
                    dynamicParams.Add("@group_code", excelTable.Rows[k][9].ToString().Trim());
                    dt = DapperHelper.selectdata(sql, dynamicParams);
                    if (dt == null || dt.Rows.Count <= 0)
                    {
                        ExcelErro erro = new ExcelErro();
                        erro.RoeNumber = "/";
                        erro.ErrorField = "{班组编码}";
                        erro.ErrorCont = "用户表:{班组编码}字段" + excelTable.Rows[k][7].ToString().Trim() + "不存在";
                        list.Add(erro);
                    }
                }
            }
            if (list.Count > 0)
            {