pldrhandler.java

java操作excel数据批量导入

					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					try {
						rowkp.setFz((int) nc.getValue());
						validate.validateFz(rowkp.getFz());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 13: {
					if (tempStr.equals("")) {
						rowkp.setFkpbh(0);
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					try {
						rowkp.setFkpbh((long) nc.getValue());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 14: {
					if (tempStr.equals("")) {
						rowkp.setFkpxh(0);
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;

					try {
						rowkp.setFkpxh((long) nc.getValue());
						validate.validateFkpxh(rowkp.getFz(), rowkp.getFkpbh(),
								rowkp.getFkpxh());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 15: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "增加类型不能为空");
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					try {
						rowkp.setZjlx((int) nc.getValue());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 16: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "结构规格程式不能为空");
						break;
					}
					rowkp.setJgggcs(tempStr);
					break;
				}
				case 17: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "生产厂家不能为空");
						break;
					}
					rowkp.setSccj(tempStr);
					break;
				}
				case 18: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "数量不能为空");
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setSl(nc.getValue());
					// try {
					// validate.validateSl(rowkp.getSl());
					// } catch (Exception e) {
					// message += getErrorMessage(row, col, e.getMessage());
					// }
					break;
				}
				case 19: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "管理部门不能为空");
						break;
					}
					rowkp.setGlbm(tempStr);
					break;
				}
				case 20: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "使用部门不能为空");
						break;
					}
					rowkp.setSybm(tempStr);
					break;
				}
				case 21: {
					// if (tempStr.equals("")) {
					// message += getErrorMessage(row, col, "使用地点不能为空");
					// break;
					// }
					rowkp.setSydd(tempStr);
					break;
				}
				case 22: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "保管人不能为空");
						break;
					}
					rowkp.setbgy(tempStr);
					break;
				}
				case 23: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "购买日期不能为空");
						break;
					}
					if (cell.getType() != CellType.DATE) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					DateCell dc = (DateCell) cell;
					rowkp.setGmrq(dc.getDate());
					break;
				}
				case 24: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "开始使用日期不能为空");
						break;
					}
					if (cell.getType() != CellType.DATE) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					DateCell dc = (DateCell) cell;
					rowkp.setKssyrq(dc.getDate());
					break;
				}
				case 25: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "入帐日期不能为空");
						break;
					}
					if (cell.getType() != CellType.DATE) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					DateCell dc = (DateCell) cell;
					rowkp.setRzrq(dc.getDate());

					break;
				}
				case 26: {
					if (tempStr.equals("")) {
						if (rowkp.getFz() != 1) {
							message += getErrorMessage(row, col, "原值不能为空");
							break;
						} else {
							rowkp.setYz(0);
							break;
						}

					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					// NumberFormat format = NumberFormat.getInstance();
					// format.setMaximumFractionDigits(18);
					rowkp.setYz(nc.getValue());
					if (rowkp.getYz() <= 0) {
						message += getErrorMessage(row, col, "原值应大于0");
						break;
						// } else {
						// try {
						// validate.validateYz(format.format(rowkp.getYz()));
						// } catch (Exception e) {
						// message += getErrorMessage(row, col, e.getMessage());
						// }

					}
					break;
				}
				/*
				 * case 27: { if (tempStr.equals("")) { if (rowkp.getFz() != 1) {
				 * message += getErrorMessage(row, col, "累计折旧不能为空"); break; }
				 * else { rowkp.setLjzj(0); break; } } if (cell.getType() !=
				 * CellType.NUMBER) { message += getErrorMessage(row, col,
				 * "数据类型不匹配"); break; } NumberCell nc = (NumberCell) cell;
				 * rowkp.setLjzj(nc.getValue()); break; }
				 */
				case 27: {
					if (!tempStr.equals("")) {
						if (!tempStr.equals("0.00")) {
							message += getErrorMessage(row, col,
									"累计折旧不能有数值或不为0");
							break;
						}
					}

					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setLjzj(nc.getValue());
					break;
				}

				case 28: {
					if (tempStr.equals("")) {
						if (rowkp.getFz() != 1) {
							message += getErrorMessage(row, col, "累计减值不能为空");
							break;
						} else {
							rowkp.setLjjz(0);
							break;
						}

					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setLjjz(nc.getValue());
					break;
				}
				case 29: {
					if (tempStr.equals("")) {
						rowkp.setGcbh("");
						break;
					}
					rowkp.setGcbh(tempStr);
					break;
				}
				case 30: {
					if (tempStr.equals("")) {
						rowkp.setGcmc("");
						break;
					}
					rowkp.setGcmc(tempStr);
					break;
				}
				case 31: {
					if (tempStr.equals("")) {
						rowkp.setSwzcbh("");
						break;
					}
					rowkp.setSwzcbh(tempStr);
					break;
				}
				case 32: {
					if (tempStr.equals("")) {
						rowkp.setPzhm("");
						break;
					}
					rowkp.setPzhm(tempStr);
					break;
				}
				case 33: {
					if (tempStr.equals("")) {
						rowkp.setKhsx(0);
						break;
					}
					if (cell.getType() == CellType.NUMBER) {
						NumberCell nc = (NumberCell) cell;
						rowkp.setKhsx((int) nc.getValue());
					} else if (cell.getType() == CellType.LABEL) {
						LabelCell lc = (LabelCell) cell;
						rowkp.setKhsx(Integer.parseInt(lc.getString()));
					} else {
						message += getErrorMessage(row, col, "数据类型不匹配");
					}
					break;
				}
				case 34: {
					if (tempStr.equals("")) {
						rowkp.setBz("");
						break;
					}
					rowkp.setBz(tempStr);
					break;
				}
				case 35: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "盘赢否不能为空");
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setPyf((int) nc.getValue());
					try {
						validate.validatePyf(rowkp.getPyf());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 36: {
					/*
					 * if (tempStr.equals("")) { rowkp.setPzhm(""); break; }
					 */
					if (tempStr.equals("")) {
						rowkp.setSyr("");
						break;
					}
					rowkp.setSyr(tempStr);
					break;
				}
				case 37: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "资产名称不能为空");
						break;
					}
					rowkp.setZcmc(tempStr);
					break;
				}
				case 38: {
					if (tempStr.equals("")) {
						message += getErrorMessage(row, col, "建卡人不能为空");
						break;
					}
					rowkp.setJkr(tempStr);
					break;
				}
				case 39: {
					/*
					 * if (tempStr.equals("")) { message += getErrorMessage(row,
					 * col, "区域编码不能为空"); break; }
					 */
					rowkp.setQybm(tempStr);
					break;
				}
				case 40: {
					if (tempStr.equals("")) {
						rowkp.setSbwzh("");
						break;
					}
					rowkp.setSbwzh(tempStr);
					break;
				}
				case 41: {
					if (tempStr.equals("")) {
						rowkp.setBklyl(0.00);
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setBklyl(nc.getValue());
					try {
						validate.validateBklyl(rowkp.getBklyl());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 42: {
					if (tempStr.equals("")) {
						rowkp.setYhszl(0.00);
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setYhszl(nc.getValue());
					try {
						validate.validateYhszl(rowkp.getYhszl());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}
					break;
				}
				case 43: {
					if (tempStr.equals("")) {
						rowkp.setGys("");
						break;
					}
					if (cell.getType() != CellType.LABEL) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					LabelCell lc = (LabelCell) cell;
					rowkp.setGys(lc.getString());
					break;
				}
				case 44: {
					if (tempStr.equals("")) {
						rowkp.setGly("");
						break;
					}
					rowkp.setGly(tempStr);
					break;
				}
				case 45: {
					if (tempStr.equals("")) {
						rowkp.setK_zclx(1);
						break;
					}
					if (cell.getType() != CellType.NUMBER) {
						message += getErrorMessage(row, col, "数据类型不匹配");
						break;
					}
					NumberCell nc = (NumberCell) cell;
					rowkp.setK_zclx((int) nc.getValue());
					try {
						validate.validateZclx(rowkp.getK_zclx());
					} catch (Exception e) {
						message += getErrorMessage(row, col, e.getMessage());
					}

					if (rowkp.getK_zclx() <= 1) {
						try {
							if (Integer.parseInt(token.getMonthLimit()) == 1) {
								validate.validateDate(rowkp.getGmrq(), rowkp
										.getRzrq(), rowkp.getKssyrq(), jkrq,
										k_ywrq);
							} else {
								validate.validateDate(rowkp.getRzrq(), k_ywrq);
							}
						} catch (Exception e) {
							message += "第" + row + "行" + e.getMessage();
						}
					}

					break;
				}
				}
			}
			if (message.equals("")) {
				this.Auto(rowkp, jkrq);
				arr.add(rowkp);
			} else {
				return null;
			}
		}
		validate.close();
		workbook.close();
		return arr;
	}

}