Example #1
0
        public static void importCarsParams(String dataFilePath)
        {
            DataTable dt = ExcelUtils.ExcelUtil.getDataTableFromExcel(dataFilePath);

            int rowParamNameFirst  = 4; //检查参数名称第一顺位行
            int rowParamNameSecond = 3; //检查参数名称第二顺位行

            int[] cursorPackageCode = searchFromDataTable(dt, "Model");
            ParamsCollection.dt = dt;
            Dictionary <String, HtmlAttribute> dicRules = ParamsCollection.dicRules;
            //所有车型配置信息的list
            List <CarParams> listCarParams = new List <CarParams>();
            int rowCounterBeforeConfig     = getRowCounterBeforeConfig(dt);
            int carConfigCounter           = dt.Rows.Count - rowCounterBeforeConfig;

            //针对每个配置信息获取对应参数
            for (int carConfigIter = 0; carConfigIter < carConfigCounter; carConfigIter++)
            {
                CarParams      cps         = new CarParams();
                List <paramPo> listParampo = new List <paramPo>();
                //配置所在行数
                int rowNo = carConfigIter + rowCounterBeforeConfig;
                //行号
                int columnNo = 0;

                //当没有到达最后一列的时候继续增加列数
                while (columnNo < dt.Columns.Count)
                {
                    String cname       = null;
                    String value       = null;
                    String cnameFirst  = null;
                    String cnameSecond = null;
                    Param  p           = null;
                    //因为packageCode与其他参数在不同行,所以需要单独判断
                    if (cursorPackageCode[1] >= 0 && columnNo <= cursorPackageCode[1] + 2)
                    {
                        int rowNoPackageCode = cursorPackageCode[0];
                        cname = dt.Rows[rowNoPackageCode][columnNo].ToString().Trim();
                        value = dt.Rows[rowNo][columnNo].ToString().Trim();
                        if (!String.IsNullOrEmpty(cname))
                        {
                            p = new EngineParam(cname, null, value);
                            cps.listParams.Add(p);
                        }
                        columnNo++;
                        continue;
                    }
                    cnameFirst  = dt.Rows[rowParamNameFirst][columnNo].ToString();
                    cnameSecond = dt.Rows[rowParamNameSecond][columnNo].ToString();
                    value       = dt.Rows[rowNo][columnNo].ToString().Trim();
                    cname       = null;
                    if (!String.IsNullOrEmpty(cnameFirst))
                    {
                        cname = cnameFirst.Trim();
                    }
                    else
                    {
                        if (!String.IsNullOrEmpty(cnameSecond))
                        {
                            cname = cnameSecond.Trim();
                        }
                        else
                        {
                            columnNo++;
                            continue;
                        }
                    }
                    p = new EngineParam(cname, null, value);
                    cps.listParams.Add(p);
                    columnNo++;
                }
                //获取配置号信息
                String packageCode = ImportServiceForHCBM.getParameter("Model", cps.listParams) + "_"
                                     + ImportServiceForSHFY.getParameter("Package", cps.listParams) + "_"
                                     + ImportServiceForSHFY.getParameter("Profile", cps.listParams);
                cps.packageCode = packageCode;
                listCarParams.Add(cps);
            }
            //将全部参数添加到参数合集当中
            ParamsCollection.carParams = listCarParams;
        }
