<div id="dataImport" class="mini-webuploader" pickerText="选择文件上传" fileSingleSizeLimit="5120" action="szProjectRegListAction.getDataImportModel"

			limitType="xls,xlsx" mimeTypes=".xls,.xlsx" dataImport="true" auto="true" onfilesqueued="ztb.uploader.onFilesQueued" onuploadfinished="ztb.uploader.onUploadFinished" data-options="{refreshIds:'datagrid'}"></div>

public DataImportModel9 getDataImportModel() {

        if (dataImportModel == null) {

            dataImportModel = new DataImportModel9(new ImportExcelHandler()

            {

                private static final long serialVersionUID = 1L;

                @Override

                public void refreshTable() {

                    CRUDService crud = null;

                    try {

                        if (execlList.size() > 0) {

                            crud = new CRUDService();

                            for (int i = 0, size = execlList.size() - 1; i < size; i++) {

                                service.insert(execlList.get(i));

                                InsertBiaoDuanInfo(i);//add by qgj 插入标段表

                            }

                            service.insert(execlList.get(execlList.size() - 1));

                            InsertBiaoDuanInfo(execlList.size() - 1);

                        }

                        execlList.clear();

                    }

                    catch (Exception e) {

                        e.printStackTrace();

                        execlList.clear();

                        excelImportModel.setMessage("导入失败  ,请联系管理员！");

                    }

                    finally {

                        if (crud != null) {

                            crud.closeDataSource();

                        }

                    }

                }

                @Override

                public String saveExcelData(String filename, String sheetName, int sheet, int curRow, int totalRows,

                        Object[] data) {

                    if (sheetName != null) {

                        if (curRow == 0)

                            return null;

                        if (curRow == 1)

                            return null;

                        if (sheet == 0) {

                            if (data == null) {

                                return null;

                            }

                            String projectname =ZtbCommonDao.getInstance().queryString("select projectName from cg_projectinfo where projectName='" + data[0].toString().trim() + "'");

                            if(StringUtil.isNotBlank(projectname))

                            {

                                return null;

                            }

                            String SQLJianSheDanWeiGuid =ZtbCommonDao.getInstance().queryString("select DanWeiGuid from View_HuiYuan_AllJianSheDanWei where DanWeiName='" + data[21].toString().trim() + "'");

                            if(StringUtil.isBlank(SQLJianSheDanWeiGuid))

                            {

                                return null;

                            }

                            int nullCount = 0, entryCount = 0;

                            for (int i = 0; i < data.length; i++) {

                                if (data[i] == null) {

                                    nullCount += 1;

                                }

                                else {

                                    if ("".equals(data[i].toString())) {

                                        entryCount += 1;

                                    }

                                }

                            }

                            if (nullCount == data.length || entryCount == data.length) {

                                return null;

                            }

                            CgProjectinfo bean_Projectinfo = new CgProjectinfo();

                            try {

                                String msg = Uploader2_FileUploaded(bean_Projectinfo, data);

                                if(StringUtil.isNotBlank(msg))

                                    return msg;

                                execlList.add(bean_Projectinfo);

                            }

                            catch (Exception e) {

                                e.printStackTrace();

                                execlList.clear();

                                return "导入数据出现异常，请联系管理员！";

                            }

                        }

                    }

                    return null;

                }

            });

        }

        return dataImportModel;

    }