mateoutdetaildao.java

JSP移动商品管理平台源代码.........

	}
	
	public ArrayList getMateOutDetailBeanOfOutNo(String outNo){
		ArrayList list = new ArrayList();
		MateOutDetailBean modb = new MateOutDetailBean();
		dbpool.getConnection();
		String sql ="select OutNoId,OutNo,MaterialName,MaModel,MaBrand,MaMadeIn,MaterialTypeNo,MaterIalNo,PriceUnit,OutCount,ChaFlag from Material_Out_Detail where OutNo='"+outNo+"'";
		
		//System.out.println(sql);
		
		try {
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				modb.setOutNoId(rs.getInt("OutNoId"));
				if(rs.getString("OutNo")==null){
					modb.setOutNo("");
				}else{
					modb.setOutNo(rs.getString("OutNo").trim());
				}
				if(rs.getString("MaterialName")==null){
					modb.setMaterialName("");
				}else{
					modb.setMaterialName(rs.getString("MaterialName").trim());
				}
				if(rs.getString("MaModel")==null){
					modb.setMaModel("");
				}else{
					modb.setMaModel(rs.getString("MaModel").trim());
				}
				if(rs.getString("MaBrand")==null){
					modb.setMaBrand("");
				}else{
					modb.setMaBrand(rs.getString("MaBrand").trim());
				}
				if(rs.getString("MaMadeIn")==null){
					modb.setMaMadeIn("");
				}else{
					modb.setMaBrand(rs.getString("MaMadeIn").trim());
				}
				if(rs.getString("MaterialTypeNo")==null){
					modb.setMaterialTypeNo("");
				}else{
					modb.setMaterialTypeNo(rs.getString("MaterialTypeNo").trim());
				}
				modb.setMaterialNo(rs.getInt("MaterialNo"));
				modb.setPriceUnit(rs.getDouble("PriceUnit"));
				modb.setOutCount(rs.getInt("OutCount"));
				if(rs.getString("ChaFlag")==null){
					modb.setChaFlag("");
				}else{
					modb.setChaFlag(rs.getString("ChaFlag").trim());
				}
				list.add(modb);
			}
			stmt.close();
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
		}
		return list;	
	}
	
	public ArrayList[] searchMateOutDetailBean(String startDate,String endDate,String materialTypeNo,int useDep){
		ArrayList[] list = new ArrayList[2];
		MateOutBaseBean mobb = new MateOutBaseBean();
		MateOutDetailBean modb = new MateOutDetailBean();
		dbpool.getConnection();
		String sql ="select mot.OutDate,mot.UserCode,mot.UseDep,mot.ManagerBy,mot.UseBy,mot.RoomNu,mot.BuildingNu,mot.OutCause,mot.ReMark,mod.OutNoId,mod.OutNo,mod.MaterialName,mod.MaModel,mod.MaBrand,mod.MaMadeIn,mod.MaterialTypeNo,mod.MaterIalNo,mod.PriceUnit,mod.OutCount,mod.ChaFlag " +
				"from Material_Out_Detail mod,Material_Out_Table mot where mod.OutNo=mot.OutNo and OutDate "+startDate+" between "+endDate+" and MaterialTypeNo like '%"+materialTypeNo+"%' and UseDep ="+useDep;
		try {
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				mobb.setOutNo(rs.getString("OutNo").trim());
				if(rs.getString("OutDate")==null){
					mobb.setOutDate("");
				}else{
					mobb.setOutDate(rs.getString("OutDate").trim());
				}
				if(rs.getString("UserCode")==null){
					mobb.setUserCode("");
				}else{
					mobb.setUserCode(rs.getString("UserCode").trim());
				}
				mobb.setUseDep(rs.getInt("UseDep"));
				if(rs.getString("ManagerBy")==null){
					mobb.setManagerBy("");
				}else{
					mobb.setManagerBy(rs.getString("ManagerBy").trim());
				}
				if(rs.getString("UseBy")==null){
					mobb.setUseBy("");
				}else{
					mobb.setUseBy(rs.getString("UseBy").trim());
				}
				if(rs.getString("RoomNu")==null){
					mobb.setRoomNu("");
				}else{
					mobb.setRoomNu(rs.getString("RoomNu").trim());
				}
				if(rs.getString("BuildingNu")==null){
					mobb.setBuildingNu("");
				}else{
					mobb.setBuildingNu(rs.getString("BuildingNu").trim());
				}
				mobb.setOutCause(rs.getInt("OutCause"));
				if(rs.getString("ReMark")==null){
					mobb.setReMark("");
				}else{
					mobb.setReMark(rs.getString("ReMark").trim());
				}
				modb.setOutNoId(rs.getInt("OutNoId"));
				if(rs.getString("OutNo")==null){
					modb.setOutNo("");
				}else{
					modb.setOutNo(rs.getString("OutNo").trim());
				}
				if(rs.getString("MaterialName")==null){
					modb.setMaterialName("");
				}else{
					modb.setMaterialName(rs.getString("MaterialName").trim());
				}
				if(rs.getString("MaModel")==null){
					modb.setMaModel("");
				}else{
					modb.setMaModel(rs.getString("MaModel").trim());
				}
				if(rs.getString("MaBrand")==null){
					modb.setMaBrand("");
				}else{
					modb.setMaBrand(rs.getString("MaBrand").trim());
				}
				if(rs.getString("MaMadeIn")==null){
					modb.setMaMadeIn("");
				}else{
					modb.setMaBrand(rs.getString("MaBrand").trim());
				}
				if(rs.getString("MaterialTypeNo")==null){
					modb.setMaterialTypeNo("");
				}else{
					modb.setMaterialTypeNo(rs.getString("MaterialTypeNo").trim());
				}
				modb.setMaterialNo(rs.getInt("MaterialNo"));
				modb.setPriceUnit(rs.getDouble("PriceUnit"));
				modb.setOutCount(rs.getInt("OutCount"));
				if(rs.getString("ChaFlag")==null){
					modb.setChaFlag("");
				}else{
					modb.setChaFlag(rs.getString("ChaFlag").trim());
				}
				list[0].add(mobb);
				list[1].add(modb);
			}
			stmt.close();
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
		}
		return list;	
	}