Example #2
0
        public void importCarsParams(String dataFilePath)
        {
            String    engineInfoStartString = "车辆名称";
            String    configInfoStartString = "MD配置信息";
            String    patacCodeInitial      = "P";
            DataTable dt = ExcelUtils.ExcelUtil.getDataTableFromExcel(dataFilePath);

            ParamsCollection.dt = dt;
            Dictionary <String, HtmlAttribute> dicRules = ParamsCollection.dicRules;
            //所有车型配置信息的list
            List <CarParams> listCarParams = new List <CarParams>();

            LoggerUtils.LoggerUtils.logger(dt.Columns.Count.ToString());
            int columnCounterBeforeConfig = 3;
            int carConfigCounter          = dt.Columns.Count - columnCounterBeforeConfig;

            //针对每个配置信息获取对应参数
            for (int carConfigIter = 0; carConfigIter < carConfigCounter; carConfigIter++)
            {
                CarParams      cps         = new CarParams();
                List <paramPo> listParampo = new List <paramPo>();
                //配置所在列数
                int columnNo = carConfigIter + columnCounterBeforeConfig;
                //行号
                int    rowno = 0;
                String cname = dt.Rows[rowno][0].ToString();
                String value = dt.Rows[rowno][columnNo].ToString();
                String pcode = dt.Rows[rowno][1].ToString();
                //当不是车辆名称的时候继续增加行数
                while (!cname.Equals("车辆名称"))
                {
                    rowno++;
                    cname = dt.Rows[rowno][0].ToString();
                    if (rowno >= dt.Rows.Count)
                    {
                        throw new Exception("已经超过最大行,还未找到车辆名称");
                    }
                }
                //从车辆名称到燃料种类
                while (!cname.Equals("部门会签"))
                {
                    if (String.IsNullOrEmpty(cname))
                    {
                        rowno++;
                        cname = dt.Rows[rowno][0].ToString();
                        continue;
                    }
                    value = dt.Rows[rowno][columnNo].ToString();
                    pcode = dt.Rows[rowno][1].ToString();
                    Param p = new EngineParam(cname, pcode, value);
                    cps.listParams.Add(p);
                    rowno++;
                    cname = dt.Rows[rowno][0].ToString();
                }

                //获取配置号信息
                String packageCode = ImportServiceForSHFY.getParameter("Model Code", cps.listParams)
                                     + ImportServiceForSHFY.getParameter("Package Code", cps.listParams) + "-"
                                     + ImportServiceForSHFY.getParameter("Order Sample", cps.listParams);
                cps.packageCode = packageCode;

                //获取是否需要申报配置号信息
                String needConfig = ImportServiceForSHFY.getParameter("是否申报新配置", cps.listParams);
                if (needConfig.Equals("Y", StringComparison.OrdinalIgnoreCase))
                {
                    cps.needConfigCode = true;
                }
                else
                {
                    cps.needConfigCode = false;
                }

                //通过配置号信息获取工程信息数据
                List <String> listPackageCode = new List <string>();
                if (!String.IsNullOrEmpty(packageCode))
                {
                    //如果需要填报才显示对应的packagecode
                    if (cps.needConfigCode)
                    {
                        listPackageCode.Add(packageCode);
                    }
                    listParampo = ImportServiceForSHFY.getParamsByPackageCode(listPackageCode);
                }
                foreach (Param p in cps.listParams)
                {
                    //只有型式认证编码有效的才能够获取数据
                    if (p.patacode.StartsWith(patacCodeInitial))
                    {
                        String paramValue = ImportServiceForSHFY.getParameter(cps.packageCode, p.patacode, listParampo);
                        if (String.IsNullOrEmpty(p.value))
                        {
                            //p.value = "test";
                        }
                        if (String.IsNullOrEmpty(paramValue))
                        {
                            continue;
                        }
                        p.value = paramValue;
                    }
                }



                //获取配置信息版本号
                String versionNum = getVersionNumFromListParamPo(listParampo);
                cps.version = versionNum;

                //获取配置信息

                //从部门会签到MD配置信息
                while (!cname.Equals("MD配置信息"))
                {
                    rowno++;
                    cname = dt.Rows[rowno][0].ToString();
                }

                //对配置参数进行转化,转化为参数列表(listParams而不是listHtmlAttributes)
                while (rowno < dt.Rows.Count)
                {
                    cname = dt.Rows[rowno][0].ToString().Trim();
                    //将全部英文符号换成中文符号
                    cname = cname.Replace("(", "(").Replace(")", ")");
                    value = dt.Rows[rowno][columnNo].ToString().Trim();
                    if (String.IsNullOrEmpty(cname))
                    {
                        rowno++;
                        continue;
                    }
                    HtmlAttribute ha = null;
                    if (dicRules.ContainsKey(cname))
                    {
                        ha = dicRules[cname];
                    }
                    //当能够找到对应参数而且参数值不为空的时候才进行
                    //适用于能够直接找到对应参数名称的情况
                    if (ha != null && !String.IsNullOrEmpty(value))
                    {
                        //处理text类型和checkbox类型
                        if (ha.elementType.Equals(Matcher.Matcher.TYPE_TEXT) || ha.elementType.Equals(Matcher.Matcher.TYPE_CHECK_BOX))
                        {
                            Param p = new ConfigParam(cname, null, Matcher.Matcher.VALUE_CHECKBOX);
                            cps.listParams.Add(p);
                        }
                        //处理othercheckbox类型
                        else if (ha.elementType.Equals(Matcher.Matcher.TYPE_OTHER_CHECK_BOX))
                        {
                            Param p1 = new ConfigParam(cname, null, Matcher.Matcher.VALUE_CHECKBOX);
                            cps.listParams.Add(p1);
                            if (dicRules.ContainsKey(cname + "内容"))
                            {
                                Param p2 = new ConfigParam(cname + "内容", null, value);
                                cps.listParams.Add(p2);
                            }
                        }
                    }
                    else if (cname.Contains("下拉菜单"))
                    {
                        cname = cname.Replace("(下拉菜单)", "").Trim();
                        //如果不包含直接下一个参数U
                        if (!dicRules.ContainsKey(cname))
                        {
                            rowno++;
                            continue;
                        }
                        ha = dicRules[cname];
                        Boolean got = false;
                        while (!cname.Equals("其他"))
                        {
                            rowno++;
                            cname = dt.Rows[rowno][0].ToString();
                            value = dt.Rows[rowno][columnNo].ToString();
                            if (!got)
                            {
                                if (!String.IsNullOrEmpty(value) && ha != null)
                                {
                                    //如果是S的话就是有这个配置,如果有这个配置就把对应的cname作为value。因为这是一个下拉菜单项
                                    Param p1 = new ConfigParam(ha.name, null, cname);
                                    cps.listParams.Add(p1);
                                    got = !got;
                                    if (cname.Equals("其他")) // 其他项目内容
                                    {
                                        Param p2 = new ConfigParam(ha.name + "其他", null, value);
                                        cps.listParams.Add(p2);
                                    }
                                }
                            }
                        }
                    }
                    rowno++;
                }
                listCarParams.Add(cps);
            }
            //将全部参数添加到参数合集当中
            ParamsCollection.carParams = listCarParams;
        }