//	修改出库明细所有信息

	public boolean update(String outNo,MateOutDetailBean modb){
		flag = false;
		dbpool.getConnection();
		String sql="update Material_Out_Detail set outNo='"+modb.getOutNo()+
		"',materialName='"+ modb.getMaterialName()+"',maModel='"+modb.getMaModel()+"',maBrand='"+modb.getMaBrand()
		+"',maMadeIn='"+modb.getMaMadeIn()+"',materialTypeNo='"+modb.getMaterialTypeNo()+"',materialNo="+modb.getMaterialNo()
		+",priceUnit="+modb.getPriceUnit()+",outCount="+modb.getOutCount()+" where outNo="+outNo;
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			pstmt=null;
		}
		
		return flag;
	}

//根据List明细添加出库明细

public boolean save(List list){
		flag = false;
		MateOutDetailBean modb;
		dbpool.getConnection();
		Iterator it = list.iterator();
		dbpool.setAutoCommit(false);
		while(it.hasNext()){
		modb=(MateOutDetailBean)it.next();
		String saveSql = "insert into Material_Out_Detail(outNoId,outNo,materialName,maModel," +
				"maBrand,maMadeIn,materialTypeNo,materialNo,priceUnit,outCount)  values(OutNoId.nextval," +
				"'"+modb.getOutNo()+"','"+modb.getMaterialName()+"','"+modb.getMaModel()+"','"+modb.getMaBrand()+"','"+
				modb.getMaMadeIn()+"','"+modb.getMaterialTypeNo()+"',"+modb.getMaterialNo()+","+modb.getPriceUnit()+","+modb.getOutCount()+")";
		try {
			pstmt=dbpool.conn.createStatement();
			flag = pstmt.executeUpdate(saveSql)>0?true:false;		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			if(flag==false){
		 		dbpool.rollback();
				break;
			}
		}
		dbpool.commit();
		dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				pstmt=null;
			}
		return flag;
	}

//修改chaflag标志

	public boolean updateChaflag(int outNoId){
		flag = false;
		dbpool.getConnection();
		String sql="update Material_Out_Detail set chaFlag='*' where outNoId="+outNoId;
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			pstmt=null;
		}
		
		return flag;
	}
	public boolean updateChaflag(int outNoId, boolean chaflag){
		flag = false;
		dbpool.getConnection();
		String sql;
		if(chaflag){
			sql="update Material_Out_Detail set chaFlag = '*' where outNoId="+outNoId;
		}else {
			sql="update Material_Out_Detail set chaFlag = null where outNoId="+outNoId;
		}
		
		try {
			
			pstmt=dbpool.conn.createStatement();
			flag=pstmt.executeUpdate(sql)>0?true:false;
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			flag=false;
			e.printStackTrace();
		}finally{
			dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			pstmt=null;
		}
		
		return flag;
	}
	public boolean save(ArrayList list, MateOutBaseBean mobb) {
		// TODO Auto-generated method stub
		flag = false;
		MateOutDetailBean modb;
		dbpool.getConnection();
		Iterator it = list.iterator();
		dbpool.setAutoCommit(false);
		while(it.hasNext()){
		modb=(MateOutDetailBean)it.next();
		String saveSql = "insert into Material_Out_Detail(outNoId,outNo,materialName,maModel," +
				"maBrand,maMadeIn,materialTypeNo,materialNo,priceUnit,outCount)  values(OutNoId.nextval," +
				"'"+mobb.getOutNo()+"','"+modb.getMaterialName()+"','"+modb.getMaModel()+"','"+modb.getMaBrand()+"','"+
				modb.getMaMadeIn()+"','"+modb.getMaterialTypeNo()+"',"+modb.getMaterialNo()+","+modb.getPriceUnit()+","+modb.getOutCount()+")";
		try {
			pstmt=dbpool.conn.createStatement();
			flag = pstmt.executeUpdate(saveSql)>0?true:false;		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			if(flag==false){
		 		dbpool.rollback();
				break;
			}
		}
		dbpool.commit();
		dbpool.freeConnection();
			if(pstmt!=null){
				try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				pstmt=null;
			}
		return flag;
	}


}